A collection of Power BI projects showcasing data cleaning, modelling, analysis and interactive dashboard creation using DAX, Power Query, filters, KPIs and data visualisations.
Data_Technician_Workbook_Week_
This repository contains Power BI projects and practical exercises completed during my Data Technician Skills Bootcamp.
The projects demonstrate my ability to connect to multiple data sources, clean and transform raw data, create interactive reports and present business insights through clear visualisations.
- Imported data from Excel workbooks and external OData feeds
- Cleaned, transformed and loaded data using Power Query
- Combined information from multiple data sources
- Created relationships and structured data models
- Designed interactive dashboards using filters and slicers
- Built reports using bar charts, line charts, maps, tables and KPI-style visuals
- Analysed sales, profit, quantity, products and geographical performance
- Applied introductory DAX calculations and worked with semantic models
- Published and shared reports through Power BI Service
- Used data storytelling to communicate trends and business performance
This report explores product and sales performance across different countries, categories and customer segments.
The dashboard includes:
- Profit by country
- Sales and profit trends over time
- Sales by product category and customer segment
- Quantity and profit comparisons by location
- Interactive filters for exploring individual countries
This report was created to explore sales performance and identify important trends within the dataset.
The dashboard demonstrates:
- Sales performance analysis
- Comparison of products and categories
- Interactive filtering
- Clear dashboard formatting and layout
- Visual communication of key business metrics
- Power BI Desktop
- Power BI Service
- Power Query
- Microsoft Excel
- OData
- DAX fundamentals
- Connected Power BI to the required data sources
- Reviewed the structure and quality of the raw data
- Cleaned and transformed data using Power Query
- Created relationships between relevant tables
- Built charts, filters and interactive report elements
- Organised the visuals into clear dashboard layouts
- Reviewed the results to identify trends and insights
- Published completed reports to Power BI Service