- Virtual Workshop for up to 12 attendees
- Taught as a series of two-hour sessions, two sessions per week, for four weeks
- Curricula will cover Power BI basics and require the attendee to build a report solution for a real-world need
- Virtual Active Mentoring one-hour sessions that will begin the week after the last training session
- Sessions will be held once a week, for eight weeks.
Price: $10,000.00
Curriculum:
Program designed by Treb Gatte, Microsoft MVP
- Introduction
- Overview
- Power BI Overview
- The Design Process
- Conversation-centric design process
- Analyzing the request
- Capturing the end user terminology
- Defining the questions
- Outlining the answers
- Finding the data
- Bringing the Data Together
- Connecting to Excel data
- Connecting to Office 365 data
- Key Data patterns
- Star schema
- Snowflake schema
- Create a basic model
- Transforming Data
- Power Query Basics and DAX basics
- Merging basics
- Classifying Data
- Extending the data model with custom columns, measures, and tables
- Creating Reports and Dashboards
- Visual Design basics and best practices
- Wireframing toolkit basics
- Create a Basic Report
- Review Virtualization Types and when to use each
- Design considerations for Mobile Access
- Design Considerations for Power Q7A
- Reports vs. Dashboards
- Creating Reports
- Creating Dashboards
- Testing your dashboards in web and mobile experiences
- Publishing to PowerBI.com
- Testing Power Q&A
- Advanced Features
- Advanced Data Transformations
- Creating Applications
- Custom Visuals
- Gateways for On-Premises Data
- Change Management Recommendations
- New Impacts by Power BI
- Discuss Business Intelligence as a strategic capability
- Discuss how Business Intelligence and Artificial Intelligence is creating Collaborative Intelligence
- Discuss the new wave of data coming via products like Project Cortex
- Discuss how BI and AI can create new strategic and revenue opportunities