About the course:
Our Power BI training course will give you hands-on experience with Microsoft's heavy hitting Business Intelligence platform. Open up more highly-extensible reporting and analysis capabilities than you would have thought possible.
The latest suite of Power BI tools are the culmination of a raft of integration, business logic, visualisation and deployment technologies presented in such a way that self-service "pick-your-own" business intelligence now brings genuinely powerful control and takes away a lot of the complexity these functions would previously have required.
Power BI has the capability to pull in and process data from hundreds of other platforms - not just Microsoft's own (such as Dynamics, Sharepoint, SQL Server, Excel...) but pretty much anything with a solid API, whether on-premise or in the cloud - and squirt out interactive dashboards to browsers and desktop / mobile apps.
If you have a specific use case, project requirement or skills gap, please get in touch to find out how we can tailor a Power BI training workshop for you and / or your team's needs for flexible, remote, custom delivery.
Learning outcomes
- Business Intelligence fundamentals
- An overview of the Power BI suite
- Connecting to various data sources
- Data Modelling
- Data Analysis Expressions (DAX) language
- Data Visualisation
- Publishing your solution (web / mobile apps)
Who should attend
Data analysts, business analysts, software developers and other business stakeholders who want to create and publish cross-platform Business Intelligence dashboards solutions
Prerequisites
Knowledge of Excel, or an equivalent reporting package (such as Crystal Reports, Business Objects) would be useful but is not mandatory.
Live, instructor-led online and on-site training
We appreciate that you need flexibility to fit in with new working situations - whether you're an individual, part of a distributed team, or simply have projects and deadlines to meet.
Our remote training can take place online in a virtual classroom, with content split into modules to accommodate your scheduling challenges and meet your learning goals. Get in touch today to find out how we can help design a cost-effective, flexible training solution.
As soon as it's safe, we'll return to also offering the on-site custom training courses and programmes upon which we've built our reputation.
Introduction
- Data visualisation and Big Data
Why Power BI?
Overview of Power BI
- Power BI Desktop
- Power BI Service
- Power BI Mobile
Tour of Power BI Desktop
- Report Tab
- Canvas
- Filters pane
- Visualisations pane
- Fields pane
- Data Tab
- Relationships Tab
Dashboard Building: Quick Demo
- Connect to Data
- Create Quick Visualisations
- Publish the Dashboard to Power BI Service
Data Cleansing
- Power Query Editor
- Data Structure
- Transformations
- Adding Columns
DAX Introduction
- Why DAX?
- Measures
- Calculated Columns
- CALCULATE function
- Time Intelligence
Data Modelling
- Relationships
- Hierarchies
- Merge vs Append (Join vs Union)
Data Visualisation
- Overview of visualisations available
- Visualisation marketplace
- Key visualisations:
- Bar/Column Chart
- Line Chart
- Scatter Chart
- Pie Chart
- Map
- Card
- Slicer
- Table/Matrix
- Filters
- Drill Up/Down with Hierarchies
- Formatting Visualisations
- Applying Analytics
- Insert Image/Shape/Text
Tour of Power BI Service
- Sharing Reports
- Scheduled Refresh
- Row-Level Security