https://106c4.wpc.azureedge.net/80106C4/Gallery-Prod/cdn/2015-02-24/prod20161101-microsoft-windowsazure-gallery/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Icon/large.png

Power BI Advanced Data Shaping: 1-Day Workshop

Advaiya Solutions Inc.

A 1-day training session, helping business users to learn how to import data from multiple data sources into Power BI and understand Power Query M language for doing complex transformations.

This training will help the business users to import and shape data from variety of sources. By the end of the training, attendees will be able to:

  • Understand the Power BI Desktop data model, its components and most effective schemas
  • Understand 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

Agenda:

  • Understanding basic Data Modeling
  • Getting Started with Power Query M Language
  • Importing data and Basic Transformations
  • Advanced M Transformations
  • Understanding Variable, Parameters and Functions
  • Best practices for optimization of queries and data model
At a glance
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/Thumbnails/f67ad6cc-23ce-489a-bb08-ab339c6ebcd8.png
/images/videoOverlay.png
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/Thumbnails/d96ad85a-77ba-41c0-82cf-dc0ea6ef5188.png
/images/videoOverlay.png
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/Thumbnails/dc19fdde-9ee8-4776-975e-29cc6f7cd4bb.png
/images/videoOverlay.png
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/SampleImage/9400651e-e545-4283-bfb6-ef39cc2def03.png
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/SampleImage/8bcc3733-ed91-472b-b1d2-62dc768e8048.png
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/SampleImage/2c00fc70-8205-43ca-b26f-5fc39392aef6.png
https://gallery.azure.com/artifact/20151001/advaiya.advanced-data-shaping-with-power-bi-workshop.1.0.0/Artifacts/SampleImage/7b12c2e4-f788-494c-8235-6431a483c8db.png