Project Details

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

Project Overview: I created a dashboard for AtliQ Hardware, a company that sells computer hardwares in India, to help them understand their business performance and make data-driven decisions.
Data Sources: I used data from Excel/CSV files and a MySQL database, and integrated them into Power BI using Power Query and DAX.
Data Analysis and Visualization: I developed a data model and created various charts and visuals to show the financial, sales, marketing, supply chain, and executive performance of the company.
Dashboard Interactivity: I also added features such as filters, slicers, drill-downs, and tooltips to make the dashboard interactive and user-friendly.
Performance Improvement: I optimized the dashboard’s performance using DAX Studio and best practices, resulting in a faster and more efficient report.
Business Impact: The dashboard helps AtliQ Hardware to identify their strengths and weaknesses, opportunities and threats, and areas for improvement.

Live Interactive Dashboard

Live Interactive Dashboard

Project Details

I utilized SQL queries to extract and analyze data, ensuring accuracy and relevance. I implemented stored procedures to streamline the process, automating repetitive tasks and enhancing efficiency. Additionally, I used views to improve query performance by simplifying complex data retrieval and ensuring faster execution. This combination of SQL techniques allowed for better data management and reporting.

I have learned the following:

1. Data retrieval using SQL queries.
2. Entity Relationship Diagram.
3. Extract, Transform, Load.
4. OLTP and OLAP.
5.SQL functions.
6. Creation of a Database.
7. SQL Data types.
8. Automation with stored procedures.
9. Streamlining data management
10. Kanban - Project Management Methodology.

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their short-term goals. By leveraging data analysis, businesses can unlock new opportunities, drive growth, and stay competitive.

Project Details

In this project, I used SQL to dive into the data and perform ad-hoc analysis, ensuring the information was accurate and relevant. I worked on extracting key insights from complex datasets, helping business owners make better, quicker decisions.

I turned to Python for data visualization to make the findings easier to understand. Using libraries like Matplotlib and Seaborn, I created clear and impactful visualizations, making the insights more accessible and actionable for everyone involved.

What I Learned:

• How to perform ad-hoc analysis and extract data using SQL.
• Creating engaging data visualizations with Python (Matplotlib, Seaborn).
• Streamlining data processes for better efficiency.
• Using visual storytelling to communicate insights more clearly.
• Presenting complex data in a way that simplifies decision-making.

Impact:
This project improved data analysis efficiency and empowered stakeholders to make informed, data-driven decisions with clarity.

Project Details

Overview :
This project analyzes data for AtliQ Grand to uncover insights into sales, revenue, and customer trends, supporting decision-making in the hospitality sector.

Objectives:

•Analyze revenue trends over time.
•Understand customer patterns based on demographics.
•Visualize sales, revenue, and customer segmentation.

Analysis Highlights:

•Sales Trends: Identified peak sales periods.
•Customer Segmentation: Grouped customers by age for targeted promotions.
•Revenue Insights: Analyzed revenue growth over time.
•Policy Impact: Examined how policy changes influenced business performance.

Key Findings:

•Identified months of high revenue growth and areas for operational improvement.

Conclusion:

The project provides actionable insights to enhance profitability and customer satisfaction.

Future Scope:

•Extend analysis to include customer feedback data.
•Implement dashboarding for real-time data visualization.