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.
Understand classes and objects.
Creating classes and 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.
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.
Linked universe concept.
Creating links between universes.
Universe Access Restrictions.
Setting access restrictions on a universe.
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.
Designing Web Intelligence Reports.
Working with Web Intelligence documents.
Displaying data in tables and charts.
Working with tables.
Presenting data in free.
Presenting data in charts.
Various features of WebI in Reports.
Formatting breaks and cross tabs.
Ranking data t.
see top or bottom values.
Tracking data changes.
Using alerters t.
Organizing a report int.
Copying data t.
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 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.
Install Database (MS SQL).
Install Framework Manager.
Install Cognos BI Application.
Setting up the Environment.
Setting up Samples in 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.
Importing Metadata from one and more 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.
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.
Create or Modify Package.
Controlling access to Metadata.
Guideline for Modeling Metadata.
Presentation and Database layers.
Perform Calculations and Filters.
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.
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.
Cognos Report Studio.
Introduction to Report Studio.
Report Studio User Interface.
Creating, Save and Run Reports.
Types of Reports.
Formatting a Report.
Report Layout Guidelines.
Fonts, Styles, Header, Footer and Borders.
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.
Drill through Reports.
Drill up/Drill down Reports.
Cognos Event Studio.
Introduction to Event Studio.
Studio User Interface.
Creating, Save and Run Agents.
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.
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 Intelligence Server.
MicroStrategy Report Services.
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).
OLA, ROLAP & MOLAP.
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.
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.
Consolidations and Custom Groups.
Advanced OLAP Services.
Report Data Options.
Report Developer Tools.
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 Big data analytics training.
OBIEE 11 BI Services.
OBIEE Weblogic Admin.
OBIEE Repository (.rpd).
OBIEE Administration Tool.
BI Publisher-BI Agents/Actions-KPI/Scorecard.
Oracle Business Analysis Warehouse.
Sample Request Processing.
Using the OracleBI Administration Tool.
Repository Files ( Initialization files and log files).
Loading a repository into Oracle BI Server memory.
Creating a repository.
Repository Modes ( ONLINE and OFFLINE ).
Business Model & Mapping Layer.
Presentation Catalogs, Folders and Columns.
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 the Presentation Layer of a Repository.
Creating a new Presentation Catalog.
Modifying Presentation layer objects.
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 & 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.
Data warehousing concepts.
SAS Variables and Attribute.
Styles of Input.
Reporting & Dataset Option.
SAS Input Methods.
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.
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.
Producing vertical and horizontal bar charts with the GCHART procedure, VBAR and HBAR statements.
Understanding chart variables.
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.
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
Implementing a Star and Snowflake Schema.
Managing Slow Changing Dimensions (SCD).
Extending the Cube with 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.
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.
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.
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.
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.
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.
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.
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.
Designing Data Descriptor Dimensions.
Data Descriptor Dimensions Overview.
Designing Time Dimensions.
Designing Scenario Dimensions.
Designing Accounts Dimensions.
Testing Outline Calculations.
Optimizing Data Descriptor Dimensions.
Creating Member Aliases.
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.
Creating Attribute Dimensions with Rules Files.
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 Reports with Smart View.
Updating Essbase Data Integrating,Essbase Data with Microsoft Office.
Creating Shared Database Perspectives.
Creating Custom Reports.
Data Storage and Calculation.
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.
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.
Planning Data Normalization.
Normalizing Rates and Drivers.
Copying and Clearing Data.
Creating Attribute Dimensions.
Attribute Dimensions Overview.
Adding Attribute Dimensions to Outlines.
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.
Data warehousing concepts.
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.
Creating Task Lists.
Using Flow Diagrams.
Hyperion Planning Adapter.
Flat File Adapter.
Hyperion Planning Application Setup.
Enterprise Performance Architect Modulus(EPMA).
Steps to Share Report.
Steps to establish DS Connection.
Calculate data in Smart view.
Taking Data Form Off Line.
Hyperion Financial Management
Data warehousing concepts.
Hyperion FM Dimension.
Monitoring Running Tasks.
Creating Security Classes.
Creating Appln Security files.
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.
Consolidating Data & Process.
Creating Task Flow.
Budgeting & Forecasting.
Financial Reporting Components.
Create Batch & Schedule Report.
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.
Datasets and Data sources.
Using Report elements.
Working with SQL queries.
Using styles and fonts.
Exporting and previewing reports.
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.
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.
Some Features of Data.
Relationships Between Quantitative and Categorical Variables.
Examining Relationships Between Two Categorical Variables.
Relationships Between Two Quantitative Variables.
The Need for Probability.
Some Probability Basics.
Long Run Averages.
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.
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.
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.
Looping Vectorized calculations.
Getting Data into the R environment.
Reading local data.
Overview of Statistics in R.
Introduction to R Graphics.
Scatter plot,Box plot.
T-test and non-parametric equivalents-Chi-squared test, logistic regression,
Object Oriented R.
More about Graphics.
Sophisticated Graphics in R.
R for Mapping and GIS.
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.
SNOW FLAKE SCHEMA.
Difference between STAR and SNOW FLAKE Schema.
Other terminologies Cleansing, Purging etc..
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.
Menu Commands and Syntax.
Handling DATA SOURCE FILES.
The QWT (Access File example) primary data source.
The QWT (Access File example with QVD Conversion) secondary data files.
Creating a connection to the database.
Reading tables into QlikView.
Big data Analytics.
Connecting of Qlikview with Bigdata hadoop.
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).
Calculation and expressions.
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.
Day4: Top 10 Chart
Text Table/Cross Tab .
Scatter Plot/Bubble Chart.
Day5: Interacting With the Viewer
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.
Day8: Creating Dashboards
Containers, Images, Text, and Web Pages.
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