Star icon
Most Popular
Trending Arrow Icon
Trending

Become a Certified Business Intelligence & Data Analyst (BIDA)™

blur

5

(5)

Learn Path Description

Analyze data like a pro using all the most popular business intelligence tools

  • Save hours of time by automating data transformation
  • Combine data to create world-class visuals and dashboards
  • Analyze and predict events using complex datasets 

Skills You Will Gain

Courses In This Learning Path

blur
icon

Total Duration

1.5 hour

icon

Level

Beginner

icon

Learn Type

Certifications

Introduction to Business Intelligence

This course will also discuss the types of visuals that are used in business intelligence to communicate key messages to decision-makers as well as the best practices when it comes to designing. We'll also discuss data types, data structures and files commonly used in Business Intelligence.

This course, Introduction to Business Intelligence, provides a basic overview of business intelligence. This course provides an overview of business intelligence, including how it differs to data science. It then covers the key roles and processes involved. Each role will be explained in detail, and you'll also learn what skills are required for each. You will learn how each role works together to provide actionable insights. Additionally, you'll see examples of BI tools that can revolutionize your work as you move through the course.

blur
icon

Total Duration

2 hours

icon

Level

Beginner

icon

Learn Type

Certifications

Data Science Fundamentals

We will first discuss exploratory data analysis and feature selection. Next, we'll explore feature engineering and other common methods for understanding and preparing the data for analysis. We will then explore some of the different algorithms that can be used to create both unsupervised or supervised machine-learning models. We will also discuss how to use validation/resampling techniques to train and test the data. We will also discuss evaluation techniques that can be used to evaluate the model's performance, and how to improve it based on those evaluations. The data science cycle will be demonstrated using a real-life example.

Data science allows us make data-driven insights. This Data Science Fundamentals course will provide an overview of data science and its use in finance and business. We will walk through the data science cycle to learn how to create machine learning models that can make predictions.

blur
icon

Total Duration

2.5 hours

icon

Level

Beginner

icon

Learn Type

Certifications

Statistics Fundamentals

This course will help you to conduct good analysis, apply data to business decisions, and explore the more advanced topics in the Business Intelligence and Data Analysis program, such as machine algorithms.

Statistics fundamentals introduces you to the concepts and methods required to interpret the results of a statistical test. We will overview the two branches of statistics-descriptive statistics and inferential statistics--and run hypothesis tests on real and simulated data sets using Excel's Data Analysis ToolPak. We will also be examining key concepts such as the Central Limit Theorem and Empirical Rule.

blur
icon

Total Duration

6 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Power Query Fundamentals

Power Query is a vital skill for Excel-focused analysts. It is also a valuable asset to Business Intelligence analysts. These skills will allow you to spend less time manipulating data and more time working on analysis projects.

This online Power Query Fundamentals course will teach you about data transformation and automation. Learn how to extract data from different sources and convert it into more suitable layouts for analysis. You will learn how to automate data connections, transformations, and how to extract and consolidate multiple files. We'll also discuss common mistakes.

Stop. Power Query will revolutionize your work.

You've probably worked with Excel data extracts and regular reports. If so, you know how tedious it can be to modify the layout, extract data, or lookup values from other tables. These tasks are repeated every week or monthly, depending on whether you receive a new report.

Stop wasting time manipulating data

blur
icon

Total Duration

10 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Power BI Fundamentals

This is the final dashboard that you will create in the course. You can explore the interactive version below.

Power BI is an increasingly popular tool for Financial Analysts. Its powerful dashboarding functions can automate your work and help you create compelling visuals to tell meaningful stories using complex data. These dashboards can help you make measurable strategic decisions for your company.

This online Power BI Fundamentals course will teach you how to use the powerful dashboarding tool and tell meaningful stories using data. We'll work with complex data-sets, and show you how to organize, manipulate and dashboard this data. As we build a 3-page dashboard, we will begin with the core functionality. This course is ideal for students who wish to learn more about Power BI and how it can be used in business intelligence or finance.

blur
icon

Total Duration

7 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Power Pivot Fundamentals

This course will show you how to create a business intelligence dashboard using Excel Power Pivot. This course will teach you the best practices and key functions for creating a dashboard. As you move through the course you will be able to apply what you have learned to a real-world example with data that we provide. You'll be able to create your own Excel dashboards and track KPIs.

blur
icon

Total Duration

10 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

SQL Fundamentals

SQL is a key component of Business Intelligence. It allows us to access databases and extract the data for other BI tools. This course teaches SQL basics and essential transformations using practical examples. This course provides learners with access to the Azure Data Studio data warehouse, which allows them to run the queries they have learned. The data warehouse can be accessed from any computer, whether it is Windows, iOS or Linux.

blur
icon

Total Duration

7 hours

icon

Level

Beginner

icon

Learn Type

Certifications

Tableau Fundamentals

You will be able create interactive Tableau dashboards that deliver meaningful and data-backed stories by the end of this course. You will be able to use Tableau Public in its basics, and you'll also have the skills and knowledge to create stunning visuals and dashboards.

