Sale!

Power BI Data Analyst Training

$1,659.00 $1,319.00

This outstanding Power BI Training is exclusively designed for aspiring Data Analysts, Power BI Developers, and Reporting Developers.
This training includes understanding real-world case studies, meeting the Power Query, working with Power BI desktop and service, creating different kind of dashboards, and more!
100% Practical, Step by Step, and with these real-world experiences you will be ready to go to your next goal: Become in a Power BI Developer.

Category:

Description

Course Overview

Session 01: Getting Started

  1. Course structure and outline
  2. Setting Expectations
  3. Heads UP! PL-300 Exam
  4. Exam structure
  5. Skills Measured
  6. Exam Questions Type
  7. Example Knowledge-based questions
  8. Example Case Study questions
  9. Exam Rules
  10. Scheduling Exam
  11. Exam Results
  12. Certification Renewal Process

Session 02: Setting Up Power BI Desktop and Service

  1. Installing Power BI – Desktop
  2. Creating an Account and Free Trial
  3. Power BI Service Interface
  4. Creating your first workspace

Session 03: Data Prep: Getting Data from Different Sources

  1. Connecting Data
  2. The Query Editor
  3. Example | Connecting to JSON files
  4. Example | Connecting to PBDIS files
  5. Example | Connecting to Microsoft Dataverse
  6. Example | Connecting to SSAS
  7. Example | Connecting to Sharepoint Online
  8. Storage modes
  9. Data Source Settings
  10. Dynamic Sources with Parameters

Session 04: Data Prep: Profiling

  1. The View Menu
  2. Column Quality
  3. Column Distribution
  4. Column Profile

Session 05: Data Prep: Cleaning, Transforming, and Loading

  1. Basic Table Transformations
  2. Index Column
  3. Conditional Columns
  4. Columns from Example
  5. Grouping and Aggregation
  6. Pivoting and Unpivoting
  7. Merging Queries
  8. Appending Queries
  9. Intro to M Code and Editing Applied Steps
  10. The Advance Editor
  11. Common M Function Categories
  12. M Code Syntax

Session 06: Data Modeling 101

  1. What is a Data Model
  2. Data Tables vs Lookup Tables
  3. Creating Table Relationships
  4. Relationship Cardinality and Filter Row
  5. Active and Inactive Relationship
  6. Creating a Snowflake schemas
  7. Automatic Data Tables
  8. Data Table Requirements
  9. Model Optimization Tips

Session 07: Data Modeling: DAX Calculations

  1. Meet DAX
  2. Calculated Columns
  3. Measures
  4. Quick Measures
  5. Common DAX Function Categories
  6. Basic Aggregation Functions
  7. Iterator Functions
  8. DIVIDE
  9. CALCULATE
  10. CALCULATE (Modifiers)
  11. USERELATIONSHIP
  12. ALL
  13. FILTER
  14. TOPN
  15. Time Intelligence Functions

Session 08: Data Visualization: Creating Reports and Dashboards

  1. Power BI Report View
  2. Objects and Basic Charts
  3. TIP: Small Multiples
  4. Editing Reports Interactions
  5. Drill-through Filters
  6. Bookmarks
  7. Tooltips
  8. Importing Custom Visuals
  9. R & Python Visuals
  10. Accessibility Features
  11. Creating a Dashboard in Power BI Service
  12. Dashboard Interface
  13. Web vs Mobile Layout
  14. TIP: Paginated Reports
  15. TIP: Creating PivotTables from Power BI Datasets

Session 09: Data Analysis: Enhancing Reports

  1. Chart Types based on Analysis.
  2. Chart Analytics Options
  3. Q&A Visuals
  4. Filtering Options
  5. Slicers
  6. Key Influencers Visual
  7. Decomposition Tree Visual
  8. Clustering
  9. Grouping and Binning

Session 10: Deploying and Maintaining Deliverables

  1. Schedule Datasets refresh
  2. Static Row-Level security
  3. Dynamic Row-Level security
  4. Apply RLS in Power BI Service
  5. Azure Security Groups
  6. Subscriptions
  7. Sharing Options
  8. User Roles and Permissions
  9. Publishing Apps
  10. Deployment Pipelines
  11. Data Lineage
  12. Incremental refresh and Query folding
  13. Configuring incremental refresh
  14. Large Dataset Storage Format
  15. Endorsing Content
  16. Sensitivity Labels

Every topic will be done with real world use cases, using many examples that allow you to see how the real work is in a role related to BI Developer, Reporting Developer, or Data Analyst.

Price: $1659.00
Offer for Enrollments this Month: $1319

Duration: 20 hours

Available Schedules:

  • To be determined.

Related products