Data analytics learning guide

Which data analytics course should you take?

Choose according to the work you need to perform: preparing data, analyzing results, building Power BI reports, writing findings, or presenting insights through charts and dashboards.

See the Learning Paths Ask for a Recommendation

Start with your current challenge.

You do not need every course. Pick the task that most closely matches your role or reporting problem.

Excel analysts

I analyze data in Excel

You need advanced PivotTables, statistics, forecasting, Power Query, Power Pivot, and clearer analytical presentation.

View Excel Data Analysis outline →

Data preparation

I repeatedly clean and combine data

You import files, fix formats, consolidate recurring reports, and want a refreshable preparation workflow.

View Power Query outline →

Interactive reporting

I want to build Power BI reports

You need interactive visuals, filters, relationships, transformed data, and publishable business reports.

View Power BI Beginners outline →

The technical analytics path

Follow the whole path when your role covers data preparation, analysis, modeling, and interactive reporting—or enter at the stage that matches your current skills.

Mastering Power Query

Connect, clean, reshape, merge, append, and prepare reliable datasets in Excel and Power BI.

View outline

Power BI for Beginners

Build visuals, filters, relationships, transformed datasets, dashboards, and publishable reports.

View outline

Intermediate to Advanced Power BI

Strengthen models, joins, bridge tables, interactions, advanced visuals, and DAX calculations.

View outline

Choose a complementary specialization according to your output:

Intermediate Excel

For users who need stronger functions, worksheet controls, combination charts, PivotTables, PivotCharts, and basic dashboards before deeper analytics.

View outline

Excel Data Analysis

For advanced PivotTables, statistics, forecasting, regression, Power Pivot, and decision support within Excel.

View outline

Data Analysis and Interpretation

For assessing data quality, comparing performance, finding patterns, investigating causes, and making responsible business decisions.

View outline

Analysis and Report Writing

For interpreting evidence and turning results into structured findings, conclusions, and recommendations.

View outline

Visualization and Storytelling

For choosing charts, applying design principles, shaping narratives, and communicating insights responsibly.

View outline

Choose your communication course.

These courses overlap slightly, but each produces a different workplace capability.

Charts

Charting Like a Pro

Choose this when your immediate need is creating clearer, more professional and responsible Excel charts.

View outline →

Complete foundation

Data Visualization and Storytelling

Choose this for chart selection, Excel execution, psychology, PowerPoint integration, context, ethics, and dashboard foundations.

View outline →

Influence decisions

Inspiring Change with Dashboards

Choose this when you already work with dashboards and need stronger story flow, context, design, ethics, and decision support.

View outline →

Compare all ten courses.

Use this table when two or more options appear suitable.

Course	Best for	Recommended starting knowledge	Primary outcome	Outline
Intermediate Excel	Basic Excel users preparing reports and summaries	Basic formulas and worksheet navigation	Intermediate functions, charts, PivotTables, PivotCharts, and dashboards	View
Excel Data Analysis	Excel analysts and decision-support teams	PivotTable familiarity	Statistics, forecasting, modeling, and analytical interpretation	View
Data Analysis and Interpretation	Professionals who interpret reports, metrics, or operational results	No specialized software required	Defensible insights, cause investigation, recommendations, and data-based decisions	View
Data Analysis and Report Writing	Professionals preparing analytical reports	Experience working with reports or data	Defensible findings, conclusions, and recommendations	View
Mastering Power Query	Recurring cleanup and consolidation work	Comfort with tables and datasets	Refreshable data-preparation workflows	View
Power BI for Beginners	New Power BI and interactive-report users	Basic reporting familiarity	Interactive reports, models, and dashboards	View
Advanced Power BI	Existing Power BI report builders	Beginner Power BI skills	Advanced modeling, interactions, visuals, and DAX	View
Visualization and Storytelling	Analysts and managers communicating insights	Basic Excel chart familiarity is helpful	Audience-focused stories, visuals, and dashboards	View
Charting Like a Pro	Excel users improving charts	Basic Excel knowledge	Clear, professional, responsible Excel visualizations	View
Dashboard Storytelling	Dashboard creators influencing decisions	Experience with charts or dashboards	Story-driven dashboards with context and ethical design	View

Still unsure? Match the problem.

Choose the statement that sounds most like your current work.

“I need stronger Excel functions, charts, PivotTables, and dashboards before advanced analytics.” “I clean and combine the same files every month.” “I need statistics, forecasting, or deeper Excel analysis.” “I want to build my first interactive Power BI report.” “I already use Power BI and need better models and DAX.” “I need to interpret results, test possible causes, and decide what action to recommend.” “I need to write findings and recommendations from data.” “My dashboards show numbers but do not drive action.”

Need a customized analytics pathway?

Tell us about your data sources, current tools, reports, and intended decisions. We can recommend or combine modules for your team.

Request a Proposal View Public Classes