Training Power BI

TUJUAN

Microsoft Power BI merupakan kumpulan dari software services, apps, dan connectors yang bekerja sama untuk mengubah sumber data yang tidak berelasi ke dalam suatu insight yang koheren, interaktif, dan menarik secara visual. Pada pelatihan ini membahas: dasar penggunaan aplikasi Power BI, instalasi, mengambil sumber data, menghubungkan sumber data, menggunakan fungsi DAX, analisis dan visualisasi dalam bentuk Dashboard. Dengan kemampuan dasar ini, peserta sudah bisa mengolah raw data menjadi visualisasi data yang menarik.

MATERI

1. Introduction to Power BI

• What is Power BI
  
• Power BI Desktop: The First Experience
  
• Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map and Power Q&A

2. Pengenalan Power BI

• What is Power Query
  
• Get Started with Power Query
  
• Power BI Get Data From Excel: Everything You Need to Know
  
• Definitive Guide to Power BI Personal Gateway
  
• File Sources
  
• Folder as a Source
  
• Database Sources
  
• Analysis Services Connection

3. 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

4. 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

5. 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

6. 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

Souvenir

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Training 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

August 6, 2025

Training Online – Total Productive Maintenance (TPM)

August 6, 2025

Sistem Manajemen Anti Penyuapan (SMAP) ISO 37001

August 6, 2025

Sertifikasi Profesi HR Manager by BNSP