1 / 13

OBIEE Training Part III

OBIEE Training Part III. Bringing it all Together. Ronda Stemach EDM Group February 5, 2013. Where we’ve Come. Data Warehouse and Hyperion started in 2008 Data Warehouse and OBIEE completed in 2010 for Finance and HR. Where we’re Going. Introduction of Student Data in Data Warehouse.

quintessa-urban
Download Presentation

OBIEE Training Part III

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. OBIEE Training Part III Bringing it all Together Ronda Stemach EDM Group February 5, 2013

  2. Where we’ve Come • Data Warehouse and Hyperion started in 2008 • Data Warehouse and OBIEE completed in 2010 for Finance and HR

  3. Where we’re Going • Introduction of Student Data in Data Warehouse

  4. Fact: Number of units a Student has taken • Dimensions: • Who? Person (and related bio-demo data) • When? Academic Term, Year • Where? Class, Department, College hierarchy What do we get with EPM 9.1? • Name Translations: • Stu_Car_Term table = Term Enrollment • Application of Business Rules & Logic • Data Organization & Presentation to OBIEE Author • Reports and Dashboards delivered with EPM • Reports and Dashboards created by the Authors

  5. Subject Groupings and Areas

  6. Subject Groupings and Areas

  7. Census Data

  8. Why OBIEE? Business intelligence (BI) is defined as the ability for an organization to take its and convert it into Knowledge Data • OBI is a Reporting Tool • OBI is the “Front End” view of the Data Warehouse • OBI is about making the mind of your institution’s business talk to you • Kimball Star Schema Design • Analyze wide range of Information LIVE LIVE

  9. Think about how you Consume Data When you want a weather report, do you go here:

  10. Think about how you Consume Data … OR Here: • Summary to Detail • Multiple layers of info • Layout of Information

  11. Prompt Section should appear at the top of the Dashboard • For multi-page dashboards, be aware of the scope of your prompt • The number of pages per dashboard should not exceed the horizontal width of your screen – avoid having to scroll to pages • Don’t overuse the constrain option in prompts – it can really slow down performance • Check “Print Rows” setting of Dashboard, in PDF & Print Properties – All versus Visible • Consider web page eye movement and the level of priority of the elements of your dashboard. HSU Best Practices in OBI Design Dashboards and Prompts

  12. Always display your filters at the bottom • Limit your columns, if possible, to avoid horizontal scrolling • Use consistent color coding when possible • Use consistent export links • Provide insight, not just Excel – create interactive ways to view the data. Create links, drill to-s, different views, pivots… • Provide context – comparison to previous year, comparison to budget, highs and lows, comparison to others. • Make use of the Run Date/Time feature in your Title • Add a Subtitle to further explain the report HSU Best Practices in OBI Design Analyses

More Related