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

Data and Analytics Tutorial

Welcome to Data Warehousing and Business Intelligence Tutorials including: OLAP, BI, Architecture, Data Marts, and more.

Times are changing in the field of data warehousing and business intelligence, so I wrote this tutorial and accompanying book to provide a fresh perspective on the field.

Upon finishing this tutorial, you will understand what data warehousing, business intelligence, and analytics are. You will be familiar with the goals of and components that make up data warehousing, business intelligence, and analytics. In addition, approaches used by data warehousing professionals will become clear. Examples in the tutorial will enable you to be ready to work and manage others in the field of data warehousing.

The book, The Analytical Puzzle: Profitable Data Warehousing, Business Intelligence and Analytics provides even more details - plus over 20 helpful templates to accelerate your data warehousing and analytics projects.

You will better understand: 

  • How to get the right people involved in the project
  • How to determine data warehouse business requirements
  • How to choose between a data warehouse and a data mart
  • How to load the data warehouse
  • How to choose data going into the data warehouse
  • How to achieve the benefits of business intelligence
  • How to manage the ongoing data warehouse
  • How to define a data warehousing architecture
  • How to create data models for data warehouses and data marts
  • How to avoid traps and pitfalls, so you can avoid problems and succeed
  • How to present information to users of the data warehouse and business intelligence system.

 Data Warehousing and Business Intelligence Introduction

This tutorial introduces data warehousing and business intelligence. Learn the fundamentals and benefits of this exciting subject.
more...


Project Management for Data Warehousing

Learn how to organize a data warehousing and business intelligence project. Make the winning moves and avoid the killer mistakes.
more...


Data Warehousing and Business Intelligence Methodology

Learn the steps of successful data warehousing and business intelligence efforts. These proven steps can put your time on the path to success.
more...


Data Warehousing Business Requirements

Learn how to gather and organize business intelligence and data warehousing business requirements.
more...


Data Modeling for Data Warehouse

Data models are key to successful for data warehouses and data marts. Design patterns for each part of the data warehouse will help you to design needed databases.
more...


Metadata for Data Warehousing and Business Intelligence

Metadata is often called "data about data". Learn how to manage metadata for your data warehousing and business intelligence project.
more...

ETL : Extract, Transform, Load

Learn how to use ETL for your data warehousing project. Topics include: ETL architecture, data mapping, data cleansing, data transformation and loading data.
more...


Data Warehousing Databases

Which database software and features should you use for you data warehousing project? Learn how to use database technology for your data warehousing project.
more...


OLAP / MOLAP / ROLAP

OLAP (OnLine Analytical Processing) is a key technology for data warehousing and business intelligence. Learn how to strengths and weaknesses of OLAP forms: MOLAP, ROLAP and HOLAP.
more...


BI / Business Intelligence

Business intelligence tools are used to analyze and present data. Gain an understanding of types of business intelligence (BI) that can help with your data warehousing project.
more...


Data Warehousing Rollout

The rollout is the project phase when the data warehousing / business intelligence system is made available to its users. Follow these steps to increase your chances of success.
more...


Sustaining BI and Data Warehousing

A sustainable program will keep your BI and Data Warehousing efforts moving in the right direction.
more...


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