Home » Advanced Power BI
Advanced Power BI
June 23, 2022
Jadwal Pelatihan Advanced Power BI
| Tanggal | Tempat | Kota | | Belum ada jadwal terbaru |
MATERI Training Advanced Power BI
1. Data Visualization With Power BI
- Data Visualization Best Practices
- Power BI Desktop Visualization
- Custom Visuals in Power BI Desktop
- Formatting Visuals in Power BI Desktop
- Power View for Excel
- Charts, Scorecards, and other visualization items in Power View
- Sorting, Filtering and categorization with Power View
- Best Practices to work with Power View
- 3D Geospatial visualization with Power Map
2. Power Query For Data Transformation
- Installation, Requirements and Configuration
- Different versions of Power Query
- Power Query Introduction
- Query Editor
- Transformation GUI
- Row Transformations
- Column Transformations
- Data Type
- Adding Column
- Text Transformations
- Number Column Calculations
- Date and Time Calculations
- Data types, Lists, Records, and tables in M
- M built-in functions
- Generators in M
- Writing Custom Functions
- Error handling
- Advanced Data Transformations with M
3. Power Pivot For Data Modelling
- Power Pivot xVelocity engine basics and concepts
- Different versions of Power Pivot
- Relationships in Power Pivot
- Best practices
- Introduction to DAX
- Calculated Members
- Row Context vs Set Context
- Advanced calculations using Calculate functions
- Time Functions
- DAX Advanced
- Power Pivot embedded in Power BI Desktop
- Different versions of Power Map
- Best Practices to work with Power Map
4. Power BI Desktop; Combination Of Three Tools
- Power BI Desktop Introduction
- Getting data from different data sources
- Differences of Power Query stand-alone with Power Query in Power BI Desktop
- Modeling data, and relationships
- Creating calculated measures
- Power Pivot difference in Power BI Desktop
- Visualizing data in Power BI Desktop
- Power View difference in Power BI Desktop
- Best practices of designing solutions with Power BI
- Custom Visuals for Power BI Desktop
TRAINING METHOD
Pre Test
Presentation
Discussion
Case Study
Post Test
Evaluation
FACILITIES
Training Kit
Handout
Certificate
1x Lunch & 2x Coffee Break
Masker + Face Shield
Souvenir
