iTrain Scotland IT Training Edinburgh image
 
Home > Courses > Microsoft courses > Microsoft Power BI Level 2

Microsoft Power BI Level 2

This 1 day course covers intermediate topics to enhance your data analysis skills. You'll learn to automate data appending from multiple files and connect to SharePoint for live synchronisation. The course delves into transforming data with Power Queries, including creating custom columns, unpivoting, and automating steps. You'll also explore DAX for creating measures and columns, and learn about time intelligence functions. Additionally, the course covers the Power BI Service, focusing on applying row-level security, creating workspaces, refreshing datasets, and sharing reports. Finally, you'll be introduced to integrating Copilot with Power BI.

A basic understanding of Power BI either having completed the level 1 course or a knowledge of the topics.

  • Increase your understanding of data connections
  • Develop your skills in Power Queries
  • Introduce Measures using DAX
  • Extend your knowledge of the Power BI Service
  • Introduce Copilot integration

Lesson 1: Data Connections

  • Folders to automate appending data from multiple files
  • Connecting to SharePoint files for live synchronisation
  • Connecting to SharePoint Lists
  • Using Microsoft Forms for data collection

Lesson 2: Transforming data using Power Queries

  • Data transformation tools
  • Creating custom columns using M language
  • Date functions
  • Unpivoting
  • Merging and Appending data
  • Applied steps
  • Automating steps

Lesson 3: Measures and Columns using DAX

  • Introduction to DAX
  • DAX functions
  • Time Intelligent functions
  • CALCULATE

Lesson 4: Power BI Service

  • Applying Row-Level Security
  • Creating Workspaces
  • Refreshing datasets
  • Sharing Reports
  • Creating dashboards

Lesson 5: Copilot

  • Introducing Copilot integration with Power BI
Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Virtual Classroom. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.
Group discount
1 place £ 350 n/a
2 places £ 700 n/a
3 places £ 1050 £ 956
4 places £ 1400 £ 1260
5 places £ 1750 £ 1558
6 places £ 2100 £ 1848
7 places £ 2450 £ 2132
8 places £ 2800 £ 2408