Build Interactive Analytics Dashboards
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
1- Swiggy Sales Analytics Dashboard | SQL, Power BI, DAX, Power Query
● Analyzed 1.96M+ records across 5 relational tables (Orders, Menu, Food, Restaurant, and Users) using SQL to evaluate revenue, order trends, customer behavior, restaurant performance, and city-wise sales.
● Built an interactive Power BI dashboard with DAX measures, KPIs, slicers, and drill-down analysis for revenue, AOV, orders, customer segmentation, and restaurant performance and sales trends.
● Performed data cleaning and transformation using SQL and Power Query, and developed business insights for revenue growth, customer retention, and top-performing restaurants.
2- IPL Analysis Dashboard (2008–2025) | SQL, Power BI, DAX
● Examined IPL match and ball-by-ball data across 2008–2025 using SQL and Power BI to identify team, player, venue, and match-performance trends.
● Developed DAX measures, KPIs, and visualizations including Points Table, Orange Cap, Purple Cap, Powerplay, Death Over, and Venue Analysis with dynamic season filtering.
● Enabled comparative performance analysis across teams and seasons through dynamic filtering and drill-down visuals.
3- Bike Sales Executive Dashboard | SQL, Excel, Tableau
● Studied sales, customer, product, and regional performance using SQL, Excel, and Tableau to uncover trends in customer behavior, store performance, and product sales.
● Prepared datasets for reporting through SQL joins, aggregations, and data transformation.
● Designed a dynamic Tableau dashboard with KPIs, filters, customer analysis, brand performance, and regional sales insights.
4- Indian General Election 2024 Analysis | SQL, Power BI, DAX
● Investigated 2024 Indian General Election data across 543 constituencies using SQL to evaluate party performance, vote share, alliance trends, and state-wise electoral outcomes.
● Carried out data cleaning, transformation, and data modeling to integrate constituency, demographic, and geographic datasets, ensuring accurate and reliable analysis.
● Delivered a comprehensive Power BI dashboard with DAX measures, KPIs, maps, slicers, and drill-down reports for state-wise seat distribution, constituency analysis, and party performance, enabling data-driven insights.
● Analyzed 1.96M+ records across 5 relational tables (Orders, Menu, Food, Restaurant, and Users) using SQL to evaluate revenue, order trends, customer behavior, restaurant performance, and city-wise sales.
● Built an interactive Power BI dashboard with DAX measures, KPIs, slicers, and drill-down analysis for revenue, AOV, orders, customer segmentation, and restaurant performance and sales trends.
● Performed data cleaning and transformation using SQL and Power Query, and developed business insights for revenue growth, customer retention, and top-performing restaurants.
2- IPL Analysis Dashboard (2008–2025) | SQL, Power BI, DAX
● Examined IPL match and ball-by-ball data across 2008–2025 using SQL and Power BI to identify team, player, venue, and match-performance trends.
● Developed DAX measures, KPIs, and visualizations including Points Table, Orange Cap, Purple Cap, Powerplay, Death Over, and Venue Analysis with dynamic season filtering.
● Enabled comparative performance analysis across teams and seasons through dynamic filtering and drill-down visuals.
3- Bike Sales Executive Dashboard | SQL, Excel, Tableau
● Studied sales, customer, product, and regional performance using SQL, Excel, and Tableau to uncover trends in customer behavior, store performance, and product sales.
● Prepared datasets for reporting through SQL joins, aggregations, and data transformation.
● Designed a dynamic Tableau dashboard with KPIs, filters, customer analysis, brand performance, and regional sales insights.
4- Indian General Election 2024 Analysis | SQL, Power BI, DAX
● Investigated 2024 Indian General Election data across 543 constituencies using SQL to evaluate party performance, vote share, alliance trends, and state-wise electoral outcomes.
● Carried out data cleaning, transformation, and data modeling to integrate constituency, demographic, and geographic datasets, ensuring accurate and reliable analysis.
● Delivered a comprehensive Power BI dashboard with DAX measures, KPIs, maps, slicers, and drill-down reports for state-wise seat distribution, constituency analysis, and party performance, enabling data-driven insights.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.