OLAP Tools

May 10, 2016

OLAP Tools

OLAP (online analytical processing) uses multidimensional structures to provide rapid access to data for analysis. OLAP enables analysts to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information. OLAP transforms raw data so that it reflects the real dimensionality of the enterprise as understood by the user.

Understanding BusinessObjects Universes

BusinessObjects universe concepts.

Understanding universe development cycle.

Creating the Basic Universe.

Getting started t.

create the universe.

Building the Universe Structure.

Create the universe structure.

Defining joins in a universe.

Dimension Objects.

Understand classes and objects.

Creating classes and objects.

Measure Objects.

Measure object concepts.

Creating measure objects.

Loops in a Universe.

Understanding loops concept.

Resolving loops using aliases.

Resolving loops using contexts.

Understanding and Resolving SQL Traps.

Understanding SQL traps and universes.

Detecting and resolving chasm traps.

Detecting and resolving fan traps.

Applying Restrictions on Objects

Restricting the data returned by objects.

Using functions with Objects.

Defining functions.


prompt syntax.





Hierarchies and universes concept.

Working with hierarchies.

Lists of Values.

Creating a list of values.

Working with LOVs in Universe Designer.

Creating a cascading LOV.

Derived Tables and Indexes.

Derived tables concept and its use.

Applying index awareness.

Linking Universes.

Linked universe concept.

Creating links between universes.

Universe Access Restrictions.

Setting access restrictions on a universe.

Universe Management.

Documenting universes.

Deploying universes.

Maintaining universes.

Web Intelligence Introduction.

Web Intelligence concepts.

Creating Web Intelligence Documents with Queries.

Creating a new report.

Editing Report query.

Understanding query properties.

Restricting Data Returned by a Query.

Restricting data with query filters.

Predefined query filter.

Single value query filter.

wildcards in query filters.


complex filters.

Designing Web Intelligence Reports.

Working with Web Intelligence documents.

Displaying data in tables and charts.

Creating tables.

Working with tables.

Presenting data in free.

standing cells.

Presenting data in charts.

Various features of WebI in Reports.

Breaks, calculations.


Formatting breaks and cross tabs.

Report filters.

Ranking data t.

see top or bottom values.

Tracking data changes.

Using alerters t.

highlight information.

Organizing a report int.


Copying data t.

other applications.

Formatting Reports.

Formatting documents.

Formatting charts.

Calculating Data with Formulas and Variables.

Explaining formulas and variables.

Using formulas and variables.

Using Multiple Data Sources.

Synchronizing data from multiple data sources.

Creating multiple queries in a document.

Synchronizing data with merged dimensions.

Using a personal data provider.

Analyzing Data.

Analyzing the data cube.

Drilling in Web Intelligence documents.

Setting Web Intelligence drill options.

Managing and Sharing Web Intelligence Documents.

Exporting documents t.

the CMS Managing documents in InfoView.

Viewing a Web Intelligence document in InfoView.

Sharing Web Intelligence documents.

Setting InfoView preferences.

Web Intelligence report panels.

Overview of Business Intelligence.

What is Business Intelligence.

Why is BI Important and where can we use it.

Components of BI.

Business Intelligence Roadmap.

Overview of Data Warehousing.

What is Data Warehouse, Why do we need it-Data Warehouse Architecture and its components.

Define Star Schema.

Fact and Dimensions.

Understand OLTP and OLAP Systems.

Overview of Cognos BI and Architecture.

Introduce Cognos BI.

Examine the different studios in Cognos BI.

Identify the different data sources within the studios.

Highlight key capabilities of Cognos BI.

Understand Cognos Multi Layered architecture.

Cognos Installations and Configuration.

Installing Cognos.

Install Database (MS SQL).

Install Framework Manager.

Install Cognos BI Application.

Setting up the Environment.

Configuring Cognos.

Setting up Samples in Cognos.

Uninstalling Cognos.

Cognos BI Administration.

Create and Modify a Data Source.

Create Database backups.

Understand Roles, Users and Groups.

Specify Permission Settings.

Cognos Framework Manager (Metadata Modeling).

Introduction to Framework Manager.

Framework Manager Basics.

User Interface, Navigation, Objects.

Planning the project and data model.

Framework Manager Workflow.

Naming Conventions for objects in a project.

Designing Project.

Create project.

Importing Metadata from one and more sources.

Exporting Metadata.

Data Sources.

Working with Data Source Connections.

