Business Insights 360 is a Power BI dashboard designed to empower AtliQ Hardware with actionable insights across Finance, Sales, Marketing, and Supply Chain.
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.
Explore the live dashboard Project Link
The dashboard seamlessly collects and utilizes data from two primary sources:
Excel/CSV Files: Targets, Market Share data, and related information are sourced from Excel/CSV files.
MySQL Database: Facts and Dimensions data are retrieved from a MySQL database.