1 / 25

Information Design Tool Overview and Best Practices

Information Design Tool Overview and Best Practices. Natasha Kishinevsky – Business Intelligence Manager. Agenda. Introduction SAP BI 4.x Platform Overview UDT vs. IDT comparison IDT – New Concepts and Terminology Universe Creation Process Questions. Introduction: Me.

Download Presentation

Information Design Tool Overview and Best Practices

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. Information Design ToolOverview and Best Practices Natasha Kishinevsky – Business Intelligence Manager

  2. Agenda • Introduction • SAP BI 4.x Platform Overview • UDT vs. IDT comparison • IDT – New Concepts and Terminology • Universe Creation Process • Questions

  3. Introduction: Me natashak@dunnsolutions.com

  4. Introduction: Dunn Solutions Group Full-service IT consulting firm Founded in 1988 Offices • Chicago • Minneapolis • Raleigh • Bangalore, India Chicago Raleigh Bangalore Minneapolis

  5. Practice Areas Application Development Business Intelligence Packaged Solutions Custom App Dev Legal Dashboard End-to-End BI Mobile App Dev Visible Visitors Data Warehouse Portals Dashboards Optical Shop Dashboard Web Design DI + EIM/Quality Audience Opinion Training E-Commerce Budgeting & Planning Open-Enrollment Mobile BI On-Site + Custom Managed Services Jumpstart/Mentoring Predictive Analytics

  6. Selected Clients City of Chicago

  7. SAP BusinessObjects Partnership SAP Gold Partner (top level, partner since 1995) Utilize full SAP BusinessObjects stack National coverage Comprehensive SAP BusinessObjects training Authorized Education Partner since 1995 Authorized Training Centers in Raleigh, NC / Minneapolis, MN / St. Louis, MO

  8. Agenda • Introduction • SAP BI 4.x Platform Overview • UDT vs. IDT comparison • IDT – New Concepts and Terminology • Universe Creation Process • Questions

  9. SAP Business Intelligence Stack Mobile Devices Browsers MS Office On Demand Services Embedded Content EnterprisePortals Business Intelligence Platform Analysis and Exploration Dashboards Reporting Universe Semantic Layer EDW SAP NetWeaver BW TeraData Other data warehouses ERP SAP Business Suite Oracle E-Business PeopleSoft JD Edwards Oracle, IBM DB2, Microsoft SQL Server and other relational data sources SAP HANA Platform Unstructured data in Social Media and Hadoop OLAP Cubes MS Excel

  10. SAP BusinessObjects Business Intelligence Dashboards Reporting Build engaging experiences Share information • Deliver engaging information to users where they need it • Track key performance indicators and summary data • Build custom experiences so users get what they need quickly • Securely distribute information across your organization • Give users the ability to ask and answer their own questions • Build printable reports for operational efficiency Analysis and Exploration Discover. Predict. Create. • Discover areas to optimize your business • Adapt data to business needs • Tell your story with beautiful visualizations

  11. Semantic Layer: Universes Creates a Query in Web Intelligence User Asks a Business Question Semantic Layer Translates the Business Question into SQL

  12. Agenda • Introduction • SAP BI 4.x Platform Overview • UDT vs. IDT comparison • IDT – New Concepts and Terminology • Universe Creation Process • Questions

  13. Old vs. New: Overview • The Universe Design Tool is supported • The “Old” universe creation tool • Universes created have the UNV extension • The Information Design Tool – New Addition to the BI stack • The “New” and improved universe creation tool • Universes created have the UNX extension

  14. Old vs. New: Compatibility

  15. What Should I do with my “Old” universes? Convert • Conversion Process is seamless and straight forward • Take full advantage of the platform with UNX universes

  16. Agenda • Introduction • SAP BI 4.x Platform Overview • UDT vs. IDT comparison • IDT – New Concepts and Terminology • Universe Creation Process • Questions

  17. New Concepts - Project • Projects serve as Workspaces • Connections and Connection Shortcuts • Data Foundation Layer • Business Layer • Multiple Retrievals • Shared Projects • Synchronize Changes with the platform • Collaborate on Universe development

  18. New Concepts - Data Foundation Universe Structure • Define relationships (joins) between tables • Multi-Source Data Foundations • Detect and resolve Loops • Create Calculated Columns • Create Derived tables • Define Parameters and Lists of Values • Profile Data • Create multiple views of the data structure

  19. New Concepts – Business Layer • Business Layer is the new Universe • When published, is combined with the Connection and Data Foundation to form a UNX file • Contains folders and objects • Objects can be tested with Business Layer Queries

  20. New Terminology

  21. Agenda • Introduction • SAP BI 4.x Platform Overview • UDT vs. IDT comparison • IDT – New Concepts and Terminology • Universe Creation Process • Questions

  22. Universe Creation – Step by Step

  23. Universe Creation – Demo

  24. Agenda • Introduction • SAP BI 4.x Platform Overview • UDT vs. IDT comparison • IDT – New Concepts and Terminology • Universe Creation Process • Questions

  25. Any Questions?

More Related