Create and Modify Data Sources.

Improve Performance by setting Query Processing Type.

Preparing Relational Metadata for use in Reports.

Verifying Relationships.

Working with Dimensions.

Working with Query Subjects.

Data, Model and Stored Procedure Query Subject.

Working with Query Items.

Set Usage and Aggregate Property.

Making Metadata Available to Report Authors.

Verify Model-Set Governors.

Improving Performance.

Create or Modify Package.

Controlling access to Metadata.

Explore Package.

Publish Package.

Guideline for Modeling Metadata.

Best Practices.

Presentation and Database layers.

Merge Metadata.

Perform Calculations and Filters.

Cognos Connection.

What is Cognos Connection.

Examine Cognos Connection UI elements.

Create a URL, Login, Logoff.

Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties.


Public and Private Folder.

Open reports with Report Name, Go to Links, Run Reports from a View.

Run Reports.

Prompt Pages, Printing a report and Open in Excel.

View the run history of a report and Historical Reports.

Closing and Creating Quick links to Reports.

My Folder Shortcut and Browser Bookmark.

Personalize Cognos Connection.


Export of Cognos, Content Store or select items for Backups.

Restore an exported Backup.

Create and Customize a Page and share a single page with Multiple Users.

Cognos Query Studio.

Introduction to Query Studio.

Create Reports (List, Grouped List, Crosstab, Charts).

Changing the Appearance of Reports (Format).

Sorting and Grouping.

Filters and Prompts.

Subtotals and Calculations.

Run and Manage Reports.

Drill Through reports.

Cognos Analysis Studio.

Introduction to Analysis Studio.

Creating a Basic

Working with data in Crosstab.

Exploring Data.

Limiting Data.

Calculating Data.

Sharing Data.

Cognos Report Studio.

Introduction to Report Studio.

Report Studio User Interface.

Creating, Save and Run Reports.

Report Templates.

Managing Reports.

Types of Reports.

List Reports.

Crosstab Reports.


Formatting a Report.

Report Layout Guidelines.

Fonts, Styles, Header, Footer and Borders.

Insert objects.

Swap Columns and Rows.

Working with Data.

Filters, Parameters and Prompts.

Sorting and Grouping.

Subtotals and Calculations.

Working with Queries.

Working with Reports.

Managing changes in the Package.

Conditional Formatting.

Drill through Reports.

Drill up/Drill down Reports.

Master-Detail Reports.

Scheduling Reports

Cognos Event Studio.

Introduction to Event Studio.

Studio User Interface.

Creating, Save and Run Agents.

Create agents.

Different tasks.

Task Execution rules.

Cognos Metric Studio.

Introduction to Metric Studio.

Cognos Power Play Transformer (Power Cube Modeling).


What is Cognos Transformer.

Understanding Power Play Data Sources.

Starting and Navigating Transformer.

Importing your source Data.

Creating your Power Cube.

Building the Time Dimension.

Create the Time Dimension Manually.

Building a Transformer Model.

Performance Considerations.

Build Model with AutoDesign.

Modify Property sheets for Dimensions, Levels and Categories.

Build Model without AutoDesign-Create New Dimensions from Source Data.

Creating Exception Dimensions from Source Data.

Specify a Level Label.

MicroStrategy 9.x:

MicroStrategy Administrator.

MicroStrategy Architect.

MicroStrategy Desktop.

MicroStrategy Intelligence Server.

MicroStrategy Office.

MicroStrategy Report Services.

MicroStrategy Web.

Data Warehouse Concept.

Differences between Transactional and Warehoused Data.

Data Warehouse Architecture.

Logical & Physical Design.

Difference between Data Warehouse & Data Mart.

Source Data, Staging Data & Target Data.

Operational Data Sources (ODS).


Star Schema, Star FLAKE Schema & Snow Flake Schema.

Normalization and De-normalization.

Meta Data & Data Mining.

Introduction to MicroStrategy Business Intelligence.

The MicroStrategy Platform.

MicroStrategy Reporting Terminology.

Versions of MicroStrategy Web and Introduction to the MicroStrategy Web Interface.

Executing Reports and Documents.

Basic Report Manipulators in MicroStrategy Web.

Overview of Report Services.

Project Design Essentials.

Designing the Local Data Model.

Designing the Data Warehouse Schema.

Creating a Project in MicroStrategy Architect.

Working with Tables.

Working with Facts.

Working with Attributes.

Working with User Hierarchies.

