Training
Data Analytics Training
Turn raw data into insights and decisions with Excel, SQL, Python, Power BI and AI-assisted analytics.
10
Curriculum modules
About 10
Weeks
Real data
Hands-on projects
Portfolio
Capstone dashboard
Overview
Turn Data Into Decisions
Data analytics is the process of examining raw data to uncover patterns, insights and trends that drive better decisions. It helps organizations optimize operations, understand customers and forecast outcomes.
This program teaches the tools analysts use every day, adds today’s AI-assisted analytics techniques, and finishes with a portfolio project built on real-world data.
At a Glance
- About 10 weeks
- Beginner friendly
- Excel, SQL, Python, Power BI and Tableau
- AI-assisted analytics included
- Portfolio capstone project
Learning Path
From Spreadsheets to Dashboards
- 1
Foundations
Data and the analytics process
- 2
Excel and SQL
Prepare and query data
- 3
Statistics
Find patterns and test ideas
- 4
Python
Analyze at scale
- 5
Visualize
Power BI and Tableau
- 6
Capstone
Present your insights
What You’ll Learn
Skills You Will Build
- Understand data fundamentals and real-world applications
- Gather, clean and prepare data with Excel, SQL and Python
- Apply descriptive and inferential statistics
- Build interactive dashboards in Power BI and Tableau
- Use AI assistants to speed up analysis responsibly
- Present data stories that drive decisions
Curriculum
Course Modules
01Introduction to Data Analytics4 topics
- The role of data in business decisions
- Data types, sources and the data life cycle
- Data analytics vs. data science vs. business intelligence
- The analytics process: ask, prepare, process, analyze, share, act
02Excel for Data Analysis5 topics
- Cleaning, sorting and filtering data
- Formulas, XLOOKUP and dynamic arrays
- PivotTables and charts
- Power Query for data preparation
- Building reports and dashboards
03SQL for Data Analysis5 topics
- Databases and relational concepts
- SELECT, filtering, joins and aggregation
- CTEs and window functions
- Working with PostgreSQL and MySQL
- Real-world database projects
04Statistics for Analysts4 topics
- Descriptive statistics and distributions
- Sampling and confidence intervals
- Correlation vs. causation
- Hypothesis testing and A/B testing
05Python for Analytics5 topics
- Python basics for analysts
- pandas and NumPy for data manipulation
- Cleaning and transforming data
- Visualization with Matplotlib and Seaborn
- Working in Jupyter notebooks
06Dashboards with Power BI and Tableau4 topics
- Power Query, data modeling and DAX
- Interactive Power BI reports
- Tableau visualizations
- Dashboard design best practices
07Data Storytelling3 topics
- Defining KPIs and business questions
- Turning analysis into recommendations
- Presenting to executives and stakeholders
08AI-Assisted Analytics4 topics
- Using AI copilots in Excel, Power BI and Python
- Asking questions of data in natural language
- Validating AI-generated results
- Protecting sensitive data when using AI tools
09Data Quality and Governance3 topics
- Data quality checks and documentation
- Privacy and handling personal data
- Data ethics and responsible use
10Capstone Portfolio Project3 topics
- Analyze a real-world dataset end to end
- Build an interactive dashboard
- Present findings and add the project to your portfolio
Career Paths
Roles This Training Prepares You For
More Training
Explore Other Programs
Ready to Build Your Skills?
Ask about upcoming cohorts, corporate training and group enrollment.
