Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

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 Grand, a leading 5-star hotel chain in India, is struggling with revenue decline due to ineffective decision-making and strong competition. To overcome these challenges, they are turning to "Business and Data Intelligence" for smarter, data-driven strategies.

📋 𝗢𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲𝘀:
The goal of this data analysis initiative is to equip AtliQ Grand's Revenue Team with valuable insights from historical data. As a data analyst, my task is to uncover key trends, define metrics, build an insightful dashboard, and offer actionable recommendations to drive better decision-making.

💡 𝗠𝘆 𝗔𝗰𝗵𝗶𝗲𝘃𝗲𝗺𝗲𝗻𝘁𝘀:
✅ Integrated various datasets for a holistic analysis
✅ Gained deep understanding of hospitality metrics and terminology
✅ Developed KPIs to track revenue performance by room type, booking platform, and occupancy rates, providing detailed insights int

Live Interactive Dashboard

Project Details

Atliq Hardwares, a prominent computer hardware manufacturer, faced challenges in deriving actionable insights for quick, data-driven decisions. To address this, their data analytics director, Tony Sharma, launched a SQL challenge to assess potential junior analysts. The task involved solving 10 ad-hoc business queries using SQL to extract insights on product performance, customer behavior, and sales channels. I utilized SQL for data analysis and created visualizations in Power BI to present the findings effectively. This project tested both my technical skills in data querying and analysis, as well as my ability to present insights clearly. The solution provided valuable insights, helping Atliq's management make informed decisions across multiple business functions.