BI Bytes With Me

About BIBytesWithMe

Data Analytics made simple & practical

Hi, I'm Aini — the trainer behind BIBytesWithMe - Power BI user since 2019 and experienced Data Analytics Consultant. I've helped organizations turn raw data into clear, meaningful insights and interactive dashboards.

Now I want to share those same skills with you - through a hands-on, step-by-step style that works even if you have zero IT background.

Power BI Data Analytics Dashboard Design DAX Data Storytelling

Build a real dashboard in your very first class Not a drill - by the end of session one you'll have a working Power BI report built from real data.

Real tips from real client projects Every example comes from actual consultant work - no textbook fluff, just skills you can use immediately.

Telegram group support included Your learning doesn't stop when class ends. Get ongoing support in a dedicated group after every session.

Level 1 · Beginner Friendly

Power BI Essential

No IT background? No problem. If you can use Excel, you can learn Power BI. We practice together every step of the way — and by the end of class, you will have your very first dashboard or report ready.

RM 50

Group class · 4 to 6 students only 3.5 hours · 9:00am – 12:30pm · Session recording provided
No pre-requisite needed · Absolute beginners welcome

Module 1

Power BI Introduction and Interface

What Power BI is and why it is widely used in the workplace
Understanding the three main views - Report, Data and Model
Navigating the interface comfortably from your very first session

Module 2

Data Sources and Connectivity

Connecting Power BI to Excel, CSV and other common file types
Understanding how data flows from source into your report
Tips for working with different file structures and formats

Module 3

Data Transformation and Cleaning

Why data cleaning is the most important step before building anything
Using Power Query to remove errors, fix formats and reshape data
Hands-on practice with real-world style messy datasets
Common data problems and how to fix them step by step

Module 4

Introduction to DAX

What DAX is and when you need it
Writing your first simple measures and calculated columns
Using DAX to answer basic business questions with your data

Module 5

Creating Visualizations and Choosing the Right Charts

Overview of chart types and when to use each one
Building bar charts, line charts, cards, tables and more
Formatting visuals to look clean and professional
Understanding the difference between a report and a dashboard

Module 6

Interactivity, Storytelling and Your First Dashboard

Adding slicers, filters and drilldowns for dynamic reports
How to present your findings clearly to others
Putting it all together - build your first complete dashboard in class
Practical tips and best practices from real project experience

What You Will Walk Away With

Your first working Power BI dashboard or report

Confidence to clean and connect your own data

Skills you can apply at work immediately

Session recording to revisit anytime

Telegram group support after class

Practical tips from real consultant projects

Perfect For

Complete beginners with zero Power BI experience
Non-IT professionals who work with data in Excel
Anyone who wants to turn spreadsheets into visual reports
Business users who need to present data more clearly
Students or career changers exploring data analytics

Why This Class?

✓ IT and non-IT friendly - we learn together at the same pace
✓ Strong focus on data cleaning before building anything
✓ Small group of 4 to 6 - everyone learns together at the same pace
✓ You build a real dashboard in class - not just watch
✓ Session recording provided so you never miss anything

Portfolio

Sample Dashboards

Coffee Shop AnalyticsVideo below

Brewed for Business

Sales patterns, customer preferences and revenue trends across 3,547 transactions. 8 coffee types, RM 112K total revenue. Dataset sourced from Kaggle.

Store Sales ReportVideo below

XYZ Store Sales Insights 2025

$1M revenue with 18.75% growth, regional breakdown across 4 areas and month-on-month growth tracking. Mock data generated with Python.

HR Analytics

HR Dashboard - Headcount & Attrition

Employee turnover analysis with active/inactive trends, tenure breakdown and department-level turnover rates.

Education Analytics

DMZ College Student Enrollment

Enrollment by course, faculty, gender and nationality with scholarship tracking and student status breakdown.

All dashboards built in Microsoft Power BI · Mix of Kaggle datasets, Python-generated mock data and real client projects

Level 2 · New Course

