1 / 8

Organizational Data Architecture (2/19 – 2/21)

Organizational Data Architecture (2/19 – 2/21). Recap current status. Discuss the issues involved in designing and developing a data architecture for an organization. Enhance the design exercise from last week to incorporate additional data inputs and requirements. Origins of Data.

paiva
Download Presentation

Organizational Data Architecture (2/19 – 2/21)

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. Organizational Data Architecture (2/19 – 2/21) • Recap current status. • Discuss the issues involved in designing and developing a data architecture for an organization. • Enhance the design exercise from last week to incorporate additional data inputs and requirements.

  2. Origins of Data Data-Driven Decision Making • Internal Data: • Generated by the organization • ERP databases; • Separate application databases; • Non database transactions; and • Accounting, customer service, inventory, manufacturing, marketing Collect Store Maintain Transform Integrate Make Meaningful Organizational objectives Alignment of objectives with business intelligence Varying Levels of BI Relative usage of BI for decision making • External Data: • Not generated by the organization • Governmental data such as census, tax, property, climate; • Procured data such as financial, marketing, research; • Twitter feeds; and • Social networking data.

  3. Data-Driven Decision Making • What does the user need to make data driven decisions? • What are the characteristics of good quality data? • Why isn’t all data inherently of good quality? Organizational objectives Alignment of objectives with business intelligence Varying Levels of BI Relative usage of BI for decision making

  4. Origins of Data • Internal Data: • Generated by the organization • ERP databases; • Separate application databases; • Non database transactions; and • Email, Word, Sharepoint • Where is internal data stored? • Who is responsible for data management? • How is it usually stored? • External Data: • Not generated by the organization • Governmental data such as census, tax, property, climate; • Procured data such as financial, marketing, research; • Twitter feeds; and • Social networking data. • How is external data obtained? • Who is responsible for data management? • How is it usually stored?

  5. Organizational Data Architecture Data Sources Internal External Data Mart Enterprise Data Warehouse Derived Data Operational Data Reconciled Data

  6. Big Questions • Do the layers represent physical databases? • Are all three layers necessary for all organizations? • Are additional layers necessary for some organizations?

  7. What are the issues for each layer? • Is raw data stored or derived from an existing data store? • What are the key characteristics of the data? • What are the three most important design goals? • What are the biggest challenges during design?

  8. What is the format of a derived data model? • One spreadsheet-type table? • Fact table and dimension tables. • Multiple tables: • Star format • Snowflake format

More Related