Terima kasih telah mengirimkan pertanyaan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Terima kasih telah mengirimkan pemesanan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Kerangka Materi
Pengantar Power Query
- Gambaran antarmuka Power Query
- Memahami kueri dan langkah yang diterapkan
- Menavigasi integrasi Power BI dan Excel
Menghubungkan ke Sumber Data
- Mengimpor file Excel, CSV, dan teks
- Bekerja dengan folder dan dataset terstruktur
- Menghubungkan ke sumber online dan database
Dasar-dasar Pembersihan Data
- Menghapus kesalahan dan duplikat
- Mengefilter, mengurutkan, dan membentuk data
- Bekerja dengan nilai yang hilang
Transformasi dan Pembenaran Data
- Memisahkan dan menggabungkan kolom
- Pivot dan unpivot
- Mengelompokkan dan mengagregasi data
Menggabungkan Kueri
- Append vs. merge kueri
- Jenis join dan pertimbangan struktur data
- Memodelkan dataset multi-sumber
Pengenalan Bahasa M
- Memahami rumus M
- Mengedit kueri menggunakan Editor Lanjutan
- Menulis transformasi kustom
Otomatisasi dan Refresh
- Membuat alur kerja transformasi yang dapat digunakan kembali
- Mengonfigurasi jadwal refresh
- Mengelola dependensi dan kinerja kueri
Teknik Lanjutan
- Parameterisasi kueri
- Menggunakan fungsi dalam M
- Praktik terbaik untuk pipa transformasi yang dapat diperluas
Ringkasan dan Langkah Selanjutnya
Persyaratan
- Pemahaman tentang pekerjaan data berbasis spreadsheet
- Pengalaman dengan tugas analisis data dasar
- Kenalan dengan format file umum seperti CSV dan Excel
Audience
- Profesional data yang perlu membersihkan dan mempersiapkan dataset
- Analis bisnis yang bertanggung jawab atas alur kerja data berulang
- Siapa pun yang terlibat dalam pelaporan data dan otomatisasi proses
10 Jam
Testimoni (5)
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Kursus - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Kursus - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.
Marco Iuliano
Kursus - Power BI Dashboards
Training adjust the training according to our needs and knowledge. He understood participants experience with Power BI.
Cristian Tudor - Gilbarco ACIS SRL
Kursus - Creating Dashboards Using Microsoft Power BI
Offering a more in-depth scope about Power BI more than any training institute that I came across to.
