Power BI Basic to Intermediate

Satu project, dari data mentah sampai dashboard.One project, from raw data to dashboard.

• Kelas grup, liveA live group class

  Belajar bersama peserta lain lewat Zoom, dengan demo langsung dari instruktur dan waktu untuk bertanya.Learn with other participants on Zoom, with live demos from the instructor and time for questions.

• Materi dan rekamanMaterials and recordings

  Materi dibagikan sebelum kelas dimulai, dan setiap pertemuan direkam, jadi bisa ditonton ulang kapan saja.Materials are shared before the class starts, and every meeting is recorded, so you can watch it again any time.

• Untuk pemulaFor beginners

  Cukup bisa Excel dasar. Tidak perlu pengalaman coding, SQL, atau statistik.Basic Excel is enough. No coding, SQL or statistics needed.

• Praktik duluHands-on first

  Lebih dari separuh waktu dipakai untuk demo dan praktik langsung, bukan teori.More than half the time goes to demos and hands-on practice, not theory.

• Satu dataset dari awal sampai akhirOne dataset, start to finish

  Data penjualan toko kopi fiktif Kopi Kita Nusantara: kopi, teh, alat seduh, dan snack, lewat Website, Marketplace, dan Toko Offline di beberapa kota Indonesia, Januari 2024 – Desember 2025.Sales data from a fictional coffee shop, Kopi Kita Nusantara: coffee, tea, brewing gear and snacks, sold through its website, marketplaces and offline stores in several Indonesian cities, January 2024 – December 2025.

• Dashboard sendiriYour own dashboard

  Hasil akhirnya satu Sales Performance Dashboard yang rapi dan interaktif, dibangun sendiri dari data mentah yang sengaja dibuat berantakan.You finish with a clean, interactive Sales Performance Dashboard, built yourself from raw data that is messy on purpose.

Dashboard akhir menjawab 5 pertanyaan bisnisThe final dashboard answers 5 business questions

1. Berapa total penjualan, gross profit, dan jumlah transaksi?What are total sales, gross profit and the number of transactions?
2. Bagaimana tren penjualan per bulan, dan bulan apa yang tertinggi dan terendah?How do sales trend by month, and which months are highest and lowest?
3. Kategori dan produk apa yang paling laku dan paling menguntungkan?Which categories and products sell best and are most profitable?
4. Channel mana yang kontribusinya paling besar?Which channel contributes the most?
5. Kota dan segmen pelanggan mana yang paling banyak membeli?Which cities and customer segments buy the most?

Setiap pertemuan menambah satu lapisan.Each meeting adds one layer.

Semua pertemuan memakai file project yang sama, sampai menjadi dashboard utuh di Pertemuan 6. Alurnya: Understand → Import → Clean → Transform → Model → Relate → Analyze → Visualize → Build Dashboard.Every meeting builds on the same project file, until it becomes a full dashboard in Meeting 6. The flow: Understand → Import → Clean → Transform → Model → Relate → Analyze → Visualize → Build Dashboard.

1. PertemuanMeeting 1

   Understand, Visualize & Import Pengenalan Power BI, visualisasi dasar, dan data sourceIntroduction to Power BI, basic visuals and data sources

   Interface Power BI Desktop; report, page, visual, dan model; workflow Power BI; memilih visual yang tepat (card, bar/column, line, table, slicer); struktur data tabular dan tipe data; import Excel dan CSV; raw data vs data siap analisis; data profiling; pengenalan Power Query Editor.The Power BI Desktop interface; reports, pages, visuals and the model; the Power BI workflow; choosing the right visual (card, bar/column, line, table, slicer); tabular data and data types; importing Excel and CSV; raw vs analysis-ready data; data profiling; an introduction to Power Query Editor.

2. PertemuanMeeting 2

   Clean & Transform Data cleaning dengan Power QueryData cleaning with Power Query

   Remove, rename, change type, null, duplicate, replace, filter; split dan merge column; custom column; merapikan Applied Steps; refresh.Remove, rename, change type, nulls, duplicates, replace, filter; split and merge columns; custom columns; tidying Applied Steps; refresh.

3. PertemuanMeeting 3

   Model, Relate & Analyze Data model, relationship, dan DAX dasarData model, relationships and basic DAX

   Fact vs dimension table; primary dan foreign key; relationship one-to-many; cardinality; calculated column vs measure; DAX dasar (SUM, AVERAGE, COUNT, DISTINCTCOUNT, MIN/MAX, IF, DIVIDE).Fact vs dimension tables; primary and foreign keys; one-to-many relationships; cardinality; calculated columns vs measures; basic DAX (SUM, AVERAGE, COUNT, DISTINCTCOUNT, MIN/MAX, IF, DIVIDE).

