PENDAHULUAN DATA VISUALIZATION WITH POWER BI
Pelatihan Data Visualization With Power BI dirancang untuk membantu para profesional dalam memahami dan memanfaatkan Power BI untuk mengolah dan menyajikan data secara efektif. Peserta akan belajar cara membuat visualisasi data yang informatif dan menarik, yang dapat membantu dalam pengambilan keputusan bisnis yang lebih baik. Melalui pelatihan ini, peserta akan diberikan pemahaman mendalam tentang fitur-fitur Power BI serta teknik terbaik dalam mendesain dashboard yang interaktif.
Baca Juga: Pelatihan Analis Kebijakan BNSP Online PT Duta Mandiri Training Sukses Digelar 28-29 April 2025
Pelatihan ini tidak hanya menekankan pada aspek teknis, tetapi juga pada strategi dan praktik terbaik dalam analisis data. Dengan mengikuti pelatihan ini, peserta diharapkan mampu mengubah data mentah menjadi informasi yang dapat ditindaklanjuti, serta mengkomunikasikan temuan mereka kepada pemangku kepentingan dengan cara yang jelas dan efektif.
MATERI
- Module 1: Overview and Introduction to Power BI
- Introduction to Power BI
- Advantages of Using Power BI
- Power BI Desktop vs. Power BI Web
- Module 2: Getting Started with Power BI Desktop
- Installation and Setup
- Introduction to Power BI Desktop
- Connecting to Data
- Importing data from files (Excel, CSV).
- Connecting to databases and cloud services.
- Data source configuration and management.
- Module 3: Data Transformation and Shaping
- Transforming Data
- Understanding the Power Query Editor.
- Cleaning and transforming data: removing duplicates, handling missing data, etc.
- Shaping Data
- Merging and appending queries.
- Creating calculated columns and measures.
- Data modeling basics: relationships, hierarchies, and more.
- Data Integration
- Combining data from multiple sources.
- Introduction to DAX (Data Analysis Expressions) for data transformation.
- Transforming Data
- Module 4: Data Modeling and Calculations
- Creating a Data Model
- Building relationships between tables.
- Understanding primary and foreign keys.
- Advanced Calculations
- Using DAX for complex calculations.
- Creating calculated tables and columns.
- Time intelligence functions in DAX.
- Optimization Techniques
- Best practices for efficient data models.
- Performance optimization tips.
- Creating a Data Model
- Module 5: Reports and Visualization
- Basic Reports and Visualizations
- Creating basic charts, tables, and matrices.
- Using visualizations like line charts, bar charts, and pie charts.
- Interactive Visualizations
- Adding interactivity with slicers, filters, and drill-downs.
- Navigating reports with filters and drill features.
- Advanced Visualizations
- Using custom visuals and themes.
- Data storytelling with Power BI reports.
- Data Visualization Best Practices
- Principles of effective data visualization.
- Avoiding common visualization pitfalls.
- Basic Reports and Visualizations
- Module 6: Dashboards and Sharing
- Building Dashboards
- Creating and customizing dashboards in Power BI.
- Combining visuals from different reports.
- Using tiles, KPIs, and gauges.
- Sharing and Collaboration
- Saving and publishing reports to Power BI Service.
- Sharing dashboards with colleagues and stakeholders.
- Managing permissions and data security.
- Direct Query and Live Connections
- Creating Power BI reports by connecting to real-time data sources and applications.
- Building Dashboards
Waktu & Tempat
No | Bulan | Minggu | Tempat Pelaksanaan | ||||
I | II | III | IV | V | |||
1 | Januari | 2 – 3 | 7 -8 | 14 – 15 | 21 – 22 | 30 – 31 | Bali, Batam, Balikpapan, Manado atau Lombok, Bandung, Medan, Jakarta, Surabaya, Solo, Semarang atau Yogyakarta |
2 | Februari | 4- 5 | 11 – 12 | 18 – 19 | 25 – 26 | ||
3 | Maret | 4- 5 | 11 – 12 | 18 – 19 | |||
4 | April | 8 – 9 | 15 – 16 | 22 – 23 | 29 – 30 | ||
5 | Mei | 6 – 7 | 13 – 14 | 20 – 21 | 27 – 28 | ||
6 | Juni | 3 – 4 | 10 – 11 | 17 – 18 | 24 – 25 | ||
7 | Juli | 1 – 2 | 8 – 9 | 15 – 16 | 22 – 23 | 29 – 30 | |
8 | Agustus | 5 – 6 | 12 – 13 | 19 – 20 | 26 – 27 | ||
9 | September | 2 – 3 | 9 – 10 | 16 -17 | 23 – 24 | 30 Sep – 1Okt | |
10 | Oktober | 7 – 8 | 14 – 15 | 21 – 22 | 28 – 29 | ||
11 | November | 4 – 5 | 11 – 12 | 18 – 19 | 25 – 26 | ||
12 | Desember | 2 – 3 | 9 – 10 | 16 – 17 | 23 – 24 | 30-31 |
Investasi & Fasilitas
- Online Training
- Rp. 4.800.000/ Peserta (Durasi 6 Jam /Hari selama 2 hari)
- Fasilitas: Certificate dan Materi (Softfile dan Hardfile)
- Offline Training
- Rp. 6.800.000/ Peserta, untuk lokasi Yogyakarta (Non Residential)
- Rp. 7.800.000/ Peserta, untuk lokasi di Bandung, Jakarta atau Surabaya (Non Residential) minimal 2 peserta terdaftar
- Rp. 8.800.000/ Peserta, untuk lokasi di Bali, Batam, Balikpapan, Manado atau Lombok (Non Residential) minimal 3 peserta terdaftar
- Fasilitas: Certificate, Training kits, Lunch, Coffee Break, Souvenir
- Bagi peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel khusus bagi perusahaan yang mengirimkan minimal 3 orang peserta)
Instruktur
Tim Instruktur