Interactive Mentor-Led Cohorts

(02) 8902 0900contact@aumtrend.comWhatsApp / Viber
AUM Training
HomeCourses
Who We Serve
About UsContact
LMS Portal
JOB-READY SQL & BI (50H)
50 Hours (25 Days × 2 Hours)
View Full Curriculum

Data Analyst - Job Ready

Master the complete analyst workflow: clean and prepare messy data using Excel & Power Query, query databases with MySQL joins and window functions, apply statistical methods, and build interactive dashboards with DAX in Power BI.

Live Interactive Syllabus
50 Hours (25 Days × 2 Hours)
•
Instructor-Led Online
•
25 Hands-on Coding Labs
What you'll master in Level 3
Target Competency Outcome

Master the complete analyst workflow: clean and prepare messy data using Excel & Power Query, query databases with MySQL joins and window functions, apply statistical methods, and build interactive dashboards with DAX in Power BI.

Training Objectives & Core Deliverables

Clean and prepare messy data using Excel, Power Query and SQL

Use Excel formulas, lookups (XLOOKUP, INDEX-MATCH), pivot tables and Power Query for fast, accurate analysis

Apply statistics (averages, spread, correlation, hypothesis tests, A/B tests) and read results correctly

Write SQL queries with joins, grouping, subqueries, CTEs and window functions to answer business questions

Build a star-schema data model and interactive dashboard in Power BI using DAX measures and time intelligence

Present findings as a clear business story for managers and deliver an end-to-end portfolio capstone project

Day-by-Day Training Schedule & Live Labs
25 Live Sessions • 100% Hands-on
Day 1
What is data analytics? (Foundations & Setup)
Live Session
Topics Explored:
Data analyst vs data engineer vs data scientist
Types of analytics: descriptive, diagnostic, predictive, prescriptive
The analytics workflow and how to turn a business problem into a data question
Types of data: structured, semi-structured, unstructured
Tool setup: Power BI Desktop and MySQL Workbench
Hands-on Lab Exercise

Set up all tools. Take a business question (for example, why are loan defaults rising?) and list the data you would need to answer it.

Day 2
Excel essentials for analysts
Live Session
Topics Explored:
Data entry best practices, Excel tables, sorting and filtering
Number, date and text formats
Core formulas and relative vs absolute references
Conditional formatting
Hands-on Lab Exercise

Format and explore a sales dataset, highlight top and bottom performers.

Day 3
Data cleaning and text/date functions
Live Session
Topics Explored:
Remove duplicates, TRIM, CLEAN, LEFT, RIGHT, MID, TEXTJOIN
Text to Columns and Flash Fill
Date functions and data validation
Hands-on Lab Exercise

Clean a messy customer or loan list with mixed formats and duplicates.

Day 4
Logical and conditional functions
Live Session
Topics Explored:
IF, IFS, AND, OR
COUNTIFS, SUMIFS, AVERAGEIFS
Building summary tables with conditional formulas
Hands-on Lab Exercise

Build a branch-wise summary report using conditional totals.

Day 5
Lookups and combining tables
Live Session
Topics Explored:
VLOOKUP, XLOOKUP, INDEX-MATCH
Handling errors with IFERROR
Combining data from two or more tables
Hands-on Lab Exercise

Combine a transactions sheet with customer and product lists using lookups.

Day 6
Pivot tables and charts
Live Session
Topics Explored:
Pivot tables, grouping, calculated fields
Slicers and timelines
Pivot charts, and choosing the right chart type
Hands-on Lab Exercise

Create a region-wise and month-wise sales analysis with pivots and charts.

Day 7
Power Query and Excel dashboards (Mini Project 1)
Live Session
Topics Explored:
Power Query: import, transform, merge and append data
Designing a one-page Excel dashboard with slicers
Mini Project 1: one-page Excel dashboard on a sales or HR dataset
Hands-on Lab Exercise

Build and present Mini Project 1: a one-page Excel dashboard with pivots, charts and key statistics on a sales or HR dataset.

Day 8
Descriptive statistics and distributions
Live Session
Topics Explored:
Mean, median, mode, range, variance and standard deviation
Quartiles, percentiles and outliers
The normal distribution (intuition)
Statistics functions and the Analysis ToolPak in Excel
Hands-on Lab Exercise

Describe and compare the salary or loan amount distribution across groups, and flag outliers.

Day 9
Correlation, hypothesis testing and A/B tests
Live Session
Topics Explored:
Correlation vs causation
Samples and confidence intervals (intuition)
Null and alternative hypotheses, p-values, t-test in Excel
Reading an A/B test result
Hands-on Lab Exercise