Each chapter ends with a hands-on example that uses alternative scenarios. A new dataset is also provided for the final assessment. This will give you another opportunity to assess your skills.

This course will show you how to create stunning interactive visuals in Tableau before publishing them in Tableau Public. Learn how to prepare and manipulate data before creating calculations that deliver business insight.

blur
icon

Total Duration

6.5 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Dashboards & Data Visualization

This comprehensive dashboards course will show you how to create a custom Excel dashboard by using professional data visualization techniques. You will be able to combine data, charts, graphs and other visuals in order to tell a story.

blur
icon

Total Duration

7 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Case Study - Financial Statements in Power BI

Power BI is a powerful way to interact with financial data at high levels.

This course provides a scenario-based case study that will reinforce your knowledge of PowerBI. It also includes interactive exercises and extended student challenges.

Three significant challenges are involved in creating financial statements in Power BI. We will help you overcome them using a combination BI tools.

This is the ultimate Power BI walkthrough on Financial Statements. This case study will teach you how to use BI skills as a Business Intelligence developer. Your role is to automate and visualize financial statements for a retail business.

blur
icon

Total Duration

5 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Case Study - Trading Dashboard in Tableau

This step-by-step Trading Dashboard case studies will help you to improve your Tableau skills. This case study will show you how to play the role of an Investment Bank Business Intelligence Analyst. CFI Capital Partners' Sales and Trading team needs you to create custom dashboards to assist them with market analysis.

blur
icon

Total Duration

5.5 hours

icon

Level

Beginner

icon

Learn Type

Certifications

Python Fundamentals

Python is the most popular programming language used for data science and is a must-know to start or advance your career in data. In this course, you will learn the most fundamental skills to write and execute Python code. We will have an overview of the basic Python concepts, which will enable you to get started with a data science project! You will see how to load, clean, analyze, and transform data with two popular Python packages: Numpy and Pandas. Then, we will demonstrate how to effectively communicate the key insights from your analysis by visualizing your data using the Matplotlib and Seaborn packages. Finally, you’ll combine these skills and put your new knowledge into practice by analyzing financial data through a case study.

blur
icon

Total Duration

4 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Modeling Risk with Monte Carlo Simulation

Monte Carlo simulation is a powerful technique that can help businesses model and quantify uncertainty. This course covers the basics of Monte Carlo simulation and provides five scenarios to help understand its application in financial modeling. Unlike traditional scenario analysis, which relies on a few "best-case" and "worst-case" scenarios, Monte Carlo simulation allows for the simulation of multiple uncertainty scenarios simultaneously. By using this technique, businesses can more effectively model and assess risk. The course teaches participants how to use Monte Carlo simulation to make better business decisions by quantifying unfavorable scenarios. Through this training, individuals will gain a solid understanding of the basics of Monte Carlo simulation and its applications in modeling uncertainty.

blur
icon

Total Duration

8 hours

icon

Level

Advanced

icon

Learn Type

Certifications

Loan Default Prediction with Machine Learning

Andrew will guide you through the Machine Learning process step-by-step.

Machine Learning is a hot topic within the data science and data mining worlds. Machine Learning isn't as complicated as it sounds at a fundamental level. You may be surprised to discover that you have already made steps towards this exciting new world if you have ever done linear regression.

The entire Machine Learning process will be covered in Python. This will reinforce concepts from Python basics. Learn how to create and fine-tune predictive classification models, test them, and how to interpret their results.

It is extremely valuable for pricing and risk management to predict defaults and creditworthiness.

After your model has classified each loan, you can visualize your predictions and see how the model performed.

Machine Learning is the ability to make predictions using data. This course will teach you how to use Machine Learning skills to predict the likelihood of customers defaulting on loans.

blur
icon

Total Duration

3 hours

icon

Level

Beginner

icon

Learn Type

Certifications

Professional Ethics

This Professional Ethics course will help you prepare for ethical dilemmas in your career. This course will cover the importance of ethics in an organization, key elements of business ethics and the factors that contribute to a strong ethics culture within the company.

blur
icon

Total Duration

7.5 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Excel VBA for Finance

VBA can be used to automate repetitive tasks in Excel. It is also capable of simplifying long and complex calculations. This course examines the case of a multinational corporation to demonstrate how VBA can be used to create custom functions.

This course will help you master Excel VBA. It is ideal for finance professionals who are familiar with Excel but want to improve their skills. This course will teach you the basics of Excel VBA. It will also show you when and why VBA is used. The foundation will be used to move on to more advanced topics like how to handle exceptions and errors, publish functions and share them with colleagues, setup events and automation, and working with arrays.

blur
icon

Total Duration

3 hours

icon

Level

Intermediate

icon

Learn Type

Certifications

Bayesian Thinking

Bayesian methods offer a different way of thinking about probability. They have applications in business decision making.

Learn Path Reviews

Average Rating Based on 5 reviews

5.0

100%

blur