Course duration
- 4 days
Course Benefits
- Ingest, clean, and transform data
- Model data for performance and scalability
- Design and create reports for data analysis
- Apply and perform advanced report analytics
- Manage and share report assets
- Create paginated reports in Power BI
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- Getting Started with Power BI
- Lab: Getting Started
- Getting Started
- Prepare Data in Power BI
- Get data from various data sources
- Optimize performance
- Resolve data errors
- Lab: Preparing Data in Power BI Desktop
- Prepare Data
- Clean, Transform, and Load Data in Power BI
- Data shaping
- Enhance the data structure
- Data Profiling
- Lab: Transforming and Loading Data
- Loading Data
- Design a Data Model in Power BI
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
- Lab: Data Modeling in Power BI Desktop
- Create Model Relationships
- Configure Tables
- Review the model interface
- Create Quick Measures
- Lab: Advanced Data Modeling in Power BI Desktop
- Configure many-to-many relationships
- Enforce row-level security
- Create Measures using DAX in Power BI
- Introduction to DAX
- DAX context
- Advanced DAX
- Lab: Introduction to DAX in Power BI Desktop
- Create calculated tables
- Create calculated columns
- Create measures
- Lab: Advanced DAX in Power BI Desktop
- Use the CALCULATE() function to manipulate filter context
- Use Time Intelligence functions
- Optimize Model Performance
- Optimze the model for performance
- Optimize DirectQuery Models
- Create and manage Aggregations
- Create Reports
- Design a report
- Enhance the report
- Lab: Designing a report in Power BI
- Create a live connection in Power BI Desktop
- Design a report
- Configure visual fields adn format properties
- Lab: Enhancing Power BI reports with interaction and formatting
- Create and configure Sync Slicers
- Create a drillthrough page
- Apply conditional formatting
- Create and use Bookmarks
- Create Dashboards
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
- Lab: Designing a report in Power BI Desktop - Part 1
- Create a Dashboard
- Pin visuals to a Dashboard
- Configure a Dashboard tile alert
- Use Q&A to create a dashboard tile
- Create Paginated Reports in Power BI
- Paginated report overview
- Create Paginated reports
- Lab: Creating a Paginated report
- Use Power BI Report Builder
- Design a multi-page report layout
- Define a data source
- Define a dataset
- Create a report parameter
- Export a report to PDF
- Perform Advanced Analytics
- Advanced Analytics
- Data Insights through AI visuals
- Lab: Data Analysis in Power BI Desktop
- Create animated scatter charts
- Use teh visual to forecast values
- Work with Decomposition Tree visual
- Work with the Key Influencers visual
- Create and Manage Workspaces
- Creating Workspaces
- Sharing and Managing Assets
- Lab: Publishing and Sharing Power BI Content
- Map security principals to dataset roles
- Share a dashboard
- Publish an App
- Manage Datasets in Power BI
- Parameters
- Datasets
- Row-level security
- Security in Power BI
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Business Intelligence class:
- Understanding core data concepts.
- Knowledge of working with relational data in the cloud.
- Knowledge of working with non-relational data in the cloud.
- Knowledge of data analysis and visualization concepts.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.