Test whether two branches or two campaign groups differ significantly, and write the conclusion in plain language.

Day 10
Database basics and querying
Live Session
Topics Explored:
Relational databases, tables, primary and foreign keys
Connecting to MySQL
SELECT, WHERE, ORDER BY, LIMIT, DISTINCT
IN, BETWEEN, LIKE and handling NULL values
Hands-on Lab Exercise

Query a customers and orders database to answer simple business questions.

Day 11
Aggregation and joins
Live Session
Topics Explored:
COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING
INNER, LEFT and RIGHT joins, joining multiple tables
Hands-on Lab Exercise

Produce branch-wise and product-wise reports by joining 3 tables.

Day 12
Subqueries, CTEs and CASE
Live Session
Topics Explored:
Subqueries and CTEs
CASE WHEN for segmentation
Date and string functions, UNION
Hands-on Lab Exercise

Segment customers into groups and calculate month-wise trends.

Day 13
Window functions
Live Session
Topics Explored:
ROW_NUMBER, RANK, running totals, LAG and LEAD
Views, and writing clean, readable queries
Hands-on Lab Exercise

Rank products within categories and calculate month-on-month change.

Day 14
SQL project and SQL with Excel and Power BI (Mini Project 2)
Live Session
Topics Explored:
Solving business questions end to end
Exporting query results to Excel
Connecting Power BI to a SQL database (preview)
Mini Project 2: answer 10 business questions using SQL
Hands-on Lab Exercise

Build Mini Project 2: execute and document a set of 10 business questions answered with production SQL queries, including multi-table joins and window functions.

Day 15
Power BI introduction and data loading
Live Session
Topics Explored:
Power BI Desktop interface
Connecting to Excel, CSV and SQL data
Power Query Editor: cleaning and transforming data
Data types and common errors
Hands-on Lab Exercise

Load and clean a multi-file sales dataset in Power BI Desktop.

Day 16
Data modelling
Live Session
Topics Explored:
Relationships between tables, cardinality, filter direction
Star schema: fact and dimension tables
Building a date table
Hands-on Lab Exercise

Build an enterprise data model with 3 to 4 related tables and a dedicated date calendar.

Day 17
DAX fundamentals
Live Session
Topics Explored:
Calculated columns vs measures
SUM, COUNT, DISTINCTCOUNT, DIVIDE
Introduction to CALCULATE and FILTER
Hands-on Lab Exercise

Create core KPI measures such as total sales, average order value (AOV), and profit margin.

Day 18
DAX time intelligence
Live Session
Topics Explored:
CALCULATE with filters, ALL and ALLSELECTED
Year to date (YTD), previous year and month-on-month growth
Ranking and Top N measures
Hands-on Lab Exercise

Create growth % and year-to-date measures and test them in an interactive matrix visual.

Day 19
Visualisation and report design
Live Session
Topics Explored:
Choosing visuals: cards, bar, line, matrix, maps
Slicers, filters and formatting
Colour, layout and storytelling principles
Hands-on Lab Exercise

Design a clean, two-page interactive report with unified typography and palettes.

Day 20
Interactivity, publishing and sharing
Live Session
Topics Explored:
Drill-down, drill-through, tooltips and bookmarks
Power BI Service overview, workspaces and publishing
Refresh basics, sharing options and introduction to row-level security
Hands-on Lab Exercise

Add drill-through and bookmarks to the report and publish it to the Power BI Service workspace.

Day 21
Power BI project (Mini Project 3)
Live Session
Topics Explored:
Building a complete dashboard from a SQL or Excel data model
Reviewing layout, measures and accuracy
Peer and instructor feedback
Mini Project 3: interactive business dashboard, published and explained
Hands-on Lab Exercise

Build and present Mini Project 3: an interactive Power BI business dashboard with star-schema data model, dynamic DAX measures, and slicers.

Day 22
Capstone kick-off and data preparation
Live Session
Topics Explored:
Project brief and dataset shared by the instructor
Defining key business questions and analytical roadmap
Clean and prepare data using SQL or Excel
Hands-on Lab Exercise

Learners clean the raw capstone dataset and document their structured question list with mentor support.

Day 23
Capstone: data model and measures
Live Session
Topics Explored:
Load data into Power BI and build the relational data model
Create dynamic DAX measures for the primary business metrics
Checking numbers and reconciling data against SQL or Excel
Hands-on Lab Exercise

Learners build the multi-table model and calculated measures with mentor code reviews.

