Back to Courses
Advanced

Data Analytics Complete Package

The ultimate all-in-one data analytics programme. Master Python, Excel, Power BI and SQL in one structured 4-month course u2014 everything you need to land a data analyst role, built from the ground up with no prior experience required.

$5994 monthsAdvanced

What You'll Learn

Python programming from basics to data analytics
NumPy and Pandas for data manipulation
Data cleaning and preprocessing techniques
Data visualisation with Matplotlib and Seaborn
Excel advanced formulas and functions
Pivot tables, Power Query and automation
VBA macros and Excel dashboards
SQL fundamentals and advanced queries
JOINs, subqueries and window functions
Power BI data modelling and relationships
DAX measures and time intelligence
Interactive dashboard design and publishing
Real-world capstone project across all 4 tools
Career guidance and portfolio building

Course Outline

1
Month 1 u2014 Week 1

Python Fundamentals

  • Installing Python and VS Code
  • Variables, data types and strings
  • Lists, tuples, dictionaries and sets
  • Conditional statements and loops
2
Month 1 u2014 Week 2

Python Functions & OOP

  • Defining functions and arguments
  • Lambda functions and map/filter
  • Classes, objects and inheritance
  • Importing and using external libraries
3
Month 1 u2014 Week 3

NumPy & Pandas

  • NumPy arrays and mathematical operations
  • Pandas DataFrames and Series
  • Loading CSV, Excel and JSON files
  • Filtering, sorting, grouping and merging data
4
Month 1 u2014 Week 4

Data Cleaning & Visualisation

  • Handling missing values and duplicates
  • Data type conversion and outlier treatment
  • Matplotlib charts and plots
  • Seaborn statistical visuals and Python project
5
Month 2 u2014 Week 1

Excel Advanced Formulas

  • XLOOKUP and VLOOKUP
  • INDEX and MATCH combinations
  • Dynamic arrays and FILTER function
  • Named ranges and data validation
6
Month 2 u2014 Week 2

Pivot Tables & Power Query

  • Pivot table design and slicers
  • Calculated fields and pivot charts
  • Power Query data import and transform
  • Combining and appending data sources
7
Month 2 u2014 Week 3

Excel Dashboards & Charts

  • Advanced chart types and formatting
  • Conditional formatting for insights
  • Interactive dashboard layout design
  • Linking charts to dynamic data
8
Month 2 u2014 Week 4

VBA Macros & Automation

  • Recording and editing macros
  • VBA variables, loops and conditions
  • Automating repetitive Excel tasks
  • Excel project u2014 automated reporting dashboard
9
Month 3 u2014 Week 1

SQL Fundamentals

  • Relational database concepts
  • SELECT, WHERE and ORDER BY
  • Filtering with AND, OR and NOT
  • DISTINCT, LIMIT and aliasing
10
Month 3 u2014 Week 2

SQL JOINs & Relationships

  • INNER JOIN and LEFT JOIN
  • RIGHT JOIN and FULL OUTER JOIN
  • Multi-table queries
  • Subqueries and nested SELECT
11
Month 3 u2014 Week 3

Advanced SQL

  • Aggregations u2014 SUM, COUNT, AVG, MIN, MAX
  • GROUP BY and HAVING clauses
  • Common Table Expressions (CTEs)
  • Window functions u2014 ROW_NUMBER, RANK, LAG, LEAD
12
Month 3 u2014 Week 4

SQL Performance & Project

  • Query optimisation techniques
  • Indexes and execution plans
  • Stored procedures basics
  • SQL project u2014 sales data analysis
13
Month 4 u2014 Week 1

Power BI Foundations

  • Power BI Desktop interface tour
  • Connecting to data sources
  • Power Query in Power BI
  • Data types and transformations
14
Month 4 u2014 Week 2

Data Modelling & DAX

  • Star schema and relationships
  • Calculated columns vs measures
  • DAX basics u2014 SUM, CALCULATE, FILTER
  • Time intelligence u2014 TOTALYTD, SAMEPERIODLASTYEAR
15
Month 4 u2014 Week 3

Dashboard Design & Visuals

  • Choosing the right visual type
  • Slicers, filters and drill-through
  • Report layout and design best practices
  • Bookmarks and page navigation
16
Month 4 u2014 Week 4

Publishing & Capstone Project

  • Publishing to Power BI Service
  • Sharing and collaboration
  • Row-level security basics
  • Final capstone u2014 end-to-end analytics project using Python, Excel, SQL and Power BI
$599

4 months · Advanced

This course includes:

4 months of content
14 topics covered
Certificate of completion
Advanced level
Chat on WhatsApp