Introduction to the Architect Graphical Interface.

Reporting Essentials Online.

Introduction to MicroStrategy Business Intelligence.

Introduction to MicroStrategy Desktop.

Reports in Desktop.

Report Manipulators in Desktop.



MicroStrategy OLAP Services in Desktop.

Prompts and Searches MicroStrategy Tutorial.

Report Developer Tools and Project Preferences.

Document Essentials Online.

Introduction to Report Services.

Creating Documents.

Document Basics.

Document Design Concepts.

Documents and MicroStrategy OLAP Services.

Document Design Methodology.

Useful Design Techniques.

Linking from Documents.

Multiple Dataset Considerations.

Document Performance Considerations.

Advanced Reporting Online.

Introduction to Advanced Reporting.

Advanced Metrics.

Advanced Filters.

Consolidations and Custom Groups.

Advanced OLAP Services.

Derived Elements.

Report Data Options.

Drill Maps.

Report Developer Tools.

MicroStrategy Tutorial.

Dynamic Dashboards Online.

Introduction to Dashboards.

Creating Dynamic Dashboards.

Flash Mode and Widgets.

Designing Multipanel Dashboards.

Graphs in Documents Widgets II.

Document Performance Considerations.

Freeform SQL Essentials Online.

Introduction to Freeform SQL Reporting.

Creating Freeform SQL Reports.

Prompts in Freeform SQL Reports.

Advanced Topics for Freeform SQL Reports.

MicroStrategy Office Essentials Online.

Introduction to MicroStrategy Office.

Using MicroStrategy Office.

Using Advanced Features of MicroStrategy Office.

Microstrategy Mobile.

Microstrategy Big data analytics training.


OBIEE Overview

OBIEE Architecture


OBIEE 11 BI Services.

OBIEE Weblogic Admin.

OBIEE Repository (.rpd).

Data Sources.

OBIEE Components.

OBIEE Administration Tool.

OBIEE Analysis.

Intelligence Dashboards.

BI Publisher-BI Agents/Actions-KPI/Scorecard.

BI Office.

Repository Basics.

Oracle Business Analysis Warehouse.

Weblogic Server.

Enterprise Manager.

Sample Request Processing.

Using the OracleBI Administration Tool.

Repository Directory.

Repository Files ( Initialization files and log files).

Loading a repository into Oracle BI Server memory.

Creating a repository.

Connection Pool.

Repository Modes ( ONLINE and OFFLINE ).

Physical Layer.

Business Model & Mapping Layer.

Presentation Layer.

Presentation Catalogs, Folders and Columns.

Error Messages.

Building the Physical Layer of a Repository.

Defining an ODBC System DSN.

Setting up connection pool properties.

Importing data sources ( Physical Schema ).

Verifying the import.

Defining physical keys and joins.

Creating alias and select tables.

Building the Business Model and Mapping Layer of a Repository.

Creating the logical business model.

Creating the logical tables, columns, and sources.

Defining logical joins.

Adding Calculation to a Fact Table.

Building measures.

Building the Presentation Layer of a Repository.

Creating a new Presentation Catalog.

Modifying Presentation layer objects.

Rename tables.

Reorder Table.

Testing and Validating a Repository.

Checking repository consistency.

Defining a repository in the initialization file.

Testing a repository using Oracle BI Answers.

Adding Multiple Logical Table Sources.

Adding multiple logical table sources to a logical table.

Specifying logical content.

Adding Calculations to a Fact Table.

Creating new calculation measures based on existing logical columns.

Creating new calculation measures based on physical columns.

Creating new calculation measures using the Calculation Wizard.

Creating Dimension Hierarchies and Level-Based Measures.

Creating dimension hierarchies.

Creating level.

Based measures.

Creating & Using Aggregates.

Purpose of aggregate tables in dimensional modeling.

Modeling aggregate tables to improve query performance.

Testing aggregate navigation.

Using Initialization Blocks Repository Variables.

Creating Dynamic Repository Variables.

Execute Direct Database Requests.

Accessing database directly.

Creating Time series Measures.

Using time comparisons in business analysis.

Using Oracle BI time series functions to model time series data.

BI Analysis and Dash board & Publisher.

Creating and Editing Analysis.

Creating Interactive Dashboards using Analysis.

Creating query and chart.

Working with Filters.

Working with Pivot Table.

Building Views and Charts in Requests.

Creating and Configuring Interactive Dashboards.

