Programs
Data Analytics Training
Turn data into decisions with Excel, Power BI, SQL, Python and Microsoft Fabric. Hands-on courses from first spreadsheet to Microsoft certification.
- Tools teams useExcel, Power BI, SQL Server, Python and Fabric
- CredentialsCertificates and Microsoft certification prep
- Teams welcomeGroup enrollment and written quotes
Not sure where to start?
Excel
Analyze and visualize data in the spreadsheet you already use.
Data Analysis Fundamentals Using Excel
Start data analysis in Excel: clean and prepare data, use Named Ranges and Tables, work with data types and apply logical and lookup functions.
Data Analysis and Visualization with Microsoft Excel
Use Excel Tables, PivotTables, Power Pivot, maps and AI-assisted analysis to turn raw data into an interactive dashboard.
Excel for Data Analysts
Build Excel skills for data analysis: clean data, automate repeated work and create clear charts and visualizations.
Power BI
Reports, dashboards, data models and DAX, through to the PL-300 certification.
Data Analysis Using Power BI Desktop - Level 1 - Report Builder
Learn to build, filter, and share interactive Power BI reports and dashboards from a prepared data model, from Power BI Desktop through to the Power BI service.
Microsoft Power BI Interactive Data Visualizations
Turn CSV, TXT, Excel, and database data into reports and dashboards in Power BI Online by merging, grouping, summarizing, and calculating in Power BI Desktop.
Microsoft Power BI for Excel
Move a recurring Excel report into Power BI: acquire and shape data, build a model, create visuals, publish and share, and send refreshable data back to Excel.
Data Model Design Using Power BI
Connect to varied sources, clean and transform raw data in Power Query, design a sound Power BI model, and add a first set of DAX and time intelligence measures.
DAX for Power BI
Build advanced DAX skills in Power BI: columns, measures, and tables, row and filter context, multi-table and time calculations, error handling, and testing in DAX Studio.
Microsoft Power BI Intermediate
Take the next step in Power BI with harder imports, time intelligence, R and Python visuals, KPIs and scorecards, advanced report design, and basic statistical analysis.
Advanced Microsoft Power BI
Take your Power BI work further with advanced DAX, Query Editor transformations, spatial analytics, R integration, and the security and governance needed to deploy it.
Data Visualization with Power BI
Turn raw data into interactive reports and dashboards in Microsoft Power BI, including its AI-powered analytics features.
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Exam prep for Microsoft Certified: Power BI Data Analyst Associate (PL-300): prepare, model, visualize and analyze data, and manage Power BI.
SQL and databases
Query, design, run and integrate databases with SQL Server.
Fundamentals of SQL Querying
Write SQL queries that filter, calculate, group, join and rank data, then check AI-written SQL and produce a verified report.
SQL for Data Analysis
Learn SQL for data analysis: query databases, manage data and write complex queries that answer real questions.
SQL (All Versions)
A clear introduction to SQL: write queries to retrieve, filter, join and analyze data, and use AI tools to write and debug SQL.
SQL (All Versions) Advanced
For learners who know basic SQL or another language: write complex queries, design databases, import data and go deeper into database work.
Developing SQL Databases
Design and build SQL Server 2025 database objects, including tables, constraints, indexes, views, stored procedures, functions and triggers.
Administering a SQL Database Infrastructure
Learn to secure, back up, restore, automate and monitor SQL Server 2025 databases through hands-on administration labs.
SQL Server Integration Services
Build, deploy and maintain SSIS packages that extract, transform and load data, using SQL Server 2025 Integration Services and Visual Studio 2022.
Python, statistics and data science
Statistics and Python for analysis, automation and data science.
Introduction to Data and Statistical Analysis
Learn the fundamentals of data analytics and statistical analysis, and use statistics to interpret data and support decisions.
Python for Data Analytics
Use Python to obtain, clean and prepare data, then describe, visualize and model it to answer real business questions.
Python Programming for Data Analysis
Use Python and its data libraries to clean, analyze and visualize data.
Programming for Data Science with Python
Learn the four everyday tools of a data team, SQL, Python with pandas, the command line and Git, and how they work together.
Microsoft Fabric and cloud AI
End-to-end analytics in Microsoft Fabric, and AI on AWS.
Data Analytics with Microsoft Fabric
Build an end-to-end analytics solution in Microsoft Fabric with a lakehouse, dataflows, pipelines, a notebook, a warehouse, and a Direct Lake semantic model.
Microsoft Certified: Fabric Analytics Engineer Associate
Prepare for exam DP-600 by learning to prepare data, build lakehouses and warehouses, and manage semantic models in Microsoft Fabric.
AWS Certified AI Practitioner
Exam prep for the AWS Certified AI Practitioner (AIF-C01): AI and machine learning basics, generative AI, foundation models, responsible AI and security.
More data courses
Python Certified Entry-Level Programmer (PCEP)
Prepare for the Python Institute's entry-level programmer certification (PCEP).
Designing and Building AI Products and Services
Plan, design and build AI products and services, from the problem to a working solution.
Advanced Python 3 Programming
Advanced Python techniques and tools for developers who solve complex problems.
Intermediate Python
Build on the basics with data structures, functions, files and real-world Python programs.
Python Programming Level 1: Introduction for Programmers
Learn Python, the language behind most AI and data work.
Training a team?
Enroll a group together, mix courses by role, and get a written quote. Live online or in-person sessions are available for an additional fee.
Frequently asked questions
Where should I start with data analytics?
If you work in spreadsheets, start with Excel. If you need reports and dashboards, start with Power BI Report Builder. If your data lives in a database, start with Fundamentals of SQL Querying.
Do I need a Windows PC?
Power BI Desktop and some Excel features run only on Windows, so most Power BI and Excel courses require a Windows PC. Each course page lists its requirements.
Which courses prepare me for a certification?
Microsoft Certified: Power BI Data Analyst Associate (PL-300) and Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) prepare you for Microsoft exams, and AWS Certified AI Practitioner prepares you for the AWS exam. Each page says whether the exam is included.
Can you train our whole team?
Yes. Groups enroll together, and we send written quotes for teams. Email admissions@wecancodeit.org or use the form on any course page.