1 / 30

Using BIRT with PostgreSQL

Using BIRT with PostgreSQL. SCEA US R&D 2010-10-20. Who am I?. Oracle Corporation (1986 – 1999) Versions 4, 5, 6, 7, 8, 9 EnterpriseDB (2005 – 2007) Sony Computer Entertainment America – PlayStation (2010 – Now).

levi
Download Presentation

Using BIRT with PostgreSQL

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. Using BIRT with PostgreSQL SCEA US R&D 2010-10-20

  2. Who am I? • Oracle Corporation (1986 – 1999) • Versions 4, 5, 6, 7, 8, 9 • EnterpriseDB (2005 – 2007) • Sony Computer Entertainment America – PlayStation (2010 – Now)

  3. How SCEA Uses PostgreSQL • In Game Advertising for PlayStation®3 • PlayStation®3 is Network Enabled • Allows us to record impressions (similar to website display advertising) • Allows us to send new advertising content to existing games

  4. Advertising Data • Banners in Sports Games • Billboards in Driving Games • Stores in Virtual Worlds

  5. What is BIRT? • Business Intelligence and Report Tools • Report writing tool (Eclipse based) • Similar to JasperReports and Crystal Reports • Report display environment • Can export to HTML, PDF, Excel, Word, or PowerPoint

  6. Why SCEA Chose BIRT • Open Source with backing from IBM • Features • Ease of use • Pool of resources • Books • Websites • Communities

  7. How SCEA Uses BIRT • Dashboards • Graphs • Raw Data

  8. The BIRT Development Environment

  9. The BIRT Development Environment

  10. A Simple Report

  11. Creating a Simple Report

  12. Creating a Simple Report Demo

  13. Adding a Graph or Chart

  14. Chart Type

  15. Chart Data

  16. Format Chart

  17. The Finished Report

  18. Creating a Simple Report Demo

  19. Change Pie to a Bar Chart

  20. Format the Bar Chart

  21. The Finished Report

  22. Creating a Simple Report Demo

  23. Adding a Second Y-axis

  24. Data for 2nd Y-axis

  25. Proper Color Selection

  26. Adding the Legend

  27. Y-axis Titles

  28. The Completed Report

  29. Creating a Simple Report Demo

  30. Matthew_Bennett@playstation.sony.com Thank You

More Related