Learning Outcomes

Sorting Function

Filter And Conditional Formatting

Pivot Tables And What-If Analysis

Lesson Summary

This module will discuss Excel's sorting, filters, and pivot tables, and you will see how Excel can significantly contribute to effective data organization and analysis. You will learn that the sorting function enables users to arrange data in ascending or descending order based on selected criteria.

Vlookup and Hlookup Functions

Goal Seek And Data Table

Average, Median And Countif Functions

This module will cover the most powerful Microsoft Excel functions like VLOOKUP, HLOOKUP, and Goal Seek. You will learn that they are powerful tools that enhance data analysis and decision-making. You’ll also see that VLOOKUP is a function that enables users to search for a specific value in a vertical column and retrieve information.

Mastering Data Analysis Using Microsoft Excel – Course Assessment

Learn the hot topics of Big Data, Data Analysis, and Microsoft Excel formulas in this free online course.

Mastering Data Analysis Using Microsoft Excel

This course is an invaluable opportunity to gain insight into Data analysis and Microsoft Excel. The knowledge gained will give you the ability to make sense of your company’s data. In addition, you will have the competence to assist your company and managers in making informed decisions based on your data analysis. Discover the different Microsoft Excel formulas and tables that can help you reach your potential.

Frameworks For Information Technology

A Framework Base On IT

The Basics Of Information Systems

Learn more about the relationships between business frameworks and Information Technology.

Modern Organizations

Organizational Flexibility

Strategic Issues Of Information Technology

Learn more about corporate IT strategy in modern businesses and organizations.

Introduction to Corporate IT Strategy and Business Frameworks - Course Assessment

Learn more about the role of IT in the business framework and corporate strategy development with this online course.

Beginner Corporate IT Strategy and Business Frameworks

This free online Corporate IT Strategy and Business Frameworks course will introduce you to the importance of IT in the design of business frameworks. IT has become one of the key elements in the design of business frameworks and has a significant influence on corporate strategy. In this course, you will learn all about the different types of tools that help in information systems and the main characteristics of each type of system.

Introduction to Data Management

Designing a Database

Database Management Systems

This module introduces the concept of data and databases. It consists of topics that cover the following concepts: Definitions of data, information and knowledge, hierarchical relationship and the DIKW pyramid, introduction to relational databases, designing databases, database normalization, an introduction to Structured Query Language(SQL), Database Management System (DBMS), big data and enterprise databases.

Data Warehouse

Data Mining

Knowledge Management

This module discusses data warehouses and data mining. It covers the following: Introduction to data warehouse, bottom-up and top-down approaches to data warehouse design, benefits of setting up a data warehouse, the process of data mining, business Intelligence and business analytics and organizational knowledge management and its role in decision making.

Data, Databases and Mining - Course assessment

Learn how businesses can gain a competitive advantage through data with this free online course.

Data, Databases and Mining

This free online course explains the importance of data and knowledge to an organization. It describes the lifecycle of data in the wisdom hierarchy and how knowledge management can be used in business intelligence. By the end of the course, you will be able to describe the flow of data through the information ladder and its role in organizational growth. Start your learning journey on the uses of databases and data mining today!

Association Rule Mining

Association Rule Mining (cont'd)

This module introduces associative rule mining. You will learn about frequent patterns and rules in mining and be able to list when association rules can be applied. You will also learn about the apriori algorithm.

Big Data , A small introduction

Big Data , A small introduction(cont'd)

In this module you will learn about big data. You will learn about the four V’s of big data and why social media data can be hard to disambiguate.

Clustering Analysis

Clustering Analysis(cont'd)

In this module you will learn about clustering analysis. This module will teach you about why clustering is used and the different types of clustering. You will also learn about K-means and K-meloids.

Introduction to Experimentation and Active Learning

Introduction to Experimentation and Active Learning(cont'd)

An Introduction to Online Learning - Reinforcement Learning

An Introduction to Online Learning - Reinforcement Learning(cont'd)

In this module you will learn about experimentation and active learning and creating data in an online and offline context. You will learn about online learning and the n-arm bandit problem.

Data Analytics - Mining and Analysis of Big Data - Assessment

Learn how to analyse big data using mining and clustering techniques, in this free online big data analytics course.

Data Analytics - Mining and Analysis of Big Data

This free online Big Data Analytics course from Alison will teach you how to mine and analyse big data. This process of studying and evaluating data is widely used in business and commercial industries and even in the government sector. With the help of this course, you will also learn how to create clustering data models which in turn can help you make more informed decisions. Make this a part of your business practice now!

Microsoft Power BI Data Analytics

Working with Big Data

In this module, you will be introduced to Microsoft Power BI and its features. You will learn how to perform big data analytics using Microsoft Power BI. We will also discuss how you can create interactive visualizations, reports and dashboards from your big data sets for analysis.

Course Assessment

In this free analytics course, learn how to use Power BI to transform your data into interactive visual reports.

Introduction To Data Analytics Using Microsoft Power BI

Data analysis is a powerful skill to have today and by using Microsoft Power Business Intelligence (BI) you can do so effectively and efficiently. Through this course, you will learn how to create interactive visualizations, reports and dashboards with a few clicks or drag-and-drops. You will also see how Power BI can handle files that are too large for Excel.