Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data
Power BI Foundation Course
Who should attend
Anybody who is getting started analysing data or building reports with Power BI.
Course Length
2 days
Learning Objectives
Attendees will have a broad understanding of how to explore analyse and visualise data using Power BI and will be comfortable using Power BI Desktop to build reports and dashboards.
Pre-requisites
None
Course Content
This is a very practical hands-on course. Attendees will build Power BI visualisations, reports of increasing power and sophistication as the course progresses. Most time will be spent in lab exercises these will use data from public datasets. The course covers the following topics.
- Import data from text/CSV files and spreadsheets
- Clean and transform data – replace or remove bad values, filter the rows, group, summarise, pivot and unpivot data, calculate results
- Build helpful and insightful visuals such as bar charts, line charts, scatter plots, matrix and table visuals, and maps
- Filter data with slicers and the filter pane
- Improve and polish reports: add text, images and other non-data elements to enhance the report; apply conditional formatting e.g. data bars; configure titles, axes, colours, labels.
- Publish content to the Power BI Service