Creating and Configuring Dashboard Prompts.

Configuring Action Links.

Creating and understanding KPI,KPI Watchlists and Scorecards.

Oracle BI for MS Office.

Sending Alerts Using Delivers.

Using Job Manager.


Database Concepts.

Data warehousing concepts.

SAS Concepts.

SAS Modules.

Resume Preparation.

Career Guidance.

Certification Guidance.

Case Studies.

Project Work.

SAS Variables and Attribute.

Creating Libraries.

Styles of Input.

Reporting & Dataset Option.

Conditional Statement.

Infile Statement.

SAS Input Methods.

SAS Formats.

PDV SAS/Base SAS/Connect SAS/Macros SAS/Access SAS/Stat SAS/Graph SAS/SQL.

SAS System Basics.

Accessing the SAS System.

Navigating through the SAS windows including the editor, log, and output windows Creating and executing SAS programs in batch and interactive mode.

Understanding errors in the SAS log.

Exploring program output.

Understanding SAS data set and library structure.

Creating DATA and PROC steps.

Understanding SAS syntax and SAS naming conventions.

Working with temporary and permanent SAS data sets.

Creating Reports

Using the REPORT Procedure.

Creating reports in a WYSIWYG interactive environment without code-Creating reports in a batch environment with code and NOWD.

Using COLUMN, DEFINE, and COMPUTE statements for structure.

Using ODS to generate HTML, RTF and XML reports.

Using Report options such as WIDTH=, FORMAT=, DISPLAY, GROUP, HEADLINEand HEADSKIP.

Summarizing and sorting reports.

Adding titles, footnotes and labels to reports.

Using the PRINT procedure.

Selecting report columns with the VAR statement.

Grouping reports with the BY statement.

Summing report columns with the SUM statement.

Producing frequency tables using the FREQ procedure.

Creating Graphs

Producing vertical and horizontal bar charts with the GCHART procedure, VBAR and HBAR statements.

Understanding chart variables.

Using RUN.

group processing for multiple graphs in the same session.

Understanding options to tailor graphs, such as DISCRETE, SUMVAR=, and TYPE=

Reading SAS Data Sets

Reading data sets with the SET statement.

Restricting data set size by selecting variables with DROP= and KEEP= options-Using IF-THEN/ELSE logic processing.

Understanding the difference between subsetting IF and WHERE clause processing-to restrict observations.

Creating SAS Data Sets

Reading raw data using list, column and pointer input.

Naming variables.

Understanding how to read any type of data using SAS informats.

Using INFILE and INPUT statements to read raw data.

Examining the structure of a SAS data set and its variables attributes using the CONTENTS procedure.

Creating new variables using SAS functions and assignment statements.

Recoding and Reorganizing Data

Using SAS formats to recode data values for better presentation in reports and analyses.

Using the FORMAT procedure to create user defined value labels.

Reordering rows of data with the SORT procedure

Summarizing Your Data.

Calculating descriptive statistics with the MEANS and SUMMARY procedures.

Grouping data using the CLASS statement.

Analyzing data values using the VAR statement and appropriate functions such as-SUM, MEAN, MEDIAN and more.

Generating one-way and multi-way frequency tables using the FREQ procedure.

Using the TABLES statement in the FREQ procedure to specify analysis structure.

Combining SAS Data Sets.

Concatenating SAS data sets using the SET statement.

Merging multiple SAS data sets on common key variables.

Using the SQL procedure.

Comparing methods of merging (joining) data sets.

Programming II: Data Manipulation Using The Data Step

Understanding The Data Step

Understanding the difference between compile and execute phases of the Data Step.

Learning about Data Step storage areas.

Reading and creating multiple SAS data sets.

How to Debug Your Program

Learning to Dump the Input Buffer and Program Data Vector with the PUT statement.

Using the interactive debugger to understand program logic problems-

Reading External Data Types and Creating Flat File Basics

Reading flat files using delimiters.

Reading data from a relational database.

Creating user defined informats for special data.

Creating flat files in SAS-

Creating New Variables and Adding Value to Your Data

Cleaning existing data.

Assigning new character, numeric and date variables.

Using Picture Statements to create user defined formats.

Combining Data Files Using a Match Merging and Interleaving

Match Merging multiple SAS data sets together.

Interleaving SAS data sets with the SET statement.

Changing variable types using the PUT and INPUT functions Summarizing Data.


Summarizing data in the data step using Sum and Retain statements.

Creating group totals with First and Last processing.

