Modern Data Architecture

Data Architecture – Series 1 Part 1 – Data Architecture Introduction

Data Architecture refers to the art and science of building data structures and the process of building enterprise data structures. In this series of videos, you can learn the elements of data-architecture as an Introduction.

Big Data Series

Big data: source and value.

Big Data Technologies The main sources of Big Data are data generated by machines, people, and organisations.Machine generated data we refer to data generated from real time sensors in industrial machinery or vehicles that logs that track user behaviour online, environmental sensors or personal health trackers, and many other sense data resources.Human generated data, we… Continue reading Big data: source and value.

Relational Data Warehouse

6. Introduction to DWBI – Goals of Data Warehouse

Building a Data warehouse Purpose & Goals of Data Warehouse Purpose & Goals of Data Warehouse: Focus on fundamentals before delving into details of modeling and implementation. Listen to the Business and understand the goals and current pain points in reporting the business needs. The Data warehouse must make the organizational information readily available and… Continue reading 6. Introduction to DWBI – Goals of Data Warehouse

Relational Data Warehouse

5. Introduction to DW&BI – ETL Extract Transform and Load

ETL – Extract Transform & Load Extract Transform and Load: ETL means Extract, Transform, and Load. ETL is a process combined with technology. Using this process data is extracted from all sources, and depending on the user requirements the data is transformed for reporting needs, and finally, data loaded into the Data warehouse. ETL is… Continue reading 5. Introduction to DW&BI – ETL Extract Transform and Load

Relational Data Warehouse

4.Introduction to DW & BI – DWBI Cycle

DWBI Cycle Data Warehousing and Business Intelligence: A real Business Intelligence passes through a Data warehouse and utilizes the data-stored for information, knowledge, and plans that produce effective business actions. So, Business Intelligence is a combination of process, technology, and a tool. Means Business Intelligence encompasses Data warehouse, Tools, and Visual knowledge management. Among all,… Continue reading 4.Introduction to DW & BI – DWBI Cycle

Relational Data Warehouse

3.Introduction to DW&BI – Kimball or Inmon Model

Data warehouse - Kimball or Inmon model. The following information provides an understanding of the basics of two different approach in Data warehouse modeling: History of Data Warehouse: In 1990 Inmon wrote a book "Building the Data Warehouse." Inmon defines an architecture for the collection of disparate sources into detailed, time variant data store (The… Continue reading 3.Introduction to DW&BI – Kimball or Inmon Model

Big Data Series

SSIS – Part 1. ETL – Creating an SSIS Project and Package

Creating an SSIS Project and Package

Big Data Series

SSDB – Part 13. ETL – Connecting Foreign Keys to Surrogate Keys

Connecting Foreign Keys to Surrogate Keys

Big Data Series

SSDB – Part 6. ETL – Documentation

Understanding Transformations: Setup and Renaming Columns for Legibility........READ MORE......

Big Data Series

SSDB – Part 5. ETL – Delete VS Truncate

SSDB ETL - Delete vs Truncate