Power BI: Data Modelling & DAX

Level up from basics to professional - master the skills that separate analysts from beginners.

RM 90

Alumni price: RM 80 4 hours · 9:00am – 1:00pm · Max 5 students · Session recording provided
Pre-requisite: Basic Power BI or Essential class completed

Module 1

Professional Data Modelling

Star Schema Design - fact and dimension tables done right
Real-World Evolution - handle multiple fact tables (Sales + Returns)
Date Table Mastery - the critical foundation for time analysis
Relationship Best Practices - one-to-many, filter direction, troubleshooting
Cross-Fact Analysis - connect multiple transaction types seamlessly

Module 2

Essential DAX Formulas

Measures vs Columns - know when to use which (critical!)
CALCULATE Function - the most powerful DAX tool for dynamic filtering
Time Intelligence - YTD, Last Year, Growth % and trend analysis
Business Calculations - % of Total, Rankings, Running Totals
Error Handling - common mistakes and how to fix them

Module 3

Hands-On Dashboard Lab

Build a complete analytics dashboard - KPIs, trends, insights
Cross-Fact Analysis - return rates, net sales, problem identification
Professional Presentation - design principles for executive dashboards

What You'll Walk Away With

Properly modelled data that performs fast

Confidence writing essential DAX formulas

A complete dashboard for your portfolio

Session recording to revisit anytime

DAX formula cheat sheet

Practice datasets & reference materials

Perfect For

Essential course alumni ready for the next level
Data analysts wanting to improve modelling skills
Business professionals building complex dashboards
Career changers targeting analyst roles
Anyone struggling with DAX formulas

Why This Course?

✓ Real-world scenarios - not just theory
✓ Business-focused DAX - every formula answers a real question
✓ Max 5 students - live instruction, real-time Q&A
✓ Malaysian context - KL, Selangor, Raya trends as examples

All Training Options

Choose Your Path

Beginner

Power BI Essential

RM 50

Build your first real dashboard from scratch. No IT background needed.

4–6 students per session
Interface, data & visualizations
Introduction to DAX
Telegram support included

Intermediate · New

Data Modelling & DAX

RM 90

Star schema, CALCULATE, time intelligence & executive dashboards.

Max 5 students
4 hours intensive
3 hands-on modules

Flexible

1-on-1 Personalized

Fully customized sessions built around your goals and your own data.

Your data, your pace
Immediate feedback
Session recording provided
Schedule anytime

Enquire →

From Past Students

What Students Say

1-on-1 Session

After just 1 session with BIBytesWithMe —

I started with zero knowledge. Could not even log in to Power BI. After the session, I spent 2 hours practicing that night. The next morning my boss was so happy because our report is now live. Basically from zero knowledge, but in front of my team I look like expert!

Lesson learned: even if you are good at your work, if you don't know how to properly report, you still look fail.

Ffa***i 1-on-1 Student · Applied skills next day at work

Trainer is very resourceful and patient to help participants.

Past Student Power BI Essential Class

The bonus tips and guidance on creating dashboards were so useful!

Past Student Power BI Essential Class

Great introduction to Power BI. I found it gave me a good overview of how Power BI can be used to analyze data and create dashboards.

Past Student Power BI Essential Class

You cover the theory part in an interesting way that helped me understand the reason behind all the analysis. I love this class!

Past Student Power BI Essential Class

Thank you very much everyone, it was a good sharing. I will continue to explore and apply to my work.

Sky**** Past Student · Power BI Essential Class

Based on feedback from group class and 1-on-1 sessions

See It In Action

Dashboard Demos

Short walkthroughs of real dashboards built in class.

Coffee Shop Analytics

Brewed for Business

Sales patterns, customer preferences and revenue trends across 3,547 transactions. Dataset from Kaggle.

Store Sales Report

XYZ Store Sales Insights 2025

$1M revenue overview with regional breakdown, category analysis and MoM growth tracking. Mock data generated with Python.

Turn Data
Into Insight.

Data Analytics made simple & practical