Creating summary data sets with Proc Summary.

Selecting specification summarization hierarchies using the _TYPE_ variable.

Perform Iterative Processing on Data

Using DO loops for repetitive calculations and processing.

Using Arrays to process across an observation.

Using DO WHILE and DO UNTIL statements for conditional looping.

Creating a simple random sample.

Producing Exception Reports

Using a WHERE statement to subset data.

Using a contribution option to perform table lookups when merging files.

Identifying duplicate rows of data in a file.

SQLServer Analysis Services / Reporting Services


Building and Modifying an OLAP Cube

Designing a Unified Dimension Model (UDM)

Identifying measures and their suitable granularities.

Adding new measure groups and creating custom measures

Creating dimensions

Implementing a Star and Snowflake Schema.

Managing Slow Changing Dimensions (SCD).

Identifying role.

Play dimensions

Extending the Cube with Hierarchies

Creating hierarchies

Building natural hierarchies.

Many to many hierarchies.

Creating attribute relationships.

Distinguishing between ragged, balanced and unbalanced hierarchies.

Discretizing attribute values with the Clusters and Equal Areas algorithms.

Parent-child relationships.

Defining parent and key attributes.

Generating level captions with the Naming Template feature.

Removing repeated entries with the MembersWithData property

Exploiting Advanced Dimension Relationships.

Storing dimension data in fact tables.

Building a degenerate dimension.

Configuring fact relationships.

Saving space with referenced dimension relationships

Identifying candidates for referenced relationships.

Utilizing the Dimension Usage tab to configure referenced relationships.

Including dimensions with many-to-many relationships.

Implementing intermediate measure groups and dimensions.

Reporting on many to many dimensions without double counting.

Designing Optimal Cubes.

Assembling cube components.

Selecting the appropriate fact tables.

Adding cube dimensions.

Distinguishing between additive, semiadditive and nonadditive measures.

Designing storage and aggregations.

Choosing between ROLAP, MOLAP and HOLAP.

Partitioning cubes for improved performance.

Designing aggregations with the Aggregation Design Wizard.

Leveraging the Usage-Based Optimization Wizard.

Automating processing.

Exploiting XMLA scripts and SSIS.

Refreshing cubes with Proactive Caching.

Performing Advanced Analysis with MDX.

Retrieving data with MDX.

Defining tuples, sets and calculated members.

Querying cubes with MDX.

Navigating hierarchies with MDX and utilizing set functions.

Monitoring business performance with KPIs

Building goal, status and trend expressions.

Using PARALLELPERIOD to compare with past time periods.

Creating calculations with MDX.

Adding runtime calculations to the cube.

Comparing MDX calculations with DSV calculated columns.

Securing Cube Data.

Securing data and simplifying the user interface.

Distinguishing between perspective feature and security.

Creating roles for administrative privileges.

Securing dimension data.

Implementing cell level security.

Gaining Business Advantage with Data Mining.

Determining the correct model.

Identifying business tasks for data mining.

Training and testing data mining algorithms.

Comparing algorithms with the accuracy chart and classification matrix.

Optimizing returns with the Profit Chart.

Performing real-world predictions.

Classifying with the Decision Trees, Neural Network and Naive Bayes algorithms.

Predicting with the Time Series algorithm.

Deploying models.

Predicting new cases with algorithms.

Utilizing DMX to perform batch and singleton predictions.

Exploring results with data mining viewers.


Introduction to SQL Server 2008 Reporting Services.

Identifying deployment: native, integrated or single server.

Managing Web farm deployment with/without SharePoint.

Developing Reports.

Designing fundamental reports.

Connecting to relational and multidimensional data sources.

Generating a Tablix reporting structure.

Building an interactive chart.

Creating reports with richly formatted text.

Composing expressions.

Computing custom fields.

Managing built in collections.

Linking expressions to properties.

Employing conditional formatting.

Arranging and sorting data.

Multiple level grouping and categorizing the results.

Applying aggregate functions.

Producing various outputs from a Tablix.

Creating parallel dynamic group report formats.

Combining dynamic and static columns.

Integrating Parameters and Filters.

Incorporating parameters into reports.

Yielding subsets of data with query parameters.

Aligning report parameters to query parameters.

Constructing cascading report parameters.

Transmitting parameters to stored procedures.

Handling multivalued parameters.

Applying filters to report data

Augmenting performance with filters.

Determining filters vs. query parameters.

