NeoCoder

Data Warehouse, ETL & BI Concepts

Home Training Library Big Data Data Warehouse, ETL & BI Concepts

We've everything to build a perfect L&D program

700+
Learning Topics
120+
Video Content
100+
Coding Exercises
300+
Quiz
450+
Skill Assessment
100+
Hands-on Projects

Topics Covered

Data Warehouse, ETL & BI Concepts
Data Warehouse - Introduction
  • Evolution of Data Warehousing
  • Data marts Vs Data Warehouses
  • Operational Data Stores
  • Warehouse components
  • Data Warehouse Architecture
  • Data Staging
  • Three layer Architecture
Data Warehouse, ETL & BI Concepts
Data Warehouse - Modeling
  • Schemas
  • Data Aggregation
  • Data Explosion
  • Dimensional modeling
  • Star and Snowflake Schema
  • Transactions and Snapshot Schemas
  • Staging Area Modeling Views of Bill Inmon and Ralph Kimbal
Data Warehouse, ETL & BI Concepts
Business Intelligence Concepts
  • Meta Data
  • Accessing Data Warehouse
  • OLAP and Dashboard
  • OLTP
  • OLAP
  • Types of OLAP
  • OLTP vs. OLAP
  • BI Tools
  • Issues
  • Dashboards
Data Warehouse, ETL & BI Concepts
Data Warehouse - ETL
  • ETL – Definition
  • ETL – Introduction
  • Framework of ETL
  • Data Extraction – Overview
  • Extraction Methods
  • Data Transformation Activities
  • Aggregation Techniques
  • Data Loading
  • Types of Load
  • ETL Architecture
Data Warehouse, ETL & BI Concepts
Data Warehouse - Design Factors
  • Meta Data
  • Accessing Data Warehouse DW
  • Modeling techniques Requirement
  • Modeling & Analysis Modeling
  • Tool selection
Data Warehouse, ETL & BI Concepts
Data Warehouse - Introduction
  • Evolution of Data Warehousing
  • Data marts Vs Data Warehouses
  • Operational Data Stores
  • Warehouse components
  • Data Warehouse Architecture
  • Data Staging
  • Three layer Architecture
Data Warehouse, ETL & BI Concepts
Data Warehouse - ETL
  • ETL – Definition
  • ETL – Introduction
  • Framework of ETL
  • Data Extraction – Overview
  • Extraction Methods
  • Data Transformation Activities
  • Aggregation Techniques
  • Data Loading
  • Types of Load
  • ETL Architecture
Data Warehouse, ETL & BI Concepts
Data Warehouse - Modeling
  • Schemas
  • Data Aggregation
  • Data Explosion
  • Dimensional modeling
  • Star and Snowflake Schema
  • Transactions and Snapshot Schemas
  • Staging Area Modeling Views of Bill Inmon and Ralph Kimbal
Data Warehouse, ETL & BI Concepts
Data Warehouse - Design Factors
  • Meta Data
  • Accessing Data Warehouse DW
  • Modeling techniques Requirement
  • Modeling & Analysis Modeling
  • Tool selection
Data Warehouse, ETL & BI Concepts
Business Intelligence Concepts
  • Meta Data
  • Accessing Data Warehouse
  • OLAP and Dashboard
  • OLTP
  • OLAP
  • Types of OLAP
  • OLTP vs. OLAP
  • BI Tools
  • Issues
  • Dashboards

Tailor the curriculum for your tech team with customizable skill modules

Yes, L&D professionals can handpick the skill modules of their choice from our huge repository to design the perfect skill development program for their tech team and drive greater ROIs.

Contact us for a Demo +91 - 93429 07576

Why neoCoder's skill
modules are the finest?

Content structured to different learning level

Organizations commit a huge mistake in the employee L&D programs by providing the same learning content for both entry-level freshers and experienced professionals.

Organizations commit a huge mistake in the employee L&D programs by providing the same learning content for both entry-level freshers and experienced professionals.

  • Noob
  • Beginner
  • Intermediate
  • Advanced
  • Master

 

24x7
Replenishing content

In a world of continuous technological advancement, the learning materials should be fresh and updated.

Our skill modules are constantly updated with respect to the changes in the tech universe. Hence your employees stay on track with the latest tools and technologies used in the industry.

Diverse
assessment options

Our powerful AI-powered engine helps you to assess your employee’s potential at once. With the aid of the auto-evaluation feature, the following diverse assessment modules are evaluated at a rapid rate, thereby saving an enormous time.

  • Quiz
  • Skill assessments
  • Coding Exercises
  • Hands-on projects

Accelerate your upskilling program with NeoCoder