Introduction to Data Mart

Introduction to Data Mart teaches participants the various data levels and models used to extract data from the Data Mart, The class focuses on report analysis leading to Data Mart design, creating and submitting Data Mart models to populate data within the Mart, and accessing data via 3rd-party applications.
Show Interest
Introduction to Data Mart

About the Course

By the end of this course you will be able to:

  • Explain Data Mart use, requirements and workflows, including reporting analysis
  • Create, Modify, and Submit Data Mart models
  • View and query Mart data
  • Analyze execution logs to identify/troubleshoot issues
  • Describe the use of multiple Marts, including EAGLEMART and packaged reports
  • Access data in third party tools

Course Outline

Introduction to Data Mart

  1. Overview of Data Mart
  2. Process Flow
  3. Report Analysis
  4. Ex.1 and Ex.2
  5. System Overview
  6. Ex.3 – Create the Daily Holding Group Level Model
  7. Custom market value Report and Model analysis
  8. Snapshots
  9. Submitting Models
  10. Ad Hoc Model Submission
  11. Execution Logs
  12. Q&A Session
  13. View Execution Log
  14. Viewing Mart Data
  15. Schedules
  16. View Mart Data
  17. Build a Query
  18. Connecting Data Mart to Third Party tool
  19. Multiple Marts
  20. Eagle Mart

Wrap-Up

  1. Lets take a pause now