Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
PL-300T00 Microsoft Power BI Data Analyst
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.
Provider Information
More courses from this provider:
Contact Information
VTEC Training Education Center
343 Gorham Rd
South Portland, ME 04106
Course Overview
Overall Proficiency Level
2 - Intermediate
Course Catalog Number
19228
Course Prerequisites
Successful Data Analysts start this role with experience of working with data in the cloud.
Specifically:
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.
Training Purpose
Functional Development
Skill Development
Specific Audience
All
Federal Employee
Delivery Method
Classroom
Online, Instructor-Led
Online, Self-Paced
Course Location
67 Gorham Rd
Scarborough, ME 04074
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):
Competency Areas
Feedback
If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.
Last Published Date: