1 / 15

Petros KAVASSALIS

Computer applications in the modern enterprise Επιχειρησιακές Εφαρμογές Η/Υ Lectures 10-13: Business Intelligence and Enterprise Reporting Univ. of the Aegean Financial and Management Engineering Dpt. Petros KAVASSALIS. What you will learn in this course.

milton
Download Presentation

Petros KAVASSALIS

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. Computer applications in the modern enterpriseΕπιχειρησιακές Εφαρμογές Η/ΥLectures 10-13: Business Intelligence and Enterprise ReportingUniv. of the Aegean Financial and Management Engineering Dpt Petros KAVASSALIS

  2. What you will learn in this course • A set of fundamentalconcepts and frameworks for understanding the potential impact of information technology (IT) on business strategy and structure • Computers and Information Systems (IS) • The business value chain • Business integration through Enterprise Application Integration • Information Systems in practice: How does the modern enterprise use “Business Intelligence” (BI) systems to improve decision-making • Methods and BI examples • “Hands-on” experience: create business reports by using Eclpise BIRT Reporting Tool (http://www.eclipse.org/birt/phoenix/) • The design and governance of digitized processes • Business Function and Processes • Transfer a real world business process to an e-business world*** (Guest Speakers)

  3. Communication tools • e-mail: pkavassalis@atlantis-group.gr • Course web site: see FME web site

  4. Students evaluation • Class Participation (20%) + • Assignments (20%) + • Final Exam (650%)

  5. http://ghill.customer.netspace.net.au/reporting/definition.htmlhttp://ghill.customer.netspace.net.au/reporting/definition.html Enterprise Reporting: definition • Τhe regular provision of information to decision-makers within an organization to support them in their work. These reports can take the form of • Graphs • Text • Tables • Typically, are disseminated through the Web as a set of regularly updated documents or web pages (publised in the "enterprise portal"). • Alternatively, they may be emailed directly to users or simply printed out and handed around…

  6. Enterprise Reporting: typical examples • Dashboards • KPI (Key Performance Indicators) • Alerting / Risks Identification • Trend Analysis • Benchmarking • … • OLAP cubes • http://training.inet.com/OLAP/slicing.htm

  7. Eclipse BIRT Reporting Tool • Open Source Reporting Tool • BIRT has two main components • A report designer based on Eclipse • A runtime component that you can add to your app server • (BIRT also offers a charting engine that lets you add charts to your own application) • There are several Reporting Tools • Oracle • IBM • Microsoft • Open Source • Please locate and report to me about similar to BIRT Reporting Tool commercial or open source software

  8. The anatomy of a BIRT Report • Data • Databases (and web services, Java objects etc.) • Data Transforms • Reports present data sorted, summarized, filtered and grouped to fit the user's needs. BIRT allows sophisticated operations such as grouping on sums, percentages of overall totals etc • Business Logic • Many reports require business-specific logic to convert raw data into information useful for the user. • Presentation • Once the data is ready, BIRT provides a wide range of options for presenting it to the user: tables, charts, text and more. • A single data set can appear in multiple ways, and a single report can present data from multiple data sets.

  9. How to use BIRT to create a Report http://www.eclipse.org/birt/phoenix/tutorial/basic/ • Introduction • Creating a Report • Brief UI Tour • Building a Data Source • Building a Data Set • Building a Table • Testing Your Report • Setting Visual Properties • Setting Data Properties • Using Styles • Cascading Styles • Using a Grid • Using a Text Item • Next Steps My first Report (from BIRT web site):http://download.eclipse.org/birt/downloads/examples/reports/2.1/tutorial/tutorial.html

  10. The 3 key functions • Data Source (db) • Data Set • Report Layout • Overview of BIRT Reporting System Data Source Report Layout (presentation) Data Set (processing)

  11. Data Source = Database • You can “easily” integrate a database in “BIRT” application • BIRT from http://www.eclipse.org/birt/phoenix/ is coming with a Sample Database • BIRT provided by the course, too!

  12. Data Set_Preview Results

  13. Data Set_SQL Query Builder

  14. Data Set_SQL Query[http://www.w3schools.com/sql/default.asp]

  15. Report layout • Please see Exercises 1-6

More Related