1 / 3

WHY A DATA WAREHOUSE?

WHY A DATA WAREHOUSE?. WHAT IS THE CURRENT STATE?. Data Stored in Thousands of Tables PS Query is Difficult to Use in a Multi-Table Environment Takes a Long Time to Write Reports Decisions Often Made Based on Incomplete or Inaccurate Information

sydney-munoz
Download Presentation

WHY A DATA WAREHOUSE?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WHY A DATA WAREHOUSE?

  2. WHAT IS THE CURRENT STATE? • Data Stored in Thousands of Tables • PS Query is Difficult to Use in a Multi-Table Environment • Takes a Long Time to Write Reports • Decisions Often Made Based on Incomplete or Inaccurate Information • Too Much Time Spent Generating the Data and Not Enough Time Spent Analyzing the Data • Data Locked up in Silos – Reporting Across Functions Not Possible • Dashboards and Key Performance Indicators Not Available

  3. HOW DOES A DATA WAREHOUSE HELP? • Gets the Data Out of Jail • Data is Understandable, Meaningfully Labeled and Retrievable • Pre-defined Relationships Simplify Reporting • Querying and Reporting Easier and Faster • Cross-Functional Reporting Possible • Provides for Historical Comparisons and Point-in-Time Reporting • Provides the right data, at the Right Time, to the Right People • Improves Decision Making

More Related