Covered by our 14 Day Money Back Guarantee*
Terms and conditions applyCertified Data Wrangler
Build job-ready data skills across Excel, SQL, Power BI, and Tableau. This academy turns raw data into clear, decision-ready insights through hands-on projects and practical analytics.
Data
Excel
Power BI
SQL
About This Learning Path
Data Wrangler Academy equips professionals to source, shape, analyze, and communicate data with confidence. You begin with visual data thinking, learning how the visual language hierarchy guides better charts and dashboards. From there, you strengthen statistical literacy and introductory predictive concepts so you can frame business questions, test assumptions, and quantify outcomes. Practical Excel work deepens your ability to model scenarios, automate tasks with macros, and build dynamic dashboards that surface what matters to decision‑makers. Next, you progress to modern analytics tools. In SQL, you’ll learn to query, join, aggregate, and manipulate data efficiently. In Power BI and Tableau, you’ll develop robust data models, apply DAX and Level of Detail expressions, and design clear, persuasive dashboards. Throughout, Kubicle’s applied learning model anchors skills in realistic projects—from evaluating infrastructure investments to improving customer service and identifying profitable airline routes—so you can turn messy datasets into reliable, actionable insight for finance, operations, or consulting contexts.
What You'll Learn
Understand the visual language hierarchy to create effective charts and dashboards
Build Excel models that analyze scenarios, forecast outcomes, and automate repetitive tasks
Perform SQL queries to select, join, aggregate, and transform large datasets
Apply statistical methods and basic predictive concepts to support decisions
Develop interactive reports in Power BI using data models and DAX
Design clear Tableau dashboards using formulas and Level of Detail expressions
Skills You'll Gain
Data visualization
Dashboard design
Excel modeling
SQL querying
Power BI
Tableau
DAX formulas
Statistical analysis
Predictive concepts
Data storytelling
Curriculum
Visualization Fundamentals
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Data Literacy
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Statistical Analysis
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Excel
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
SQL
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Power BI
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Curriculum
Tableau
Building Your First Dashboard
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.
1 HOURS
Advanced
2 CPE / CPD Credits
Tableau
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visual Data Thinking
Course
Course
Visualization is a critical business skill. In this course, you'll learn about the visual language hierarchy, and you'll discover how to add information to a chart in a way that maximizes its effectiveness.
1 HOUR
Beginner
1 CPE / CPD Credits
Build Your First Model
Course
Course
This introductory modeling course will teach you how to build a pricing model from scratch - helping our case study Zippy Airways, maximize profitability.
3 HOURS
Intermediate
2 CPE / CPD Credits
Forward-Looking Models
Course
Course
SupraChem has a high-risk technology project that requires additional investment. Learn how to build a forward-looking model and use new tools such as decision trees and scenario analysis to help the company reach a decision.
3 HOURS
Advanced
2 CPE / CPD Credits
Analyze the commercial viability of an airport
Project
Project
In this project, you'll help a local government analyze a big infrastructure project. You'll build a detailed Excel model analyzing potential cash flows from the project, incorporating potential risks and issues. You'll then make a recommendation on whether the investment is commercially viable.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to Excel Macros
Course
Course
Macros help you automate tasks in Excel and can be a big time-saver, particularly when formatting cells. What's more, you don't need to be a programmer to build them!
2 HOURS
Advanced
1 CPE / CPD Credits
Introducing Power Pivot
Course
Course
Power Pivot is a data modeling tool available within Excel. This course will introduce the important points of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using the data model.
2 HOURS
Intermediate
2 CPE / CPD Credits
Developing and Visualizing Your Data Model
Course
Course
In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also explore options for displaying your data that go beyond Pivot Tables, such as Power Maps and other visualization tools available in Excel
2 HOURS
Advanced
2 CPE / CPD Credits
Understanding SQL Databases
Course
Course
Learn how databases are structured to maximize efficiency and how data can be extracted from a database using SQL code.
2 HOURS
Beginner
2 CPE / CPD Credits
Selecting and Filtering Data with SQL
Course
Course
This course covers the more advanced methods for selecting data such as select distinct and subqueries. In addition, we also demonstrate how to use the where clause to filter our data.
2 HOURS
Beginner
2 CPE / CPD Credits
Joining Data with SQL
Course
Course
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
2 CPE / CPD Credits
Aggregating Data with SQL
Course
Course
Learn how to create SQL queries that can aggregate data based on the sum, count, average etc. of a numeric data type. We'll also cover how to use the group by clause to break down the aggregates on a categorical field.
2 HOURS
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
Course
Course
The best way to create effective visualizations using the visual language hierarchy is through practice. In this course, we'll work through several visual case studies, and learn how to use the hierarchy to improve visualizations and make them more effective.
1 HOUR
Beginner
1 CPE / CPD Credits
Data Manipulation with SQL
Course
Course
In this course we expand on data types in SQL and learn how to manipulate dates, parse strings and perform calculations.
2 HOURS
Advanced
2 CPE / CPD Credits
Building Your First Dashboard
Course
Course
This course introduces Power BI and its capabilities to new users. You'll learn how to create a dashboard, import data and create a report in Power BI Desktop. You'llYou will then upload the report to Power BI to create the dashboard.
2 HOURS
Beginner
2 CPE / CPD Credits
Introduction to Visualizations in Power BI
Course
Course
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
2 HOURS
Beginner
2 CPE / CPD Credits
Developing Effective Visualizations
Course
Course
In this course, we'll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We'll also see how to add custom visuals, and we'll look at features like hierarchies, quick measures and groups.
1 HOURS
Intermediate
2 CPE / CPD Credits
Designing Effective Dashboards
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
2 HOURS
Intermediate
2 CPE / CPD Credits
The Query Editor
Course
Course
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we'll import files from a folder, combine them into one query, and transform the data using the Query Editor.
1 HOURS
Advanced
2 CPE / CPD Credits
Reduce an internet provider's customer complaints
Project
Project
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
2 HOURS
Advanced
2 CPE / CPD Credits
Introduction to DAX
Course
Course
Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced DAX Functions and Concepts
Course
Course
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel's, such as row and filter contexts.
2 HOURS
Advanced
2 CPE / CPD Credits
Practical Applications of DAX
Course
Course
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
1 HOURS
Advanced
2 CPE / CPD Credits
Visualization in Practice
Course
Course
Getting started with visualization software like Power BI and Tableau can be intimidating. Follow an accountant's journey as she learns about the value of integrating BI tools into her workflow.
30 MINS
Beginner
1 CPE / CPD Credits
Introducing Tableau
Course
Course
Our first Tableau course will show you how to connect datasets to Tableau, understand the user interface, create interactive visualizations and how to save and distribute your work.
2 HOURS
Beginner
2 CPE / CPD Credits
Creating Visualizations in Tableau
Course
Course
Tableau has many excellent visualization options for your data, from simple bar charts to interactive maps and box-plots. In this course, we will step through each type of visualization, learning how and when to use them.
2 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
Course
Course
Filters, sets and groups enable users to create custom lists and calculations that can enhance your ability to isolate certain portions of your dataset. Filters also create great interactive elements on your dashboards.
2 HOURS
Beginner
2 CPE / CPD Credits
Dashboard Design
Course
Course
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
3 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Formulas in Tableau
Course
Course
Tableau has its own Calculation Language that is similar to SQL or Excel. In this course, we'll write some basic formulas in the Tableau Calculation Language, incorporating useful in-built functions like LOOKUP() and WINDOWSUM().
2 HOURS
Intermediate
2 CPE / CPD Credits
Further Formulas in Tableau
Course
Course
In our second course on Tableau formulas, we learn how to use logical functions, such as AND, IF and OR. In the second part of this course we also examine text, time and date functions and how they are best used in Tableau.
2 HOURS
Intermediate
2 CPE / CPD Credits
Level of Detail Expressions
Course
Course
In Tableau, it can be difficult to combine different levels of granularity in a single view. Level of Detail (LOD) Expressions solve this problem but do require some practice to master.
2 HOURS
Advanced
2 CPE / CPD Credits
Advanced Visualizations in Tableau
Course
Course
This course moves beyond the regular visualizations in Tableau and shows users how to create more advanced charts such as layered maps, funnels and waterfall charts.
1 HOURS
Advanced
1 CPE / CPD Credits
Identify profitable airline routes with data visualization
Project
Project
Help an airport increase the number of direct flight routes, while minimizing the number of unprofitable flight routes. You'll achieve this by visualizing and analyzing passenger data to determine how these expansion goals can be met.
2 HOURS
Intermediate
2 CPE / CPD Credits
Principles of Statistics
Course
Course
Statistics is the process of collecting, analyzing and interpreting data. This course demonstrates how to summarize a dataset of interest and draw conclusions about the data
1 HOURS
Intermediate
2 CPE / CPD Credits
Introduction to Predictive Modeling
Course
Course
Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.
3 HOURS
Beginner
2 CPE / CPD Credits
Probability Principles
Course
Course
Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.
2 HOURS
Intermediate
2 CPE / CPD Credits
Introducing Statistics
Course
Course
Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!
2 HOURS
Intermediate
1 CPE / CPD Credits
Charts in Depth
Course
Course
Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
1 CPE / CPD Credits
Build Your First Dashboard
Course
Course
Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.
2 HOURS
Intermediate
2 CPE / CPD Credits
What's Included?
71.5 Hours
38 Courses
Language:
English
Course Level:
Intermediate
69 CPE & CPD Credits
$550.00
Certificates and Diplomas
Upon completing any Kubicle Path or Academy course, learners earn professionally recognized certificates accredited by CPE, CPD, NASBA, and CAI. These credentials are easily shareable on social networks and widely trusted by leading organizations as a benchmark for excellence in tech, data, AI, and business skills training.
Start your learning journey today!
Become part of a global community of learners who are enhancing their skills and advancing their careers through Kubicle Paths and Academies.
