https://store-images.s-microsoft.com/image/apps.24000.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.08f176fb-7a61-45c1-82ab-0df5e2cd52d9

Advanced Modelling with Power BI: 1-Day Workshop

Advaiya Solutions Inc.

Learn how to structure and model your organizational data for consumption in Microsoft Power BI.

This 1-day workshop is to help business users understand the key concepts of creating a data model that will not only be useful to create efficient Power BI reports but will also help in increasing the performance of dependent processes and systems. After this training, attendees will also learn the best practices on creating data models with various DAX calculations.

Prerequisites and basic training

  • Attendees will need a solid grasp of Power BI Desktop's basic functionality
  • We can provide full basic training "Dashboard in a Day" or short-session refreshers

Advaiya will design and execute an in-person, group training for up to 20 people

Agenda:

  • Data Modeling Basics
  • Components of data model
  • Data model types in Power BI
  • Data modelling best practices
  • DAX Calculated Columns and Measures
  • DAX Evaluation Contexts
  • Time Intelligence Functions
  • DAX best practices

Note

Advaiya will work to understand what the specific needs of the client are and craft a unique, structured training. The training will consist of advanced functionality and scripting specific to the needs of the client, instructor lead lab, hands-on workshop, and a “Bring Your Own Data” experience.

At a glance

https://store-images.s-microsoft.com/image/apps.5184.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.9587a68d-2ab8-490c-bc48-4f0d3cb39650
/staticstorage/b043a486/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.2263.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.9d0c40c2-6d7e-4da9-8210-1f9e646dd791
/staticstorage/b043a486/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.27183.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.aa6cb95d-478b-46a0-8cf9-50cac4215c68
https://store-images.s-microsoft.com/image/apps.8.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.59cadba8-6f33-4c90-9d76-af0b40385658
https://store-images.s-microsoft.com/image/apps.12548.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.5aeec62f-bee7-4eef-bfcd-c1098b7b2b9d
https://store-images.s-microsoft.com/image/apps.25730.56c9cd60-902f-4dcf-96d5-7cb2088de38c.223124a5-667b-431d-a3eb-7cb95b4b7220.e4386f9b-a295-424c-858f-c23102dcc5df

Other consulting services from Advaiya Solutions Inc.

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
Discover Your Data: 3-Day AssessmentAdvaiya Solutions Inc.
+1
A 3-day assessment to understand current reporting, data, and analytical capabilities. Provides a report of findings and actionable recommendations.
NaN out of 5
$4,500
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
Power BI Advanced Data Shaping: 1-Day WorkshopAdvaiya Solutions Inc.
+3
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.
NaN out of 5
$3,500
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