Advanced Power BI

MATERI 

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

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Advanced Power BI
Link
*Jumlah Peserta	Estimasi Jumlah Peserta yang di ajukan
*Nama Peserta Yang Didaftarkan
	Personal Data
*Nama
*Jabatan	Jabatan/Divisi/Departement
*Nama Perusahaan
*Alamat Perusahaan
*Email Perusahaan
*Email Alternatif	eg: gmail, yahoo, hotmail
*Telepon Kantor
Ekstensi
*Handphone
	* Harus di isi
	Submit

SIMILAR ARTICLES

November 26, 2024

Excess Laytime & Demurrage Masterclass by M.I.C.E

November 26, 2024

Export Import Procedure

November 26, 2024

Pelatihan dan Sertifikasi Ahli K3 Listrik