1 / 32

Business Intelligence:

Business Intelligence:. Report Creation and Automation Using Business Objects. Dylan Black University of Wisconsin – Platteville blackdy@uwplatt.edu. About Me. Senior – Majors: Computer Information Systems Business Administration IT Analyst – John Deere C&F

chancellor-steele
Download Presentation

Business Intelligence:

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. Business Intelligence: Report Creation and Automation Using Business Objects Dylan Black University of Wisconsin – Platteville blackdy@uwplatt.edu

  2. About Me • Senior – Majors: • Computer Information Systems • Business Administration • IT Analyst – John Deere C&F • Extensive Training / Experience in Business Objects • Darlington WI

  3. Overview • What is Business Intelligence (BI) • Business Intelligence Software Solutions • Business Objects (BO) Overview • Business Objects Report Creation • Future of Business Objects • Conclusion

  4. Business Intelligence (BI) Defined • Applications and Technology • Gather Data • Provide Access to Data • Analyze Data

  5. Reasons for BI • Ultimate Goal • Improve Timeliness/Quality of Information • Crystal Ball “Theory” • Business Intelligence Shows the Best Course to Take

  6. Benefits of BI • Eliminate Guesswork • Enhance Communication • Respond to Changes: • Financial Conditions • Customer Preferences • Supply Chain Operations

  7. BI Technology Requirements Key Issues - • Security – Access to Data • Data Volume • Data Retention • Benchmark and Performance Targets

  8. BI Software Solutions • Balanced Scorecard • Measures a Company’s Activities • Visions • Strategies • Competitive Analysis • Performance Management • Many, Many More…

  9. Business Objects

  10. Business Objects Overview • Leading Implementation of BI • More Than 39,000 customers • 80 % of Fortune 500 companies • 4,900 Employees Worldwide

  11. Business Objects Platform • Three Main Aspects • Report Creation • Report Scheduling • Report Access

  12. Business Objects Platform – Report Creation • User-Friendly Full Featured Application • Novice • Advanced

  13. Business Objects Platform – Report Creation • Two Levels of Variables • Universe • Separate Application – Universe Designer • Insulates Users From Raw Data • Keeps Data Secure • Allows Multiple Users to Access the Same Data in Different Reports • Stored Procedure

  14. Business Objects Platform – Report Creation • Report Level • User Can Apply Conditions on Universe Level Variables • Built-in Functions • Sum • Average • Standard Deviation • Comparable to Microsoft Excel, More Graphical Options

  15. Business Objects Platform – Report Creation

  16. Business Objects Platform – Report Creation

  17. Business Objects Platform – Report Creation

  18. Business Objects Platform – Report Creation “Slice and Dice” Panel

  19. Business Objects Platform – Data Access • Three Options • Universe • Executes Stored SQL Queries to Import Data From DB2 Tables • Excel Spreadsheets • Free-Hand SQL (FHSQL) • Advanced Users Can Write Specialized SQL Queries To Access Data • Data is Returned As A Variable

  20. Business Objects Platform – Data Manipulation • Countless Options • Charts • Graphs • Compound Conditions • Visual Basic Macros

  21. Business Objects Platform – Data Manipulation

  22. Business Objects Platform – Report Automation • BO Broadcast Agent Console (BCA) • Server Application • Scheduler • Report Repository

  23. Business Objects Platform – Scheduler • Scheduling Abilities • Intervals • Monthly • Weekly • Daily

  24. Business Objects Platform – Scheduler

  25. Business Objects Platform – Scheduler • File Watcher • Connects Old With the New! • Legacy Programs Executed on Mainframe • Programs Manipulate Data in DB2 Tables • COBOL • SAS • JCL Utilities • When Complete, These Applications Create a File that BCA “Sees”  Triggers Report Creation

  26. Business Objects Platform – Scheduler • Visual Basic Macro • BCA Supports Visual Basic for Applications (VBA) • This allows to create PDF and Excel versions of Business Objects Reports. • Reports Are Saved to Server so Users Can Access at Anytime.

  27. Business Objects Platform – Report Access • Web Intelligence (WEBI) • Online Application • Users Can Create and Send Reports to Other Users • Reports Created by Scheduler Can Be Stored For Later Access • Users Can View Scheduled Report Status

  28. Business Objects Platform – Report Access • Java Web Applications • PDF and Excel? • Create ‘Front End’ All Users Can Use to Access PDF and Excel Files Stored On Server and Display in Web Browser

  29. Business Objects Platform – Report Access • Business Objects + Microsoft Office • Revolutionary! • BO Reports Can be Embedded In PowerPoint, Excel and Word Documents • Real Time Access! • Available in Newest Version of BO – Business Objects XI Release 2

  30. Future of Business Objects and BI • Implement New Technologies while still interacting with old. • VERY IMPORTANT • Older Technologies / Languages Such As Mainframe COBOL ARE Going to be Around. • Too Expensive to Convert • Still Work! • Must Find New Ways To Tie “Old with the New”

  31. Conclusion • Business Intelligence – Quickly Growing Field • Job Opportunities • Business and IT are No Longer Separate

  32. References • www.successfactors.com • www.wikipedia.org • www.businessobjects.com

More Related