Transcript PostgreSQLnBIRT_20101020

Using BIRT with
PostgreSQL
SCEA US R&D
©2010
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)
©2010
2
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
©2010
3
Advertising Data
 Banners in Sports Games
 Billboards in Driving Games
 Stores in Virtual Worlds
©2010
4
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
©2010
5
Why SCEA Chose BIRT




Open Source with backing from IBM
Features
Ease of use
Pool of resources
 Books
 Websites
 Communities
©2010
6
How SCEA Uses BIRT
 Dashboards
 Graphs
 Raw Data
©2010
7
The BIRT Development Environment
©2010
8
The BIRT Development Environment
©2010
9
A Simple Report
©2010
10
Creating a Simple Report
©2010
11
Creating a Simple Report
Demo
©2010
12
Adding a Graph or Chart
©2010
13
Chart Type
©2010
14
Chart Data
©2010
15
Format Chart
©2010
16
The Finished Report
©2010
17
Creating a Simple Report
Demo
©2010
18
Change Pie to a Bar Chart
©2010
19
Format the Bar Chart
©2010
20
The Finished Report
©2010
21
Creating a Simple Report
Demo
©2010
22
Adding a Second Y-axis
©2010
23
Data for
©2010
nd
2
24
Y-axis
Proper Color Selection
©2010
25
Adding the Legend
©2010
26
Y-axis Titles
©2010
27
The Completed Report
©2010
28
Creating a Simple Report
Demo
©2010
29
[email protected]
THANK YOU
©2010
30