This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling| visualizing| and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Learning Objectives
Course Details
Module 1: Get Started with Microsoft Data Analytics
Data Analytics and Microsoft
Getting Started with Power BI
Module 2: Getting Data in Power BI
Data Analytics and Microsoft
Optimize Performance
Resolve Data Errors
Lab : Preparing Data in Power BI Desktop
Module 3: Cleaning| Transforming| and Loading Data in Power BI
Shaping the Data
Profiling the Data
Enhance the data structure
Lab : Loading Data in Power BI Desktop
Module 4: Design a Data Model in Power BI
Introduction to data modeling
Working with tables
Dimensions and Hierarchies
Lab : Data Modeling in Power BI Desktop
Module 5: Create Model Calculations using DAX in Power BI
Introduction to DAX
Real-time dashboards
Advanced DAX
Lab : Introduction to DAX in Power BI Desktop
Lab : Advanced DAX in Power BI Desktop
Module 6: Optimize Model Performance in Power BI
Optimize the data model for performance
Optimize DirectQuery Models
Module 7: Create Reports in Power BI
Design a report
Enhance the report
Lab : Enhancing reports with interaction and formatting in Power BI Desktop
Lab : Designing a report in Power BI Desktop
Module 8: Create Dashboards in Power BI
Create a Dashboard
Real-time Dashboards
Enhance a Dashboard
Lab : Creating a Dashboard in Power BI Service
Module 9: Identify Patterns and Trends in Power BI
Advanced Analytics
Data Insights through AI visuals
Lab : Data Analysis in Power BI Desktop
Module 10: Create and Manage Workspaces in Power BI
Creating Workspaces
Sharing and Managing Assets
Module 11: Manage Files and Datasets in Power BI
Parameters
Datasets
Module 12: Row-level Security in Power BI
Security in Power BI
Lab : Enforce Row-Level Security
Framework Connections
The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):