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.
What you'll master in Level 3
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
What is data analytics? (Foundations & Setup)
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.
Excel essentials for analysts
Format and explore a sales dataset, highlight top and bottom performers.
Data cleaning and text/date functions
Clean a messy customer or loan list with mixed formats and duplicates.
Logical and conditional functions
Build a branch-wise summary report using conditional totals.
Lookups and combining tables
Combine a transactions sheet with customer and product lists using lookups.
Pivot tables and charts
Create a region-wise and month-wise sales analysis with pivots and charts.
Power Query and Excel dashboards (Mini Project 1)
Build and present Mini Project 1: a one-page Excel dashboard with pivots, charts and key statistics on a sales or HR dataset.
Descriptive statistics and distributions
Describe and compare the salary or loan amount distribution across groups, and flag outliers.
Correlation, hypothesis testing and A/B tests
Test whether two branches or two campaign groups differ significantly, and write the conclusion in plain language.
Database basics and querying
Query a customers and orders database to answer simple business questions.
Aggregation and joins
Produce branch-wise and product-wise reports by joining 3 tables.
Subqueries, CTEs and CASE
Segment customers into groups and calculate month-wise trends.
Window functions
Rank products within categories and calculate month-on-month change.
SQL project and SQL with Excel and Power BI (Mini Project 2)
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 introduction and data loading
Load and clean a multi-file sales dataset in Power BI Desktop.
Data modelling
Build an enterprise data model with 3 to 4 related tables and a dedicated date calendar.
DAX fundamentals
Create core KPI measures such as total sales, average order value (AOV), and profit margin.
DAX time intelligence
Create growth % and year-to-date measures and test them in an interactive matrix visual.
Visualisation and report design
Design a clean, two-page interactive report with unified typography and palettes.
Interactivity, publishing and sharing
Add drill-through and bookmarks to the report and publish it to the Power BI Service workspace.
Power BI project (Mini Project 3)
Build and present Mini Project 3: an interactive Power BI business dashboard with star-schema data model, dynamic DAX measures, and slicers.
Capstone kick-off and data preparation
Learners clean the raw capstone dataset and document their structured question list with mentor support.
Capstone: data model and measures
Learners build the multi-table model and calculated measures with mentor code reviews.
Capstone: dashboard and insights
Learners finalize the dashboard visual hierarchy and draft actionable business insights.
Presentations, portfolio and career prep
Present the capstone project, receive panel feedback, and finalize GitHub / LinkedIn portfolio items.
Detailed Module-wise Curriculum
Data entry best practices, Excel tables, sorting and filtering
Number, date and text formats
Core formulas and relative vs absolute references
Conditional formatting
Remove duplicates, TRIM, CLEAN, LEFT, RIGHT, MID, TEXTJOIN
Text to Columns and Flash Fill
Date functions and data validation
IF, IFS, AND, OR
COUNTIFS, SUMIFS, AVERAGEIFS
Building summary tables with conditional formulas
VLOOKUP, XLOOKUP, INDEX-MATCH
Handling errors with IFERROR
Combining data from two or more tables
Pivot tables, grouping, calculated fields
Slicers and timelines
Pivot charts, and choosing the right chart type
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
Mean, median, mode, range, variance and standard deviation
Quartiles, percentiles and outliers
The normal distribution (intuition)
Statistics functions and the Analysis ToolPak in Excel
Correlation vs causation
Samples and confidence intervals (intuition)
Null and alternative hypotheses, p-values, t-test in Excel
Reading an A/B test result
Relational databases, tables, primary and foreign keys
Connecting to MySQL
SELECT, WHERE, ORDER BY, LIMIT, DISTINCT
IN, BETWEEN, LIKE and handling NULL values
COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING
INNER, LEFT and RIGHT joins, joining multiple tables
Subqueries and CTEs
CASE WHEN for segmentation
Date and string functions, UNION
ROW_NUMBER, RANK, running totals, LAG and LEAD
Views, and writing clean, readable queries
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
Power BI Desktop interface
Connecting to Excel, CSV and SQL data
Power Query Editor: cleaning and transforming data
Data types and common errors
Relationships between tables, cardinality, filter direction
Star schema: fact and dimension tables
Building a date table
Calculated columns vs measures
SUM, COUNT, DISTINCTCOUNT, DIVIDE
Introduction to CALCULATE and FILTER
CALCULATE with filters, ALL and ALLSELECTED
Year to date (YTD), previous year and month-on-month growth
Ranking and Top N measures
Choosing visuals: cards, bar, line, matrix, maps
Slicers, filters and formatting
Colour, layout and storytelling principles
Drill-down, drill-through, tooltips and bookmarks
Power BI Service overview, workspaces and publishing
Refresh basics, sharing options and introduction to row-level security
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
Project brief and dataset shared by the instructor
Defining key business questions and analytical roadmap
Clean and prepare data using SQL or Excel
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
Design executive dashboard pages with user-friendly navigation
Write 5 to 7 key business insights and strategic recommendations
Prepare a short executive presentation deck
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
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.
Enroll in Data Analyst - Job Ready
Reserve your seat for upcoming live batches, syllabus consultation & fee structure.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.
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.
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.