Implementing Interactive Features.

Combining multiple data regions in one report.

Applying sequential and nested regions.

Creating master/detail reports and linking subreports.

Executing advanced data visualizations.

Applying the radial and linear gauge.

Customizing charts with scale breaks.

Charting KPIs from Analysis Services

Showing robust data with relevant detail.

Drilling through report detail and drilling down report data.

Navigating reports with document maps.

Reporting with hierarchical rows and dynamic headers.

Deploying and Delivering Reports.

Deploying reports to the server.

Publishing reports and configuring project properties.

Verifying results with Report Manager.

Identifying delivery options.

Electing on demand or via subscription.

Enhancing performance with cached instances and snapshots.

Configuring snapshot history.

Formatting different outputs.

Dispatching subscription reports

Publishing reports via e-mail and fileshare.

Seamlessly delivering reports by data driven subscriptions.

Integrating reports with SharePoint.

Deploying reports to SharePoint.

Viewing results in Report Center and Data Connections libraries.

Safeguarding Reporting Services.

Structuring content security.

Leveraging existing Windows authentication.

Establishing permission levels on report items.

Ensuring the RS system.

Instituting varying levels of administrative roles.

Allowing and withdrawing system.

level permissions.

Empowering Users with Ad Hoc Reporting.

Designing models for users.

Building personalized reports with Model Designer.

Defining data source views.

Creating and refining models.

Designing reports with Report Builder.

Launching Report Builder to users across the enterprise.

Dragging and dropping entities onto charts and tabular reports.

Exploiting Analysis Services cubes as report models.

Delivering Reports to Users.

Accessing and controlling reports using URLs.

Leveraging RS Web services.

Embedding reports in applications with the Report Viewer.

Delivering reports through SharePoint.

Essbase Overview.

Multidimensional Analysis.

Oracle’s Enterprise Performance Management System.

Essbase Production Environment Components.

Designing Applications and Databases.

Essbase Implementation Process.

Analyzing and Planning Implementations.

Creating Applications and Databases.

Creating Outlines.

Designing Data Descriptor Dimensions.

Data Descriptor Dimensions Overview.

Designing Time Dimensions.

Designing Scenario Dimensions.

Outline Calculations.

Designing Accounts Dimensions.

Testing Outline Calculations.

Optimizing Data Descriptor Dimensions.

Creating Member Aliases.

Dimension Types.

Creating Period to Date.


Dynamic Calc Members.

Enhancing Accounts Dimensions.

Optimizing Data Storage.

Developing Dimension Designs.

Business View Dimensions Overview.

Attributes in Database Design.

Combining Business Views.

Developing Label Outlines.

Creating Basic Dimension Build Rules Files.

Rules Files Overview.

Creating Dimension Build Rules Files.

Configuring Dimension Maintenance Settings.

Creating Advanced Dimension Build Rules Files.

Advanced Dimension Build Rules Files Overview.

Creating Shared Members.

Manipulating Fields.

Creating User.

Defined Attributes.

Creating Attribute Dimensions with Rules Files.

Loading Data.

Data Load Overview.

Creating Data Load Rules Files.

Selecting and Rejecting Records.

Capturing New Members.

Getting Started with Smart View.

Navigating Smart View.

Connecting to Data Sources.

Creating Ad Hoc Grids.

Setting the Point of View.

Associating Data Sources with Worksheets.

Creating Free.

Form Grids.

Creating Reports with Smart View.

Updating Essbase Data Integrating,Essbase Data with Microsoft Office.

Creating Shared Database Perspectives.

Creating Custom Reports.

Data Storage and Calculation.

Calculation Overview.

Database Calculation Order.

Data Block Fundamentals.

Data Blocks and the Index System.

Interpreting Database Statistics.

Data Block Creation.

Database Calculation Process

Creating Calculation Scripts.

Calculation Script Organization.

Returning Correct Calculation Results.

Troubleshooting CALC DIM Processes.

Controlling the Calculation Process.

Top Down Calculation.

Focusing Calculations with FIX Statements.

Calculating Conditionally with IF Statements.

Performance Considerations.

Referencing Members in Calculations.

Referencing Members Explicitly.

Referencing Members Dynamically.

Creating Calculation Variables.

Developing and Testing Complex Calculation Scripts.

Implementing a Script Development Process.


Level Data Loads.

Intelligent Calculation.

Normalizing Data.

Allocating Data.

Planning Data Normalization.

Normalizing Rates and Drivers.

