Learning Outcomes

Qlik Sense and Its Different Versions

Exploring the Qlik Sense Interface

Loading Data – Part 1

Loading Data – Part 2

Lesson Summary

Data becomes comprehensible and easier to process for the human mind through a visual context. In this module, you will be introduced to a data analytics platform that helps in creating engaging visuals for business insights along with decision making. You will explore the interface of Qlik Sense and compare it with its earlier version.

Creating and Uploading Apps

Adding Your First Chart

Editing Your Visualisation – Part 1

Editing Your Visualisation – Part 2

The second module of this course will teach you about creating and uploading apps on Qlik Sense. You will also learn to add your first chart by understanding the roles of Insight Advisor, Chart Suggestion Assistance and No Assistance tabs. Finally, you will get the guidelines and best practices for creating and editing visualisations on Qlik Sense.

Publishing and Sharing Apps

Data Assets in Visualisation – Part 1

Data Assets in Visualisation – Part 2

After creating an app on Qlik Sense, there is a way to share its contents with other users, this is done by publishing it. In this module, you will learn to share and publish your apps on Qlik Sense. You will also become competent in the understanding of various data assets in visualisation namely, dimensions, measures, fields and master items.

Course assessment

Pick up the data visualisation skills required to improve decision-making in this free online data science course.

Getting Started in Qlik Sense

Learn how to work with Qlik Sense, a self-service business intelligence and visual analytics platform, in this free online course. You will master the essentials of navigating Qlik Sense by learning to load data and creating and loading apps. You will also learn about editing your visualisation in addition to publishing and sharing apps. This course is particularly beneficial for those wanting to use data and visual analytics for quick insights.

Introduction to Open-Source Intelligence

Tackling Cyber Threats with OSINT

Dealing with Online Anonymity with OSINT

Practical Uses of OSINT

This module helps you understand the crucial concepts surrounding Open-Source Intelligence (OSINT). You will learn about its various applications and uses against cyber threats and online anonymity. Moreover, it will also explain the intelligence cycle and its steps in detail.

Fundamentals of Open-Source Intelligence (OSINT) - Assessment

This free online course will introduce you to the fundamental aspects of Open-Source Intelligence and its applications.

Fundamentals of Open-Source Intelligence (OSINT)

The world of cybercrimes is becoming increasingly complex and intricate. By employing modern tactics, cybercriminals are making it difficult for governments and regulatory agencies to track them and their activities. However, Open-Source Intelligence (OSINT) and its associated practices are a robust stronghold against their activities. In this short course, developers will provide Alison students with an overview of OSINT and its practices.

An Overview to Modelling and Analytics

Introduction to Supply Chain

Uncertainty and Risks in Supply Chain

Decisions and Performance Measures in Supply Chain

Introduction to Analytics in Supply Chain

Analytics Framework Based on SCOR Model

Design Options for Distribution Network

This module presents the basics of modelling and analytics in the supply network. You will learn about the flows of the supply chain, measures for analysing the performance of the supply chain and how big data analytics can be leveraged in managing the supply chain.

Linear Programming

Linear Point Method

Rating and Ranking Method

Clustering Method

MCDM Techniques

This module highlights the various analytics involved in the supplier selection process. You will learn about the need for mathematical modelling in selecting suppliers, various methods of selecting suppliers and the process of converting qualitative information into numeric market information.

Transportation Cost Modelling

Min-Max and Max-Min Model

Maximum Flow Model

Shortest Path and Minimal Spanning Tree Model

This module presents the modelling and analytics techniques involved in transportation. You will learn about the various techniques available for transportation modelling, how to minimize the maximum quantity on a high cost transportation route and how to determine the shortest route when there are networks of roads.

Decision Making for Warehouse Location

Break Even and Centre of Gravity Model

Ardalan Heuristic and Transportation Cost Model

Total Cost Model

Warehouse Layout

Warehouse Space Calculation

Storage Space Calculation

This module presents the modelling and analytics techniques involved in determining the locations and space requirements of warehouses. You will learn about the various conventional and modern ways for determining warehouse locations, the procedure for determining the overall size of the warehouse and the process of estimating the space requirement and storage patterns in a warehouse.

Performance of the Entire Supply Chain

Data Envelopment Analysis

This module presents the strategic performance measurements used for improving the efficiency of the warehouse. You will learn about the procedure for measuring the performance of the warehouse, various input and output operations in the warehouse and the role of DEA,CRS and VRS models in improving performance operations of a warehouse.

Concepts in Inventory Management

Simultaneous Production and Consumption Model

Lost Sales

Multiple Items Inventory Models

Constraint on Space and Number of Orders

This module presents the concept of inventory and inventory management in the context of supply chain. You will learn about the different terminologies used in inventory management and how inventory modelling helps in dealing with the constraints on space, planned shortages with backorders and lost sales.

First Course Assessment

Safety Stock and Reorder Level

Continuous Review System

Periodic Review System

This module presents the functions of various review systems in the context of inventory management. You will learn about the tracking procedure of  inventory and how to determine the fixed interval reorder point for reviewing the inventory.

Transport Systems in India and the World

Transport Costing

Public Transport Costing

Fixing Fare for Public Transportation System

Foreign Trade Logistics

This module presents an overview of the transportation systems in the context of Supply Chain Management. You will learn about the procedure for determining transportation costs using mathematical modelling, the use of formula and passenger–kilometre approaches to fix the costs of public transports and how logistics takes place between India and its neighbouring countries.

Analytical Hierarchy Processing (AHP) Method

Technique of Order Preference by Similarity to Ideal Solution (TOPSIS) Method

VIKOR Method

ISM Method

