I recently completed a Power BI Project in Codebasics Bootcamp - "AtliQ Hardware Business Insights 360" project.
⛳Project Objective: I created a project based on AtliQ Hardware, a fast-growing consumer electronics company struggling with Excel-based analytics. Their reliance on outdated tools led to significant losses in Latin America due to ineffective insights. 👉The goal was create a report which focuses on improving their data analytics to drive better business decisions.
🔎 Power BI Dashboard Overview: The dashboard comprises six pages-->
Finance View:
Analyzes profit and loss (LY vs Target) and net sales performance over time. Highlights top products and customers by net sales.
Sales View:
Tracks customer performance across platforms and product performance. Includes net sales breakdown, GM%, and regional metrics.
Marketing View:
Focuses on product, region, and customer performance. Also covers net profit by evaluating gross margin and operating expenses.
Supply Chain View:
Monitors forecast accuracy, net/absolute error, and key metrics by customer. Shows net error trends and product metrics.
Executive View:
Provides market share comparison (AtliQ vs competitors) and year-over-year trends. Includes revenue analysis by channel and region.
𝗟𝗲𝗮𝗿𝗻𝘁 𝗧𝗲𝗰𝗵 𝘀𝘁𝗮𝗰𝗸𝘀
➡️ SQL
➡️ PowerBi Desktop
➡️ Excel
➡️ DAX language
𝗟𝗲𝗮𝗿𝗻𝘁 𝗣𝗼𝘄𝗲𝗿𝗕𝗜 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀
➡️ What are all the questions should be asked before staring the project
➡️ Creating calculated columns
➡️ Creating measure using DAX language
➡️ Data modeling
➡️ Using Bookmarks to switch between two visuals
➡️ Page navigation with buttons
➡️ Using divide function to prevent zero division errors
➡️ Creating date table using m language
➡️ Dynamic titles based on the applied filters
➡️ Using KPI indicators
➡️ Conditional formatting the values in visuals using icons or background color
➡️ Publishing reports to PowerBi services
➡️ Setting up personal gateway to set up the auto refresh of data
𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐫𝐞𝐥𝐚𝐭𝐞𝐝 𝐭𝐞𝐫𝐦𝐬
➡️ Gross price
➡️ Pre-invoice deductions
➡️ Post-Invoice deductions
➡️ Net Invoice sale
➡️ Gross Margin
➡️ Net sales
➡️ Net profit
➡️ COGC - cost of goods sold
➡️ YTD - Year to Date
➡️ YTG - Year to Go
➡️ Direct
➡️ Retailer
➡️ Distributors
➡️ Consumer
AtliQ platform & sales channel:
➡️Sales Channel:
⚫ Retailer: Major chains and online platforms
⚫ Direct: Branded stores and ecommerce sites
⚫ Distribution: Third party like Neptune in South Korea & China
➡️Platform :
⚫ Brick & Mortar: Physical retail stores eg Croma & Best Buy
⚫ Ecommerce: eg., Amazing & flipkart