Hello Everyone 😊
This is My First Dashboard of Power bi 🙈
Exciting news! I've just completed the Codebasics POWER BI 2.0 Course and wrapped up my inaugural project, Business Insights 360, designed for AtliQ Hardware.
Problem Statement: AtliQ Technologies, a thriving hardware company specializing in peripherals, faced a significant challenge in LATIN AMERICA. Their quest? To rectify the issue through data-driven decision-making.
I'm thrilled to introduce Business Insights 360, a project aimed at enabling AtliQ Technologies to make informed decisions through insights into Finance, Sales, Marketing, Supply Chain, and an Executive View.
Key Insights:
Finance View: Analyzed crucial KPI indicators such as Net Sales, Gross Margin %, and Net Profit %. Created a comprehensive P & L Statement with YOY growth.
Sales View: Explored Customer Performance based on Net Sales and Gross Margin.
Marketing View: Enhanced Marketing insights with segment performance and Net Profit metrics.
Supply Chain View: Surveyed the variance of Actual Sales and Forecast accuracy.
Executive View: Examined Yearly Trends by Revenue, GM %, NP % & Market Share %. Listed the TOP 5 Customers & Products by Revenue Contribution.
Learnt Tech Stacks
🔹SQL
🔹Power BI Desktop
🔹Excel
🔹DAX Language
🔹DAX Studio(for optimizing the report)
🔹Project charter file
Learnt POWER BI Techniques
🔹From calculated columns to dynamic titles, I've delved into data modelling, bookmarks, page navigation, M Language, and beyond.
Business Exploits
💰 Pre-invoice deduction
💰 Post-invoice deduction
💰 Gross margin
💰 Net sales
💰 Net Profit
💰 YTD - Year To Date
💰 YTD - Year To Go
💰 Forecast accuracy
💰 Net error
💰 Absolute error
To interactive dashboard : https://lnkd.in/gcsJVGKV
Thanks to Codebasics for creating this amazing course and special thanks to Dhaval Patel sir and Hemanand Vadivel for such an engaging content throughout the course.
#PowerBI #SQL #DAX #Dashboards #PowerQuery #Analytics #Sales #Finance #SupplyChain #Marketing #Insights #BusinessIntelligence #DataAnalysis #DataVisualization #BIReporting #DataInsights #BIAnalytics #DataDriven #DataManagement #DataScience #BIConsulting #BusinessAnalysis #BusinessReporting #DataTransformation #BusinessMetrics #DataMining #BIPlatform #BusinessIntelligenceTools
#DataVisualizationTools #codebasics #buisnessinsight360