Online Training - Power BI

Dilihat 395

Cakra Biwa Consultant

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

Form Pendaftaran pelatihan di cakra

Formulir Pendaftaran

Silahkan isi FORMULIR PENDAFTARAN berikut dengan data yang benar agar
Kami dapat konfirmasi ulang kembali via email, WA maupun telepon.

Form Data Personal

Personal Data

*Harus diisi

Nama Lengkap*

Nama Perusahaan*

Alamat Perusahaan*

Jabatan*

Email Perusahaan*

Email Alternatif*

Phone/Wa*

Nomor Kantor*

Ekstensi

Form Data Materi Training

Data Materi Training

*Harus diisi

Topik Training*

Jumlah Peserta*

Nama Peserta yang Didaftarkan*

Form Data Materi 2 Training

Pastikan data yang diisi sudah benar agar Kami konfirmasi ulang kembali via email, WA maupun telepon terimakasih.

HUBUNGI KAMI

Komplek Pertokoan Ruko Tritunggal No. T7, Jotawang, Bantul, Yogyakarta 55188

Phone : 0811 2949 265

Email : marketing1@cakrabiwa.co.id

Kirim Pesan Kepada Cakra!

Kami siap membantu kebutuhan pelatihan anda, silakan isi form berikut: