https://store-images.s-microsoft.com/image/apps.24000.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.0b07e48f-40d0-421d-86c7-371b499330e8

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 business users to import and shape data from a 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

Rychlý přehled

https://store-images.s-microsoft.com/image/apps.5184.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.fad93c37-6715-4890-b1b1-3cbecb612211
/staticstorage/21c6880/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.2263.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.f00d66c2-6f93-4bdb-a5f5-c898159e27c4
/staticstorage/21c6880/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.51575.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.37df41e1-9bc4-4f36-883e-3c88720759b3
/staticstorage/21c6880/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.27183.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.b9d7c221-1ffd-4ecd-a5d6-a711a8fca91f
https://store-images.s-microsoft.com/image/apps.8.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.892659dd-50d9-4dc7-9c70-5066f6e35379
https://store-images.s-microsoft.com/image/apps.25730.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.023fa50e-a55a-451e-8ee6-b64eabd0ce64
https://store-images.s-microsoft.com/image/apps.12548.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.92627d5a-cac9-468c-a985-9d268ddd57bc