Personalized Analytics and Insights with BIRT for Hadoop
Note: this tutorial was validated with Sandbox 1.3
Welcome to the open source Eclipse-based BIRT (Business Intelligence and Reporting Tools) tutorials developed by Actuate – The BIRT Company™. There are two tutorials for your learning enjoyment, each fairly straightforward and designed to help you get connected with BIRT within minutes to access data from the Hortonworks Sandbox and immediately gain personalized analytics and insights into that data. There are two tutorials for your learning enjoyment:
- Open source Eclipse BIRT (Business Intelligence and Reporting Tools) Connectivity
- Introduction to Integrating BIRT (Business Intelligence and Reporting Tools) with the Hortonworks Sandbox
Get Started Tutorial 1 – Open Source Eclipse BIRT (Business Intelligence and Reporting Tools)
This tutorial is a fairly simple one which will show you how to connect the Sandbox to Open Source BIRT. This will allow you to develop your own BIRT reports from the Hortonworks Sandbox and is the prerequisite for the second tutorial on integrating BIRT with the Sandbox.
This tutorial is a prerequisite tutorial for the “Integrating BIRT with the Hortonworks Sandbox ” tutorial. We will need to use an updated BIRT ODA (Open Data Access) driver to connect to the Hortonworks Sandbox because the Sandbox is using the updated Apache Hive Server2.
Once you have successfully performed all of the steps in the tutorial, you have the foundation to complete the “Reporting with Open Source BIRT” tutorial as well as developing your own BIRT reports which access the Hortonworks Sandbox.
Get Started Tutorial 2: Introduction to Integrating Eclipse BIRT (Business Intelligence and Reporting Tools) with the Hortonworks Sandbox
This tutorial will demonstrate how to configure BIRT (Business Intelligence and Reporting Tools) to access data from the Hortonworks Sandbox and its integrated Hive Server. BIRT is an open source Eclipse-based reporting system that integrates with your Java/Java EE application to produce compelling reports. BIRT provides core reporting features such as report layout, data access and scripting.
You will create a report to visualize which occupations have the highest salaries, identify opportunities with the fewest number
of employees, in a particular occupation, that also pays the highest average salary using occupational information that includes an occupational code, description, total number of employees in that field, and the average salary for each of these occupation.
- Complete Tutorial 1: Business Intelligence and Reporting Tools (BIRT) Connectivity
- Review the Integrating Eclipse BIRT tutorial
The main steps to complete this tutorial include:
- Creating a BIRT Project, BIRT Report, Data Source, and Data Sets by connecting to the Hortonworks Sandbox Hive Server.
- Creating a BIRT report utilizing charting and conditional table formatting features.
- Viewing the BIRT in the browser report utilizing Paging and Exporting to formats such as PDF and Excel functionality.
To help you along the way, here are some videos:
- Step 1 – Create BIRT Project, BIRT Report, Data Source and Data Sets
- Step 2 – Designing Page 1 of Report – Narrative Section
- Step 3 – Designing Page 1 of Report – Pie Chart
- Step 4 – Designing Page 1 of Report – Summary Table
- Step 5 – Designing Page 1 of Report – Bar Chart
- Step 6 – Designing Remaining Pages of the Report – Detail Table
- Step 7 – Viewing Report