Other Projects
Power BI Project: Business Insights 360 for AtliQ Hardware
Introduction
AtliQ Hardware, a company specializing in hardware products like PCs, printers, and accessories, faced challenges in analyzing data effectively due to reliance on Excel. The project aimed to provide a robust business intelligence solution using Power BI to enhance decision-making, reduce losses, and identify growth opportunities.
Problem Statement
AtliQ Hardware experienced significant losses in Latin America due to inadequate data analysis methods. The company needed advanced tools to gain insights into business performance, sales trends, revenue opportunities, and operational challenges.
Solution Overview
Developed an end-to-end Power BI solution with interactive dashboards to empower data-driven decisions: Finance Dashboard: Profit/loss statements Key financial metrics Sales Dashboard: Sales trends analysis Customer behavior insights Product performance evaluation Marketing Dashboard: Marketing campaign performance Customer engagement metrics Market trend analysis Supply Chain Dashboard: Inventory management Supplier performance Logistics and forecast accuracy Executive Dashboard: Integrated business performance overview Strategic insights for decision-makers
Key Technologies and Skills Applied
Power Query Data import, cleaning, and transformation Column transformations, conditional columns, date tables using M language Data Modelling Star and Snowflake schema Table relationships and data validation DAX (Data Analysis Expressions) Measures and calculated columns using functions like SUMX, CALCULATE, ALL, SWITCH, SAMEPERIODLASTYEAR Filter context manipulation for advanced calculations. Data Visualization Dynamic visuals and dashboards Slicers, filters, and drill-down capabilities Power BI Service Report publishing and sharing Workspace management and data refresh scheduling
Outcomes and Impact
Enhanced financial visibility Improved sales strategy planning Optimized supply chain efficiency Better marketing campaign insights Executive-level strategic overviews
Link to View Live Dashboard
SQL Project: Pizza Hut Sales Project
In the project, the schema consists of multiple tables including orders, order details, pizzas, and pizza types, each designed to efficiently store and manage sales information for Pizza Hut. Using SQL queries, I tackled various problem statements related to sales analytics. These queries enabled me to extract valuable insights, such as identifying top-selling pizzas, analyzing sales trends over time, and understanding customer ordering patterns. This project demonstrates my ability to design a structured database, implement complex SQL queries, and derive actionable business insights from raw data. It showcases my skills in data management, relational database design, and SQL programming.
