Data Analytics with SQL & Business Intelligence
A hands-on analytics course that takes participants from raw data to dashboard. Students write SQL confidently, clean and explore data with Python and Pandas, and build interactive business intelligence dashboards. The emphasis is on answering real business questions and communicating findings, making it suitable for analysts, operations staff, and career switchers.
Dipercaya oleh Perusahaan Terkemuka
Tentang Kursus Ini
A hands-on analytics course that takes participants from raw data to dashboard. Students write SQL confidently, clean and explore data with Python and Pandas, and build interactive business intelligence dashboards. The emphasis is on answering real business questions and communicating findings, making it suitable for analysts, operations staff, and career switchers.
Silabus Kursus
01 Data Literacy & Analytical Thinking
Data Literacy & Analytical Thinking
- Types of data, metrics vs KPIs, and framing the right question.
- Common analytical pitfalls and how to spot misleading charts.
- Mapping business questions to data sources.
- Mini Project: Translate a business brief into a measurable analytics plan.
02 SQL Fundamentals
SQL Fundamentals
- SELECT, filtering, sorting, and limiting results.
- Aggregations with GROUP BY and HAVING.
- Working with dates, text, and conditional logic.
- Mini Project: Answer ten business questions from a transactional database.
03 Advanced SQL for Analysis
Advanced SQL for Analysis
- Joins across multiple tables and relationship models.
- Subqueries and Common Table Expressions (CTEs).
- Window functions for ranking, running totals, and cohorts.
- Mini Project: Build a monthly retention and revenue cohort query.
04 Data Cleaning & Exploration with Python
Data Cleaning & Exploration with Python
- Pandas DataFrames: loading, selecting, and transforming.
- Handling missing values, duplicates, and type conversion.
- Exploratory data analysis and quick summary statistics.
- Mini Project: Clean a messy sales dataset and document every transformation.
05 Business Intelligence & Dashboard Design
Business Intelligence & Dashboard Design
- Data modeling basics: facts, dimensions, and star schema.
- Choosing the right chart for the question.
- Building an interactive dashboard in Power BI or Looker Studio.
- Mini Project: Create a one-page executive sales dashboard with filters.
06 Statistics for Decision Making
Statistics for Decision Making
- Distributions, averages, and variability.
- Correlation vs causation and sampling bias.
- A/B testing basics and reading experiment results.
- Mini Project: Evaluate a marketing experiment and recommend a decision.
07 Capstone & Data Storytelling
Capstone & Data Storytelling
- Structuring an insight narrative for non-technical stakeholders.
- Executive summaries and recommendation writing.
- Presenting dashboards and defending assumptions.
- Capstone Project: Deliver an end-to-end analytics case with dashboard and insight memo.
Proyek Akhir
Sales Performance Analytics Dashboard
Students build a complete analytics deliverable: from SQL extraction and cleaning through a business-ready dashboard and a written recommendation memo.
Mengapa Memilih Training Korporasi?
Program training yang disesuaikan dengan kebutuhan tim dan organisasi Anda
Diskon Tim
Dapatkan harga khusus untuk pendaftaran grup. Semakin banyak peserta, semakin besar diskonnya.
Kurikulum Kustom
Materi training dapat disesuaikan dengan kebutuhan spesifik tim dan proyek perusahaan Anda.
Jadwal Fleksibel
Pilih waktu training yang sesuai dengan tim Anda: hari kerja, akhir pekan, atau sesi khusus di kantor Anda.
Sertifikat Resmi
Semua peserta menerima sertifikat profesional setelah menyelesaikan training.
Dukungan Pasca-Training
Dapatkan akses konsultasi gratis selama 30 hari setelah training untuk memastikan implementasi yang sukses.
Proyek Nyata
Peserta akan mengerjakan proyek nyata yang dapat segera diterapkan di lingkungan kerja mereka.
Butuh program training yang disesuaikan untuk tim Anda?
Minta Penawaran KorporasiDipercaya oleh Perusahaan Terkemuka
Lihat apa yang dikatakan klien korporasi kami tentang program training kami
Pertanyaan yang Sering Diajukan
Temukan jawaban untuk pertanyaan umum tentang program training kami
Ya, kami menyediakan opsi training online (remote), offline (di kantor Anda, khusus korporasi), atau hybrid berdasarkan kebutuhan tim Anda. Semua format mendapatkan materi dan sertifikat yang sama.
Kami menawarkan tiga format. Privat 1-on-1 selalu tersedia dan dapat dimulai kapan saja untuk 1 orang. Grup Kecil adalah kelas berisi 2-4 orang dengan harga per peserta. Perusahaan adalah batch tim berisi 6-8 orang dengan satu harga per batch yang transparan — semakin banyak peserta, semakin hemat per orang (mulai hemat di 6 peserta, hingga 25% di 8 peserta). Untuk tim di luar rentang ini, silakan hubungi kami untuk penawaran khusus.
Tentu saja. Kami menawarkan layanan kurikulum kustom di mana materi dapat disesuaikan dengan tumpukan teknologi, proyek aktif, dan kebutuhan spesifik tim Anda.
Privat 1-on-1 adalah opsi premium kami (selalu tersedia, harga tertinggi). Grup Kecil (2-4 orang) lebih terjangkau per peserta. Training Perusahaan dihargai per batch untuk tim 6-8 orang dengan harga awal yang transparan — hemat hingga 25% per orang di batch penuh. Untuk tim yang lebih besar, hubungi kami untuk penawaran khusus.
Durasi training bervariasi tergantung materi. Untuk training korporasi, jadwal dapat disesuaikan dengan kebutuhan tim Anda - hari kerja, akhir pekan, atau jadwal kustom.
Ya, semua peserta yang menyelesaikan training akan mendapatkan sertifikat resmi dari Rumah Coding. Sertifikat digital dapat diverifikasi secara online.
Tentu. Kami menyediakan dukungan konsultasi gratis selama 30 hari setelah training untuk membantu implementasi. Peserta juga mendapatkan akses ke komunitas eksklusif dan materi rekaman training.
Masih punya pertanyaan?
Hubungi Tim KamiKursus Terkait
Python Fundamentals
Master the fundamentals of Python through hands-on, real-world projects. Designed for absolute beginners, this course takes you from writing your first line of code to building a fully functional application. By the end of this course, you will have a solid grasp of core programming concepts, data structures, and file management, laying a strong foundation for future studies in Data Science, Web Development, or Automation.
LLM Bootcamp
This project-based bootcamp is designed for beginners to dive practically into the world of Large Language Models (LLMs). Through hands-on building, you will learn how to interact with top-tier AI APIs, master prompt engineering, orchestrate complex workflows using LangChain, and implement Retrieval-Augmented Generation (RAG) to query your own documents. By the end of this course, you will have the skills to build, test, and deploy a fully functional, custom AI web application.
Object Detection and Tracking with YOLO
Dive into the world of computer vision with this beginner-friendly, project-based course. Learn how to leverage the powerful YOLO (You Only Look Once) architecture to build real-time AI applications from scratch. Through hands-on exercises, you will master everything from running pre-trained models and creating custom datasets to implementing robust object tracking. By the end of this journey, you will have the practical skills to build and deploy your own intelligent vision systems.
Data Science with Python
Master the art of data analysis, visualization, and predictive modeling.
Harga & Pilihan Format
Pilih format belajar yang paling sesuai untuk Anda
Privat (1-on-1)
Selalu tersedia · eksklusif satu-satu, mulai kapan saja
/peserta
Grup Kecil
Kelas kecil 2-4 orang
/peserta
Perusahaan
Harga batch transparan untuk tim
Mulai dari Rp 24.000.000
/batch
Detail Program
- 3 hari × 6 jam · 09:00 - 16:00
- Total 18 jam
- 2/minggu × 60 menit/sesi
- 18 Sesi langsung · Total 18 jam
- ±9 minggu dengan ritme ini