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


  • 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

Begiratu batean

Advaiya Solutions Inc. enpresaren beste aholkularitza-zerbitzu batzuk

Project Online Dashboards: 1-Wk ImplementationAdvaiya Solutions Inc.
An implementation of Power BI dashboards for your Project Online service.
NaN 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.
NaN 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.
NaN 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.
NaN out of 5
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.
NaN out of 5