Infogoal Logo
GOAL DIRECTED LEARNING
Master DW

Data and Analytics Tutorial

Data and Analytics Overview
Under Construction

Data and Analytics Success

Data and Analytics Strategy
Project Management
Data Analytics Methodology
Quick Wins
Data Science Methodology

Requirements

BI Requirements Workshop

Architecture and Design

Architecture Patterns
Technical Architecture
Data Attributes
Data Modeling Basics
Dimensional Data Models

Enterprise Information Management

Data Governance
Metadata
Data Quality

Data Stores and Structures

Data Sources
Database Choices
Big Data
Atomic Warehouse
Dimensional Warehouse
Logical Data Warehouse
Data Lake
Operational Datastore (ODS)
Data Vault
Data Science Sandbox
Flat Files Data
Graph Databases
Time Series Data

Data Integration

Data Pipeline
Change Data Capture
Extract Transform Load
ETL Tool Selection
Data Warehoouse Automation
Data Wrangling
Data Science Workflow

BI and Data Visualization

BI - Business Intelligence
Data Viaulization

Data Science

Statistics
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics

Test and Deploy

Testing
Security Architecture
Desaster Recovery
Rollout
Sustaining DW/BI

Under Construction Data and Analytics Topic

These Data and Analytics topics are under construction. Your success is important to us, so new topics are being added and enhanced.

Data Analytics Success topics include:

Come back soon.


Enterprise Information Management (EIM)

Enterprise Information Management (EIM) is a commonly used terminology that unifies displines of Information Architecture, Data Architecture and Data Management. EIM topics are addressed at multiple points in this tutorial. These disciplines, among others, compose EIM:

Return to Topic List


Time Series Data

The modern world is filled with situations where the timing sequence is critical to effective analysis. The Internet of Things (IoT) is generating high volumes, continuous flow of metrics obtained through measurement of devices. Stock markets are generating a high volume of trades on a second by second basis. Computer systems are generating high volumes of data about there status-bar such as jobs processed, memory used and computing cycles expended. High volume streams of data need to be rapidly captured, stored and analyzed. This is a big challenge.

What is a Time Series Database?

A Time Series DataBase (TSDB) is a DataBase Management System (DBMS) optimized to store and access high volumes of data which contains timestamps, an attribute which specifies date and time to a detailed level. Time Series DataBases provide distinctive capabilites:

Who Provides Time Series Databases?

Multiple vendors provide Graph DBMS Software. DB-Engines publishes a ranked list of graph DBMS. InfluxDB is the market leader in TSDB according to DB-Engines research. The top five in that list as of June 9, 2020 are:

In addition to the above suppliers, consider DBMS that have been improved to support time series such as: Teradata, Redis and Informix.

Time Series Data References and Links

Check out these Time Series Data links:

Return to Topic List


Data Integration

This article is under construction. Come back soon to see completed article.

What is Data Integration?

Lead in sentence:

Data Integration References and Links

Check out these Data Integration links:

Return to Topic List


Data Pipeline

This article is under construction. Come back soon to see completed article.

What is a Data Pipeline?

Lead in sentence:

Data Pipeline References and Links

Check out these Data Pipeline links:

Return to Topic List


Change Data Capture (CDC)

This article is under construction. Come back soon to see completed article.

What is Change Data Capture (CDC)?

Lead in sentence:

Change Data Capture (CDC) References and Links

Check out these Change Data Capture (CDC) links:

Return to Topic List


Data Warehouse Automation

This article is under construction. Come back soon to see completed article.

What is Data Warehouse Automation?

Lead in sentence:

Data Warehouse Automation References and Links

Check out these Data Warehouse Automation links:

Return to Topic List


Data Wrangling

This article is under construction. Come back soon to see completed article.

What is Data Wrangling?

Lead in sentence:

Data Wrangling References and Links

Check out these Data Wrangling links:

Return to Topic List


Data Science Workflow

This article is under construction. Come back soon to see completed article.

This different that methodology. Instead refers to workflow of the developed solution. Reference tools like: Alteryx and Knime.

What is a Data Science Workflow?

Lead in sentence:

Data Science Workflow References and Links

Check out these Data Science Workflow links:

Return to Topic List


Data Visualization

This article is under construction. Come back soon to see completed article.

What is BI Data Visualization?

Lead in sentence:

BI Data Visualization References and Links

Check out these BI Data Visualization links:

Return to Topic List


BI Data Visualization

This article is under construction. Come back soon to see completed article.

What is BI Data Visualization?

Lead in sentence:

BI Data Visualization References and Links

Check out these BI Data Visualization links:

Return to Topic List


Statistics

This article is under construction. Come back soon to see completed article.

What is Statistics?

Lead in sentence:

Statistics References and Links

Check out these Statistics links:

Return to Topic List


Descriptive Analytics

This article is under construction. Come back soon to see completed article.

What is Descriptive Analytics?

Lead in sentence:

Descriptive Analytics References and Links

Check out these Descriptive Analytics links:

Return to Topic List


Predictive Analytics

This article is under construction. Come back soon to see completed article.

What is Predictive Analytics?

Lead in sentence:

Predictive Analytics References and Links

Check out these Predictive Analytics links:

Return to Topic List


Prescriptive Analytics

This article is under construction. Come back soon to see completed article.

What is a Prescriptive Analytics?

Lead in sentence:

Prescriptive Analytics References and Links

Check out these Prescriptive Analytics links:

Return to Topic List


Security Architecture

This article is under construction. Come back soon to see completed article.

What is Security Architecture?

Lead in sentence:

Security Architecture References and Links

Check out these Security Architecture links:

Return to Topic List


Disaster Recovery

This article is under construction. Come back soon to see completed article.

What is Disaster Recovery?

Lead in sentence:

Disaster Recovery References and Links

Check out these Disaster Recovery links:

Return to Topic List


Advertisements

Advertisements:
 


Infogoal.com is organized to help you gain mastery.
Examples may be simplified to facilitate learning.
Content is reviewed for errors but is not warranted to be 100% correct.
In order to use this site, you must read and agree to the terms of use, privacy policy and cookie policy.
Copyright 2006-2020 by Infogoal, LLC. All Rights Reserved.

Infogoal Logo