Power BI Training
What is Power BI?
Power BI has been out since 2015, and is fast becoming the go-to technology for business analytics. Its core components are available in Excel, so I consider it to be “Son of Excel”.
Power BI has two main aspects: Power BI Desktop, a computer application used for modelling your data and producing reports, and the Power BI Service, an online subscription-based SaaS (Software as a Service) which hosts your published reports, adds dashboard functionality and lets you share these across your organisation.
Why use Power BI?
Data visualisation tools such as Power BI can give your business focus and clarity, providing actionable insights and helping you make better business decisions.
Spot trends and anomalies in your business data and explore the possible reasons for these
Combine your data with external information, such as weather statistics or exchange rates, for deeper insights into your business
Keep an eye on important metrics and KPIs and trigger notifications
Scalable to industry-level use, with true Big Data capacity
Power BI Courses
Dashboard in a day
A one-day course designed to get you up and running in Power BI Desktop.
- Getting started with Power BI
- Importing files
- Simple data preparation
- Creating Reports in Power BI Desktop
- Formatting Report Visuals
- Publishing to the Power BI service
- Creating a Dashboard online
Power BI Desktop
A two-day introductory course that will teach you to create a data model and produce Power BI reports and dashboards.
- Getting started with Power BI
- Importing files
- Creating a simple report
- Filter interactions
- Simple data transformation
- The Data Model
- Combining tables with Append and Merge
- Drill-through pages
- Creating and testing Roles
- Publishing to the Power BI Service
Advanced Power BI
Extend your data model with calculated columns in Power Query and DAX and learn to create more sophisticated reports
- Connecting to different data sources
- Further data transformation
- Adding columns in Power Query
- Calculated columns in DAX
- DAX measures
- Dedicated Calendar tables
- Time Intelligence measures
- Custom Tooltips
- Bookmarks
- Parameters