Jasper BI & Data Warehouse

Section 0: Introductions Instructor & class introductions Section 1: The Architectures The Four Architectures Information Architecture Data Architecture Technology Architecture Product Architecture Data Integration Framework (DIF) Architecture Processes & Data Stores Standards Tools Resources & Skills Section 2: DIF Processes Data Preparation Data Sourcing Data Cleansing Data Quality Data Transformation Data Loading Data Franchising Data filtering Data Summarization & Aggregation Data Transformation Data Loading Information Access & Analytics Information Access & Reporting Analytics & Performance Management Metadata Management Inter-tool interfaces Audit & What-If Capability Data Management Data Modeling Data Profiling Database Management Section 3: Data Store Components Data Modeling Basics Conceptual, Logical & Physical Models Entity-Relationship & Dimensional Mod...

What is the difference between a data warehouse architect and a data architect? How about BI solution architect? Both data architect and data warehouse architect do data modelling, as in ERWin stuff. Or Embarcadero ER Studio. But a data warehouse architect is more specialised on designing the data model for a data warehouse, whereas a data architect is more specialised on designing the data model for databases used by transactional systems. A data warehouse architect does a lot more than just data modelling. They also does the ETL and the infrastructure. These are areas that a data architect doesn’t do normally. For a data architect to be able to call themselves a data warehouse architect, they don’t only need to learn how to create a data model for a data warehouse (as in dimensional modelling). But they need to also understand the ETL architecture. And they need to understand the servers. For example, they need to be able to specify the specification for the production dat...

·          Reports :- Jaspersoft is known for its picture pixel perfect  reporting. Jasper uses ireport for designing the reports. Hence, for  having reports, Jaspersoft is the most ideal candidate. Pentaho uses  Pentaho Report Designer. ·          Dashboards :- Pentaho  provides much more capabililties, interactivity in terms of dashboards.  Dashboards designed in Pentaho are far more superior in functionality,  aesthetically as compared to Jaspersoft. Pentaho CE uses CDE/CDF,  Pentaho EE uses PDD . Dashboard functionality is present only in the  Enterprise edition of Jaspersoft. ·          Mobile BI compatibility :-  Jaspersoft scores higher than Pentaho here. They have BI for iOS,  Android platforms. Functionality wise and user interface wise Jaspersoft  mobile BI is better. They even have an opensouce App...

JasperSoft is one of the top Open Source BI tools in the market (Pentaho is another tool positioned in the same space), finding a place in Gartner’s Magic Quadrant over the last few years. JasperSoft provides a comprehensive BI platform. The JasperSoft Enterprise Edition has a reporting server, ad hoc query, in-memory analysis, dashboarding, a reports library, OLAP and ETL. Due to its embeddable architecture and relaxed GNU General Public License terms and conditions, JasperSoft earns more than half of its business from OEMs, SaaS providers and other companies that integrate JasperSoft into their software offerings or internal applications. Tableau, though not Open Source, is the undisputed leader in Gartner’s Magic Quadrant and is loved by business users / dashboard consumers across the globe for its visualization capabilities.  In this respect, a head-to-head between these JasperSoft and Tableau might seem like an apples and oranges comparison – but we find more and more exis...