Copying and Clearing Data.

Creating Attribute Dimensions.

Attribute Dimensions Overview.

Adding Attribute Dimensions to Outlines.

Design Considerations.

Analyzing Varying Attributes.

Varying Attributes Overview.

Creating Varying Attributes.

Viewing Varying Attribute Data.

Analyzing Text and Dates.

Typed Measures Overview.

Enabling Typed Measures.

Creating Text Measures.

Creating Date Measures.

Viewing Typed Measures.

Calculations Based on Typed Measures.

Hyperion Planning

Data warehousing concepts.

Hyperion Components.

Hyperion EPM 11.1.1 Overview.

Planning Architecture,Budgeting & Forecasting.

Create & Manage Application.

Importing & Exporting Native Directory Data.

Setting up Security.

Setting up Audit trails.

Creating Data Forms.

Managing User /Global Variables.

Business Rules & Roles.

Launching a Business Rules.

Managing Budget Process.

Planning Units.

Creating Task Lists.

Using Flow Diagrams.

Hyperion Planning Adapter.

Flat File Adapter.

Hyperion Planning Application Setup.

Enterprise Performance Architect Modulus(EPMA).


Accessing PMA.

Financial Reporting.

FR Components.

Steps to Share Report.

Smart View.

Steps to establish DS Connection.

Calculate data in Smart view.

Working Offline.

Taking Data Form Off Line.

Hyperion Financial Management

Data warehousing concepts.


Hyperion FM Dimension.

Managing Application.

Defining Calendars.

Creating Applications.

Monitoring Running Tasks.

Creating Security Classes.

Creating Appln Security files.

Managing Metadata.

Define Entity/Scenario Members.

Define Appln Setting-Setting up Intercompany Partner.

Creating Data Grid-Journal.

Entries in Accounting.

Calculating Account Balances.

Balance Sheet & Income Stmt.

Managing Data Formsr.

Defining Reports.

Managing Rules.

HFM Objects.

Rule Function.

Plug Accounts.

Consolidating Data & Process.

Automating Tasks.

Creating Task Flow.

Budgeting & Forecasting.

Financial Reporting Components.

Create Batch & Schedule Report.

smart View.

Establish Data Source Connection.


Overview of Jaspersoft BI Suite.

Jaspersoft BI Suite components.

Understanding report life cycle.

Jaspersoft BI Suite components.


Understanding the report cycle.

Navigating iReport.

Datasets and Data sources.

Report structure.

Using Report elements.

Creating expressions.

Working with SQL queries.

Performing calculations.

Using styles and fonts.

Incorporating subdatasets.

Exporting and previewing reports.

Handling errors.

Internationalizing reports.

Configuring iReport.

JasperServer for Developers.

Understanding the repository.

Creating Ad Hoc Topics and Domains.

Security and multi tenancy Building JasperServer source with BuildSource-Extending JasperServer functionality.

Installing and upgrading.


Introduction to JasperETL environment.

Overview of ETL components.

Understanding of ETL job, its elements and execution options.


Data warehourse overview.

Navigating JasperAnalysis.

Using the Jsper Workbench.

Describing OLAP Schemas.

Publishing an OLAP Schema.

Big data Anlaytics training Using R :

Phase I of Data science -Statistics

Phase II of Data science -R

Introduction to Statistics.

Five Number Summary.

The Centre of the Data and the Effects of Extreme Values.

The Spread of the Data.

The Shape of the Data.

Categorical Variables.

Some Features of Data.

Relationships Between Quantitative and Categorical Variables.

Examining Relationships Between Two Categorical Variables.

Relationships Between Two Quantitative Variables.

Data Collection.


Data Collection.

Observational Studies.

Data Collection.


The Need for Probability.

Some Probability Basics.

Probability Distributions.

Long Run Averages.

Sampling Distributions.

Introduction to Confidence Intervals.

Confidence Intervals for Proportions.

Sample Size for Estimating a Proportion.

Confidence Intervals for Means.

Robustness of Confidence Intervals.

Introduction to Statistical Tests.

The Structure of Statistical Tests.

Hypothesis Testing for Proportions.

Hypothesis Testing for Means.

Power and Type I and Type II Errors.

Connection Between Confidence Intervals and Hypothesis Testing.

Matched Pairs.

Comparing Two Proportions.

Comparing Two Means.

The Linear Regression Formula.

Regression Coefficients Residuals and Variances.

