Courses

Power BI: Advanced Data Shaping

This course will cover, using Power BI Desktop to import and shape data from a variety of different sources.

Power BI: Advanced Data Shaping

This course will cover, using Power BI Desktop to import and shape data from a variety of different sources.

What you will learn

This course will cover, using Power BI Desktop to import and shape data from a variety of different sources.

What you will learn:

	Understand the Power BI Desktop data model, its components and most 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
	Organize queries using folders

Class Size: 10

Course Outline:

I.	Introduction
	a.	Course Introduction
	b.	Study - Kit
II.	Module 1: Basic Data Modeling
III.	Module 2: Getting Started with M (Power Query Language)
IV.	Module 3: Advanced M Transformations
V.	Module 4: Variable, Parameters, and Functions
VI.	Module 5: Optimization Techniques
VII.	Further Readings: Other Interesting M topics

Skills you will gain

Microsoft Power BI

Data Visualization

Power Query Language

Data Shaping

Reports Generation

Instructor

Argelo Royce Bautista

Anonimouse Technologies Inc.

Business Systems Analyst @ Analog Devices Inc for 6 years

3-time awardee of Microsoft Most Valuable Professional Award for Data Platform

Microsoft Certified Trainer

Microsoft Certified Solutions Expert for Data Management and Analytics

Microsoft Certified Solutions Associate for Business Intelligence Reporting

Requirements

Prerequisite Knowledge: • Basic Structure of Programming Languages • Functional Programming Concepts • Set Operations Prerequisite Technologies: • Power BI Desktop x64 2.79.5768.1082 64-bit (March 2020) • Microsoft Excel

About Anonimouse Technologies Inc.

We are one of the country's leading technology-based education provider, committed to providing a platform to give access for both technical and non-technical learners through workshop sessions, which are friendly for beginners.

Offered by