Learning about error rows configuration, package logging, defining package configuration, understanding constraints and event handlers.
Reports and Authenticity
Understanding Report Cache, Authorization, Authentication and Report Snapshot, learning about Subscriptions and Site Security.
MSBI SSAS Course Content
Getting started with SSAS
Understanding the concept of multidimensional analysis, understanding SSAS Architecture and benefits, learn what is Cube, working with Tables and OLAP databases, understanding the concept of Data Sources, working with Dimension Wizard, understanding Dimension Structure, Attribute Relationships, flexible and rigid relationship.
Structures and Processes
Learning about Process Dimension, the Process database, creation of Cube, understanding Cube Structure, Cube browsing, defining the various categories, Product Key and Customer Key, Column Naming, processing and deploying a Cube, Report creation with a Cube.Hands-on Exercise – Create a Cube and name various columns Deploy a cube after applying keys and other rules Create reports with a cube
Type of Database Relationship
Understanding Data Dimensions and its importance, the various relationships, regular, referenced, many to many, fact, working on Data Partitions, and Data Aggregations.
Learning about SSAS Cube, the various types of Cubes, the scope of Cube and comparison with Data Warehouse.
Cube: Operations & Limitations
The various operations on Cube, the limitations of OLAP Cubes, the architecture of in-memory analytics and its advantages.
Cube and In-memory Analytics
Deploying cube with existing data warehouse capabilities to get self-service business intelligence, understanding how in-memory analytics works.Hands-on Exercise – Deploy cube to get self-service business intelligence
Data Source View
Logical model of the schema used by the Cube, components of Cube, understanding Named Queries and Relationships.
An overview of the Dimensions concept, describing the Attributes and Attributes Hierarchies, understanding Key/Value Pairs, Metadata Reload, logical keys and role-based dimensions.Hands-on Exercise – Create role based dimensions, Use Attributes Hierarchies
Measures & Features of Cube
Understanding the Measure of Cube, analyzing the Measure, exploring the relationship between Measure and Measure Group, Cube features and Dimension usage.
Measures and Features of Cube Cont.
Working with Cube Measures, deploying analytics, understanding the Key Performance Indicators, deploying actions and drill-through actions on data, working on data partitions, aggregations, translations and perspectives.Hands-on Exercise – Work with Cube Measures, Deploy analytics, Deploy actions and drill-through actions on data, Make data partitions
Working with MDX
Understanding Multidimensional Expressions language, working with MDX queries for data retrieval, working with Clause, Set, Tuple, Filter condition in MDX.Hands-on Exercise – Apply Clause, Set and filter condition in MDX query to retrieve data
Functions of MDX
Learning about MDX hierarchies, the functions used in MDX, Ancestor, Ascendant and Descendant function, performing data orderingHands-on Exercise – Create MDX hierarchies, Perform data ordering in ascending order, in descending order
Data Analysis Expressions (DAX), Using the EVALUATE and CALCULATE functions, filter DAX queries, create calculated measures, perform data analysis by using DAXHands-on Exercise – Use the EVALUATE and CALCULATE functions, filter DAX queries, create calculated measures, perform data analysis by using DAX
BI Semantic Model
Designing and publishing a tabular data model, Designing measures relationships, hierarchies, partitions, perspectives, and calculated columnsHands-on Exercise – Design and publish a tabular data model, Design measures relationships, hierarchies, partitions, perspectives, and calculated columns
Plan and deploy SSAS
Configuring and maintaining SQL Server Analysis Services (SSAS), Non-Union Memory Architecture (NUMA), Monitoring and optimizing performanceHands-on Exercise – Configure and maintain SQL Server Analysis Services (SSAS), Monitor and optimize performance
Analyzing Big Data with Microsoft R
Reading data with R Server from SAS, txt, or excel formats, converting data to XDF format; Summarizing data, rxCrossTabs versus rxCube, extracting quantiles by using rxQuantile; Visualizing data (rxSummary and rxCube, rxHistogram and rxLinePlot) Processing data with rxDataStep Performing transforms using functions transformVars and transformEnvir Processing text using RML packages Building predictive models with ScaleR Performing in-database analytics by using SQL ServerHands-on Exercise – Read data with R Server from SAS, txt or excel formats, convert data to XDF format; Summarize data, Extract quantiles by using rxQuantile; Visualize data (rxSummary, rxCube, rxHistogram and rxLinePlot) Perform transforms using functions transformVars and transformEnvir Build predictive models with ScaleR Perform in-database analytics by using SQL Server
Informatica Course Content
Data Warehousing and Cleansing Concepts
Introduction to data warehousing, what is ETL, and overview of data cleansing, data scrubbing, data aggregation, learn what is Informatica PowerCenter ETL.
Informatica Installation and Configuration
Overview of Informatica configuration, Integration Services, Installation of Informatica, operational administration activities.Hands-on Exercise – Install PowerCenter
Working with active and passive transformation
Learn what is active and passive transformation and the differences between the two.
Working with expression transformation
Learning about expression transformation, connected passive transformation to calculate value on a single row.Hands-on Exercise – Calculate value on a single row using connected passive transformation
Working with Sorter, Sequence Generator, Filter transformation
The different types of transformations like Sorter, Sequence Generator and Filter, the characteristics of each and where they are used.Hands-on Exercise – Transform data using Filter technique, Use a sequence generator, Use a Sorter
Working with Joiner Transformation
Joiner transformation to bring data from heterogeneous data sources.Hands-on Exercise – Use Joiner transformation to bring data from heterogeneous data sources
Working with Ranking and Union Transformation
Understanding the Ranking and Union transformation, the characteristics and deployment.Hands-on Exercise – Perform Ranking and Union transformation
Syntax for Rank and Dense Rank
Learn about the rank and dense rank functions and the syntax for them.Hands-on Exercise – Perform rank and dense rank functions
Understanding how router transformation works and its key features.Hands-on Exercise – Perform router transformation
Source Qualifier Transformation and Mappings
Lookup transformation Overview and different types of lookup transformation:Connected, unconnected, Dynamic and StaticHands-on Exercise – Perform Lookup transformation: Connected, unconnected, Dynamic and Static
Slowly Changing Dimension in Informatica
What is SCD?,processing in xml, learn how to handle flat file, list and define various transformations, implementing ‘for loop’ in power center, concepts of pushdown optimization and partitioning, what is constraint based loading?, what is incremental aggregation?Hands-on Exercise – Load data from a flat file,Implement ‘for loop’ in power center, Use pushdown optimization and partitioning, Do constraint based data loading, Use incremental aggregation technique to aggregate data
Mapplet and loading to multiple designer
Different types of designer: Mapplet, Worklet, target load plan, loading to multiple targets, linking propertyHands-on Exercise – Create a mapplet and a worklet, Plan a target load, Load multiple targets
Performance Tuning in Informatica
Objectives of performance tuning, defining performance tuning, learning the sequence for tuningHands-on Exercise – Do performance tuning by following different techniques
Managing repository, repository manager – client tool, functionalities of previous versions, important tasks in repository managerHands-on Exercise – Manage tasks in repository manager
Best Practices in Informatica
Understanding and adopting best practices for managing repository.
Common tasks in workflow manager, creating dependencies, scope of workflow monitorHands-on Exercise – Create workflow with dependencies of nodes
Parameters & Variables
Define variable and parameter in Informatica, parameter files and their scope, parameter of mapping, worklet and session parameter, workflow and service variable, basic development errorsHands-on Exercise – Define variables and parameter in functions, Use parameter of mapping, Use worklet and session parameter, Use workflow and service variable
Error handling and recovery in Informatica
session and workflow log, using debuggers, error handling framework in informatica, failover and high availabilityHands-on Exercise – Debug development errors, Read Workflow logs, Use Error handling framework
High Availability & Failover in Informatica
configurations and mechanisms in recovery, checking health of powercenter environmentHands-on Exercise – Configure recovery options, Check health of Powercenter environment
Working with different utilities in Informatica
infacmd, pmrep, infasetup, processing of flat fileHands-on Exercise – Use commands infacmd, pmrep, infasetup
Flat file processing (advance transformations)
Fixed length and delimited, expression transformations- sequence numbers, dynamic targeting using transaction control.Hands-on Exercise – Perform expression transformations- sequence numbers, dynamic targeting using transaction control.
Dynamic target with use of transaction control, indirect loading.Hands-on Exercise – Use of transaction control with dynamic target, indirect loading.
Working with Java transformations
Importance of Java transformations to extend Power Center capabilities, transforming data, active and passive mode.Hands-on Exercise – Use Java transformations to extend Power Center capabilities
Unconnected Stored Procedure usage
Understanding unconnected stored procedure in Informatica, the different scenarios of unconnected stored procedure usage.Hands-on Exercise – Use unconnected stored procedure in Informatica in different scenarios
Advance Concepts in SCD
Use of SQL transformation (active and passive)Hands-on Exercise – Use of SQL transformation (active and passive)
Incremental Data Loading and Aggregation
Understanding Incremental Loading and aggregation and comparison between them .Hands-on Exercise – Do Incremental Loading and aggregation
Constraint based loading
Working with database constraints using PowerCenter, understanding constraint based loading and target load order.Hands-on Exercise – Perform constraint based loading in a given order
XML Transformation and active look up
The various types of XML transformation in Informatica, configuring a lookup as active.Hands-on Exercise – Perform XML transformation, Configure a lookup as active
Profiling in PowerCenter
Understanding what is data profiling in Informatica, its significance in validating content, ensuring quality and structure of data as per business requirements.Hands-on Exercise – Create data profiling in Informatica and validate the content
Workflow Creation and Deletion
Understanding workflow as a group of instruction/command for integration services, learning how to create and delete workflow in Informatica.Hands-on Exercise – Create and delete workflow in Informatica
Understanding the Database Connection, creating a new database connection in Informatica, the various steps involved.Hands-on Exercise – Create a new database connection in Informatica
Relational Database Tables
Working with relational database tables in Informatica, mapping for loading data from flat files to relational database files.Hands-on Exercise – Create mapping for loading data from flat files to relational database files
Understanding how to deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter.Hands-on Exercise – Deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter.
Connection with Sources
Connecting Informatica PowerCenter with various data sources like Social media channels like Facebook, Twitter, etc.Hands-on Exercise – Connect Informatica PowerCenter with various data sources like Social media channels like Facebook, Twitter, etc.
Push down optimization & Partitioning
Push down optimization for load-balancing on the server for better performance, the various types of partitioning for optimizing performance.Hands-on Exercise – Optimize using Push down technique for load-balancing on the server for better performance, Create various types of partitioning for optimizing performance
Understanding session cache, importance of cache creation with, implementing session cache, calculating cache requirementHands-on Exercise – Implement cache creation with, Work with session cache
Power BI Course Content
Introduction to Power BI
Introduction to Microsoft Power BI, the key features of Power BI workflow, Desktop application, BI service, and file data sources, sourcing data from web (OData, Azure), building dashboard, data visualization, publishing to cloud, DAX data computation, row context, filter context, Analytics Pane, creating columns and measures, data drill down and drill up, creating tables, binned tables, data modeling and relationships, the Power BI components like Power View, Map, Query, Pivot, Power Q & A, understanding advanced visualization.Hands-on Exercise – Demo of building a Power BI dashboard, Source data from web, Publish to cloud, Create power tables
Learning about Power Query for self-service ETL functionalities, introduction to data mashup, working with Excel data, learning about Power BI Personal Gateway, extracting data from files, folders and databases, working with Azure SQL database and database source, connecting to Analysis Services, SaaS functionalities of Power BI.Hands-on Exercise – Connect to a database, Import data from an excel file, Connect to SQL Server, Analysis Service, Connect to Power Query, Connect to SQL Azure, Connect to Hadoop
Power Query for Data Transformation
Installing Power BI, the various requirements and configuration settings, the Power Query, introduction to Query Editor, data transformation – column, row, text, data type, adding & filling columns and number column, column formatting, transpose table, appending, splitting, formatting data, Pivot and UnPivot, Merge Join, relational operators, date, time calculations, working with M functions, lists, records, tables, data types, and generators, Filters & Slicers, Index and Conditional Columns, Summary Tables, writing custom functions and error handling, M advanced data transformations.Hands-on Exercise – Install PowerBI Desktop and configure the settings, Use Query editor, Write a power query, Transpose a table
Power Pivot for Data Modeling and Data Analysis Expression – DAX Queries
Introduction to Power Pivot, learning about the xVelocity engine, advantages of Power Pivot, various versions and relationships, strongly typed datasets, Data Analysis Expressions, Measures, Calculated Members, Row, Filter & Evaluation Context, Context Interactions, Context over Relations, Schema Relations, learning about Table, Information, Logical, Text, Iterator, Table, and Time Intelligence Functions, Cumulative Charts, Calculated Tables, ranking and rank over groups, Power Pivot advanced functionalities, date and time functions, DAX advanced features, embedding Power Pivot in Power BI Desktop.Hands-on Exercise – Create a Power Pivot Apply filters, Use advanced functionalities like date and time functions, Embed Power Pivot in Power BI Desktop, Create DAX queries for calculate column, tables and measures
Data Visualization with Analytics
Deep dive into Power BI data visualization, understanding Power View and Power Map, Power BI Desktop visualization, formatting and customizing visuals, visualization interaction, SandDance visualization, deploying Power View on SharePoint and Excel, top down and bottom up analytics, comparing volume and value-based analytics, working with Power View to create Reports, Charts, Scorecards, and other visually rich formats, categorizing, filtering and sorting data using Power View, Hierarchies, mastering the best practices, Custom Visualization, Authenticate a Power BI web application, Embedding dashboards in applicationsHands-on Exercise – Create a Power View and a Power Map, Format and customize visuals, Deploy Power View on SharePoint and Excel, Implement top-down and bottom-up analytics, Create Power View reports, Charts, Scorecards, Add a custom visual to report, Authenticate a Power BI web application, Embed dashboards in applications, Categorize, filter and sort data using Power View, Create hierarchies, Use date hierarchies, use business hierarchies, resolve hierarchy issues
Power Q & A
Introduction to Power Q & A, intuitive tool to answer tough queries using natural language, getting answers in the form of charts, graphs and data discovery methodologies, ad hoc analytics building, Power Q & A best practices, integrating with SaaS applicationsHands-on Exercise – Write queries using natural language, Get answers in the form of charts, graphs, Build ad hoc analytics, Pin a tile and a range to dashboard
Power BI Desktop & Administration
Getting to understand the Power BI Desktop, aggregating data from multiple data sources, how Power Query works in Power BI Desktop environment, learning about data modeling and data relationships, deploying data gateways, scheduling data refresh, managing groups and row level security, datasets, reports and dashboards, working with calculated measures, Power Pivot on Power BI Desktop ecosystem, mastering data visualization, Power View on Power BI Desktop, creating real world solutions using Power BIHands-on Exercise – Configure security for dashboard Deploy data gateways, Aggregate data from multiple data sources, Schedule data refresh Manage groups and row level security, datasets, reports and dashboards, Work with calculated measures
Data Warehouse Course Content
Introduction to Data Warehouse
Introducing Data Warehouse and Business Intelligence, understanding difference between database and data warehouse, working with ETL tools, SQL parsing.
Architecture of Data Warehouse
Understanding the Data Warehousing Architecture, system used for Reporting and Business Intelligence, understanding OLAP vs. OLTP, introduction to Cubes.
Data Modeling concepts
The various stages from Conceptual Model, Logical Model to Physical Schema, Understanding the Cubes, benefits of Cube, working with OLAP multidimensional Cube, creating Report using a Cube.
Understanding the process of Data Normalization, rules of normalization for first, second and third normal, BCNF, deploying Erwin for generating SQL scripts.
Dimension & Fact Table
The main components of Business Intelligence – Dimensions and Fact Tables, understanding the difference between Fact Tables & Dimensions, understanding Slowly Changing Dimensions in Data Warehousing.
SQL parsing, Cubes & OLAP
SQL parsing, compilation and optimization, understanding types and scope of cubes, Data Warehousing Vs. Cubes, limitations of Cubes and evolution of in-memory analytics.
Erwin Design Layer Architecture
Learning the Erwin model, understanding the Design Layer Architecture, data warehouse modeling, creating and designing user defined domains, managing naming and data type standards.
Forward & Reverse Engineering
Understanding of the forward and reverse engineering, comparison between the two.
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.
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.
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.Hands-on Exercise – Use 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.Hands-on Exercise – Create a Star Schema, Work 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.Hands-on Exercise – Create a Project Source in MicroStrategy, Connect with metadata database, Create public and schema objects
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.Hands-on Exercise – 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.Hands-on Exercise – Create schema objects, Use data warehouse catalog, Create schema tables, Create and edit of Attributes and Facts, Update a Schema
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.Hands-on Exercise – Creating folders, Organize Attributes, Get a structured view of Facts and Attributes, Map attributes depending on the folder in which they are located, Create hierarchies, Navigate to different places using hierarchies
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.Hands-on Exercise – Create basic metrics and level metrics, define metrics using filters
Learning about the step by step process for creating filters and the different options in creating filters.Hands-on Exercise – Create filters and use different available options to change the filters
Understanding the different ways of creation of Prompts and its various uses.Hands-on Exercise – Create different types of Prompts and use them
Learning how to create Search Objects, the usage of Search Objects in Prompts andHands-on Exercise – Create Search Objects, Use search objects in Prompts
The method to creating Consolidation Objects, the significance of them, learning through detailed demonstration, understanding the difference between Consolidation and Custom Groups (Doesn’t belong here. This line is present in Custom Groups also)Hands-on Exercise – Create Consolidation Objects
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.Hands-on Exercise – Create Custom Groups, Generate SQL query in Custom Groups
Understanding Drill Maps creations, its significance, role of hierarchies in drill navigation, detailed demonstration of Drill Maps and Navigation.Hands-on Exercise – Create a Drill Map, Use a map for analysis
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.Hands-on Exercise – Create a 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.Hands-on Exercise – Create and executing a Report command, Create a desgin view, Use a Grid view, Deploy View Filters and Report Editor, Create Reports by using using Filters, Prompts, Sorts, Drill-down and Format
Understanding the MicroStrategy Web Interface, learning about folder structure, Report deployment and other features.Hands-on Exercise – Practice on MicroStrategy Web Interface, Deploy a Report generation
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.Hands-on Exercise – Create a Dashboard using Web Interface
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.Hands-on Exercise – Use MicroStrategy Intelligence Server, Use Reporting, Distribution and Transaction Services, Make Cluster
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.
Learning about the various QlikView products, understanding about the QlikView Desktop, Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.Hands-on Exercise – Practice 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.Hands-on Exercise – 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.Hands-on Exercise – Load data from a database, Generat script, Load a delimited text file, Load data from excel file, Load inline table, generic tables, media content,Include image, Load a web page data
Structuring the Script
Learning to create tabs in the scripts, debugging of scripts, inclusion of variables and comments in the scripts.Hands-on Exercise – Create tabs in the scripts, debug a script, Include 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.Hands-on Exercise – Work with the Table Viewer, the System Table and System fields.
Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.Hands-on Exercise – Use Join, Concatenation
Data Modelling Considerations
The rules of data modeling in QlikView, introduction to circular references, synthetic key tables, resolving synthetic keys and circular references.Hands-on Exercise – Resolve 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.Hands-on Exercise – Create QVD file
Creating a Master Calendar
Creating a master calendar in QlikView, extracting the highest and lowest data, deploying scripts to create variables,