Skip to main content
CloudTechAnalytics
All courses

Data Analytics Professional Course

Data Analytics

Turn raw data into reports and dashboards people can act on.

This course takes you from cleaning a messy dataset to presenting a finished dashboard. You'll work in the tools most analyst roles ask for, Excel, SQL, Power BI and Tableau, and finish with an end-to-end project.

What you'll learn

  • Data collection and cleaning techniques
  • Advanced Excel for data analysis
  • SQL for database management and querying
  • Data visualization with Power BI
  • Dashboard creation with Tableau
  • Statistical analysis fundamentals
  • Business intelligence concepts
  • Data storytelling and presentation skills
  • Real-world case studies and projects

Curriculum

6 modules

Weeks 1–2Introduction to Data Analytics
  • The data analytics landscape
  • Types of data analysis
  • The data analytics life cycle
  • Introduction to business intelligence
Weeks 3–4Excel for Data Analytics
  • Advanced formulas and functions
  • Pivot tables and charts
  • Data cleaning and transformation
  • What-if analysis and Solver
  • Macros and VBA basics
Weeks 5–6SQL and Database Management
  • Database design principles
  • Writing complex SQL queries
  • Joins, subqueries and CTEs
  • Data aggregation and grouping
  • Working with multiple tables
Weeks 7–9Power BI
  • Power BI interface and components
  • Data import and transformation (Power Query)
  • DAX functions and calculations
  • Creating interactive dashboards
  • Report publishing and sharing
Weeks 10–11Tableau Visualization
  • Tableau Desktop fundamentals
  • Advanced chart types
  • Calculated fields and parameters
  • Interactive dashboards
  • Tableau Server and Online
Week 12Capstone Project
  • End-to-end data analysis project
  • Business problem solving
  • Dashboard creation
  • Presentation and documentation

Who it's for

  • Graduates looking to start a career in data
  • Working professionals moving into analytics
  • Business analysts upgrading their skills
  • Entrepreneurs who want to make decisions from data

How it's taught

  • Live classes, online or in person
  • Recorded sessions for revision
  • Hands-on practice exercises
  • Industry projects
  • One-on-one mentorship
  • Lifetime access to course materials

Other courses