Skip to content

Latest commit

 

History

History
24 lines (15 loc) · 995 Bytes

README.md

File metadata and controls

24 lines (15 loc) · 995 Bytes

The key topic areas are:

  • Data architecture
  • Dimensional data modeling
  • Data integration and ETL (extract, transform & load)
  • Data engineering & Data Preparation
  • BI & data analytics design

This repository examines both:

  • Modern Analytical Data Architecture (ADA) approach leveraging relational, columnar, on-line analytical processing (OLAP), Hadoop & NoSQL databases.
  • Traditional BI approach with an Enterprise Data Warehouse (DW)
  • The repository includes concepts and best practices along with workshops, homework and team projects applying learnings with industry-leading products such as: Tableau, Microsoft PowerBI, Talend Data Integration and Alteryx.

Additional software in conjunction with BI and data integration tools:

Microsoft SQL Server, Oracle, MySQL, PostgreSQL, Talend Big Data sandbox, Alteryx, ERStudio Data Architect

Instructor: Rick Sherman

Reference Book: Business Intelligence Guidebook: From Data Integration to Analytics