Just a moment, logging you in...
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.
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
At a glance
https://store-images.s-microsoft.com/image/apps.5184.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.fad93c37-6715-4890-b1b1-3cbecb612211
https://store-images.s-microsoft.com/image/apps.2263.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.f00d66c2-6f93-4bdb-a5f5-c898159e27c4
https://store-images.s-microsoft.com/image/apps.51575.aa0082a7-eb40-446a-9cf7-4835a058aac5.47902b90-8292-472e-ba08-91f529c8b7d6.37df41e1-9bc4-4f36-883e-3c88720759b3
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
Other consulting services from Advaiya Solutions Inc.
Project Online Dashboards: 1-Day Proof of ConceptAdvaiya Solutions Inc.A pilot implementation using pre-populated Power BI dashboards for Executives, Project Managers, PMOs and Resource Managers.
+1
Applicable to:
Power BI apps
Power BI appsNaN out of 5
Advanced Modelling with Power BI: 1-Day WorkshopAdvaiya Solutions Inc.Learn how to structure and model your organizational data for consumption in Microsoft Power BI.
+1
Applicable to:Power BI apps
Power BI appsNaN out of 5
Dashboard-in-a-Day: 1-Day WorkshopAdvaiya Solutions Inc.A comprehensive training session to help you understand and explore Power BI as a solution for business data collaboration.
+1
Applicable to:Power BI apps
Power BI appsNaN out of 5
Project Online Dashboards: 2-Hr BriefingAdvaiya Solutions Inc.An introduction to Power BI dashboards and reports for Project Online and live demo.
+1
Applicable to:Power BI apps
Power BI appsNaN out of 5
Discover Your Data: 3-Day AssessmentAdvaiya Solutions Inc.A 3-day assessment to understand current reporting, data, and analytical capabilities. Provides a report of findings and actionable recommendations.
+1
Applicable to:Power BI apps
Power BI appsNaN out of 5