A Beginners Guide On Creating BIRT Reports

Overview

Introduction to Business Intelligence Reporting with Business Intelligence Reporting Tools (BIRT) . Learn to Install BIRT on a Window machine.

Learn to connect BIRTto multiple Database connections(SQL Server, Oracle, DB2, etc). Learn to connect BIRT to a file sources like Excel.

You will also learn how to set up BIRTData Sets that use various data sources. You will also learn how to create a basic BIRT Data Cube.

You will learn how to use Grouping and Sorting on report objects. You will learn different filtering methods in BIRT.

You will learn how to create Aggregations and different places you can add Aggregation in a BIRT report. You will learn how to create a computed column in a data set.

You will learn how to create Report Parameters and use them in your reporting. You will learn how to use Cascading Parameters.

You will learn to use Page Breaks and create custom reports This course is just for beginners who need to learn the basics of setting up BIRTand BIRT Report Development, However if you are an advanced user there are tips you might not be aware of covered in this course. Course comes with Report Design files for reference with some of the lectures.

Syllabus

• Introduction to Business Intelligence Reporting
Overview of Business Intelligence Reporting Tools (BIRT)
• Installation of BIRT
Step-by-step guide to installing BIRT on Windows
• Connecting BIRT to Databases
Setting up connections to SQL Server, Oracle, and DB2
Connecting to file sources like Excel
• Creating BIRT Data Sets
Overview of data sources
Setting up various data sets
• Creating BIRT Data Cubes
Introduction to data cubes
Basic creation and setup
• Report Object Management
Grouping and sorting techniques
Filtering methods in BIRT
• Aggregations in BIRT Reports
Methods for creating aggregations
Locations for adding aggregations in reports
• Advanced Data Set Operations
Creation of computed columns
• Parameter Utilization in Reports
Creating and using report parameters
Implementing cascading parameters
• Customizing Reports
Utilizing page breaks
Creating custom report designs
• Course Resources
Access to report design files for reference and practice

Taught by

Robert Baakel

Subjects

Business