Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Project Details

• AtliQ Mart is a FMCG (Fast-Moving Consumer Goods) producer located in Gujarat, India. The company operates in Surat, Ahmedabad, and Vadodara presently. Expansion plans are in place to reach more major or Tier 1 cities within two years.
• Develop a system to track and evaluate 'On-time Delivery (OT) %', 'In-full Delivery (IF) %', and 'OnTime in Full (OTIF) %' metrics for customer orders daily. Use insights from the analysis to make necessary improvements in the delivery process.
• Creating and using the supply chain analytics dashboard improved service quality, helped with better decisions, and set us up well for future growth.

Live Interactive Dashboard

Project Details

➢ In May 2022, AtliQo, a prominent Indian telecom provider, introduced 5G plans
simultaneously with other industry players.Subsequent to the 5G launch, AtliQo has
experienced a decrease in both active user numbers and revenue growth.
➢ To analyze and present key performance indicators (KPIs) before and after the 5G launch in
May 2022, providing actionable insights to help top-level management make informed
decisions to recover active user rates and optimize internet plans.
➢ After the 5G launch in May 2022, AtliQo observed a decline in active users and revenue
growth. This report provides a comprehensive comparison of key performance indicators
(KPIs) between the pre and post-5G launch periods.

Live Interactive Dashboard

Project Details

🚀 Vrinda Store Annual Report
🏪 Vrinda store want to create annual report for 2022. So that, Vrinda store can understand their customers and grow in 2023

1️⃣ women are more likely to buy compare to men.
2️⃣ Maharashtra , Karnataka and Uttar Pradesh are the top 3 states.
3️⃣ Adult age group (30-49) is max contributing.
4️⃣ Amazon, Flipkart and Myntra channels are max contributing

🚀 Final Conclusion to improve Vrinda store sales:
➡ Target women customer of age group(30-49 yrs) living in
Maharashtra . Karnataka and Uttar Padesh by showing ads/offers/coupons available on Amazon , Flipkart and Myntra.