Covered by our 14 Day Money Back Guarantee*
Terms and conditions applyAdvanced Data Visualization for Finance
Master advanced Power BI techniques to create compelling financial dashboards, visualize key metrics, and transform data into actionable insights for business performance and reporting.
Data
Power BI
Finance
About This Learning Path
The Advanced Data Visualization for Finance Academy is designed for finance professionals seeking to elevate their analytical and visualization capabilities using Power BI. Starting from the fundamentals, you’ll learn how to build your first dashboard, import and structure data, and create impactful visual reports. You’ll then progress into advanced topics, such as designing effective dashboards, applying sophisticated Data Analysis Expressions (DAX), and leveraging Power BI’s Query Editor to transform and model complex financial datasets. Throughout the academy, you’ll explore real-world projects that simulate professional use cases, from building financial statements to solving business challenges using data-driven insights. By the end, you’ll be able to design professional-grade dashboards and visualizations that enable informed financial decision-making, communicate insights clearly, and enhance the strategic value of data in your organization.
What You'll Learn
Build dynamic Power BI dashboards and import data for effective financial reporting.
Understand and apply DAX formulas to calculate, model, and analyze financial data.
Develop engaging visualizations and organize dashboards for maximum communication impact.
Transform and clean financial data using Power BI’s Query Editor for reliable insights.
Apply data visualization principles to create performance dashboards and statements.
Use real-world projects to analyze business data and provide actionable recommendations.
Skills You'll Gain
Power BI Dashboards
Financial Visualization
DAX Functions
Data Modeling
Dashboard Design
Financial Reporting
Data Transformation
Performance Analysis
Power BI Service
Data Automation
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
Python Fundamentals
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 CPE / CPD Credits
Tableau
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 HOURS
Advanced
2 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.
3 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
Intermediate
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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
Intermediate
2 CPE / CPD Credits
Curriculum
Visual Data Thinking
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 HOUR
Beginner
1 CPE / CPD Credits
Dashboard Design
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Prevent decision paralysis with dashboard reports
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
Beginner
2 CPE / CPD Credits
Introduction to Formulas in Tableau
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
Further Formulas in Tableau
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
Level of Detail Expressions
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
Reshaping Data in Tableau Prep
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
1 CPE / CPD Credits
Optimizing for Performance
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
1 CPE / CPD Credits
Advanced Visualizations in Tableau
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
1 CPE / CPD Credits
Connecting to Different Data Sources
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
Identify profitable airline routes with data visualization
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
Intermediate
2 CPE / CPD Credits
Applying Visual Data Skills
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 HOUR
Beginner
1 CPE / CPD Credits
Preparing Financial Statements
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.
3 HOURS
Advanced
2 CPE / CPD Credits
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.
2 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
Identify taxpayer cohorts by exploring data
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
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
Intermediate
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
Intermediate
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
Intermediate
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.
2 HOURS
Intermediate
2 CPE / CPD Credits
Visualization in Practice
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.
30 MINS
Beginner
1 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
Building Financial Statements
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.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
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
The Power BI Online Service
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
Advanced Data Connections
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
Python Fundamentals
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
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.
3 HOURS
Intermediate
3 CPE / CPD Credits
Introducing Tableau
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
Creating Visualizations in Tableau
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.
3 HOURS
Beginner
2 CPE / CPD Credits
Filter, Groups, and Sets
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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
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
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
Prevent decision paralysis with dashboard reports
Project
Project
Help a meal-prep startup that's paralyzed by a lack of clear and current data. At present, reports are contained within static PowerPoint and quickly go out of date. You'll assist the company by building a valuable Tableau Dashboard that updates automatically.
2 HOURS
Beginner
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
Reshaping Data in Tableau Prep
Course
Course
This course is about the Tableau Prep tools which enable you to reshape and reform your data. This includes merging multiple data sources, adjusting the granularity of the data and pivoting from wide to tall datasets.
2 HOURS
Intermediate
1 CPE / CPD Credits
Optimizing for Performance
Course
Course
As Tableau can combine multiple large data sources, users must monitor performance and loading times carefully. In this course, we'll see techniques for reducing loading times, from joining data sources to changing calculations.
1 HOURS
Advanced
1 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
Connecting to Different Data Sources
Course
Course
Tableau contains connectors to many data sources, from Google Sheets to SQL databases. We'll learn how to connect to these data sources, create joins and blends across them, and publish them to Tableau Online and Tableau Server.
1 HOURS
Advanced
2 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
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
Preparing Financial Statements
Course
Course
Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 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 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.
2 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
Identify taxpayer cohorts by exploring data
Project
Project
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
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
Intermediate
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
Intermediate
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
Intermediate
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'll see how to perform various common calculations and use them to produce compelling visualizations.
2 HOURS
Intermediate
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
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
Building Financial Statements
Course
Course
Power BI provides an ideal environment for financial statements, letting you analyze and visualize your data in one place. In this course, you'll develop an Income Statement, Balance Sheet and Statement of Cash Flows in Power BI Desktop, and you'll analyze these accounts to create a compelling financial report for your company.
3 HOURS
Intermediate
2 CPE / CPD Credits
Power BI Case Study
Course
Course
In this course, we'll apply the techniques we've seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
2 HOURS
Advanced
2 CPE / CPD Credits
The Power BI Online Service
Course
Course
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2 HOURS
Intermediate
2 CPE / CPD Credits
Advanced Data Connections
Course
Course
In this course, you'll learn about some of the more advanced but practical data connections in Power BI, like APIs. You'll learn how to monitor and improve the performance of large data models, and you'll learn how to refresh data automatically without slowing down your data models. Some functionality covered requires access to Power BI Pro or Power BI Premium.
2 HOURS
Intermediate
2 CPE / CPD Credits
Python Fundamentals
Course
Course
In this course, the learner will get a grasp of the basics of Python. We'll learn about the basic principles behind Python, along with learning what Python is and why it's popular.
3 HOURS
Beginner
2 CPE / CPD Credits
Functions, Conditionality and Loops
Course
Course
In this course, we learn some important Python functionality that considerably enhances what we can do with Python code. We learn about functions, conditional statements, and repeating code loops.
3 HOURS
Intermediate
3 CPE / CPD Credits
Storing, Transforming and Visualizing Data
Course
Course
This course focuses on using Python to organize data We'll learn about ways to load, clean, transform and visualize our data. We'll also cover 3 critical Python libraries: NumPy for advanced calculations, Pandas for reading and manipulating datasets, and MatPlotLib for visualizing data.
3 HOURS
Intermediate
3 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.
3 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
Intermediate
2 CPE / CPD Credits
What's Included?
31 Hours
14 Courses
Language:
English
Course Level:
Intermediate
28 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.
