At a high level this session will cover using Power BI Desktop to import and shape data from a variety of different sources. Specifically, you will be able to understand the Power BI Desktop data model, the components of effective schemas, gain an understanding of the Power Query M language, import data from a variety of sources (including XLS and CSV files), create queries using toolbar navigations and Advanced Editor, understand parameters and finally, organize queries using folders.
Overview
COURSE DIFFICULTY
COURSE DURATION
2h 20m
Skills Learned
After completing this online training course, students will be able to:
Design efficient data models with proper relationships
Transform and shape data using Power Query
BI Developers, Data Analysts
Basic Power BI knowledge; Basic understanding of APIs
01. Introduction
02. Basic Data Modeling (Overview)
03. Basic Data Modeling (Lab)
04. Getting Started with M (Overview)
05. Getting Started with M (Import and Basic Transform Lab)
06. Advanced M Transformations (Overview)
07. Advanced M Transformations (Complex Transformations Lab)
08. Variables and Parameters (Overview)
09. Variables and Parameters (Creating Parameters and Paths Lab)
10. Optimization Techniques
11. Class Wrap-Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Design efficient data models with proper relationships
Transform and shape data using Power Query
WHO SHOULD ATTEND
BI Developers, Data Analysts
PREREQUISITES
Basic Power BI knowledge; Basic understanding of APIs
COURSE OUTLINE
01. Introduction
02. Basic Data Modeling (Overview)
03. Basic Data Modeling (Lab)
04. Getting Started with M (Overview)
05. Getting Started with M (Import and Basic Transform Lab)
06. Advanced M Transformations (Overview)
07. Advanced M Transformations (Complex Transformations Lab)
08. Variables and Parameters (Overview)
09. Variables and Parameters (Creating Parameters and Paths Lab)
10. Optimization Techniques
11. Class Wrap-Up
