Project Details

🌟Business Scenario: Vrinda Stores is a clothing company that operates through various channels across different states. They require insights based on data for strategic marketing. 📈

🌟Workflow: Performed Data Cleaning and preprocessing, then created a dashboard using pivot tables, pivot charts and slicers. 📊

🌟 Insights Obtained: March emerged as a sales powerhouse, implying a seasonal trend worth capitalizing on. The buying force of women stood out, driving the majority of sales and top states were known. Adult women emerged as a crucial demographic, underlining their significance as customers. Notably, Amazon drove the most revenue among various channels.

🌟 Recommendations: Focused advertising efforts were proposed, honing in on women aged 30-49 in key states. Furthermore, a multi-channel approach was suggested, leveraging platforms like Amazon, Flipkart, and Myntra to maximize market reach and engagement.

Project Details

🌟Business Scenario: To create a report that can be used by stakeholders from sales, marketing, finance and executive teams.🚀📊

🌟Workflow:
◾ Connecting Power BI to the data source then Data Cleaning and ELT using Power Query Editor.
◾ Data Modelling involving 10+ tables.
◾ Creating calculated columns and complex measures using DAX language.
◾ Creating dynamic visuals and dynamic titles with different filters according to requirements.
◾ Using Bookmarks to switch between different visuals, Creating tooltips for visuals and Conditional Formatting.
◾ Dax studio to analyze the performance of the dashboard.
◾ Performance optimization to improve user experience.
◾ Deploying Reports to PowerBI service.

📈During the project, I also gained some financial and business knowledge such as
◾Gross Price, Pre and Post invoice deductions, Net Sales, COGS(Cost of Goods Sold), Net Profit and Supply Chain Basics

🌟Output: A dashboard with views for different departments.

Live Interactive Dashboard

Project Details

AtliQ Grands, renowned for its chain of five-star hotels across India, boasts a rich 20-year history in the hospitality sector. Nevertheless, they currently grapple with diminishing market share and revenue in the luxury and business hotel segment, attributed to competitive pressures and less effective management choices. In response to this challenge, the managing director of AtliQ Grands is embarking on a strategic initiative to integrate "Business and Data Intelligence" into their operations. The primary aim is to recapture market share and bolster revenue.

ACHIEVED OBJECTIVES
1. Formulated metrics in accordance with the provided metric list.
2. Designed a dashboard aligning with stakeholder-provided mock-up.
3. Generated valuable insights extending beyond the specified metric list and mock-up dashboard.
UTILIZED SKILLS
4. Leveraged Power BI

Live Interactive Dashboard

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.