4. PertemuanMeeting 4

   Measures, Filtering & Visual Editing Measure KPI, filter, dan merapikan visualKPI measures, filtering and visual formatting

   Measure KPI (gross profit, margin %, rata-rata nilai transaksi, perbandingan antar periode); Filters pane (visual, page, report level), slicer, cross-filter dan edit interactions, drill-down, Top N; format pane, judul dinamis, conditional formatting, data label, tooltip, sorting.KPI measures (gross profit, margin %, average transaction value, period comparisons); the Filters pane (visual, page and report level), slicers, cross-filtering and edit interactions, drill-down, Top N; the format pane, dynamic titles, conditional formatting, data labels, tooltips, sorting.

5. PertemuanMeeting 5

   Build Dashboard I: Layout & Visuals Layout dashboard dan visual hierarchyDashboard layout and visual hierarchy

   Dashboard vs report; menentukan audience dan pertanyaan bisnis; layout dan visual hierarchy; formatting yang konsisten.Dashboards vs reports; deciding the audience and business questions; layout and visual hierarchy; consistent formatting.

6. PertemuanMeeting 6

   Build Dashboard II: Storytelling & Presentation Data storytelling dan presentasiData storytelling and presenting

   Merangkai semua bagian menjadi satu dashboard; data storytelling; presentasi dengan pola storytelling.Bringing every part into one dashboard; data storytelling; presenting with a storytelling pattern.

Seperti ini hasil yang bisa dibangun dengan Power BI: dari data mentah sampai dashboard yang interaktif.This is the kind of work Power BI makes possible: from raw data to an interactive dashboard.

Wajib: Power BI Desktop sudah ter-install dan bisa dibuka sebelum kelas dimulai. Instalasi dilakukan sendiri oleh peserta; tidak ada tutorial atau sesi bantuan instalasi, dan waktu kelas tidak dipakai untuk instalasi.Required: Power BI Desktop must be installed and opening before the class starts. Participants install it on their own; there is no installation tutorial or help session, and class time is not used for installing.

• Laptop/PC Windows 10 atau 11A Windows 10 or 11 laptop/PC. RAM minimal 4 GB (disarankan 8 GB) dan ruang kosong ± 3 GB. Power BI Desktop tidak tersedia untuk macOS; pengguna Mac perlu Windows lewat Parallels/VM atau meminjam laptop Windows.At least 4 GB of RAM (8 GB recommended) and about 3 GB free. Power BI Desktop is not available for macOS; Mac users need Windows through Parallels/a VM, or a borrowed Windows laptop.
• Power BI DesktopPower BI Desktop. Versi terbaru, gratis dari Microsoft Store atau situs Microsoft, sudah ter-install dan bisa dibuka sebelum Pertemuan 1. Akun Power BI Service berbayar tidak diperlukan.The latest version, free from the Microsoft Store or Microsoft website, installed and opening before Meeting 1. A paid Power BI Service account is not needed.
• Excel atau Google SheetsExcel or Google Sheets. Untuk membuka file dataset.To open the dataset files.
• ZoomZoom. Sudah ter-install. Dua layar (atau laptop + tablet/HP untuk Zoom) sangat membantu supaya bisa melihat demo sambil praktik.Installed beforehand. Two screens (or a laptop plus a tablet/phone for Zoom) help a lot, so you can watch the demo while you practise.
• Excel dasarBasic Excel. Bisa membuka file, filter, sort, dan memahami baris dan kolom.Opening files, filtering, sorting, and understanding rows and columns.

1. Isi formFill in the formPilih jadwal dan rencana bayar.Choose a schedule and payment plan.
2. Dihubungi via WhatsAppGet a WhatsApp messageMaksimal H+1 untuk pembayaran, lunas atau cicil 2×.Within one day (D+1) to arrange payment, in full or 2 instalments.
3. Masuk grup kelasJoin the class groupLink dikirim maksimal 1×24 jam setelah pembayaran diterima.The link is sent within 1×24 hours of payment.

Kuota 15 peserta per jadwal, ditambah 3 kursi waiting list. Data pendaftaran hanya dipakai untuk kelas ini.15 seats per schedule, plus 3 waiting-list seats. Registration details are used only for this class.