Who is this course for?
Anybody who is getting started analysing data or building reports with Power BI.
Learning Objectives
After the course, 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.
Course Length – 2 days
Course Content
- Import data from text/CSV files, spreadsheets and databases
- Clean and transform data – replace or remove bad values, filter the rows, group, summarise, pivot and unpivot data, calculate results
- Calculate useful quantities e.g. sums, averages, cumulative values
- Build helpful and insightful visuals such as bar charts, line charts, scatter plots, matrix and table visuals, and maps
- Use interactions between visuals (as a filter, highlight) to good effect
- Explore and explain data: drill to detail, show data, add basic analytics (averages, trends, clusters, reference lines
- Filter data with slicers and the filter pane
- Tell stories with data; use bookmarks, spotlight, create drill-though pages
- 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; design for a phone / mobile device
- Publish content to the Power BI Service
Pre-requisites
None. This is a beginner level course.