Vinil Kakarla

Data Aspirant

[email protected] +91 8688986459

Resume

Hello, I am

Vinil Kakarla.

1

Excel
Project

1

PowerBI
Project

About Me

Hello! I'm Vinil Kakarla, an aspiring Data Analyst with a passion for transforming raw data into meaningful business insights. I enjoy uncovering trends, solving analytical challenges, and building interactive dashboards that help businesses make smarter decisions. With hands-on experience in Power BI, SQL, Advanced Excel, and Python, I've worked on end-to-end analytics projects involving data modeling, data cleaning, DAX, KPI reporting, and data visualization. Every project in this portfolio reflects my curiosity, continuous learning, and commitment to creating impactful, data-driven solutions. Thank you for visiting—I hope you enjoy exploring my work!

Key Skills

EXCEL

POWERBI

SQL

PYTHON

My Projects

AtliQ-Sales-Performance-Analytics

Domain/Function: Data Analytics

Business 360 Analytics

Domain/Function: Business Intelligence & Data Analytics

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/vinil-kumar-kakarla-9b36a6315/

Call Me

+91 8688986459

GitHub

https://github.com/vinilkakarla

Excel Project

AtliQ-Sales-Performance-Analytics

Domain/Function: Data Analytics

Developed an interactive Excel dashboard to analyze sales and financial performance using Pivot Tables, Pivot Charts, Power Query, and dynamic KPIs. Automated reporting and created visual insights to support data-driven business decisions.

View Project
on GitHUB

Analyzed net sales across product segments and categories using Pivot Tables to identify high-performing product groups and support data-driven sales strategy.

Built an interactive Pivot Table to compare the top 20 products by net sales across multiple years, enabling trend analysis and performance tracking.

Project Details

Developed an end-to-end Sales & Finance Analytics Dashboard in Microsoft Excel to monitor business performance through interactive reports and KPIs.

Key Features
1)Cleaned and transformed raw sales data using Power Query.
2)Built Pivot Tables and Pivot Charts for sales trend analysis.
3)Created interactive dashboards with slicers and dynamic charts.
4)Used INDEX-MATCH, XLOOKUP, IF, SUMIFS, and other advanced Excel formulas.
5)Monitored KPIs including Revenue, Profit, Orders, and Profit Margin.
6)Automated reporting to reduce manual effort and improve decision-making.

PowerBI Project

Business 360 Analytics

Domain/Function: Business Intelligence & Data Analytics

Developed an end-to-end Power BI Business 360 dashboard integrating Finance, Sales, Marketing, Supply Chain, and Executive views. Built a star schema, created DAX measures, and delivered interactive KPIs for data-driven decision-making.

Interactive Finance dashboard analyzing Net Sales, Gross Margin, Net Profit, and Profit & Loss with dynamic filters, year-over-year comparisons, and regional performance insights for informed business decisions.

Sales Performance dashboard visualizing customer and product profitability, performance matrix, and Gross Margin analysis using interactive Power BI visuals, DAX measures, and drill-through capabilities.

Project Details

Business 360 Dashboard | Power BI

Developed a comprehensive Business Intelligence dashboard in Power BI to analyze organizational performance across Finance, Sales, Marketing, Supply Chain, and Executive functions.
Key Highlights:
Built a Star Schema data model by integrating Excel, CSV, and SQL data.
Cleaned and transformed data using Power Query.
Developed advanced DAX measures for KPIs and business metrics.
Designed interactive dashboards using bookmarks, drill-through, slicers, tooltips, and navigation buttons.
Optimized report performance using DAX Studio and Power BI best practices.
Delivered actionable insights to support strategic business decisions.