Power BI Custom Certificate for Nacu Olivian
Certificate ID:
744903
Authentication Code:
f0ba3
Certified Person Name:
Nacu Olivian
Trainer Name:
Juan Pablo Maldonado Lopez
Duration Days:
2
Duration Hours:
14
Course Name:
Power BI Custom
Course Date:
20 November 2023 10:00 to 21 November 2023 17:00
Course Outline:
Getting started, data sources
- Installing Power BI and other components
- Data strategies for efficiency
- On-premises and online data sources
- Data transformations + M language
Managing Data
- Querying and aggregating data
- Importing and transferring data
- Pivoting and unpivoting data
- Transposing and joining data tables
- Tips and tricks on advanced functionalities
Advanced Data Modeling
- Working with tables and dimensions
- Defining data granularity
- Working with relationships and cardinality
- Creating measures using DAX
- Optimizing models for performance
- Fixing common issues in modeling
Advanced Rules and Calculations using DAX
- Creating tables using a formula
- Applying conditional functions
- Filtering multiple tables
- Working with disconnected tables
- Working with variables in DAX
- Calculating and filtering context
- Working with dynamic measures
Visualizations, Reports
- Visualization types in Power BI
- Customizing visual elements
- Creating Power BI maps visualization
- Creating Power BI visuals with R
- Using filters and slicers in reports
- Enhancing visual elements for reports