Israr Mohammed

Business 360 Dashboard

A Power BI dashboard built for the Codebasics Data Analytics Bootcamp, on a supplied scenario and dummy data: AtliQ, a computer-hardware distributor, needed one dashboard to replace scattered Excel reporting. I built five views — Finance, Sales, Marketing, Supply Chain and Executive — covering everything from P&L and margin to forecast accuracy and market share.

Type
Instructor-led Codebasics Data Analytics Bootcamp project, supplied scenario and dummy data
Tools
Power BI, DAX, Power Query, MySQL, Excel

The dashboard

Finance covers P&L and margin; Sales and Marketing cover customer, product and market performance; Supply Chain tracks forecast accuracy and risk; Executive rolls it all up for leadership. DAX measures handle benchmark comparisons against last year and target, and a Power Query-modelled data set drives the whole report.

View Live Dashboard
Business 360 dashboard, Finance View, showing net sales, gross margin and net profit KPIs, a profit and loss statement, and a net sales trend chart
Finance
Business 360 dashboard, Sales View, showing customer and product performance tables, a net sales versus gross margin scatter chart, and unit-economics donut charts
Sales
Business 360 dashboard, Marketing View, showing product and region/market/customer performance tables with net profit percentage, and a performance matrix scatter chart
Marketing
Business 360 dashboard, Supply Chain View, showing forecast accuracy, net error and a stock-out/excess-inventory risk column by customer and product
Supply Chain
Business 360 dashboard, Executive View, showing revenue by division and channel, a yearly trend of revenue and margin, a competitor market-share trend, and top 5 customers and products by revenue
Executive