Project Details

Sales Report Insights:

📈 Explored customer sales figures and growth percentages over the years in the Customer Performance Report.
🌐 Conducted a detailed comparison between market performance and sales targets in the Market Performance and Sales Targets Comparison.

Finance Report Insights:

💹 Evaluated financial performance over different time frames in Profit and Loss (P&L) Reports by Fiscal Year and Months.
📊 Explored market-wise insights for benchmarking in Profit and Loss (P&L) Reports by Markets.

Technical Skills Gained:

🔍 Applied ETL methodology for efficient data processing.
🔄 Generated date tables and derived fiscal months and quarters with Power Query.
💡 Established data model relationships and incorporated supplementary data using Power Pivot.

Soft Skills Gained:

📊 Developed user-centric reports with empathy in mind.
🎯 Fine-tuned report generation processes for efficiency.
📅 Devised a systematic plan for building comprehensive reports.

Project Details

•Customized Dashboard: Developed a multi-functional Power BI dashboard to specifically meet AtliQ Hardware's needs, allowing them to gain insights into their various departments.

•Data Integration: Data was sourced from disparate locations, including Excel/CSV files and a MySQL database, and seamlessly integrated into Power BI for comprehensive analysis.

•Data Model and Visualizations: A robust data model was developed within Power BI, enabling the creation of visually appealing and interactive visualizations to represent key performance indicators (KPIs).

•Performance Optimization: The dashboard's performance was significantly improved using DAX Studio, resulting in a 5% increase in report efficiency.

•Data-Driven Decisions: AtliQ Hardware can now analyze trends across different departments, empowering them to make data-driven decisions.

Live Interactive Dashboard

Project Details

➡ I developed a Power BI dashboard for AtliQ Mart, an FMCG manufacturer, to track ‘On-Time’ (OT %), ‘In-Full’ (IF %), and ‘On-Time In-Full’ (OTIF %) delivery metrics.
➡This tool aims to address service issues before the company expands to new cities.
➡ Data Sources: Integrated data from Excel/CSV files and a MySQL database, using Power Query for transformation and DAX for calculations.
➡ Data Analysis and Visualization: Built a data model and created visualizations such as line charts, bar charts, and heat maps to represent performance metrics. ➡Added interactive elements like filters and drill-downs for detailed analysis.
➡ Business Impact: The dashboard enhances visibility into delivery performance, improves customer satisfaction, supports informed decision-making, and prepares AtliQ Mart for successful expansion by resolving current service issues.

Live Interactive Dashboard

Project Details

➡ This project focuses on analyzing AtliQ Hardware’s sales and operational data using SQL for querying and Excel for visual insights.
➡The core objective was to address 10 ad-hoc requests, while I also took the initiative to explore 3 additional research questions, delivering deeper, actionable insights.
➡Key areas of focus included optimizing product performance across regions, enhancing sales channel efficiency, and refining discount strategies. By leveraging advanced SQL techniques and presenting findings through charts in Excel, the analysis provided recommendations for improving decision-making processes, boosting revenue, reducing manufacturing costs, and optimizing customer discount strategies.
➡The insights generated from this project aim to support AtliQ Hardware in achieving long-term profitability and operational efficiency, offering clear strategies to refine product offerings, streamline operations, and enhance overall market presence.