Course curriculum

  • 1

    Chapter 1: Fundamentals of Big Data Analytics - Introduction

  • 2

    Chapter 2: Fundamentals of Big Data Analytics - Big Data Technologies

    • Chapter 2 Overview

      FREE PREVIEW
    • Requirements of Big Data Architecture

    • Converting Raw Data into Insight

    • Establishing the Architectural Foundation

    • Defining Big Data Architecture

    • Evaluation Criteria Before Investing in Big Data Solution

    • Asking the Right Questions to Start Big Data Project

    • Logical Layers of Big Data

    • Big Data Sources

    • Data Massaging and Store Layer

    • Analysis Layer

    • Consumption Layer

    • Big Data Reference Architecture

    • Physical & Security Infrastructure

    • Shared Infrastructure

    • Resiliency and Redundancy

    • Security Infrastructure

    • Operational Database

    • Non-Relational Databases

    • SQL & NoSQL Database Engines

    • How Data Lakes Work

    • Extract Transform Load

    • Analytical Data Warehouse

    • Data Warehouse vs Data Lake

    • Importance of Big Data Analytics

    • Types of Visualisation Tools

    • The Cloud's Role in Big Data

    • Why The Cloud is Important for Big Data

    • Defining Cloud Computing in Big Data

    • Two Types of Cloud Model in Big Data

    • Cloud Deployment Model

    • Cloud Delivery Model

    • Using The Cloud in Big Data

    • Takeaways

    • Chapter 2 Quiz

  • 3

    Chapter 3: Fundamentals of Big Data Analytics - Managing Big Data - Software & Technology

    • Chapter 3 Overview

      FREE PREVIEW
    • Defining Big Data

    • The Datafication of Our World

    • Understanding Big Data & The 3 Vs of Big Data

    • Big Data Technologies

    • The Hadoop Story

    • Technologies in Hadoop Ecosystem

    • Hadoop HDFS

    • Hadoop MapReduce

    • Apache Spark

    • HDFS vs Spark

    • Apache Drill

    • Data Preparation

    • Clients Support for Drill

    • Datastores Supported by Drill

    • Distance to Data

    • Evolution Towards Self-Service Data Exploration

    • Hadoop Vendors

    • Takeaways

    • Chapter 3 Quiz

  • 4

    Chapter 4: Fundamentals of Big Data Analytics - Big Data Analytics

    • Chapter 4 Overview

      FREE PREVIEW
    • Big Data Analytics

    • Types of Data Analytics

    • Reasons Organisations Deploy Big Data Analytics

    • Implementing a Big Data Analytics Solution

    • Big Data Analytics Summary

    • Big Data Analytics Process Flow

    • How Big Data Analytics Are Being Used

    • Basic Analytics

    • Advanced Analytics for Insight

    • Operationalised Analytics

    • Monetising Analytics

    • Big Data Analytics Solutions

    • Machine Learning in Hadoop Ecosystem

    • Machine Learning - Apache Mahout™

    • Spark MLlib

    • Flink

    • Takeaways

    • Chapter 4 Quiz

  • 5

    Chapter 5: Fundamentals of Big Data Analytics - Use Cases

  • 6

    Chapter 6: Excel Fundamentals & Pivot Table

    • Introduction

    • Welcome Notes

    • Learning Goals

    • Learning Contents

    • Fundamentals on Worksheet, Excel Interface, Data Types and Operators

    • Quiz

    • Predefined Functions on Descriptive Statistics, Data Organisation, Conditionals, DateTime and Search Functions

    • Quiz

    • Data Normalisation & Its Technique

    • Pivot Tables, Its Functions & Applications

    • Quiz

  • 7

    Chapter 7: Excel Visualisation & Dashboard

    • Learning Contents

    • Conditional Formatting and Sparklines

    • Quiz

    • Preparing Datasets for Visualization

    • Creating Effective Charts with Design Best Practices

    • Quiz

    • Creating a PivotChart

    • Types of Dashboard and Their Functions

    • Quiz

    • Checklist for Creating a Dashboard

    • Quiz

    • Step by Step Guide to Dashboarding

    • Interacting with Your Charts

  • 8

    Chapter 8: Exploratory Data Analysis with Excel

    • Progress so far…

    • Learning Contents

    • Introduction to Statistical Data Analysis

    • One Categorical Variable - One Way Table & Pivot Table

    • One Categorical Variable - Pie Chart, Bar Chart & Application

    • One Numerical Variable - Central Tendency, Median, Mean, Mode & Application

    • Quiz

    • Dispersion, Variability, Range, Percentile, IQR, Outlier, Variance & Standard Deviation

    • Quiz

    • One Numerical Variable - Boxplot, Histogram & Application

    • Examining Relationship - Two Categorical Variables (C- > C) with Pivot Table

    • Quiz

    • Examining Relationship - Two Categorical Variables (C->C) with Charts

    • One Categorical Variable & One Numerical Variable (C-Q) with Pivot Table & Charts

    • Quiz

    • Examining Relationship - Two Numerical Variable (Q->Q) with Pivot Table

    • Examining Relationship - Two Numerical Variable (Q->Q) with Pearson’s Correlation Coefficient

    • Quiz

    • Examining Relationship - Two Numerical Variable (Q-Q) with Charts

    • Excel Analytics - Module Summary, Recap & Application

  • 9

    Chapter 9: Data Visualization for Business Intelligence with Excel

    • Introduction

    • Welcome Notes & Learning Goals

    • Learning Contents

    • Excel Interface and Essentials

    • Types of Data

    • Quiz

    • Steps to Create a Pivot Table

    • Steps to Create Bar Chart, Pie Chart and Line Chart with Time Series

    • Quiz

    • Conditional Formatting & Its Techniques

    • Quiz

    • Types of Dashboard and Their Functions

    • Quiz

    • Chart Tools & Their Functions

    • Quiz

    • Overall Summary, Recap & Application

  • 10

    Chapter 10: Data Storytelling - The Process of Effective Data Storytelling

    • Introduction

    • Welcome Notes

    • Learning Goals

    • Learning Contents

    • Examples of Poor Storytelling

    • Quiz

    • The Data Storytelling Process - Who

    • Quiz

    • The Data Storytelling Process - What

    • Quiz

    • The Data Storytelling Process - How

    • Quiz

    • Storyboarding

    • Quiz

  • 11

    Chapter 11: Data Storytelling - Making Impactful Visual for Your Data Story

    • Welcome Back!

    • Learning Contents

    • Learning Goals

    • Graphical Perception

    • Quiz

    • Choosing a Visual

    • Quiz

    • Making a Visual from Good to Great

    • Quiz

    • Overall Summary, Recap & Application