Project Details

AtliQ Hardware, a growing company, faced a big challenge. They had lots of data in different places, like SQL databases and CSV files, and they needed a way to make sense of it all.

In response to this challenge, we embarked on a journey to develop an interactive dashboard for data-driven decision-making.

🔸 Finance View: Delve into P&L statements, net sales, and top-performing products and customers for sustainable growth.
🔸 Sales View: Analyze customer and product performance, focusing on net sales, gross margins, and costs to boost revenue and profitability.
🔸 Marketing View: Assess marketing effectiveness through gross margin, net profit percentages, and operational expenses, and optimize strategies.
🔸 Supply Chain View: Explore supply chain efficiency metrics like forecast accuracy, error rates, and performance for operational excellence.
🔸 Executive View: Gain strategic insights into market share, top customers/products, and revenue trends.

Project video

Project Details

In this project, an examination of the dashboard data aimed to understand the impact of introducing 5G on the business. The analysis comprised the following components:

🔸 Identifying Underperforming KPIs: The study determined which key performance indicators (KPIs) did not meet expectations after the 5G launch.
🔸 Evaluating Plan Performance: Revenue trends were analyzed to identify successful plans and those in need of enhancement.
🔸 Plan Performance Analysis: The impact of 5G on different plans was assessed, providing recommendations on whether to continue or discontinue them.
🔸 Discontinued Plan Analysis: Plans that were discontinued after the 5G launch were explored, with insights into the reasons behind these decisions.
🔸 Offering Recommendations Based on Insights: Actionable recommendations were provided, informed by the insights gained, to facilitate astute decisions for future strategies and business expansion.

Project video

Project Details

Transferred data from Excel to the Power BI dashboard, proceeded to refine the raw data through transformation, conducted data modeling, and subsequently crafted the design for the dashboard.

Derived insights through analysis:

🔸We've analyzed data from November '22 to April '23, and March 2023 stands out with around 7,000 new customers and a revenue of 264 million.
🔸We have gained more customers and revenue, particularly from Delhi NCR.
🔸11k people have joined whose age is between 31-40. We should target the same age group in other cities.
🔸Offline agents outperform a significant revenue contributor.
🔸Looking at trends, there's a slight increase in customers and revenue for the online app and website. In contrast, offline direct sales have seen a decline.
🔸 Policy ID POL4321HEL has performed impressively, attracting over 4,000 customers.
🔸The 31-40 age group is receiving higher settlement amounts, totaling 533 million.

Project video

Project Details

This project involves a comprehensive analysis of Cyclistic, a prominent bike-sharing service in Chicago. The primary objective is to dissect usage patterns, specifically focusing on encouraging casual riders to transition into annual memberships.

Derived insights through analysis:

🔸Members contribute the highest number of rides.
🔸Casual riders exhibit the highest average ride duration on a monthly and daily basis.
🔸Member users favor both Classic bikes and electric bikes, while casual users predominantly opt for electric bikes.
🔸The top three busiest months are June, July, and August.
🔸Weekends are peak days for casual riders, while weekdays are the busiest for members.

Project video