OBIEE Training Part III Bringing it all Together
Description: OBIEE Training Part III Bringing it all Together Ronda Stemach EDM Group February 5, 2013 Where weve Come Data Warehouse and Hyperion started in 2008 Data Warehouse and OBIEE completed in 2010 for Finance and HR Where were Going
Related Topics
Download Presentation
"OBIEE Training Part III Bringing it all Together" is the property of its rightful owner. Permission is granted to download and print the materials on this website for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Presentation Transcript
slide1. OBIEE Training Part III Bringing it all Together Ronda Stemach
EDM Group
February 5, 2013<br>
slide2. Where we’ve Come Data Warehouse and Hyperion started in 2008
Data Warehouse and OBIEE completed in 2010 for Finance and HR<br>
slide3. Where we’re Going Introduction of Student Data in Data Warehouse<br>
slide4. What do we get with EPM 9.1? 4<br>
slide5. Subject Groupings and Areas<br>
slide6. Subject Groupings and Areas<br>
slide7. Census Data<br>
slide8. Why OBIEE? 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 Business intelligence (BI) is defined as the ability for an organization to take its and convert it into Knowledge Data Kimball Star Schema Design
Analyze wide range of Information LIVE LIVE<br>
slide9. Think about how you Consume Data When you want a weather report, do you go here:<br>
slide10. Think about how you Consume Data … OR Here: Summary to Detail
Multiple layers of info
Layout of Information<br>
slide11. HSU Best Practices in OBI Design Dashboards and Prompts 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.<br>
slide12. HSU Best Practices in OBI Design Analyses 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<br>
EDM Group
February 5, 2013<br>
slide2. Where we’ve Come Data Warehouse and Hyperion started in 2008
Data Warehouse and OBIEE completed in 2010 for Finance and HR<br>
slide3. Where we’re Going Introduction of Student Data in Data Warehouse<br>
slide4. What do we get with EPM 9.1? 4<br>
slide5. Subject Groupings and Areas<br>
slide6. Subject Groupings and Areas<br>
slide7. Census Data<br>
slide8. Why OBIEE? 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 Business intelligence (BI) is defined as the ability for an organization to take its and convert it into Knowledge Data Kimball Star Schema Design
Analyze wide range of Information LIVE LIVE<br>
slide9. Think about how you Consume Data When you want a weather report, do you go here:<br>
slide10. Think about how you Consume Data … OR Here: Summary to Detail
Multiple layers of info
Layout of Information<br>
slide11. HSU Best Practices in OBI Design Dashboards and Prompts 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.<br>
slide12. HSU Best Practices in OBI Design Analyses 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<br>