Atliq Hardware Analysis - Power Bi Dashboard

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.