- Combo Offers (48)
- Big Data (48)
- Data Science (11)
- Business Intelligence (43)
- Salesforce (2)
- Cloud Computing (3)
- Mobile Development (2)
- Digital Marketing (5)
- DataBase (8)
- Programming (13)
- Testing (5)
- Project Management (9)
- Website Development (5)
Home / Business Intelligence / BI Reporting Tools Training
BI Reporting Tools Training
Our BI Reporting certification master program lets you gain proficiency in the top BI reporting tools. This training includes the BI Reporting tools like QlikView, Spotfire, Tableau, Cognos, Cognos TM1, Cognos Insight, Pentaho, Jaspersoft, MicroStrategy, Hyperion,SSRS. You will work on projects in data visualization, deploying dashboard, analytics, reports for deriving business insights.
About Course
List of Courses included:
- QlikView
- Spotfire
- Tableau
- Cognos
- Cognos TM1
- Cognos Insight
- Pentaho
- Jaspersoft
- MicroStrategy
- Hyperion
- SSRS
What you will learn in this combo training course?
- Learning about Business Intelligence and important concepts
- Various BI tools and understanding how they can be used together for greater effect
- The decision making process in an enterprise and steps involved
- Setting up of various BI tools and installation
- Mastering the concept of data warehouse and its deployment in BI
- Data mining process, OLAP database, building cubes, data schemas
- Working with various BI tools, creating dashboards, statistics and reports
- Learning about predictive analytics and business forecasting with the right tools
- Implementing data aggregation and data blending
- Proficiency in deploying software programming for getting business insights.
Who should take this BI Reporting tools combo training?
- Business Intelligence, Analytics and Reporting professionals
- IT Developers, Testers, Project Managers, Data Scientists, statisticians
What are the prerequisites for taking this training?
Why should you take this combo BI Reporting tools training?
- 16% is the Annual Growth Rate of the BI Industry as a Whole – Pringle & Company
- Global Business Intelligence and Analytics Market is $16.9 Billion in 2016 – Gartner
- Lead Business Intelligence Developer in the United States can earn $106,000 – Indeed.com
The diverse range of Business Intelligence, Analytics, Reporting and Data Visualization tools included in this course will help you master every aspect of the Business Intelligence process along with the ability to work in any industry domain or vertical. You will be proficient in integrating the results of the multiple Business Intelligence tools with other technologies to drive the larger business goals of any organization ahead. Upon completion of the training you will be rightly in a position to clear the certification exams conducted by requisite organization and command top salaries.
Qlikview Course Content
Introduction to Qlikview
Introduction to the concepts of Business Intelligence, learning about QlikView, the unique features of QlikView that make it the market leader, comparison to other BI tools, the complete overview and architecture of QlikView, studying the various file types and extensions.
Qlikview Products
Learning about the various QlikView products, understanding about the QlikView Desktop, Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.
Introduction to Data and Scripting
Understanding the data warehouse architecture, the concept of dimensional model, fact tables and dimensions, learning about Star and Snow Flake schema, QlikView data model comparison to other data models, understanding the data source files.
Loading Data From The DataBase
Learning about loading data from various databases, generating script, loading of text files, delimited text files, loading data from multiple data sources, various types of data loads like incremental, binary, resident, buffer, preceding, mapping load types, understanding how to load inline table, generic tables, media content and image inclusion, web page data loading, semantic load, various examples to simplify the concepts.
Structuring the Script
Learning to create tabs in the scripts, debugging of scripts, inclusion of variables and comments in the scripts.
Basic Data Model and Table Viewer
Understanding the basic data model of QlikView, learning to work with the Table Viewer, the System Table and System fields.
Data Relationships
Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.
Data Modelling Considerations
The rules of data modeling in QlikView, introduction to circular references, synthetic key tables, resolving synthetic keys and circular references.
Qlikview Data (QVD) Files
Understanding what is QVD file in QlikView, the way to create QVD file, the standard structure of a QVD file, its various components, the various types and uses of QVD files, learning what is optimized and unoptimized load.
Creating a Master Calendar
Creating a master calendar in QlikView, extracting the highest and lowest data, deploying scripts to create variables, working with arbitrary date ranges.
Qlikview Security
Understanding the various concepts of QlikView security, defining the access controls, levels of access, maintaining the access control database, section access addition and other concepts.
Handling Null Values
The various types of null values in QlikView and the different methods to handling them.
Sheets and Sheet Objects
Working with QlikView sheets and sheet objects, learning about the sheet basics, cross tables, the data transformation in QlikView, transposing a physical table.
The List Box
Understanding a list box, most basic sheet object, the various actions in List Box, its properties, the example of a list box.
The Table Box
A sheet object that shows several fields simultaneously, learning to create a table box, sorting in table box, understanding table box formatting options, printing the data from table box, exporting to a text file.
The Multi Box
Representation of value from multiple fields, learning to create a multibox, the various selection features, formatting and resizing of multiboxes.
The Button & Text Object
Working with text and button objects, learning to create them, formatting, resizing, copying and moving of text objects, understanding of action scripts in button and text objects.
Charts
Learning the basics of QlikView Charts, graphical representation of numerical data, various types of charts like bar, pie, grid, funnel, combo, learning to create charts, selections in charts and exporting of charts.
Multi Dimensional Charts, Pivot Tables
Introduction to multidimensional charts, setting up multiple expressions in straight table and pivot table, learning about straight table and pivot table, table box and deploying visual cues.
Gauges
Learning about Gauge Chart in QlikView, the various types of Gauges, understanding how to build Gauges, the various types of Gauge Charts.
The Other Sheet Objects
Introduction to the other sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box.
Additional Editing in The Layout
The additional editing like settings of type legend, title, fast change chart type, text in chart and reference lines, caption settings and drilldown, cyclic functionality.
Uses Of Expressions
Learning about the various expressions like chart attribute, colour, working with calculated fields, labels, and dynamic text in text objects, calculated fields and dimensions in list boxes and charts.
The Settings Menu
Learning about the settings menu in QlikView, the various options like user preferences, document properties and sheet properties.
Qlikview Functions
The various QlikView functions like ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions, etc.
Adhoc Reports and Bookmarks
Learning about ad hoc report creation and editing, introduction to QlikView bookmarks, the various types of bookmarks, creating and managing bookmarks.
Layout Themes
Understanding QlikView themes, creating, applying and working with dynamic themes.
Extensions
Learning about QlikView extensions, visualizing of data with extensions, creating a simple HTML extension, HTML table, working with interactive extensions and external libraries with extensions.
Set Analysis
Understanding set analysis, defining data values that are different from set definition, working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.
Alternate States
Understanding alternate states for performing comparative analysis on sets of multiple data items, working with market basket analysis, examples of various alternate states.
What-IF Analysis
Understanding what-if analysis in QlikView, working on creating variables, slider objects, assigning variables to sheet and slider objects.
Server Installation & Deployment
The process of installation, various types of licenses, types of CALS, learn to deploy the application on the server, working with server bookmarks, annotations.
Spotfire Course Content
TIBCO Spotfire Introduction
The basics of TIBCO Spotfire, data visualization and analytics software, various Spotfire features, Data Filtering, Data drill-down, data loading, data table format, statistical representation of data, Web Player for analytics report, importing data from Excel, data types, data visualization techniques, Spotfire Dashboard, working with Bar Charts.
Spotfire Data Table & Data Sources
Working with Data Tables, data sourcing, fetching data from databases, properties of Data Table, relations in data table and column matching, data table filters, settings and filter schemas, Calculated, Binned and Hierarchy Column creation.
Spotfire Data Visualization
Visualizing data to exploring, analyzing and discovering insights, understanding the concepts of Coloring, Trellis Visualization, bar chart, combination chart and line chart, working with Zoom Slider, and Cross-table Visualization, Column Selectors.
Advanced Visualization & Analysis
In-depth understanding of Spotfire visualization techniques, advanced color coding concepts, analyzing data, working with tags, lists, bars and data labels, understanding the various techniques of Pie Chart, Tree Map and Scatter Plot.
Spotfire Server Features
Importance of Spotfire Server for Deployment, Library and Information services, working with Spotfire Expressions, Labels, Charts, Schemas, understanding of Heat Map, Dendograms.
Deep Dive into Data Analysis and Organization
The scope of Spotfire Professional, data access, visualization and analysis, working with input filter, property control dialogue for changing settings in visualization, custom expressions, deploying Action control and Dynamic items, Spotfire Dashboard features, data filtering, filter schemas, analysis techniques like Box plot, Pareto chart and Combination chart.
Spotfire Administration
Spotfire installation, administration and maintenance, deloying information designs and information links and joins, personalization, working with Web Player DXP, Spotfire authorization, authentication and security.
Predictive Analytics- Map Visualization
Map Visualization, Forcasting, Text Area Features, Upload and Store data to Library, Drag and Drop of Visualization, Application of Profiler.
Spotfire Visual Insights
Visual Appearance, Recommendations, Mark from Legend, Data Panel, Interacting Grouping of Categories, Data Connector, Data Profiler, Collaboration.
Tableau Course Content
Introduction to Tableau
Overview of Tableau, data visualization and analytics, elements of the Tableau dashboard, understanding the significance of Tableau Desktop and Tableau Server, extensively work with data visualization using line, bar, area, stacked bar, and multi line charts, connecting with Excel data.
Deep dive into Tableau Graphs
Various data representation techniques, like Tables, Graphs and Maps understanding the basics of Tree Map, Histogram, Filled Map, Symbol Map, Pie Chart, Trend Lines, Normal Tables and Multi measure Tables.
Tableau Table Joins
Understanding the conditions and methodology for joining Tables, knowledge of Multi Table Joins.
Working with Metadata
Working with Table, creation of Calculated Fields, duplicating and renaming columns, conversion of data types, default aggregation.
Hierarchy & Groups
Tableau Hierarchy creation, Static Group creation, deploying functions for Group creation.
Tableau Sorting
The various options of Sorting in Tableau, sorting of Multi-dimensional graph, deploying combined fields and setting sorting priorities.
Dual Axis Graphs
Working with Dual Line Charts, Multiline Chart, Donut Chart, Pie Chart, working with Measure Name and Measure Values.
Histogram
Learning about the different type of Single Axis Histogram, Dual Axis Histogram.
Pareto Chart
Understanding how to design and work with Pareto Chart
Motion Chart
Deploying Motion Chart for data that changes over time using x and y axes
Box Plot
Representation of numerical data through quartiles using Box Plot
Funnel Chart
Working with Funnel Chart for data that progressively reduces with each stage.
Waterfall Chart
Deploying Waterfall Chart for understanding the cumulative effect of sequential values.
Sets
Understanding the concept of Set which is an entity whose composition is based on a computed condition.
String Calculated Fields
Learning how to perform various operations on Strings like concatenation, manipulation and analyzing with String Calculated Fields
Date Calculated Fields
Working with Date Calculated Fields for performing operations like parsing, modifying and analyzing.
Tableau Parameters
Learning to use the dynamic values or parameters including What if Analysis, Column Selection Parameters, Chart Selection Parameters
Tableau Actions
Tableau lets you add interactivity and context to your data using Filter Actions, URL Actions.
Dashboard Creation
Working with the Tableau Dashboard and understanding the various concepts like Formatting, Containers, Navigations and Actions.
Tableau Architecture
Understanding the basic Architecture of Tableau, learning about Tableau Desktop features, Tableu Server, working of Tableau and the various Tableau Products.
Tableau Products, Tableau public Features, Tableau Desktop personal features, Tableau Desktop professional feature, Tableau Server Feature, Tableau File System, Tableau Working, Tableau Server Architecture
Connection Type
Tableau Connections –Live Connection and Data Extract Connection, Comparing the two Live And Extract connection
Sharing Dashboard
Learning to work on Tableau by sharing the dashboard with offline users.
Data Blending
Methods to work with data from disparate sources, defining the relationship between the data and combining it in the optimal way.
Dashboard Filter
Working with various Tableau Filter options, understanding the Filter Dimensions and ways to make the Filter Global.
Filter Deployment
Taking the various data sources and implementing to blend the graphs, using Global Fliter for blending graphs.
Tableau LOD Expression
Tableau Level of Detail Expressions for combining aggregate and non-aggregate data, converting aggregate to non-aggregate data in Tableau 9.X
MapBox Integration
Integrating MapBox on Tableau for deploying Maps into Tableau Visualization
Table Calculation
Understanding Tableau Table Calculation, familiarizing with Graph and View, learning about Context filter.
Aggregating Data
Understanding the concept of aggregating data in Tableau, defining Table Calculation, working with Drop Lines, Mark Labels, FORMAT function, working with String, Date and Logical Function, data disaggregating, forecasting.
LOD Expression Function
Deploying the Exclude function in LOD
Integration of Tableau and R
Introduction to R Statistical computing, the various applications and use cases of R language, deploying R on the Tableau platform, learning the R functions in Tableau, the concept of Outliers in tableau,
K-means in Tableau
Learning how to deploy K-means clustering in order to group and parse data in Tableau.
Tableau StoryTelling
The art of telling stories with Tableau, the importance of story point and determining when to deploy Tableau Storytelling
Storytelling on Graph
Converting the data available on a Graph into a Visual Storytelling endeavour.
Clustering and Advanced Bar charts in Tableau 10
You will learn to create clustering, understanding how it works for scatter plots, text tables and maps, creation of custom territories, mastering the art of advanced bar charts in Tableau 10.This video explains about clustering, creating custom territories and Advanced Bar charts in Tableau 10.
Multiple data source filters & advanced maps
Understanding the various Tableau 10 features like Highlighter, deploying multiple data sources for creation of filter and advanced mapping functionalities.
Beautify by design in Tableau 10
Introduction to the various new features of Tableau 10, working with Device Designer, New Device Interface, Color palette and more.
Data breakthrough in Tableau 10
Understanding new data breakthrough in Tableau 10, new features of data sources, integrating multiple data sources for deriving insights.
Cognos Developer Course Content
Overview IBM Cognos Business Intelligence and Cognos BI Architecture
Introduction to IBM Cognos Business Intelligence and analytics tool, understanding its Architecture, core concepts of data warehousing, ETL, various types of OLAP, Cognos Framework Manager, DMR models.
IBM Cognos Framework Manager Modelling
Learning to build query models to connect with report layout, deploying query model for adding reports and filters, creating custom queries by editing SQL statement, creating reports by joining query results, combining data containers based on relationships from various queries.
IBM Cognos Advance Framework Manager and Performance Improvement
Introduction to IBM Cognos Framework Manager, learning about the workflow process, writing SQL queries, performing calculations, creating projects, applying filters and creation of Star Schema, the difference between various data models, importing of metadata, access control to metadata, merging of metadata, working with data sources, stored procedure query subjects, work with macros, setting governors, performance improvement, parameter map, session parameters, learn about multi-facet, multi-grain, and stitch queries.
Cognos Report Studio
Introduction to IBM Report Studio, understanding what is Report Authoring, creating reports using Report Studio, understanding Query Studio, various types of Reports, grouping, formatting, and sorting list Reports, aggregating data, multi-facet data and Report with repeated data.
Reporting using Filters,Formatting,Charts
Performing filtering, grouping and sorting of Reports, filtering to narrow focus of Report, Cross tab Reports, formatting and sorting Cross tab Reports, creating Charts, adding context to Charts.
Reports using Prompts and calculations
Learning about various Prompts on Reports, working with Prompts to focus data, searching Prompt items, customization, page navigation, displaying user Prompt selection, extending Report capabilities using calculation, creation of statistical calculations, statistical charts with Cognos Report Studio.
Advance Report Building Techniques
Reusing objects in the same Report, layout sharing between different Reports, working with various templates, handling Reports with no available data.Learning to customize Reports with showing, hiding and highlighting data, creating multilingual reports, rendering conditional objects.
Drilling through Reports
Understanding the concept of Drill through, letting users find the data they want, comparing parameter-driven and dynamic drill through, drilling from one report to another, setting the scope of drill through, familiarizing with drill through assistant, enhancing report layout, combining data containers, formatting data and report objects.
Advanced Dynamic Reports
Introduction to advanced Cognos reporting, filtering reports on session parameters, navigating to specific location in report, navigating using table of contents, creating dynamic titles and headers, detailed learning of advanced report authoring, linking reports and displaying one report layer, editing SQL statements, distributing Report content to various users, creating Master-Detail Report, conditional formatting of Reports using variables, string and Boolean expressions, examining report specification and modifying it, deploying Java Scripts and HTML items for user interaction.
Report Distribution using Bursting
Understanding the concept of report bursting, running a report once and dividing the results as per specific recipients, steps in report bursting, specifying burst groups, setting burst options and enabling bursting, creating burst keys and burst tables, rules of report bursting and formats supported for bursting.
Statistical Reports
Learning about statistical reporting, creating statistical objects, adding cases and variables, integrating statistical objects with Cognos Report Studio, understanding descriptive statistics and statistical charts, analyzing using statistical reports and distributing results to users.
Cognos Active Reports
Creating active reports using Cognos Report Studio, designing highly interactive reports, building report as per user needs, learning about the characteristics of Active Reports and deploying it to build easy to use reports, scheduling and bursting of Active Reports, understanding Active Report controls and variables.
Active Reports – Multi-Dimensional
Introduction to dimensional data in reports, working with DMR and OLAP data sources in dimensional reporting, understanding dimensions, levels, hierarchies and members, learning about dimensional reporting methodology.
Active Reports-Advance Dimensional Reporting
Learning about focusing dimensional data in a cross tab, difference between relational and dimensional queries, various filtering techniques, filtering of dimensional queries based on dimensions, measures and members, learning how to use a tree prompt for dynamic filtering,Cognos Dimensional Functions, deploying it to create sets and tuples, working with OLAP queries to deploy arithmetic queries, characteristics of Cognos Dimensional Functions.
Advanced drilling Techniques
Introduction to advanced drilling techniques, identifying the need for overriding the default drilling, deploying advancing drill down techniques, the various member sets and support functions for performing advanced drilling.
Transformer-multi-dimensional data Modelling
Introduction to Cognos Transformer, multi-dimensional data modeling component, defining OLAP Cube structures, building multi-dimensional analysis cubes, modeling the dimensions, customizing measures, the various components of transformers, the various categories and members, creating a model plan, relating transformer model to model plan, transformer data sources and data types, matching the business requirements.
Transformer-Dynamic Cubes
Learning how to create PowerCubes, creating data source connection to PowerCube, publishing of Cube, optimizing PowerCube input and output, various factors affecting PowerCube building and deployment, partitioning of PowerCubes, benefits of partitioning, creating a partitioning strategy, time-based partitioning, comparing the automatic and manual partitioning, learning about multifile PowerCube.
Advance features in Transformer-Dynamic Cubes
Introduction to IBM Cognos Cube designer, building dynamic cubes, deploying and measuring the performance, working with star and snowflake data schema, in-memory relational OLAP functionality, benefits of Dynamic Cube, Cube Designer interface, aggregation in Dynamic Cubes, modelling a Virtual Cube and publishing with IBM Cognos Studios.
Analyzing and Administering Queries
Learning to perform Cognos Analysis in Excel, the various query settings for enhancing performance, working with Dynamic Query Analyzer, Cognos Workflow, administering IBM Cognos, understanding query service metrics, moving data from previous versions, managing and auditing the Cognos environment, enhancing the search, restricting scheduling options, disabling query service.
Cognos TM1 Course Content
Introduction to Cognos TM1
Understanding multi-dimensional OLAP database, TM1 Web, TM1 Executive Viewer, TM1 Servers and Services, Cognos TM1 Installation.
Cognos TM1 Configuration
Managing the components and tasks – start, stop and add TM1 Servers, use the components – TM1 Web, Applications and Operations Console, create or delete Windows/Desktop services using Command prompt.
Creating Dimensions
Manual creation of Dimensions, Sparse and Dense Dimensions, reviewing Cubes and Dimensions, using Turbo Integrator ETL, deploying Dimension Editor/Attributes, working with various elements.
Building Cubes and Views
learning to create New Cube View, using View Builder Wizard, understanding Cube and data Points, deploying Cubes for constructing Data Views, View types – Private, Public & Default, Dynamic and Static Subset creation.
Working with TM1 Turbo Integrator
Understanding the ETL process in Turbo Integrator, extract data from multiple sources, loading data into TM1 Cubes, creating processes for data loading and deleting, scheduling and editing processes through procedures – Data, Metadata, Prolog, Epilog, identifying and mapping variables.
Cognos TM1 Rules
Understanding TM1 rules, TM1 Rules Editor, rules compilation, using functions, rule performance optimization, working with Feeders and Skipcheck.
Advanced Scripting with Turbo Integrator
Working with Advanced tab of Turbo Integrator, creating scripts for editing procedures, deploying Dimension subsets and attributes.
TM1 Data Spreading
Distributing numeric data across cells in Cube View, data spreading functions, procedures and methods, drill-through process and rules for assigned detailed data to cells.
Advanced Modeling Techniques
Significance of advanced modeling, manually adding objects to application design, understanding application views, dimensions and hierarchy, virtual cubes, lookup cubes, spread profile cube.
TM1 Security
The various security levels including Server level, Cube level, Dimension level.
TM1 Application Web
Importance of Application Web for extreme formatting, working with TM1 Application Web.
Cognos Insight Course Content
Basic Conceptual Architecture of Business Analytics
Business Analytics: Basic concepts, Business Intelligence & Data Warehousing Concepts, Conceptual differences: RDBMS & Data warehousing, Benefits & advantages of Data warehousing
Introduction to IBM COGNOS Insight
What is IBM Cognos Insight?, Why use IBM Cognos Insight?, Add data to your Workspace, Identify Data Terms, Explore the Workspace, Filter Content using Explore Points, Navigate and Explore Data
Import Data
Import Data, Use Quick Import, Import from a File, Define Data for Mapping, Map the Cube, Map Dimensions and Measures, Import from Microsoft Excel, Import form a Relational ODBC Source, Data Source, Refresh Data, Import Inventory Data from a Relational Data Source
Restructure Data
Analyze Data, Calculate Data in a Workspace, Create Custom Calculations, Undo Changes, Restructure Data, Change the Way Measures are Summarized, Add Calculations During an Import
Create Visualizations
Choose an effective Chart, Choose a Chart Type, Area Charts, Bar Charts, Column Charts, Line Charts, Pie Charts, Point Charts, Specify Chart Options
Construct a Workspace
Add Contents using Widgets, Examine Widget Types, Modify Widget Bbehavior Organize your Workspace, Enhance Appearance with Themes
Format and Enter Data
Format and Enter Data, Understand Data Entry Colors, Use Numeric and Text Data, Use Date, Use Pick Lists, Add Annotations, Enter data Quickly using Shortcuts, Data Entry Commands
Further Learning Roadmap:
To learn analytics further and orient your career in that direction, following are the recommended study areas –
Big Data & Analytics, Text/Content Analytics, Big Data Programming, Predictive Analytics and Data Modelling
Pentaho Course Content
Introduction to Pentaho Tool
Oveview of Pentaho Business Intelligence and Analytics tools, database dimensional modelling, using Star Schema for querying large data sets, understanding fact tables and dimensions tables, Snowflake Schema, principles of Slowly Changing Dimensions.
Clustering in Pentaho
Understanding the basics of clustering in Pentaho Data Integration, creating a database connection, moving a CSV file input to table output and Microsoft Excel output, moving from Excel to data grid and log.
Data Transformation
The Pentaho Data Integration Transformation steps, adding sequence, understanding calculator, Penthao number range, string replace, selecting field value, sorting and splitting rows, string operation, unique row and value mapper.
Pentaho Flow
Working with secure socket command, Pentaho null value and error handling, Pentaho mail, row filter and priorities stream.
Deploying SCD
Understanding Slowly Changing Dimensions, making ETL dynamic, dynamic transformation, creating folders, scripting, bulk loading, file management, working with Pentaho file transfer, Repository, XML, Utility and File encryption.
Type of Repository in Pentaho
Creating dynamic ETL, passing variable and value from job to transformation, deploying parameter with transformation, importance of Repository in Pentaho, database connection, environmental variable and repository import.
Pentaho Repository & Report Designing
Working with Pentaho dashboard and Report, effect of row bending, designing a report, working with Pentaho Server, creation of line, bar and pie chart in Pentaho.
Pentaho Dashboard
Working with Pentaho Dashboard, passing parameters in Report and Dashboard, drill-down of Report, deploying Cubes for report creation, working with Excel sheet, Pentaho data integration for report creation.
Understanding Cube
What is a Cube? Creation and benefit of Cube, working with Cube, Report and Dashboard creation with Cube.
Multi Dimensional Expression
Understanding the basics of Multi Dimensional Expression (MDX), basics of MDX, understanding Tuple, its implicit dimensions, MDX sets, level, members, dimensions referencing, hierarchical navigation, and meta data.
Pentaho Analyzer
Pentaho analytics for discovering, blending various data types and sizes, including advanced analytics for visualizing data across multiple dimensions.
Hadoop ETL Connectivity
Deploying ETL capabilities for working on the Hadoop ecosystem, integrating with HDFS and moving data from local file to distributed file system, deploying Apache Hive, designing MapReduce jobs, complete Hadoop integration with ETL tool.
Creating dashboards in Pentaho
Creating interactive dashboards for visualizing highly graphical representation of data for improving key business performance.
Jaspersoft Course Content
Jaspersoft Architecture and iReport Introduction
Introduction to Architecture of Jaspersoft Business Intelligence, JasperReports Server and Report Lifecycle, installation of Jaspersoft and iReport creation.
Creating Basic Reports
Understanding the iReport Designer, navigation in iReport and learning to create bar charts, line charts and expressions.
Advance Reporting Features
A truly integrated self-service reporting, CA Clarity PPM Reporting, working with interactive reports, combination charts, passing parameters in report, working with sub-reports.
Jaspersoft Customization
Customizing the Jaspersoft branding, changing the login page, rebranding with SiteMesh Decorators, customizing web interface, understanding Bundles, Logs and Lib.
Introduction to JasperServer
JasperReports Server, standalone and embeddable reporting server, deploying Reporting and Analytics, navigating in JasperServer and learning about Parameters.
Ad Hoc Reports
Understanding ad hoc reports in JasperServer, the concepts of Domains and Topics, creation of and deployment of subreports, dashboard creation, administration of Domains and Topics, auto scheduling of Reports and sharing.
Jaspersoft User Interface
Introduction to Jaspersoft Studio, the Studio user interface, working with Jaspersoft Reports using Expressions, Objects, Variables, Parameters and Bands.
Jaspersoft Group by Bands
Grouping of data in Jaspersoft Report using bands, working with Table component, cross tab component and subreports.
Jaspersoft Datasource and Graphs
Understanding Jaspersoft Datasource, creation of charts, graphs, evaluation time and subreports, working with Jaspersoft Studio.
Jaspersoft Components
The various components of Jaspersoft Reports like Report books, table of contents, image and break components, topics, domains, input and filter controls.
Jaspersoft Advanced Properties
Advanced features of Jaspersoft Reports, working with advanced Excel and PDF properties, learning about hyperlinking and Drill-down Reports.
Jaspersoft Styles
Deploying Styles in Jasper Reports, various types of Style features, learning about standalone style export, alternate color banding and markup HTML styled field.
Jaspersoft Scriptlets
Introduction to Jaspersoft Scriptlets, interface between Jasper Reports and Java, the prerequisites to run Scriptlets, the customization benefits of Scriptlets, Reporting flexibility with user-defined functions, step by step demonstration of deploying Scriptlets.
JFreeCharts in JasperReports
Customization of JFreeCharts, chart customizer classes, resource bundle internationalization, working with Maps and Barcodes.
JR Datasource
Understanding Datasource, various input data to JasperReports engine, introduction to JR Datasource, custom JR Datasource, learning about Java bean Datasource and JR Datasource provider.
Advance features of Jaspersoft Server
Detailed understanding of Jaspersoft Server, Jaspersoft UI features, connecting with Jaspersoft Studio, publishing and updating Report on Jaspersoft Server.
scheduling of Reports
Learning how to add Reports to JasperServer, working with the cascading parameters, drilling down Reports and scheduling of Reports.
Dynamic Jasper and Custom Visualization
Introduction to Dynamic Jasper API, hiding complexities of JasperReports, linking of Java with Jaspersoft, working with Custom Visualization Element, enabling mail subscription, customization of JasperServer UI.
Advance Dashboard
Introduction to Jaspersoft dashboard, building of interactive dashboard, importing/exporting from/to JasperServer, various features of Jaspersoft dashboard, exporting of dashboard, various Parameters in JasperServer.
Adhoc Editor
Introduction to Jaspersoft Ad hoc Editor, creating and editing an Ad hoc View, analyzing data from Topic, Domain or OLAP Datasource, deploying content for Reports using Ad hoc Editor.
Introduction to Cubes and Multi Tenancy
Creation of OLAP Cubes in JasperReports Server, understanding the multi-tenancy architecture, the distinction between MOLAP, HOLAP, and ROLAP, learning about the BI application lifecycle.
Performance Tuning
Improving the performance of Jaspersoft applications, measuring of ad hoc performance, various methods of performance tuning.
MicroStrategy Course Content
MicroStrategy Introduction & Installation
Introduction to MicroStrategy Business Intelligence tool, the various capabilities of MicroStrategy in data discovery, advanced analytics, enterprise reporting and dashboard functionality, detailed knowledge of installation of MicroStrategy.
DW & BI Architecture
Understand in detail about the Data Warehousing and Business Intelligence architecture, data sources, ETL process, loading data in EDW and data marts.
Business Intelligence capability
Learning how BI capability various at different levels, operational, adhoc and dashboard needs and solutions offered like grids and graphs.
Analytical Models
Progression in analytical methods, various types models like summarization, trends, benchmarking, comparative analysis, optimization and predictions.
MicroStrategy Platform Architecture
A detailed architecture of MicroStrategy including tools and services, data assets, schemas, metadata, public objects and information delivered via web, desktop and mobile.
MicroStrategy Architecture Flow
MicroStrategy data flow architecture, the various types of setup like on-premise, cloud and mobile, understanding the need for data containers, customization using SDK, security for backend data containers and other offerings.
Connectivity and the Data ecosystems
Learning about the various backend data support that MicroStrategy offers, seamless integration with relational databases and unstructured data storage.
Analyzing data
Learning about the basic components and elements of schema, facts and dimensions, analyzing data and quantifying business elements.
Measures & Metrics
Understanding about measures and metrics in a data warehouse schema.
Logical & Physical Warehouse Schema
The MicroStrategy foundation of logical data model and schema, its role in data warehouse and business intelligence, clear understanding of Star Schema, working with Facts and Dimensions Tables.
Project Source and Creation
Creation of Project Source in MicroStrategy, connecting with metadata database, detailed learning of MicroStrategy project, the first step to creating public and schema objects.
Schema Architect
The significance of architect for the projects, a detailed demo of working with Architect for project, and creation of schema objects like Facts and Attributes.
Organizing Schema Objects
Understanding how to create schema objects, data warehouse catalog, schema tables, creation and editing of Attributes and Facts, Schema update and its need.
Creation of Hierarchies
Learning about the need for creating folders, Attributes organization, getting a structured view of Facts and Attributes, mapping of Attributes depending on the folder in which they are located, defining navigation path using hierarchies and steps to creating hierarchies.
Creating Metrics
Creation of basic metrics and level metrics, defining metrics using filters, studying the metrics generated by SQL when working with level dimensionality, detailed step by step process to create metrics.
Creating Filters
Learning about the step by step process for creating filters and the different options in creating filters.
Creating Prompts
Understanding the different ways of creation of Prompts and its various uses.
Search Objects
Learning how to create Search Objects, the usage of Search Objects in Prompts and
Consolidation
The method to creating Consolidation Objects, the significance of them, learning through detailed demonstration, understanding the difference between Consolidation and Custom Groups.
Custom Groups
Learning how to create Custom Groups and their distinction from Consolidation Objects, Custom Groups are a consequence of SQL queries and Consolidation Objects are functions of analytical engine, a detailed demonstration of steps needed for SQL query generation in Custom Groups.
Drill Maps
Understanding Drill Maps creations, its significance, role of hierarchies in drill navigation, detailed demonstration of Drill Maps and Navigation.
Partition mapping
Understanding partitioning, various type of data partitioning like homogenous and heterogeneous mapping, metadata and warehouse partitioning, a detailed demonstration of creating partition mapping in MicroStrategy.
Different type of Reports Creation
Clear understanding of how to create Reports using MicroStrategy Developer/Desktop, executing the Report, the various View types like Design, SQL and Grid, deploying View Filters and Report Editor, learning to work with Reports like creating and using Filters, Prompts, Sorts, Drill-down and Format.
MicroStrategy Web
Understanding the MicroStrategy Web Interface, learning about folder structure, Report deployment and other features.
Web Dashboard
Learning about the MicroStrategy Dashboard created using Web Interface, importance of Visual Insight for Self-service Business Intelligence, creating dashboards on web in production environment.
MicroStrategy Intelligence Server
Understanding the MicroStrategy Intelligence Server, the various components like OLAP and Reporting, Distribution and Transaction Services, Clustering and Multisourcing, learning about the two tier and three tier architecture.
Hyperion Course Content
Getting started with Hyperion
Introduction to Oracle EPM, Hyperion system 11 Components, BI+ Three Tier architecture, Client/Server Reporting Architecture, BI+ Interfaces (Plug In/HTML,etc.), Hyperion IR Core Services, DAS & LCM Utility, Typical IR Env Architecture, Report Process Flow
Introduction to IR, Relational vs. Multidimensional Reporting Tools, ODBC and DSN, OCE Optimization
IR Overview (What is BQY& OCE), Relational Data Source Connections, MDDB Data Source Connections, Difference Between Relational & Multidimensional Reporting Tools, Open Catalog Extension Building, Tnsnames Ora file integration, Oracle/Oracle Net Features, ODBC & DSN Concepts, Filtering Table/Owner/Table Type, OCE Optimization & Best Practices, Modifying the OCE from Connection Manager
SQL Queries and Important Operations and Functions
Building a Query, Different Join Types, Request/Filter & Sort Line (Query & result level), Adding Computed Items (Query & result level), Available/Custom/Selected Values in Filter, Custom SQL in filter, Loading filter values from flat files, Variable & Cascading Filters, Group by & Having Clause in Query Section, Export & Import Options, Break Total/Grand Total, Grouping Column in Results, Suppress Duplicates, Building Subqueries, Different Save Options, Working with Meta Topics (Original & Combined View), Processing Queries (all, Current, Custom), Estimating Query Size, Appending Queries (Union, Union All), Viewing SQL Log & Custom SQL, Query Options, Local Results & Derived Queries Concept
Pivot, report and Table sections, Spotlighter, and Getting started with Java Scripting
Adding & Building Pivot Section, Adding table Section & its significance, Drill Down Feature, Controlling Drill Down using Table Section, Pivot Refresh Data Options (After Process/When Displayed/Manual/Refresh Now), Variance Reporting in Pivot/Annotations in Pivot, Month Name Sorting/Top N analysis, Working with Report section (Creating Report Groups), Synchronize with DB Feature, Working with Spotlighter, Introduction to Java Scripting
Insights into Toolbar
Run Mode and Design Mode, Document Script Concept & Event Trigger, Navigating the Object Model in Script Editor, Hard Coding Values in Drop Down, Loading drop Down Values from Query using Java Script, Loading Drop Down values using Get Cell Function, Tool bars hiding using JavaScript, Filter the result based on User selection on Dashboard through Java Scripting, Working with Radio buttons & Text boxes, Explaining Pivot Properties on Dashboard (including Active/Hyperion link/View Only), Introducing Console Window, Working with Hyperlink
Advanced operations on BQY and Java Scripting
Extracting Last SQL Statement through JavaScript, Extracting report’s metadata using Java Scripting, Handling Dashboard Objects positioning based on coordinates through java Scripting, Repository Based reports & Utilities, Workspace Login/Explore & Folder Organization, Opening a BQY in Web Client, Import BQY on Workspace, Providing Adaptive States on BQY, Editing a published IR document, Administer Module Options (Administrator), CMC Console View, Data Access Service Configuration, Services in Task Manager, Job Status/Job Queue/Job Log, Managing Physical Resources, Shared Services Login, User Directories Management, Application Groups & LCM Utility
Workspace and Admin Demonstrations
Demonstration of Workspace, Demonstration of Administration Activities, Demonstration of Shared Services
MSBI SSRS Course Content
Introduction to SSRS
Get introduced to the SSRS Architecture, components of SSRS Report Building tool, learning about the data flow in different components.
Matrix and Tablix Overview
Understanding the concepts of Matrix and Tablix, working with Text Box, learning about formatting, row/column grouping, understanding sorting, formatting, concepts of Header, Footer, Totals, Subtotals and Page Breaks.
Parameters and Expression
Learning about Parameters, filter and visibility expression, understanding drill-through and drill-down, defining variables, custom code.
Reports and Charts creation
Introduction to various aspects of Bar Chart, Line Chart, Combination Chart, Shape Chart, Sub Reports
Dashboard Building
Learn how to build a Dashboard with Sparklines, Data Bars, Map Charts, Gauge Charts and drilling into reports, the basics of ad hoc reporting.
Data Bar, Sparkline, Indicator, Gauge Chart, Map Chart, Report Drilling, What is Ad hoc reporting?
Reports and Authenticity
Understanding Report Cache, Authorization, Authentication and Report Snapshot, learning about Subscriptions and Site Security.
Qlikview Project
Project – QlikView Dashboard creation using 3 principles of DAR
Topics – This project involves understanding the concepts of the QlikView Dashboard, Analysis, Reporting (DAR) methodology to creating and building of QlikView applications. This way you can reuse your earlier QlikView Worksheets with minimal changes thus saving you time and effort. You will have hands-on experience in designing the Dashboard, creating Analysis Page and ultimately develop the QlikView Reports with DAR implementation. You will learn about the business overview, deploying user-driven controls for data filters and reporting of specific details in this QlikView Dashboard project.
Spotfire Project
Project – IronPython
Data – Sales
Topics – This project is involved with creating IronPython script for Spotfire platform. You will start with the basics of implementing the IronPython scripting like importing classes for the visualization. In this sales project you will learn about the various operations and tools in IronPython scripting, creating data forms, collaboration platforms in Spotfire, framework for workflow, automating services all using the IronPython scripting.
Tableau Project
Project – Tableau Interactive Dashboard
Data Set – Sales
Topics – This project is involved with working on a Tableau dashboard for sales data. You will gain in-depth experience in working with dashboard objects, learn about visualizing data, highlight action, and dashboard shortcuts. With a few clicks you will be able to combine multiple data sources, add filters and drill down specific information. You will be proficient in creating real time visualizations that are interactive within minutes.
Upon completion of this project you will understand how to create a single point of access for all your sales data, ways of dissecting and analyzing sales from multiple angles, coming up with a sales strategy for improved business revenues.
Cognos Developer Project
Sales Dashboard
This project is involved with creating a sales dashboard for a specific company using the data available. You will learn to create a high-level graphical representation of a company’s vital performance indicators. As part of the project you will also learn to drill up and drill down data as per the specific company needs. Master the technique of navigating to various other tools like Cognos Report Studio, Cognos Query Studio, and Cognos Analysis Studio.
Employee Dashboard
This project is involved with creating an employee dashboard that can be helpful in extracting key insights and information about the employees in a particular organization. Learn to create multiple charts by joining multiple data sources into a single Cognos Report. You can easily drill down based on specific parameters in order to get insights that you are looking for. You will also master the technique of rearranging the various dimensions in a Report through the slicing and dicing multidimensional analysis technique.
Cognos TM1 Project
Project – Create and Deploy Planning Applications to the Prospects (Excel)
Data – Sales
Topics – This project is involved with exploring and analyzing data that is derived from Cognos TM1 models into the Excel spreadsheet format. Learn how to move data between Cognos TM1 model and Excel while retaining the Excel functionality, extending the analytics capabilities for faster and better decision-making. You will closely work on connecting TM1 Server with Excel, creating Slicer and Snapshot, creating and managing active forms. Upon completion of the project you will know how to build powerful multi query and multi sheet reports against different databases.
Pentaho Project
Project– Pentaho Interactive Report
Data– Sales, Customer, Product
Topics – In this Pentaho project you will be exclusively working on creating Pentaho interactive reports for sales, customer and product data fields. As part of the project you will learn to create a data source, build a Mondrian cube which is represented in an XML file. You will gain advanced experience in managing data sources, building and formatting Pentaho report, change the report template and scheduling of reports.
Jaspersoft Project
Project – Creating & Deploying Cube
Data – Sales
Topics–In this Jaspersoft project you will be working on creating a sales cube and using it on the Server. You will gain hands-on experience in Jaspersoft Reporting, drill down analysis, multidimensional expression, aggregating tables, in-memory aggregate cache, and conditional styling. It also involves accessing your OLAP data through a web interface, performing various operations on the data like filtering, visualizing, pivoting, filtering and creating alerts. Upon completion of the project you will learn how to make data-driven business decisions, detect patterns and aberrations in the data and correlate the various data sets.
MicroStrategy Project
Project– MicroStrategy Report
Data – Revenue Dataset
In this project you will be creating a complex MicroStrategy report based on the revenue dataset of a business organization. You will gain hands-on experience in working with schema objects, public objects, creation of dashboard and web interface. Learn to dice and slice the data using flexible reporting capabilities based on OLAP functionalities. The goal of the project is to predict the revenue using MicroStrategy Reports for particular country, call center, and category of product.
SSRS Project
Project – Building Dashboard
Data – Sales
Topics– In this project you will be working on SQL Server Reporting Services (SSRS) and deploying it for building dashboards in a business environment. The Business Intelligence Report that you create will be used to calculate sales based on the years and currencies that you choose. Some of the tasks that you will be performing as part of this project are – design and create Gauge and Map Charts, Sparklines and Data Bar and perform drill-through Reports, and ad hoc Reporting.
Introduction to Tableau
Tableau Project
View previous class recording
Pentaho Tutorial
MSBI Tutorial
Intellipaat is a pioneer of Business Intelligence Reporting Tools training. This is an industry-designed combo training course that includes some of the best BI Reporting Tools used in the corporate world today. BI Reporting is involved with helping the end-users visualize data, analyze it, gain new insights to make informed and data-driven business decisions.
This Intellipaat training includes the top BI Reporting tools like QlikView, Tableau, Spotfire, Cognos, Jaspersoft, Microstrategy, Hyperion, SSRS and Pentaho. This training will equip to work in the BI Reporting domain in any industry vertical thanks to the diverse range of tools included in this combo training.
The complete course content is aligned towards clearing the various certification exams viz. Tableau Desktop Qualified Associate Exam Certification, QlikView Developer Certification, Pentaho Business Analytics Implementation, MicroStrategy Certified Developer, IBM Certified Developer – Cognos BI Data Warehouses, PowerCenter Developer Certification, IBM Certified Developer – Cognos TM1 , Oracle Hyperion Interactive Reporting Certification, Spotfire Knowledge Assessment Exam, Jaspersoft Certification Exam.
Your training program includes real time projects, step-by-step assignments to evaluate your progress and specially designed quizzes for clearing the requisite certification exams.
Intellipaat also offers lifetime access to videos, course materials, 24/7 Support, and course material upgrades to latest version at no extra fees. Hence it is clearly a one-time investment.
Intellipaat basically offers the self-paced training and online instructor-led training. Apart from that we also provide corporate training for enterprises. All our trainers come with over 12 years of industry experience in relevant technologies and also they are subject matter experts working as consultants. You can check about the quality of our trainers in the sample videos provided.
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact Intellipaat even after completion of training to get support and assistance. There is also no limit on the number of queries you can raise when it comes to doubt clearance and query resolution.
The Intellipaat self-paced training is for people who want to learn at their own leisurely pace. As part of this program we provide you with one-on-one sessions, doubt clearance over email, 24/7 Live Support, lifetime LMS and upgrade to the latest version at no extra cost. The prices of self-paced training can be 75% lesser than online training. While studying should you face any unexpected challenges then we shall arrange a Virtual LIVE session with the trainer.
We provide you with the opportunity to work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready. These projects could be in exciting and challenging fields like banking, insurance, retail, social networking, ecommerce, marketing, sales, high technology and so on. The Intellipaat projects are equivalent to six months of relevant experience in the corporate world.
Yes, Intellipaat does provide you with placement assistance. We have tie-ups with 80+ organizations including Ericsson, Cisco, Cognizant, TCS, among others that are looking for skilled & quality professionals and we would be happy to assist you with the process of preparing yourself for the interview and the job.
Yes, if you would want to upgrade from the self-paced training to instructor-led training then you can easily do so by paying the difference of the fees amount and joining the next batch of classes which shall be separately notified to you.
Upon successful completion of training you have to take a set of quizzes, complete the projects and upon review and on scoring over 60% marks in the qualifying quiz the official Intellipaat verified certificate is awarded.The Intellipaat Certification is a seal of approval and is highly recognized in 80+ corporations around the world including many in the Fortune 500 list of companies.
This course is designed for clearing QlikView Certification Program, Spotfire Certification Exam, Tableau Software Certification Exam, Cognos Developer Professional Certification Exam, Pentaho Certification Exam, Jaspersoft Certification Exam, Microstrategy Training Certification Exam, Oracle Hyperion Interactive Reporting Certification, IBM Cognos Certification. At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate. Become in demand with Intellipaat certifications
$1899 | 108243
You will get Lifetime access to high quality interactive tutorials along with life time access to complete Course Material .There will be 24/7 access to video tutorials with email support. If you stuck in any unexpected problem we will provide online interactive sessions with trainer for issue resolving.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
Disclaimer
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org
Sales Offer
- To avail this offer, enroll before 20th September 2017.
- This offer cannot be combined with any other offer.
- This offer is valid on selected courses only.
- Please use coupon codes mentioned below to avail the offer
Great Course
One of the most intresting, valuable and enjoyable course i ever have. Excellent material and good tutoring. Highly recommended.
Well Explained Material
Everything is so well explained. I liked the format and the material.By far, the best online training I have ever attended. Never seen such amazing trainers with excellent knowledge and answering capabilities.