Microsoft 365 Power BI Fundamentals Part 2
Course Code: M365PBIFP2
Duration: 1 day
Price: £425
Upcoming Events
- Virtual Classroom
- Wed 15 July 2026
- 1 day
- £425.00 (€490.00)
- Virtual Classroom
- Tue 22 September 2026
- 1 day
- £425.00 (€490.00)
- Virtual Classroom
- Wed 13 January 2027
- 1 day
- £425.00 (€490.00)
- Virtual Classroom
- Wed 21 April 2027
- 1 day
- £425.00 (€490.00)
- Virtual Classroom
- Thu 1 July 2027
- 1 day
- £425.00 (€490.00)
Course Overview:
With Power BI Desktop, you get a report authoring tool that enables you to connect and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can add visualisations and create reports. Reports can then be published and shared in a variety of ways.
Target Audience:
The course builds on the skills learnt in our Power BI Fundamentals course and introduces you to more features including data modelling, performance optimization and more complex reporting.
Please note that this course does not cover PowerBI Pro, PowerBI accessed via Microsoft 365 or SharePoint Services.
Course Objectives:
By actively participating in this course, you will learn about the following:
- Data Modelling
- Working with Dates
- Creating calculations using DAX
- Performing in-depth Reporting
- Ways to collaborate and share in Power BI
Course Content:
Data Modelling
- Introduction to Data Modelling
- Joins, Relationships and Cardinality
- Many to Many Relationships
- Star Schemas
- Create a Date Table
Create Calculations using DAX
- Create Calculated Columns
- Build Quick Measures
- Use DAX to Build Quick Measures
- Join Types
Reporting
- Choose Effective Visualizations
- Import a Custom Visual
- Interactions and Drill-throughs
- Configure Conditional Formatting
- Apply Slicing, Filtering and Sorting
- Key Perform and Indicators
Prerequisites:
To be successful in this course, we recommend you first attend the following course or have equivalent knowledge:
- Microsoft Power BI Fundamentals Part 1
Software Requirements for Virtual Classroom
If you are attending our Virtual Classroom training, you will need a laptop or PC with a working microphone and two screens. A webcam is also recommended for the best experience! You will also need to have both Power BI Desktop and Power BI Service (part of Microsoft 365 Apps), available on your device.
Power BI Service is what Microsoft call the version of Power BI found in their M365 subscription list of apps. It won’t be there as a default and is something your Microsoft 365 administrator would have to enable. It is free of charge and literally just a tick box. They will need access to this as this is where reports are published to and the only place where Dashboards can be created. Plus, all of the sharing and collaboration options are to be found here.
We strongly recommend that delegates also check that their PC meets the Minimum Requirements as outlined on the Microsoft Website and ensure that they are running the latest version of the software so that they can successfully access all student files.
This course is not suitable for MAC users.
Certification / Exam:
There is no exam relating to this course.
Further Information:
For more information or to book this course, please contact our Course Enquiries Team on 0117 370 1970 or send us an email us at enquiries@skilltec.co.uk
