Learning Outcomes

Business Intelligence

Starting Case

Decision-Making Process

Problem Structure

BI Application

Dashboard Presentation

Lesson Summary

This module explains what business intelligence is and how it can be used to make useful decisions. In this module, you will see the various reasons why managers need IT supports, types of problem structures, and business intelligence applications used for analyzing data.

Types of Charts

Good Dashboard

Common Mistakes

KPI Development

Overview of Data Warehouse

Data Warehouse

This module discusses the data warehouse and how it works to manage data. In this module, you will see the different types of charts used in the BI dashboard and the common mistakes made when designing a dashboard.

Development Approaches

Basics of Data Mining

Data Mining - Classification

Data mining - Clustering

Data Mining - Applications

This module explains the basics of data mining. In this module, you will see the stages involved in data mining and the various areas where data mining can be applied.

Fundamentals of Managing and Using Data for Business Intelligence - Course Assessment

Learn about business intelligence, data mining, data management, and data warehousing with this free online BI course.

Fundamentals of Managing and using Data for Business Intelligence

This course introduces you to the application of business intelligence (BI) in making viable financial and strategic decisions. Learn about the roles of managers and the reasons why managers need IT support. You will explore data management, data mining and the mechanics of data analysis. If you are a business analyst or a small business owner or entrepreneur and want to enhance your ability to make important decisions, this course is for you.

Introduction to Datasets

Measuring Centre of a Dataset

Comparing Univariate Data in a Dataset

Introduction to Multivariate Data

Transformations to Achieve Linearity

To start, this module will introduce you to data exploration. You will learn about the important metrics used in measuring the centre of a data set. You will also be introduced to how transformations are used as a technique for linear and non-linear models.

Methods of Data Collection

Planning and Conducting Surveys

Planning and Conducting Experiments

To start, this module will introduce you to how samples are selected from populations and conclusions made about those populations based on the samples. The module also introduces how surveys are used as an instrument for asking questions from a selected group of people.

Diploma in AP Statistics - First Assessment

In order to pass this assessment, you will need to score 80 per cent or above. Remember, if you do not achieve the required standard after the first attempt, you can re-take the assessment until a successful outcome is achieved.

Introduction to Probability

Discrete Random Variables and their Probability Distributions

Normal Distribution

Sample Distributions

Central Limit Theorem

To start, this module will introduce you to several methods used in interpreting relative frequency. The module also covers the notion of dependence versus independence in probability and how they are used in statistics

Introduction to Estimation

Tests of Significance

Large Sample Confidence Interval for a Proportion

Test for a Mean

To start, this module will introduce you to the relationship between estimation and statistical inferences. You will learn about estimating population parameters and margin errors. You will also be introduced to the properties of the point estimator.

Diploma in AP Statistics - Second Assessment

Diploma in AP Statistics - Course Assessment

An introductory college-level course that looks at probability in data exploration and dataset characterization.

Diploma in AP Statistics

This course covers anticipating patterns involving the exploration of random phenomena using probability and simulation. It also describes data exploration as a statistical concept in data analysis where analysts use visualization and statistical techniques to describe dataset characterizations. By the end of this course, you should be ready to apply statistical reasoning in various fields of learning.

Introduction

Beginner Formatting

Working With Information: Basics

Essential Formatting and Analysis Tricks

In this module, learn how to create new documents from scratch or via the default templates in the gallery. A simple walkthrough of Google sheets, including how to organize your spreadsheets in Google Drive, will be presented. Then, you will discern how to work with numbers and basic functions.

Intermediate Google Sheets

Real Life Application of Google Sheets

In this module, study the methods for creating and using multi-tab formulas, and vital functions like the Count, CountA, SumIf, etc. The concatenation and vertical lookup functions will be explained. Discern how to visualize your data via charts, graphs and pivot tables. Then, the real-world applications of Google sheets will be demonstrated.

Google Sheets for Home and Business - Course Assessment

Master the use of Google spreadsheets for statistical analysis and data visualizations in this free online course.

Google Sheets for Home and Business

In this free online course, learn how to create, view, and edit Google spreadsheets. Study how to perform basic and advanced tasks with Google spreadsheets, including data formatting and modifications, arithmetic and stats operations, as well as the capabilities for data analysis, information customization, and data visualization. The tasks to be taught will range from beginner to advanced levels for a wider reach to ensure proficiency.

Introduction, Excel Basics and Formatting Elements

Application of Excel Formatting Elements

Excel Formulas and Saving a Workbook

This module will introduce you to Excel basics such as the meaning of spreadsheets and their uses. We will begin on how to start up Excel, formatting elements in Microsoft Excel, and their various applications.

Excel Functions

Advanced Functions

Printing Workbook and Setting Excel Passwords

In this module, you will be introduced to Microsoft Excel functions (beginner to advanced functions), how to print excel document (workbook), password management, and other important topics.

Mastering the Basics of Microsoft Excel - Course Assessment

Learn how to use Microsoft Excel and pick up advanced spreadsheet skills in this free online data visualisation course.

Mastering the Basics of Microsoft Excel

The world of technology sees constant change as new software hits the market and established programs are updated. Microsoft Excel is a powerful and popular spreadsheet program used by individuals and businesses of all sizes. This Excel tutorial explains how to use its basic and advanced features to make you a data visualisation expert. Spreadsheets are a staple of most white-collar jobs so sign up to enrich your skills and advance your career.

Google Sheets – Introduction

Google Sheets – Start It

Google Sheets – Insert It

Google Sheets – Organize It

Google Sheets – Work With It

Google Sheets has utilities beyond data and tables. This module will teach you the ins and outs of Google Sheets as you learn to access it in more than one way. The hands-on style of instruction will focus on presenting data in an engaging and presentable form by learning to format, insert, organize and analyze.

Course assessment

Learn how to use open-source Google Sheets to organize, analyze and present data in this free online spreadsheet course.

Basics of Google Sheets

This Google Sheets tutorial helps you to make the most of the platform’s abilities that go beyond simple tables. We explain how to start a project from scratch and insert checkboxes, notes, comments, images, drawings and videos to create an impressive digital asset. We explore the ‘format’ menu to let you organize your data before you start working. Google Sheets is more than ‘free Excel’ so sign up to learn how to use it to advance your career.

Importing Data

Working With Data

More on Working With Data

Input Types and Informats

SAS Functions

Visual Representation of Data and Analyses

In this module, you will be introduced to SAS Programming. You will learn how to import different data files and write codes. You will also be taught to create new variables, organize data, read dates and use various functions in SAS. At the end of this module, you will be shown how to represent your data in a visual form using charts and graphs and how to run statistical analyses on available data.

SAS Programming - Course assessment

Learn SAS Programming basics, various data analyses, functions, and data visualization in this free online course.

SAS Programming

In a world full of programming languages, it’s hard to know what one is relevant for you and your needs. Statistical Analysis Software (SAS) is used for advanced analytics like business intelligence, crime investigation, and predictive analysis. This data science course will teach you the various functions and analyses available using SAS programming including importing data and running statistical analyses using easy-to-understand methods.