Regression Inference and Limitations.

Residual Analysis and Transformations

Phase II of Data science -R


History of R.

Advantages and disadvantages.

Downloading and installing.

How to find documentation.


Using the R console.

Getting help.

Learning about the environment.

Writing and executing scripts.

Saving your work.

Data Structures and Variables.

Variables and assignment.

Data types-Indexing, subsetting.

Viewing data and summaries.


Naming conventions.


Control Flow.

Truth testing.


Looping Vectorized calculations.



Return values.

Variable scope.

Exception Handling.

Getting Data into the R environment.

Builtin data.

Reading local data.

Web data.

Overview of Statistics in R.

Introduction to R Graphics.

Model notation.

Descriptive statistics.

Continuous data.

Scatter plot,Box plot.

Categorical data.

Mosaic plot.


Inferential statistics.

T-test and non-parametric equivalents-Chi-squared test, logistic regression,

Distribution testing.

Power testing.

Linear Regression.

Linear models.

Regression plots.


Other Topics.



Time series.

Dimensionality reduction.

Machine Learning.

Object Oriented R.

Generic functions.

S3/S4 classes.

Installing Packages.

Finding resources.

Installing resources.

More about Graphics.


Exporting graphics.

Sophisticated Graphics in R.



Interactive graphics.

Animated GIF.


R for Mapping and GIS.

Choropleth maps.


BI and Data Warehouse Concepts.

Introduction of Data Warehouse.

Need arise of DWH-OLTP V/S DWH-OLTP V/s OLAP.

Data Warehouse /Data Marts Architecture Staging/without Staging.

Dimensions (Simple and Confirm).

Fact (Simple, fact less, coverage, confirm).

Warehouse Implementation Methods.



Difference between STAR and SNOW FLAKE Schema.

Other terminologies Cleansing, Purging etc..

Database Modeling.

Designing Methods.

Logical Designing.

Physical Designing.

Introduction of Dimension Modeling.

Difference between ER.

Modeling and Dimension Modeling.

Implementation of Dimension Model.

Forward Engineering and Reverse Engineering.

Introduction of various Database Components


QlikView data structures.

Data structures in QlikView (AQL).

Sample Application walkthrough of QlikView..

Architecture and components of QV In memory BI /OLAP.

Loading data from multiple datasources.

Script editing.

Menu Commands and Syntax.


The QWT (Access File example) primary data source.

The QWT (Access File example with QVD Conversion) secondary data files.

Script generation.

Creating a connection to the database.

Reading tables into QlikView.

Big data Analytics.

Connecting of Qlikview with Bigdata hadoop.

Advanced Scripting.

Condition on a field in a table.

Aggregating Data in Script (Resident Load and Group Function, Order By etc).

Joining tables (Left, Right, Inner, Outer Joins).


Sheet Basics.

Sheet Objects.


Calculation and expressions.

Reporting formats.

Server setup.




Day1: Introduction to Tableau 8

What is Tableau?.

Tableau User Interface.

Basic Tableau Design Flow.

Day2: Basic Visualization Design

Show Me! choosing Mark Types color,Size, and Shape Options.

shaped Axis Charts-combination Charts.

Measure Names and Measure Values.

Day3: Data Connection

Connecting to Various Data Sources.

Customizing Your View of the Data.

Sets, Groups, and Hierarchies-Extracting Data.

Data Blending.

Day4: Top 10 Chart

Bar Chart.

Line Chart.

Area Chart.

Text Table/Cross Tab .

Scatter Plot/Bubble Chart.

Bullet Chart.

Box Plot.

Tree Map.

Pie Chart.

world Cloud

Day5: Interacting With the Viewer

Quick Filters.


Worksheet Actions.

Day6: Tableau maps

Geocoded Fields/Custom Geocoding.

Background Map Options.

Custom Background Images.

Day7: Calculated Fields, Table Calculations, and Statistics

Creating Custom Calculations.

Simple and Advanced Table Calculations.

Using Table Calculations Functions in Custom Calculations.

Reference Lines, Bands, and Distribution.

Trend Lines.

Day8: Creating Dashboards

Organizing Worksheets.

Containers, Images, Text, and Web Pages.

Dashboard Actions.

Day9: Distributing and Sharing Your Dashboards

Exporting Worksheets and Dashboards.

Publishing to Tableau Server.

Creating Tableau Server User Filters.

Smartphones and Tablets with iOS and Android.

Calculation Function and Operator Reference