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
Bir bakışta
https://store-images.s-microsoft.com/image/apps.5184.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.fad93c37-6715-4890-b1b1-3cbecb612211
/images/videoOverlay.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
/images/videoOverlay.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
/images/videoOverlay.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