Day 24
Capstone: dashboard and insights
Live Session
Topics Explored:
Design executive dashboard pages with user-friendly navigation
Write 5 to 7 key business insights and strategic recommendations
Prepare a short executive presentation deck
Hands-on Lab Exercise

Learners finalize the dashboard visual hierarchy and draft actionable business insights.

Day 25
Presentations, portfolio and career prep
Live Session
Topics Explored:
Capstone project presentations and live defense feedback
Building an analyst portfolio and crafting impact points for resume
LinkedIn profile optimization tips for data analyst roles
Common interview questions: Excel, SQL, Power BI and scenario-based case studies
Next learning paths: Advanced with Python, Data Science and Data Engineering
Hands-on Lab Exercise

Present the capstone project, receive panel feedback, and finalize GitHub / LinkedIn portfolio items.

Detailed Module-wise Curriculum
25 Modules

Data analyst vs data engineer vs data scientist

Types of analytics: descriptive, diagnostic, predictive, prescriptive

The analytics workflow and how to turn a business problem into a data question

Types of data: structured, semi-structured, unstructured

Tool setup: Power BI Desktop and MySQL Workbench

Lab Practical: Set up all tools. Take a business question (for example, why are loan defaults rising?) and list the data you would need to answer it.

Data entry best practices, Excel tables, sorting and filtering

Number, date and text formats

Core formulas and relative vs absolute references

Conditional formatting

Lab Practical: Format and explore a sales dataset, highlight top and bottom performers.

Remove duplicates, TRIM, CLEAN, LEFT, RIGHT, MID, TEXTJOIN

Text to Columns and Flash Fill

Date functions and data validation

Lab Practical: Clean a messy customer or loan list with mixed formats and duplicates.

IF, IFS, AND, OR

COUNTIFS, SUMIFS, AVERAGEIFS

Building summary tables with conditional formulas

Lab Practical: Build a branch-wise summary report using conditional totals.

VLOOKUP, XLOOKUP, INDEX-MATCH

Handling errors with IFERROR

Combining data from two or more tables

Lab Practical: Combine a transactions sheet with customer and product lists using lookups.

Pivot tables, grouping, calculated fields

Slicers and timelines

Pivot charts, and choosing the right chart type

Lab Practical: Create a region-wise and month-wise sales analysis with pivots and charts.

Power Query: import, transform, merge and append data

Designing a one-page Excel dashboard with slicers

Mini Project 1: one-page Excel dashboard on a sales or HR dataset

Lab Practical: Build and present Mini Project 1: a one-page Excel dashboard with pivots, charts and key statistics on a sales or HR dataset.

Mean, median, mode, range, variance and standard deviation

Quartiles, percentiles and outliers

The normal distribution (intuition)

Statistics functions and the Analysis ToolPak in Excel

Lab Practical: Describe and compare the salary or loan amount distribution across groups, and flag outliers.

Correlation vs causation

Samples and confidence intervals (intuition)

Null and alternative hypotheses, p-values, t-test in Excel

Reading an A/B test result

Lab Practical: Test whether two branches or two campaign groups differ significantly, and write the conclusion in plain language.

Relational databases, tables, primary and foreign keys

Connecting to MySQL

SELECT, WHERE, ORDER BY, LIMIT, DISTINCT

IN, BETWEEN, LIKE and handling NULL values

Lab Practical: Query a customers and orders database to answer simple business questions.

COUNT, SUM, AVG, MIN, MAX

GROUP BY and HAVING

INNER, LEFT and RIGHT joins, joining multiple tables

Lab Practical: Produce branch-wise and product-wise reports by joining 3 tables.

Subqueries and CTEs

CASE WHEN for segmentation

Date and string functions, UNION

Lab Practical: Segment customers into groups and calculate month-wise trends.

ROW_NUMBER, RANK, running totals, LAG and LEAD

Views, and writing clean, readable queries

Lab Practical: Rank products within categories and calculate month-on-month change.

Solving business questions end to end

Exporting query results to Excel

Connecting Power BI to a SQL database (preview)

Mini Project 2: answer 10 business questions using SQL

Lab Practical: Build Mini Project 2: execute and document a set of 10 business questions answered with production SQL queries, including multi-table joins and window functions.

Power BI Desktop interface

Connecting to Excel, CSV and SQL data

Power Query Editor: cleaning and transforming data

Data types and common errors

Lab Practical: Load and clean a multi-file sales dataset in Power BI Desktop.

Relationships between tables, cardinality, filter direction

Star schema: fact and dimension tables

Building a date table

Lab Practical: Build an enterprise data model with 3 to 4 related tables and a dedicated date calendar.

Calculated columns vs measures

SUM, COUNT, DISTINCTCOUNT, DIVIDE

