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

Aperçu rapide

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
Autres services de conseil de Advaiya Solutions Inc.
Advanced Visualization: Power BI 1 Day WorkshopAdvaiya Solutions Inc.
+1
A 1-day training session that will help the business users understand the best practices to author great Power BI reports and to structure the agile process to choose and create Power BI visualization
NaN out of 5
$3,000
Project Online Dashboards: 1-Day Proof of ConceptAdvaiya Solutions Inc.
+1
A pilot implementation using pre-populated Power BI dashboards for Executives, Project Managers, PMOs and Resource Managers.
NaN out of 5
$3,000
Dashboard-in-a-Day: 1-Day WorkshopAdvaiya Solutions Inc.
+1
A comprehensive training session to help you understand and explore Power BI as a solution for business data collaboration.
NaN out of 5
$2,500
Construction Analytics : 2-Day WorkshopAdvaiya Solutions Inc.
+1
This workshop is focused on understanding current processes where analytics can be used to improve operations, creating more visibility and control across processes using Power BI and Azure
NaN out of 5
$3,000
Project Online Dashboards: 1-Wk ImplementationAdvaiya Solutions Inc.
+1
An implementation of Power BI dashboards for your Project Online service.
NaN out of 5
$8,500