Project Details

AtliQ Hardware, a leading player in computer hardware and peripherals, serves major clients like Amazon, Flipkart, Neptune, Croma, and its own e-stores through direct, retailer, and distribution channels. The challenge was to extract meaningful insights from complex sales and finance data.

Process:

🚀 Data Refinement:
Utilized Power Query to cleanse and shape raw data into detailed, strategic columns.

📊 Building a Data Framework:
Structured the data model to interconnect diverse datasets for seamless information flow and comprehensive analysis.

📈 Analytical Power:
Leveraged Power Pivot and DAX to develop precise measures and calculated fields, transforming complex data into actionable insights.

Project Details

Atliq Hardware, like many other businesses in Latin America, encountered substantial challenges driven by outdated Excel-based analytics. To combat this issue, senior executives within the company made a strategic decision to embark on a data analytics initiative.

🔄 Project Goal :
The primary mission of this project was to craft a holistic report that offers an insightful overview of Atliq Hardware's performance, all powered by the capabilities of Power BI.
𝗟𝗲𝗮𝗿𝗻𝘁 𝗧𝗲𝗰𝗵 𝘀𝘁𝗮𝗰𝗸𝘀
➡ SQL
➡ PowerBi Desktop
➡ Excel
➡ DAX language
➡ DAX studio (for optimizing the report)

𝗟𝗲𝗮𝗿𝗻𝘁 𝗣𝗼𝘄𝗲𝗿𝗕𝗜 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀
➡ Creating calculated columns
➡ Creating measures using the DAX language
➡ Data modeling
➡ Using Bookmarks to switch between two visuals
➡ Page navigation with buttons
➡ Creating date table using m language
➡ Dynamic titles based on the applied filters
➡ Using KPI indicators
➡ Conditional formatting of the values in visuals
➡ Data validat

Live Interactive Dashboard