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.
Trusted by Leading Companies
About This Course
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.
Course Syllabus
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.
Capstone Project
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.
Why Choose Corporate Training?
Training programs tailored to your team and organization's needs
Team Discounts
Get special pricing for group registrations. The more participants, the bigger the discount.
Custom Curriculum
Training materials can be tailored to your team's specific needs and company projects.
Flexible Schedule
Choose training times that suit your team: weekday, weekend, or special sessions at your office.
Official Certificate
All participants receive a professional certificate upon completion.
Post-Training Support
Get free consultation access for 30 days after training to ensure successful implementation.
Real Projects
Participants will work on real-world projects that can be immediately applied in their work environment.
Need a customized training program for your team?
Request Corporate QuoteTrusted by Leading Companies
See what our corporate clients say about our training programs
Frequently Asked Questions
Find answers to common questions about our training programs
Yes, we provide online (remote), offline (at your office, for corporate only), or hybrid training options based on your team's needs. All formats receive the same materials and certificates.
We offer three formats. Private 1-on-1 is always available and can start anytime for one person. Small Group is a class of 2-4 people priced per participant. Company is a team batch of 6-8 people at one transparent per-batch price — the more participants, the more you save per person (savings start at 6 participants, up to 25% at 8). For teams outside this range, contact us for a custom quote.
Absolutely. We offer custom curriculum services where materials can be tailored to your technology stack, active projects, and your team's specific needs.
Private 1-on-1 is our premium option (always available, highest price). Small Group (2-4 people) is more affordable per participant. Company training is priced per batch for teams of 6-8 with a transparent starting price — save up to 25% per person on a full batch. For larger teams, contact us for a custom quote.
Training duration varies depending on the material. For corporate training, schedules can be customized to your team's needs - weekday, weekend, or custom schedules.
Yes, all participants who complete the training will receive an official certificate from Rumah Coding. Digital certificates can be verified online.
Of course. We provide free consultation support for 30 days after training to help with implementation. Participants also get access to our exclusive community and training recording materials.
Still have questions?
Contact Our TeamRelated Courses
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.
Investment & Learning Format
Choose the learning format that fits you best
Private (1-on-1)
Always available · exclusive one-on-one, start anytime
/participant
Small Group
Small class of 2-4 people
/participant
Company
Transparent batch price for teams
From Rp 24.000.000
/batch
Program Details
- 3 days × 6 hours · 09:00 - 16:00
- Total 18 hours
- 2/week × 60 min/session
- 18 Live sessions · Total 18 hours
- ±9 weeks at this pace