Essentials of Data Analytics
The Essential Of Data Analytics (EDP) program is here to help everyone in the organization with the skills to leverage data for growth, and this course will equip you with the analytical prowess.
Course Outline
FREE PREVIEWWhat, Why, and How of Big Data
FREE PREVIEWSegments of Big Data
Growth of Big Data
Case Study - Cloudera
Public Cloud in Big Data
The Challenges of Big Data Adaptation
Data Silos
Driving Factor in Big Data Investments
Primary Driver of Big Data in Companies
Takeaways
Chapter 1 Quiz
Chapter 2 Overview
FREE PREVIEWRequirements 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
Chapter 3 Overview
FREE PREVIEWDefining 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
Chapter 4 Overview
FREE PREVIEWBig 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
Chapter 5 Overview
FREE PREVIEWAmex
Delta
Walmart
UPS
Alibaba
Ending
Chapter 5 Quiz
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
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
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
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
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
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