cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI Training Content

Power BI Training Content

http://aka.ms/PBItraining

 

The Power BI engineering team develops and maintains several workshops and classes that are available to our partners and community leads for free to help them to train their customers and communities on Power BI.

Every class will include all material: presenter deck, demo scripts, step-by-step student Hands-on-Lab, dataset and train the trainer video

 

·        Dashboard in an Hour (DIAH)

·        Dashboard in a Day (DIAD)

·        Advanced Modeling with Power BI

·        Advanced Visualization with Power BI

·        Advanced Data Shaping with Power BI

·        Administrator in a Day

 

The guidance for using the content is:

 

  1. You cannot make any changes to the dataset.
  2. If any changes are made to content, then they should not be branded as per the above brands (DIAH, DIAD, etc).
  3. The person presenting should be very familiar with Power BI and be able to answer any customer questions related to the workshop or Power BI in general.

 

We are always open to feedback from our customers, partners and community to enhance the content to help entire Power BI community. Please send your feedback to diadq@microsoft.com

 

 

Dashboard in an Hour (DIAH)

DIAH is a 1-hour workshop targeting the BDM to introduce them to Power BI, its capabilities and its differentiated value prop.

Download content including presentation decks, demo scripts, and instructor training material. You’ll need your Microsoft account tied to your Microsoft Partner Network ID to access this content.  English , Other languages

 

Content is offered in 9 languages; Brazilian Portuguese, English, French, German, Korean, Italian, Japanese, Simplified Chinese and Spanish.
Content will be updated monthly.

 

Dashboard in a Day (DIAD)

DIAD is a 1 Day hands-on workshop for Business Analysts, covering the breadth of Power BI capabilities.

At the end of the day, attendees will better understand how to:

·        Connect and transform data from a variety of data sources

·        Define business rules and KPIs

·        Explore data with powerful interactive visuals

·        Build stunning reports

·        Share their dashboards with their team business partners, and publish them to the web

 

The workshop assets are split into 2 parts:
Download instructor content including presentation decks, demo scripts, and instructor training material. You’ll need your Microsoft account tied to your Microsoft Partner Network ID to access this content.  English , Other languages
Download attendee content including the lab manual and datasets. English , Other languages

 

Content is offered in nine languages: Brazilian Portuguese, Chinese-Simplified (Mandarin), English, French, German, Italian, Japanese, Korean, and Spanish.
Content will be updated monthly.

 

Advanced Modeling with Power BI

This 1-day course will walk through Power BI capabilities to enhance the data model for your business users. The course covers key aspects of create a great data model to meet your business needs, various features in Power BI to enhance data model for you and your organization to build great reports and introduction to DAX  to create calculations. In this course you also learn best practices on data models and various DAX calculation patterns. 

After completing this training, the attendees should be able to learn how to build advanced calculations with Power BI.

The workshop assets are split into 2 parts:
Instructor content: which includes Presentation decks, Demo Scripts and train the trainer material, can be downloaded here.
Attendee content: which includes the Lab Manual and datasets, can be downloaded here.

 

Content is offered in English.
Content will be updated quarterly.

 

Advanced Visualization with Power BI

This 1-day course will cover the Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will enable attendees to understand the art behind visualizations, implications behind choosing the right charts, the impact of color, shape and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports and best practices to authoring great reports and dashboards for the business users. 

 

The workshop assets are split into 2 parts:
Instructor content: which includes Presentation decks, Demo Scripts and train the trainer material, can be downloaded here.
Attendee content: which includes the Lab Manual and datasets, can be downloaded here.

 

Content is offered in English.
Content will be updated quarterly.

 

Advanced Data Shaping with Power BI

This 1-day course will cover, using Power BI Desktop to import and shape data from a variety of different sources.

After completing this training, the attendees should be able to learn how to import data from a variety of data sources into Power BI. Specifically, you will be able to: ​

·        Understand the Power BI Desktop data model​

·        The components of effective schemas​

·        Gain an understanding of the 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

 

The workshop assets are split into 2 parts:
Instructor content: which includes Presentation decks, Demo Scripts and train the trainer material, can be downloaded here.
Attendee content: which includes the Lab Manual and datasets, can be downloaded here.

 

Content is offered in English.
Content will be updated quarterly.

 

Administrator in a Day

This 1-day will walk you through the Microsoft Power BI administration and the management of a Power BI tenant, including the configuration of tenant settings, usage monitoring, and provisioning of licenses, and other organizational resources. ​

It covers the typical admin tasks and tools, such as Power BI admin portal and Office 365 admin center, and how to automate them by using administrative APIs and PowerShell cmdlets.  Specific Hands-on labs around using Premium capacity in Power BI, safely sharing Power BI assets and finally using the Power BI audit log to optimize your Power BI Usage. 

 

The workshop assets are split into 2 parts:
Instructor content: which includes Presentation decks, Demo Scripts and train the trainer material, can be downloaded (Coming soon).
Attendee content: which includes the Lab Manual and datasets, can be downloaded (Coming soon).

 

Content is offered in English.
Content will be updated quarterly.

 

Best Regards, 

Power BI Team

Comments

Hi @sivah ,

 

this is very useful content, thanks for that!

I regularly use the DIAH content in our company for training and workshops at our departments.

  • When looking at the DIAH content, I think i'm missing the Lab Manuals for that, is that correct?
  • Any idea when the Administrator in a Day will be available?

Many thanks!

Nicky