Atliq Hardware Analysis - Power Bi Dashboard
Автор: Data Analysts - Personal Projects
Загружено: 2025-09-29
Просмотров: 7
Situation: Atliq Hardware wanted to understand regional sales performance across multiple markets to improve profitability and forecasting.
Task: Analyze multi-source sales data, detect patterns/outliers, and create dashboards for decision-making.
Action: Cleaned and modeled raw datasets in MySQL (joins, aggregations, ER modeling). Conducted EDA in Python (univariate, bivariate analysis, outlier detection, actual vs. forecast comparison). Designed interactive Excel dashboards (KPI cards, slicers, trend analysis) for operational reporting. Built advanced Power BI dashboards with DAX (Top-N analysis, Forecast Accuracy %, Gross Margin %, YoY trends).
Result: Delivered actionable insights on revenue drivers, forecast deviations, and regional profitability, supporting data-driven growth planning and performance optimization.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: