Data Analyst to Build Sales Dashboards
Skills Required
Description
Sales data is only valuable when it’s clear and actionable. This project will focus on designing dashboards that allow decision-makers to quickly understand performance across regions, products, and timeframes.
The analyst will work with SQL to extract and prepare raw sales data. Cleaning and validating the data will be essential to ensure that reporting is accurate and trustworthy.
Power BI will be the primary tool for visualization. Dashboards should be designed to be interactive, easy to navigate, and aligned with executive priorities.
Excel will also play a role in supporting ad-hoc analysis and quick reporting needs.
DAX formulas will be used to create measures and calculated fields that enable deeper insights into trends and patterns.
The dashboards should be intuitive enough for non-technical users to explore, while still robust enough to answer complex business questions.
The final output must not only show numbers but also highlight the story behind them—helping stakeholders make data-driven decisions with confidence.
Key deliverables and responsibilities:
Extracting and cleaning sales data from multiple sources
Building ETL workflows for reliable data processing
Designing interactive dashboards in Power BI
Writing DAX formulas for custom calculations
Creating KPIs that reflect business priorities
Ensuring dashboards are responsive and user-friendly