Power BI Women User Group July 2021 Yana Berkovich PM Instructor Led Training at Microsoft Former Data Platform MVP httpswwwlinkedincominyanaberkovich YanaBerkovich Microsoft Power Platform ID: 915676
Download Presentation The PPT/PDF document "Learning or Teaching Power BI?" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Learning or Teaching Power BI?
Power BI Women User Group
July 2021
Slide2Yana Berkovich
PM Instructor Led Training at Microsoft
Former
Data Platform MVP
https://www.linkedin.com/in/yanaberkovich
@
Yana_Berkovich
Slide3Microsoft Power Platform
Https://aka.ms/PowerPlatformILT
The low-code platform that spans Office 365, Azure, Dynamics 365, and standalone applications
Innovation anywhere. Unlocks value everywhere.
Power BI
Business analytics
Power Apps
Application development
Power Automate
Process automation
Power Virtual Agents
Intelligent
chatbots
Data
connectors
Portals
AI Builder
Dataverse
Slide4What are my options to begin?
Slide5What are my options to
continue journey
?
Slide6Self Paste Training
Slide7Instructor Led Training
https://aka.ms/pbitraining
https://aka.ms/DIAD
https://aka.ms/nextDIAD
https://aka.ms/AIAD
Power Platform Instructor led Training
https://aka.ms/powerplatformILT
Slide8Current landing pages https://powerbi.microsoft.com/en-us/instructor-led-trainingDashboard in a Day Event Web page (microsoftevents.com)
Dashboard in a Day (microsoft.com)https://aka.ms/Diad_instructorhttps://aka.ms/diad_student Find the right app | Microsoft AppSourcehttps://powerplatform.microsoft.com/en-us/instructor-led-training
Slide9Where Can we find the training content?Https://aka.ms/pbitraining
Training name
Instructor
Attendee
Dashboard in a day (DIAD)
https://aka.ms/Diad_instructor
+Train the trainer video
https://aka.ms/diad_student
Dashboard in a day (DIAD) Localized
https://aka.ms/DIAD-instructor_Local
https://aka.ms/DIAD_Attendee_Local
Advanced Data Visualization
https://aka.ms/PBI-adv_vis_Inst
+Train the Trainer video expected
https://aka.ms/PBI-adv_vis_Inst
Advanced Data Modeling & Shaping
https://aka.ms/PBIModelShapeInst
https://aka.ms/PBIModelShape
Power BI Admin in a day
https://aka.ms/PBI-AdminIAD-Inst
https://aka.ms/PBI-AdminIAD
Dev In A Day
https://aka.ms/deviad-instructor
https://aka.ms/deviad-student
+video
Leap into Power BI
https://aka.ms/LeapInstructor
https://aka.ms/LeapAttendee
PRIAD - Paginated Reports in a day
https://aka.ms/priad-instructor
https://aka.ms/priad-student
+ video
DAX in a dayWork in progress
MAIAD - Modern Excel Analyst in a day https://aka.ms/MAIAD-Inst https://aka.ms/MAIAD-Inst-En+Train the Trainer video in production
https://aka.ms/MAIAD-Attendeehttps://aka.ms/MAIAD-Attendee-EnAID - Analytics In a Day
https://aka.ms/PBISynapseTrainer NA
Slide10Where Can we find the training content?Https://aka.ms/pbitraining
Training name
Instructor
Attendee
Power Apps
App in a day (AIAD)
https://aka.ms/appinadayTrainer
https://aka.ms/appinaday
Power Apps
App in a day (AIAD) - Localized
https://aka.ms/AIADLocalTrainer
https://aka.ms/AppinadayLocal
Power Apps Portals
Build Your Own Power Apps Solution
https://aka.ms/BYOPAS_Instructor
https://aka.ms/BYOPAS_Student
Power Virtual Agent
Power Virtual Agent in a day
https://aka.ms/PVAinaDayInstructor
https://aka.ms/PVAinaday
Dataverse
for Teams
Dataverse
for Teams in a day
https://aka.ms/DataverseTeamsInst
https://aka.ms/DataverseTeamsIAD
Slide11In a Day Training
Components Instructor kit
Instructor Kit
Attendee Kit
Presentation Deck + Instructor notes
Delivery Guide/ Train the Trainer
Change log
Demo scripts
Labs, data assets, visual assets, code
Survey
Knowledge Check
Q&A – feedback
Follow up
Community
DIADQ@microsoft.com
PPILTQ@Microsoft.com
Slide12In a Day Training
Components Attendee kit
Instructor Kit
Attendee Kit
Presentation Deck (pdf)
Labs, data assets, visual assets, code
Survey
Knowledge Check
Opportunity to bring their own questions
Follow up
Join Power BI Community
Galleries
Slide13Agenda (times are approximate and will be fluid with the class)
Morning
09:00 AM – 10:00 AM
Introduction to Power BI and Power BI Demo
10:00 AM – 10:30 AM
Lab 1 Accessing & Preparing the data
10:30 AM – 10:45 AM
Break
10:45 AM – 11:15 AM
Lab 1 Solution + Questions
11:15 AM – 11:45 AM
Lab 2 Data Modeling and Exploration
11:45 AM – 12:15 PM
Lab 2 Solution + Questions
12:15 PM – 01:00 PM
Break for lunch
Afternoon
01:00 PM – 01:30 PM
Lab 3 Visualizations
01:30 PM – 02:00 PM
Lab 3 Solution + Questions
02:00 PM – 02:30 PM
Lab 4 Publishing and accessing Reports (optional Power BI Service demo)
02:30 PM – 02:45 PM
Break
02:45 PM – 03:15 PM
Lab 4 Solution + Questions
03:15 PM – 03:45 PM
Lab 5 Building a Dashboard and Sharing
03:45 PM – 04:15 PM
Lab 5 Solution + Questions
04:15 PM – 05:00 PM
Q&A
Slide14Dashboard in a Day
Https://aka.ms/DIAD
Introductory Level Training
Available in 9 Languages
Monthly updates
Included in the “In a day” Program for partners
Slide15Advanced Data Visualization
Advanced Training
Available in English
Quarterly Updates
Not included in the “In a day” Program for partners
Instructor Kit
https://aka.ms/PBI-adv_vis_Inst
+Train the Trainer video expected
Attendee Kit
https://aka.ms/PBI-adv_vis_Inst
Slide16Advanced Data Modeling and Shaping
Advanced Training
Instructor Kit
https://aka.ms/PBIModelShapeInst
Attendee Kit
https://aka.ms/PBIModelShape
Available in English
Quarterly Updates
Not included in the “In a day” Program for partners
Connecting to the data, shaping the data before the modeling process.
Understanding data modeling and how it affects the data visualization
Data modeling best practice
Slide17Power BI Admin in a day
Advanced Training
Instructor Kit
https://aka.ms/PBI-AdminIAD-Inst
Attendee Kit
https://aka.ms/PBI-AdminIAD
Available in English
Quarterly Updates
Not included in the “In a day” Program for partners
Understanding Power BI Administrator role
Establishing Power BI Environment and Enabling governance policy
Provisioning premium capacity
Usage monitoring and Auditing
Gateways
Admin Automation
Slide18Power BI Dev In a Day
Advanced Training for App dev’s
Instructor Kit
https://aka.ms/deviad-instructor
Attendee Kit
https://aka.ms/deviad-student
https://aka.ms/deviad-online-course
Available in English
Quarterly Updates
Not included in the “In a day” Program for partners
let
Source = “Hello, World!”
in
Source
Technical knowledge required to embed Power BI content. The course is designed for experienced Power BI dev’s
Working with Power BI REST API
Integrate Power BI content in labs
Working with Azure AD tokens
Slide19Leap into Power BI
From Tableau to Power BI
Advanced Training
Instructor Kit
https://aka.ms/LeapInstructor
Attendee Kit
https://aka.ms/LeapAttendee
Available in English
Quarterly Updates
Not included in the “In a day” Program for partners
This training requires minimum of a year of working experience with Tableau, it was created to help organizations who have decided to switch to Power BI with training Tableau analysts, developers and experts.
Slide20PRIAD - Paginated Reports in a day
Advanced Training
Instructor Kit
https://aka.ms/priad-instructor
Attendee Kit
https://aka.ms/priad-student
https://aka.ms/priad-online-course
Available in English
Quarterly Updates
Included in the “In a day” Program for partners
Empowers a report author with the technical knowledge required to create, publish and distribute Power BI paginated report.
Design report layouts
Connect to data sources to rereview report data
Work with parameters
Visualize data
Add interactive features
Publish, consume, deliver and embed paginated reports
Slide21MAIAD - Modern Excel Analyst in a day
Advanced Training
Available in 9 languages
Quarterly Updates
Included in the “In a day” Program for partners
Advanced capabilities available in Excel, explores how Excel and Power BI are best used together, and shows how to successfully work with them in Microsoft Teams and SharePoint online.
Analytics in Excel
Mapping analytics in Excel to Power BI—Compare Excel and Power BI desktop
Instructor Kit
https://aka.ms/MAIAD-Inst
https://aka.ms/MAIAD-Inst-En
Attendee Kit
https://aka.ms/MAIAD-Attendee
https://aka.ms/MAIAD-Attendee-En
Slide22AID - Analytics In a Day
Advanced Training (DIAD & working with Azure)
Available in English
Semi Annual Updates
included in the “In a day” Program for partners
This one day training is designed to empower data architects and BI developers with the technical knowledge required to design an enterprise BI solution that uses Azure Synapse Analytics and Power BI. The labs will focus on how to work with Azure Synapse and Power BI, developing and optimizing a Power BI model, creating a model using Direct Query, and Authoring a Power BI report.
Instructor Kit
https://aka.ms/PBISynapseTrainer
Attendee Kit
Slide23Citizen Developer
Analyst
DeveloperIT Admin
Introductory
Intermediate
Advanced
Architect
DIAD
Data Visualization
Dev in a day
Modeling & Shaping
MAIAD
AID
PRIAD
DIAD
MAIAD
PRIAD
MAIAD
PRIAD
AID
AID
Admin in a day
Leap into Power BI
Leap into Power BI
Leap into Power BI
Leap into Power BI
DIAD
Data Visualization
Modeling & Shaping
Data Visualization
Modeling & Shaping
Power BI Instructor Led Training
Slide24Prepare
Deliver
Follow up
Location
Make sure to have good network connectivity
Registration
Create a registration page for attendees
Marketing
Use your own channels, as well as the Power BI community to market the event
Proctors
We recommend 1:15 instructor to attendee ratio
Confirmation of registration:
Send the attendees an email confirming their registration
Include information about prerequisites for attendees
Ask attendees to download the content from
http://aka.ms/DIAD
,
install Power BI Desktop and sign up or sign-in to the service through
http://aka.ms/pbidiadtraining
prior to the event
Please include specific instructions related to in-person or virtual delivery available in subsequent slides
Reminder
Send a reminder to the attendees
Ask attendees if they were able to install & log in
How to organize Instructor Led training?
Logistics
Communication
Slide25Minimum technical requirements:
At minimum, a computer with 2-cores and 4GB RAM running Windows 10 / Windows Server 2008 R2, or later
Display:
At least 1440x900 or 1600x900 (16:9) recommended.
Internet connectivity:
Attendee
must have the ability to connect to the Internet (outside their organization)
Microsoft Power BI Desktop installed:
you should have downloaded and installed Power BI Desktop
from the Microsoft Store
https://go.microsoft.com/fwlink/?linkid=2135345
or from the download center https://go.microsoft.com/fwlink/?linkid=2135519
Microsoft Power BI Desktop requires Internet Explorer 10 or later.
If attendee doesn't have Power BI account- Signup for Power BI:
Go to
http://aka.ms/pbidiadtraining
and sign up for Power BI with a business email address.
If you cannot sign up for Power BI, let the instructor know.
Slide26Prepare
Deliver
Follow up
Curtain Warmer
We recommend preparing a ‘curtain warmer’ presentation or video to include important details:
Show the timer to let students know exactly when the training begins
Show the telephone dial-in number, if one is available, some attendees may require dialing-in
Play music to make sure they can hear sound and their speakers are working
Offer chat instructions so they can communicate if they lose connectivity or have problems
Share information about your organization and the presenters/proctors
Share any offers information you would like to present
Share the agenda for the day
During the lab time, keep displaying the 1
st
page of the lab on the screen and occasionally remind attendees about their expected progress or questions
Online Delivery
Slide27Prepare
Deliver
Follow up
Join 15 mins early and start the Curtain Warmer Video if you prepared one
Reinforce disclaimer regarding visibility of their name/email to all attendees
Ask attendees for feedback and satisfaction rating before leaving the session
Set expectations at the beginning of the sessions
Establish ground rules at the beginning
Let participants know it will be an interactive class
Give specific instructions on how customers can engage
Ask attendees to use Mute when not speaking to avoid any unexpected background noise
Online delivery
Slide28Prepare
Deliver
Follow up
If comfortable, turn on your camera. Note, camera use is a personal decision
Use camera for introductions at the beginning of the event
Turn off camera when delivering training content
Turn camera back on for Q&A and discussions with attendees
There may be benefits of using camera with individuals who are hearing impaired, visually impaired may prefer voice only conversation
Online delivery Camera recommendations
Slide29Prepare
Deliver
Follow up
Online delivery Driving participation
Participation / Temp Checks – This is one of the hardest things to accomplish in a virtual training but here are some tips:
Ask lots of questions and encourage dialogue using the Chat feature and schedule Q&A breaks for open discussion
Poll and/or survey/quiz the attendees in real-time
Say participant names frequently to acknowledge their contributions in the chat “John, you made a great point – thank you!” When participants hear their own names during a session, they pay closer attention.
Slide30Prepare
Deliver
Follow up
Day of the event:
“Thank you
” email, including additional resources
1-2 weeks after the event:
Provide
an update on what’s new in Power BI
Check with the attendees if they had a chance to work on their own data?
Ask the attendees if they would they be interested in one of your solutions?
Provide feedback about your experience - on the workshop content
DIADQ@microsoft.com
PPILTQ@Microsoft.com
Follow up with attendees after the event
Slide31Current Trainer’s path - How to become a partner pageDashboard in a Day Event Web page (microsoftevents.com)https://aka.ms/Diad_instructor
Slide32Useful linksPower BI Blog Anomaly detection
https://powerbi.microsoft.com/en-us/blog/anomaly-detection-preview/https://docs.microsoft.com/en-us/azure/cognitive-services/anomaly-detector/tutorials/batch-anomaly-detection-powerbi