Project Details

𝐃𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧:
Developed a comprehensive Power BI dashboard for AtliQ Hardware, specializing in computers and peripherals. The dashboard analyzes and visualizes key performance metrics across finance, sales, marketing, supply chain, and executive operations. The solution replaced Excel-based reporting, enabling data-driven decision-making and empowering stakeholders with actionable insights.

𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭:
AtliQ Hardware struggled to leverage data effectively, relying heavily on Excel reports. The project aimed to implement a smart analytics system using Power BI to help stakeholders make informed, strategic decisions.

𝐊𝐞𝐲 𝐅𝐞𝐚𝐭𝐮𝐫𝐞𝐬:
𝐑𝐨𝐛𝐮𝐬𝐭 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠: Integrated 10+ tables using data from MySQL and Excel/CSV sources.
𝐔𝐬𝐞𝐫-𝐂𝐞𝐧𝐭𝐫𝐢𝐜 𝐃𝐞𝐬𝐢𝐠𝐧: Created drillable insights with interactive visuals, tailored for various departments.

𝐊𝐞𝐲 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:
Advanced Power Query operations.
Complex DAX formulas for

Project video

Project Details

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐃𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧:

AtliQ Hardware, a global supplier of computers and peripherals, faced challenges in quickly addressing business questions due to limitations in its current reporting tool. This resulted in delays in data-driven decisions across key areas like sales, finance, and supply chain. To resolve this, the team leader assigned 10 ad hoc requests to the Data Analyst team for immediate analysis.

𝐊𝐞𝐲 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬:
◉ 36.3% increase in unique products.
◉ 9 out of 17 markets for AtliQ Exclusive are from the APAC region.
◉ Retailers account for 73.22% of sales, highlighting consumer preference for this channel

𝐒𝐐𝐋 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 𝐋𝐞𝐚𝐫𝐧𝐞𝐝:

●Aggregation Functions: MIN(), MAX(), AVG()
●COUNT(), ROUND()
●Conditional Logic: CASE-WHEN
●Joins and Its Types: Inner, Outer, Left, Right
●Subqueries
●CTEs (Common Table Expressions)
●Window Functions: RANK(), PARTITION BY

Project video

Project Details

🚩 Problem Statement
GoodCabs set ambitious 2024 performance targets, focusing on:
➡️ Trip volume
➡️ Repeat passenger rate
➡️ Passenger satisfaction
➡️ Balance between new and repeat passengers

🎯 My Role
I was tasked with delivering actionable insights using MySQL for business requests, Power BI for analysis, and provide presentation.

📊 Key Insights
📌 Total Revenue (Jan - June 2024): ₹108M
📌 Trip Volume Target Achievement: 99.27%
📌 New Passenger Target Achievement: 95.62%
📌 Passenger Rating Target Achievement: 96.1%

🚗 Top Performing Cities by Total Trips:
Jaipur: 18.05%, Lucknow: 15.09%

🚗 Top Cities by Repeat Passenger Rate:
Surat: 42.6%, Lucknow: 37.1%

📉 Bottom Cities by Repeat Passenger Rate:
Mysore: 11.2%, Jaipur: 17.4%

📌 Recommendations
1️⃣ Improve services in Vadodara, Lucknow, and Surat.
2️⃣ Boost retention in Jaipur and Mysore.

Project video