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

Anonimouse Technologies Inc.

Visit Profile

Duration

1 Day (8 hours)

Course Type

Online (Instructor-Led)

Price

Contact Us