Data Warehousing and Business Intelligence for Managers

Organizations use data warehouses to speed reporting by consolidating data across silos, support complex analytical questions, monitor current operations, and forecast trends with time-based snapshots.

Explore a four-layer data warehousing diagram—sources, staging, data warehouse, and data access—and learn how ETL pulls data from transactional systems to a historical warehouse for reporting and analysis.

Master the iron triangle of cost, scope, and time in data warehousing projects, and apply ETL processes with a specialized team to deliver production reports.

Explore the data journey from capture to usable insights in a data warehouse. Analyze sources and reports to design effective, trusted business insights for managers.

Explore Inmon's top-down relational modelling for corporate data warehouses in third normal form, emphasizing subject orientation, time variant data, nonvolatile integration, and data marts for business intelligence.

Explore how big data coexists with data warehousing, and why relational databases can't manage big data. Learn to parse repetitive data, apply textual disambiguation, normalize it, and use parallel processing.

Explore data modeling as the core of the data warehouse, using sql to query sources and create reports, and compare kimball dimensional modeling with third normal form.

Plan and design a data warehouse by mapping data sources to target dimensions and facts, implementing an etl process that extracts, transforms, and loads data using batched sql statements.

Learn how to load data into a data warehouse using star and snowflake schemas, populate dimension and fact tables, and preserve referential integrity by conformed dimensions and proper sequencing.

Compare enterprise and scrappy BI tools such as MicroStrategy, IBM Cognos, Oracle BI, and Business Objects. Understand selection factors, users' needs, and why business users rarely create their own reports.

Design a data mart and data warehouse for Virginia rail incident tracking, organize inspections and reports, manage the final project, and plan for a nationwide business intelligence solution.

Explore how real-time reporting connects operational data to corporate dashboards, enabling fast analytics, data governance, and closer IT and business collaboration to deliver a united version of the truth.

Explore how real-time data streams from multiple sources feed a data lake and an operational data store, applying schema on read to enable rapid business intelligence, alerts, and analytics.

Evaluate real-time reporting by tracing data from source to report and identifying true business use cases behind instantaneous access. Distinguish bottom-line needs from vendor hype or engineering curiosity.

Delivering yesterday's data with 24-hour latency, the traditional data warehouse relies on overnight etl, staging, and centralized processing, limiting timely insights for managers.

See how data flows from sources to streaming or batching paths via Kinesis, stored in a data lake, and queried with Redshift, Glue, and Spectrum across structured and external data.

Examine the on-premises data warehouse approach, including caching and streaming with tools like Spark, and how to choose among many options to process historical data, supporting machine learning and reporting.

Compare Microsoft and AWS cloud architectures to design data pipelines, blending data sources, batch and real-time processing, orchestration, data lakes, data warehouses, and reporting.

Organize a data lake with dedicated zones for ingestion, raw data, staging, and catalogs to support governance, security, and easy data discovery.