Introduction to CALCULATE and FILTER

Lab Practical: Create core KPI measures such as total sales, average order value (AOV), and profit margin.

CALCULATE with filters, ALL and ALLSELECTED

Year to date (YTD), previous year and month-on-month growth

Ranking and Top N measures

Lab Practical: Create growth % and year-to-date measures and test them in an interactive matrix visual.

Choosing visuals: cards, bar, line, matrix, maps

Slicers, filters and formatting

Colour, layout and storytelling principles

Lab Practical: Design a clean, two-page interactive report with unified typography and palettes.

Drill-down, drill-through, tooltips and bookmarks

Power BI Service overview, workspaces and publishing

Refresh basics, sharing options and introduction to row-level security

Lab Practical: Add drill-through and bookmarks to the report and publish it to the Power BI Service workspace.

Building a complete dashboard from a SQL or Excel data model

Reviewing layout, measures and accuracy

Peer and instructor feedback

Mini Project 3: interactive business dashboard, published and explained

Lab Practical: Build and present Mini Project 3: an interactive Power BI business dashboard with star-schema data model, dynamic DAX measures, and slicers.

Project brief and dataset shared by the instructor

Defining key business questions and analytical roadmap

Clean and prepare data using SQL or Excel

Lab Practical: Learners clean the raw capstone dataset and document their structured question list with mentor support.

Load data into Power BI and build the relational data model

Create dynamic DAX measures for the primary business metrics

Checking numbers and reconciling data against SQL or Excel

Lab Practical: Learners build the multi-table model and calculated measures with mentor code reviews.

Design executive dashboard pages with user-friendly navigation

Write 5 to 7 key business insights and strategic recommendations

Prepare a short executive presentation deck

Lab Practical: Learners finalize the dashboard visual hierarchy and draft actionable business insights.

Capstone project presentations and live defense feedback

Building an analyst portfolio and crafting impact points for resume

LinkedIn profile optimization tips for data analyst roles

Common interview questions: Excel, SQL, Power BI and scenario-based case studies

Next learning paths: Advanced with Python, Data Science and Data Engineering

Lab Practical: Present the capstone project, receive panel feedback, and finalize GitHub / LinkedIn portfolio items.
JOB-READY SQL & BI (50H) COMPETENCY BADGE
Certificate of Technical Competency — Data Analyst - Job Ready

Complete all live hands-on labs to earn this verifiable competency badge. This credential unlocks progression to full program graduation.

LIVE ONLINE COHORT
Admissions Open
Enroll in Data Analyst - Job Ready
Reserve your seat for upcoming live batches, syllabus consultation & fee structure.
Selected Course Program *
100% Privacy. Official Admissions Desk.

Frequently Asked Questions

Frequently Asked Questions: Data Engineering Course

Find clear answers to common questions about our live interactive classes, cohort schedules, project mentoring, and career assistance.

The program offers 3 comprehensive, career-focused courses: (1) Data Engineering Course (50 Hours), (2) Data Analyst - Advanced with Python (30 Hours), and (3) Data Analyst - Job Ready (30 Hours). Learners can enroll in individual courses or the complete data career master pathway.

Beginners should start with 'Data Analyst - Job Ready' to master business metrics, foundational SQL queries, and Power BI dashboards. Next, advance to 'Data Analyst - Advanced with Python' for automated analytics, and finally graduate to the 50-hour 'Data Engineering Course'.

No. Cloud basics are taught from the ground up starting with AWS IAM and S3, with step-by-step mentor guidance in every live session.

Most tasks use the AWS free tier. We configure budget alerts, and every cloud lab ends with a clean-up step to avoid unexpected bills. Learners should expect minimal or zero extra cost if instructions are followed.

Yes. All tools work on Windows, macOS, and Linux. Windows users will install WSL2 (Windows Subsystem for Linux) with mentor support, which makes the developer experience identical to Linux.

Every session is recorded in HD and shared within 24 hours, along with code repositories and daily lab tasks. You can catch up and ask questions in the next session or on the batch discussion channel.

You will finish with production-grade portfolio projects documented and pushed to your personal GitHub repository, verifiable certificates of completion, a professionally reviewed resume, and rigorous technical interview preparation.

Still have questions? We're here to help!

Speak directly with our technical advisors to discuss cohorts, curriculum, and career assistance.

FREE 1-ON-1 ACADEMIC GUIDANCE

Ready to Start Your Tech Journey?

Connect with our academic training counsellors. We analyze your background, career goals, and recommend the best live online track for your success.

Call Helpline: (02) 8902 0900WhatsApp or Viber Support