This project demonstrates the development of an end-to-end business intelligence solution using Power BI. A structured sales dataset was created and transformed into an interactive dashboard to support reporting and performance analysis.
- Develop a structured dataset for sales analysis
- Connect and transform data within Power BI
- Developed a star schema
- Build an interactive dashboard to monitor sales performance
- Deliver insights to support data-driven decision-making
- Power BI
- Power Query
- Data Modelling (basic relationships)
- Data Visualisation
- Custom-built sales dataset
- Includes:
- Sales records
- Product information
- Transaction-level data
- Imported dataset into Power BI
- Cleaned and transformed data using Power Query
- Ensured correct data types and structure
- Established relationships between tables
- Created a clean and logical schema for reporting
- Built visuals including:
- KPI cards (Total Sales, Transactions)
- Sales trends over time
- Product performance analysis
- Total Sales = SUM(Sales[SalesAmount])
- Total Transactions = DISCTINCTCOUNT(Sales[OrderID])
- Average Order Value = Total Sales ÷ Total Orders
- Sales YTD = Year-to-date sales using time intelligence functions
- DateTable = ADDCOLUMNS( CALENDAR(MIN(Sales[Order Date]), MAX(Sales[Order Date])), "Year", YEAR([Date]), "Month", FORMAT([Date], "MMM"), "MonthNumber", MONTH([Date]) )
- Selected Year (Title) = IF( HASONEVALUE(DateTable[Year]), "ST Projects: Sales Overview - " & VALUES(DateTable[Year]), "ST Projects: Sales Overview - All Years" ) These measures were used to power KPI cards and trend analysis within the dashboard.
- Identified top-performing products
- Analysed sales trends across time periods
- Highlighted underperforming areas
- Demonstrates a complete analytics workflow (data → insights → dashboard)
- Enables clear visibility of sales performance
- Supports better decision-making through interactive reporting
- Structuring data for effective modelling
- Designing clear and intuitive dashboard layouts
- Ensuring consistency across visuals and metrics
Successfully developed a fully functional Power BI dashboard, showcasing the ability to transform raw data into meaningful insights through effective data modelling and visualisation.