1 / 73

PST117: Reporting - PowerPlay

PST117: Reporting - PowerPlay. Updated August 23, 2011. Housekeeping. Cell Phones. Break. Rest Rooms. Materials. HR Building. Bridges. Fire Drill. Questions. Housekeeping. When class is over…. Roster. The ONLY official record of your attendance. Evaluation.

argus
Download Presentation

PST117: Reporting - PowerPlay

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. PST117: Reporting - PowerPlay Updated August 23, 2011

  2. Housekeeping Cell Phones Break Rest Rooms Materials HR Building Bridges Fire Drill Questions

  3. Housekeeping When class is over… Roster The ONLY official record of your attendance Evaluation Let us know what you think!

  4. Objectives In this session, we will: • Discuss fundamental terminology • Describe PowerPlay components and purpose • Investigate contents and use of cubes • Explore PowerPlay output options • Analyze departmental relevance • Discover how you can use PowerPlay

  5. Great Resource! • myUFL Toolkits • Web Simulations • Instruction Guides • Security Roles • Training • Contact Information • Other Helpful Information • Located at: http://hr.ufl.edu/training/myUFL/Toolkits/

  6. What is Business Intelligence (BI) • In-depth analysis of detailed business data • To help campus (you) make better business decisions • Improve decision making by using facts • Explore and analyze data to reveal trends within your department/unit

  7. Into Knowledge! PowerPlay What is Business Intelligence (BI) • It’s about… Into Information Transforming Data

  8. PowerPlay as a BI Tool • Use PowerPlay to: • Explore data from different angles and gain new insights • Find fast answers to organizational questions • Make informed decisions by analyzing your data

  9. Multidimensional Analysis • Two components: • Measures • Dimensions By combining dimensions and measures, you can make better decisions for your College/Department/Division.

  10. Multidimensional Analysis • Two components: • Measures • Dimensions First, measures

  11. Multidimensional Analysis • Measures • Quantitative • Numeric Values • Count • People • Number of Gator football wins • Monetary Values • US Dollars

  12. Measures • Student Credit Hours

  13. Multidimensional Analysis • Two components: • Measures • Dimensions Now, dimensions

  14. Dimension MEASURE For example 1911-2010 Multidimensional • Single dimensional • The number of Gator Football games FYI: 1040

  15. Dimension MEASURE For example 1911-2010 Multidimensional • Multidimensional • The number of Gator Football wins FYI Won: 633 Lost: 370 Tied: 37

  16. Multidimensional Multidimensional Question: How many home games have Gator’s won? How many Home Won Measure Count if Dimensions Venue & Outcome For example 1911-2010 345

  17. For example 1911-2010 Multidimensional • Multidimensional • Two more dimensions • Home Games, Won… • By > or = 10 points: 148 • Opponents 0 points: 84 • Gator Points • Opponent Points

  18. The Excel Version…

  19. Dimensions, Levels and Category • Dimension • Broad group of descriptive data about the major aspects of UF

  20. Dimensions, Levels and Category • Dimension • Broad group of descriptive data about the major aspects of UF • Level • Categories that represent an established hierarchy within a dimension

  21. Dimensions, Levels and Category • Dimension • Broad group of descriptive data about the major aspects of UF • Level • Categories that represent an established hierarchy within a dimension • Category • Data item detail description that populates a level in the dimension or exists at the lowest level in the dimension

  22. Dimensions and Levels When? Who? What? Account Date Departments Dimensions Levels Operating Ex Years College Account Code Quarters Department Months Division

  23. Categories 2005 2006 2007 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Q1 Q2 Q3 Q4 Levels and Categories Dimensions Levels Date Years Quarters Months

  24. DimensionsDates • This is what it’ll look like in PowerPlay • Let’s examine…

  25. DimensionsDates

  26. DimensionsDates

  27. DimensionsDates

  28. DimensionsDates

  29. I’ll show you a few things. Then we’ll explore together

  30. Base Cube/Primary Views

  31. Cube Icons

  32. It’s Your Turn • Together, we’ll walk through the first few exercises

  33. FIT Cubes

  34. Cube Icons

  35. “Cube”

  36. “Views” of the Base Cube

  37. Change an existing view • Save in you’re my Folder

  38. Measures FIT Cube Example

  39. Measures FIT Cube Example

  40. Measures FIT Cube Example

  41. Measures Each item had to have a unique name… General Ledger Actuals MB GL Actuals AB GL Actuals GL Actuals

  42. MeasuresGeneral Ledger Actuals General Ledger Actuals

  43. MeasuresManagerial Budget (MB) MB Managerial Budget MB GL Actuals MB Commitments MB Variance

  44. MeasuresMB to KK Managerial Budget KK Budget MB to KK Variance

  45. MeasuresAvailable Spending Authority (AS) ASA KK Budget ASA KK Actuals ASA KK Encumbrances ASA Balance

  46. MeasuresAvailable Balance (AB) AB KK Budget AB GL Actuals AB Commitments AB Balance

  47. MeasuresKK to GL KK Actuals GL Actuals KK to GL Variance

More Related