Advanced Power BI for Business - Transform, Shape and Model Data.
Course Aims
Business Intelligence (BI) is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and onpremises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualise (or discover) what’s important, and share that with anyone or everyone you want. The aim of this course is to ensure delegates are comfortable with extracting data from a variety of data sources, performing transformations on the data and creating a data model.
Course Content
Module 1 - Connecting to Data Sources with Power BI Desktop
- View all Connection Options
- Connect to an Excel Workbook
- Connect to Text/CSV Files
- Manage Data Sources
Module 2 - Using Data View
- Use Data View
- Clean Irregularly Formatted Data
- Manage Columns
- Sort Table Data
Module 3 - Using the Power Query Editor
- Open the Power Query Editor
- Use the Query Settings Pane
- Transform and Shape Data Use Merge Queries
- Use Append Queries
- View the Power Query M formula language in the Advanced Editor
Module 4 - Using Model View
- Use the Model View
- Understand Model Relationships
- Create and Manage Relationships
- Create a Hierarchy
- Lesson 4: Calculations
- Learn DAX basics
- Create a Table
- Create a Calculated Column
- Create a Measure
- Use Quick Measures
Trainers
Mary Warde, Sureskills
Who is this content for?
This course is aimed at all those using Power BI for data analysis. Participants should have completed the Introduction to Power BI course prior to completing this course.
Training Method
This course is delivered online and is delivered over 2 half days.
