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 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

لمحة سريعة

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/d1793c47/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/d1793c47/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/d1793c47/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