Power BI Desktop
Microsoft Power BI is a powerful business analytics service that can be used to transform data from multiple sources into interactive, visual reports that can be viewed on any device. With Data Analysis and Business Intelligence being vital to business success, this course will give you an introduction to the Power BI Desktop application and hands-on experience of how to connect to data sources, create accurate data models, and build visual reports upon which you can make informed decisions for your organisation.
Book your virtual training
- Date
- Venue
- Cost
- More info
- Date and time to suit you
- VenueWe will train your team
wherever they are based - CostContact us for price
- Fill in the form and we'll be in touch
within a working day.
Book your place
- There are no public, Worcester-based events for this course scheduled at the moment, but you can contact us to request a date or call 0800 018 5597
- Request dates at
Worcester Training Centre
- Understand fundamental data analysis concepts
- Connect to common data sources such as Excel workbooks and SQL Server databases
- Shape data from multiple sources and prepare the data for analysis
- Understand and create data models with calculated columns and measures
- Create engaging and interactive reports using data visualisations
- Implement a consistent theme for reports using templates and best practices
Introduction to Power BI
- What is Power BI?
- Power BI within the data analysis toolkit
- Introduction to the Power BI Desktop interface
Data Analysis Concepts
- Facts, dimensions, and measures
- Data types
- Data models and Relationships
Data Sources
- Connecting to data with Power BI Desktop
- Excel workbooks and databases
Shaping Data
- Preparing data for analysis
- Setting data types
- Exclude unnecessary columns
- Create custom columns
Modelling Data
- Create and edit relationships
- Identify and create measures
- Build hierarchies of data
Introduction to Data Analysis Expressions (DAX)
- Time intelligence functions and date tables
- Calculate(), Filter(), All()
Creating Reports
- Visualisations
- Charts, gauges, and KPIs
- Tables, matrices, and cards
- Filters and slicers
Working with Reports
- Interactions
- Drilldown, drill-through, and slicers
- Bookmarks and Selections
- Adding report objects – text, buttons etc.