Forecasting Simple and Weighted Average Mean Square Error

Exponential Smoothing Method

Seasonality in Forecasting

Trend Regression

Holt's and Winters' Method

Multi Period Forecasting

This module presents the various multi-criteria decision making and forecasting methods. You will learn about the process of determining the best supplier or best product, based on multiple criteria and the procedure of forecasting when the model estimates demand and constant.

Information Distortions in Supply Chain

Coordination and Collaboration Modelling

Six Sigma Approach to Coordination

Measuring the Degree of Coordination

This module discusses the modelling coordination in Supply Chains. You will learn about the effects of information distortions in the Supply Chain and how Six Sigma and the Queuing Theory helps in developing robust coordination systems.

Risks and Supply Chain Disruptions

Modelling Risk Analytics

This module discusses the risk analytics in Supply Network Design. You will learn how risks disrupt the supply chain, the steps involved in assessing the risks and the need for mathematical modelling to estimate the riskiness of a supply chain.

Taxation

Tax Advantages

Transhipment

Flexibility

Total Cost

Echelons

This module presents the design and modelling of the Global Supply Chain. You will learn the process of designing Global Supply Chain by taking care of tax advantages. Discover how modelling the total cost of the supply chain helps in minimizing the cost  and how to design the entire supply chain right from the supplier base to the end customer.

Second Course Assessment

Advanced Diploma in Modelling and Analytics for Supply Chain Management-Course Assessment

In this free diploma in modelling and analytic, learn how Analytics can be applied to various domains of supply chain.

Advanced Diploma in Modelling and Analytics for Supply Chain Management

This free online diploma in modelling and analytics for supply management focuses on the nature and goal of supply networks and explains the impact of analytics-based supply chain decisions on the success of a firm. The course covers key metrics that track the performance of the Supply Network, identification of the key factors to be considered when designing a distribution network, and use of analytical techniques for developing a framework.

Business Intelligence

Starting Case

Decision-Making Process

Problem Structure

BI Application

Dashboard Presentation

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.

The Connection Between Regulatory Compliance and Generative AI

Organizational Implications of Generative AI

Generative AI in Financial Sector

Generative AI in Data Collection and Analysis

AI Systems - Compliance with Governance Frameworks

This module discusses the importance and practical implications of using generative AI in the regulatory sector. You will learn about the roles of its different applications in different sectors, especially the financial industry and data collection and analysis. Moreover, the importance of AI governance models and frameworks is also present.

AI in Compliance - Enhanced Regulatory Reporting & Workflows - Course Assessment

This free online course explains how organizations can utilize AI tools to comply with regulatory requirements.

AI in Compliance - Enhanced Regulatory Reporting & Workflows

This course explores how organizations can leverage generative AI to ensure compliance with various applicable standards. Learners will gain insights into regulatory compliance challenges, generative AI's pivotal roles in financial organizations, and best data collection, analysis, and research practices. It also emphasizes the importance of robust AI governance models, ethical aspects, and risk mitigation strategies to meet regulatory demands.

Installing SQL Server 2019 Express

Installing SQL Server Management Studio

Downloading the AdventureWorks Sample Database

Course Environment Walkthrough

In this module, we review some of the essential details regarding programming in SQL. A guide on how to install SQL Server 2019 and SQL server management studio shall be provided. We will also go through the process of downloading the AdventureWorks sample database. A walkthrough of the course environment shall also be provided during the module.

Introducing Window Functions With OVER

PARTITION BY

ROW_NUMBER Function

RANK and DENSE_RANK

LEAD and LAG

In this module, we will get an introduction to the window functions with OVER across an entire data set. We will also be going through a detailed walkthrough of functions such as PARTITION BY, ROW NUMBER, and RANK along with Lead and lag. A brief guide will also be provided on subqueries.

Introducing Subqueries

Scalar Subqueries

Correlated Subqueries

EXISTS function

FOR XML PATH with STUFF

PIVOT for Data

This module will be dealing with everything related to subqueries. We will be dissecting the concepts of scalar and correlated subqueries. We will also be taking a look at the application of the EXIST function. A walkthrough on how to flatten multiple rows into one using the FOR XML PATH will be provided along with the use of PIVOT.

Data Analysis Using CTE's

CTEs Walkthrough

Recursive CTE's

This module breaks down the process of performing complex analyses on your data in a step-by-step manner using common table expressions or CTEs. We will be taking a detailed look at how to easily break down queries in a simple and linear manner. We will also examine the use of recursion in order to generate a series of values in SQL.

Temp Tables 1 and 2

CREATE and INSERT

TRUNCATE Application

Modifying Tables Using UPDATE

Removing Rows Using DELETE

In this module, we will be taking a detailed look at a more flexible alternative to common table expressions known as the temp tables. We will also be examining the CREATE and INSERT functions to manage complex data structures. The TRUNCATE and UPDATE functions for clearing, using and modifying tables will be discussed.

Optimizing With UPDATE

An Improved EXISTS with UPDATE

Introduction to Indexes

Lookup Tables

This module will be taking a look at all the things associated with optimizing queries using the UPDATE statements. An improved version of EXISTS with UPDATE will also be examined during the module. We will be taking a detailed look at database objects known as indexes and the utility of lookup tables to make something permanent.

Develop an in-depth understanding of the concepts and functions of an advanced SQL server with this free online course.

Diploma in Advanced SQL Server

In this course, we will be taking your basic database skills up a notch and providing you with a refined understanding of coding in SQL 2019. We will be going through essential coding concepts such as carrying out advanced analyses, using subqueries, common table expressions and data optimisation. All these techniques can help you become a more efficient programmer and take your skills and career to the next level. So enrol now to keep learning!