MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


Take me to MyPage
I'm not curious

IT Career Development Platform

IT Career Development, Progression, Coaching, Jobs | MyTechLogy
You are here: Home / IT Courses / IT Course View

Business Intelligence Architect Master Program

Intellipaat

Course Summary

Our Business Intelligence Architect master program lets you gain proficiency in Business Intelligence You will work on real world projects in Informatica, Tableau, MSBI, Pentaho, MS SQL, Data warehousing & Erwin, QlikView, Microstrategy and more. In this program you will cover 8 courses and 16 industry based projects


  • +

    Course Syllabus

    SQL Course Content

    Introduction to SQL

    The various types of databases, introduction to Structured Query Language, distinction between client server and file server databases, understanding SQL Server Management Studio, SQL Table basics, data types and functions, Transaction-SQL, authentication for Windows, Data control language, Identification and Keywords in T-SQL, Drop Table.

    SQL operators

    Introduction to relational databases, basic concepts of relational tables, working with rows and columns, various operators used like logical and relational, domains, constraints, stored procedures, indexes, primary key and foreign key, understanding group functions, unique key.

    Working With SQL –Join,Tables,Variables

    Deep dive into SQL Tables, working with SQL functions, operators and queries, creation of tables, retrieving data from tables, combining rows from tables using Inner, Outer, Cross and Self joins, deploying Operators like Union, Intersect, Except, creation of Temporary Table, Set Operator rules, working with Table variables.

    Deep dive into SQL Functions

    Understanding what SQL functions do, aggregate functions, scalar functions, functions that work on different data sets like numbers, characters & strings, dates, learning Inline SQL functions, general functions and duplicate functions.

    WORKING WITH SUBQUERIES

    Understanding of SQL Subqueries, rules of Subqueries, the statements and operators with which Subqueries can be used, modification of sub queries using set clause, understanding the different types of Subqueries – Where, Insert, Update, Select, Delete, etc., ways to create and view Subqueries.

    SQL Views,Functions,Stored Procedures

    Learning about SQL Views, ways of creating, using, altering, dropping, renaming and modifying Views, understanding Stored Procedures, key benefits of it, working with Stored Procedures, error handling, studying user-defined functions.

    Deep Dive into User-defined Functions

    Detailed study of user-defined functions, various types of UDFs like Scalar, Inline Table Value, multi-statement Table, what are Stored Procedures? when to deploy Stored Procedures? What is Rank Function? Triggers, when to execute Triggers?

    SQL Optimization& Performance

    Detailed understanding of SQL Server Management Studio, learning what is Pivot in Excel and SQL Server, XL path, differentiating between Char, Varchar and NVarchar, working with Indexes, creation of Index, advantages, records grouping, searching, sorting, modifying data, creation of clustered indexes, using index to cover queries, index guidelines and Common Table Expression.

    Oracle PL SQL Course Content

    Introduction to Oracle SQL
    What is RDBMS, Oracle versions, Architecture of Oracle Database Server, Installation of Oracle 12c

    Hands-on Exercise – Install Oracle 12c

    Using DDL Statements to Create and Manage Tables
    Categorize the main database objects, Review the table structure, List the data types that are available for columns, Create a simple table, Explain how constraints are created at the time of table creation, Describe how schema objects work

    Hands-on Exercise – Create a database table Person with two column (Name, Age) with constraint on age not greater than 100, Insert records using insert query

    Retrieving Data Using the SQL SELECT Statement

    List the capabilities of SQL SELECT statements, Execute a basic SELECT statement

    Hands-on Exercise – Use a basic select statement to retrieve all the records in the Person table

    Restricting and Sorting Data
    Limit the rows that are retrieved by a query, Sort the rows that are retrieved by a query, Ampersand substitution to restrict and sort output at runtime

    Hands-on Exercise – Write a select query to retrieve records where age is more than 60 yrs, Write a select query to sort the records by name, Write a select query to sort the records by age in descending order, Use ampersand substitution to restrict and sort output at runtime

    General functions
    The general functions in SQL, working with any data type and handling Null values, using COALESCE() and Null function, Constructing and executing SQL query that applies the NUL, NUL1, NUL2 and COALESCE()

    Hands-on Exercise – Use NULL function to deal with null values in data

    Using Single-Row Functions to Customize Output
    Describe various types of functions (character, number, date, string etc.) available in SQL

    Hands-on Exercise – Create a table with columns of type char, number and date, Use character, number, and date functions in SELECT statements

    Large Object Functions
    Large object functions – BFILENAME, EMPTY_BLOB, EMPTY_CLOB, Aggregate or Group functions – COUNT, COUNT(*),MIN,MAX,SUM,AVG,etc…,Group BY Clause, HAVING Clause

    Hands-on Exercise – Count records based on a condition, Use Count(*) to know the count of all records, Find Max, Min, Sum, Avg

    OLAP Functions
    The various OLAP functions, cube, model clause, roll up and grouping functions

    Hands-on Exercise – Working with OLAP commands – Cube, Roll Up, etc.

    Using Conversion Functions and Conditional Expressions
    Describe various types of conversion functions that are available in SQL, Conditional expressions in a SELECT statement

    Hands-on Exercise – Group data by using the GROUP BY clause, Include or exclude grouped rows by using the HAVING clause

    Displaying Data from Multiple Tables
    Joins, Inner Join, Outer Join, Left Join, Right Join, Equijoins and Non-equijoins

    Hands-on Exercise – Write SELECT statements to access data from more than one table using equijoins and non equijoins, Join a table to itself by using a self-join, View data that generally does not meet a join condition by using outer joins, Generate a Cartesian product of all rows from two or more tables

    Using Subqueries to Solve Queries
    Define subqueries, Describe the types of problems that the subqueries can solve, List the types of subqueries

    Hands-on Exercise – Write single-row and multiple-row subqueries

    Using the Set Operators
    Describe set operators, UNION [ALL], INTERSECT, MINUS Operators

    Hands-on Exercise – Use a set operator to combine multiple queries into a single query Control the order of rows returned

    Manipulating Data using SQL
    Describe data manipulation language (DML) statement, Insert, Update, Delete Statements, Control transactions

    Hands-on Exercise – Insert rows into a table, Update rows in a table, Delete rows from a table

    Database Transactions
    What is a database transaction, Properties of a transaction (Atomic, Consistent, Isolated, Durable – ACID), Avoiding error/fault in manipulating database records using transaction

    Hands-on Exercise – Begin a transaction, Execute queries to update or insert or delete records, If no error, commit the transaction Else roll back the transaction and end it

    Creating Other Schema Objects
    Views – simple and complex, Sequences, Index, Synonym

    Hands-on Exercise – Create simple and complex views, Retrieve data from views, Create, maintain, and use sequences, Create and maintain indexes, Create private and public synonyms

    Writing Cursor and Conditional Statement
    SQL Cursor, SQL Cursor Attributes., Controlling PL/SQL flow of executions, IF Statement, Simple IF Statement, IF-THAN-ELSE Statement Execution Flow, IF-THAN-ELSE Statement, IF-THAN-ELSIF Statement, Logic Tables, Boolean Conditions., Iterative controlling loop statement, Nested Loops and Labels.

    Hands-on Exercise – Use Boolean condition on a select query, Use logic table, Create nested loops and labels

    Introduction to Explicit Cursor
    Writing Explicit cursors, About cursors, Explicit cursor functions, Controlling explicit cursor, Opening the cursor, Fetching Data cursor, Cursor and records, Cursor for loop using sub queries

    Hands-on Exercise – Write an explicit cursor, Use cursor function, Fetch data cursor

    Advance concepts of explicit Cursor
    Advance Explicit cursor, Cursor with parameters, For update Clause, Where current of Clause, Cursor with sub queries

    Hands-on Exercise – Use cursor with subquery, Use Where Current clause to retrieve data

    Exception Handling
    Handling Exception, Handling Exception with PL/SQLPredefined Exceptions, User Defined Exceptions, Non-Predefined Error, Function for trapping Exception, Trapping user-defined Exception, Raise Application Error Procedure

    Hands-on Exercise – Use Predefined exception, Write user defined exception, Generate and handle exception, Use a function for trapping an exception

    Writing Subprogram, Procedure and passing parameters
    Overview of subprograms, PL/SQL Subprograms, What is Procedure, Syntax for creating Procedure, Creating Procedure with parameter, Example of Passing parameters, Referencing a public variable from a standalone procedure, Declaring Subprogram

    Hands-on Exercise – Create a parameterized procedure, Pass parameters in a procedure call, Access a public variable from a standalone procedure

    Creating PL/SQL Package
    PL/SQL records, Using Pl/SQL Table method and example, Creating PL/SQL Table, Packages – Objective, overview, component, developing, removing, advantages, Creating the package specification/example, Declaring Public construct, Public and private construct, Invoking package construct, Guide lines for deploying packages

    Hands-on Exercise – Create a package, Deploy the created package

    Advance Package Concepts and functions
    Overloading, Using forward declaration, One time only procedure, Package functions, User define package function, Persistent state of package function, Persistent state of package variable, Controlling the persistent state of package cursor, Purity end, Using supplied package, Using native dynamic SQL, Execution flow, Using DBMS-SQL package, Using DBMS-DDL package, Submitting jobs, Interacting with operating system links

    Hands-on Exercise – Use supplied package, Use native dynamic SQL, Use DBMS-SQL package, Use DBMS-DDL package, Submit a job

    Introduction and writing Triggers
    Triggers – Definition, objective and its event type, Application & database triggers, Business application scenarios for implementing triggers, Define DML triggers, Define Non – DML triggers, Triggers event type & body, Creating DML triggers using the create triggers statement, Define statement level triggers v/s low level triggers, Triggers firing sequence: single row manipulation, Creating a DML statement triggers, Using old and new qualifiers, Old and new qualifiers, Instead of triggers, Managing triggers using the alter & drop SQL statement, Testing triggers

    Hands-on Exercise – Create a DML statement trigger, Use old and new qualifiers, Manage a trigger using the alter & drop SQL statement, Test the created triggers

    Compound Triggers
    Viewing trigger information, Describe user triggers, What is a compound trigger and working with it, Compound trigger structure for tables, Timing-point sections of a table compound trigger, Compound trigger structure for views, Trigger restrictions on mutating tables, Compound trigger restrictions, Using a compound trigger to resolve the mutating table error, Creating triggers on system events, LOGON and LOGOFF triggers example, Call statements in triggers, Benefits of database-event triggers, System privileges required to manage triggers

    Hands-on Exercise – View a trigger’s information, Use a compound trigger structure for views, Use a compound trigger to resolve the mutating table error, Create triggers on system events, Use LOGON and LOGOFF triggers, Call statements in triggers

    Working with Dynamic SQL
    Dynamic SQL-objectives, Describe execution flow of SQL statements, Dynamic SQL with a DDL statement-example, Working with dynamic SQL, Native Dynamic SQL(NDS), Using the executive immediate statement-example, Using native dynamic SQL to compile PL/SQL code, Using DBMS-SQL with a DML statement, Using the DBMS-SQL package subprograms, Parameterized DML statement

    Hands-on Exercise – Use the executive immediate statement, Use native dynamic SQL to compile PL/SQL code, Create DBMS-SQL with a DML statement, Create a DBMS-SQL package subprograms

    Advance level- Scripting
    Managing Dependencies, Objectives, overview of schema object dependencies, Direct local dependencies, Querying direct object dependencies, Displaying direct and indirect dependencies, Fine-Grained dependency management, Changes to synonym dependencies, Maintaining valid PL/SQL program units and views, Object re-validation, Concepts of remote dependencies, Setting the remote dependencies mode parameter, Recompiling PL/SQL program unit, Packages and Dependencies, Successful and unsuccessful recompilation, Recompiling procedures

    Hands-on Exercise – Query direct object dependencies, Display direct and indirect dependencies, Set the remote dependencies mode parameter, Recompile PL/SQL program unit, Edit a procedure and recompile it

    Tableau Course Content

    Introduction to Data Visualization and Power of Tableau
    What is data visualization, Comparision and benefits against reading raw numbers, Real usage examples from various business domains, Some quick powerful examples using Tableau without going into the technical details of Tableau
    Architecture of Tableau
    Installation of Tableau Desktop, Architecture of Tableau, Interface of Tableau (Layout, Toolbars, Data Pane, Analytics Pane etc), How to start with Tableau, Ways to share and exporting the work done in TableauHands-on Exercise – Play with the tableau desktop, interface to learn its user interface, Share an existing work, Export an existing work
    Working with Metadata & Data Blending
    Connection to Excels, PDFs and Cubes, Managing Metadata and Extracts, Data Preparation and dealing with NULL values, Data Joins (Inner, Left, Right, Outer) and Union, Cross Database joining, Data BlendingHands-on Exercise – Connect to an excel sheet and import data, Use metadata and extracts, Handle NULL values, Clean up the data before the actual use, Perform various join techniques, Perform data blending from more than one sources
    Creation of sets
    Marks, Highlighting, Sort and Group, Working with Sets (Creation of sets, Editing sets, IN/OUT, Sets in Hierarchies)Hands-on Exercise – Create and edit sets using Marks, Highlight desired items, Make groups, Applying sorting on result, Make hierachies in the created set
    Working with Filters
    Filters (Addition and Removal), Filtering continuous dates, dimensions, measures, Interactive FiltersHands-on Exercise – Add Filter on data set by date/dimensions/measures, Use interactive filter to views, Remove some filters to see the result
    Organizing Data and Visual Analytics
    Formatting Data (Labels, Annotations, Tooltips, Edit axes), Formatting Pane (Menu, Settings, Font, Alignment, Copy-Paste), Trend and Reference Lines, Forecasting, k-means Cluster Analysis in TableauHands-on Exercise – Apply labels, annotations, tooltips to graphs, Edit the attributes of axes, Set a reference line, Do k-means cluster analysis on a dataset
    Working with Mapping
    Coordinate points, Plotting Longitude and Latitude, Editing Unrecognized Locations, Custom Geocoding, Polygon Maps, WMS: Web Mapping Services, Background Image (Add Image, Plot Points on Image, Generate coordinates from Image)Hands-on Exercise – Plot latitude and longitude on geo map, Edit locations on the map, Create custom geocoding, Use images of a map and plot points on it, find coordinates in the image, Create a polygon map, Use WMS
    Working with Calculations & Expressions
    Calculation Syntax and Functions in Tableau, Types of Calculations (Table, String, Logic, Date, Number, Aggregate), LOD Expressions (concept and syntax), Aggregation and Replication with LOD Expressions, Nested LOD Expressions
    Working with Parameters
    Create Parameters, Parameters in Calculations, Using Parameters with Filters, Column Selection Parameters, Chart Selection ParametersHands-on Exercise – Create new parameters to apply on a filter, Pass parameters to filters to selet columns, Pass parameters to filters to select charts
    Charts and Graphs
    Dual Axes Graphs, Histogram (Single and Dual Axes), Box Plot, Pareto Chart, Motion Chart, Funnel Chart, Waterfall Chart, Tree Map, Heat Map, Market Basket analysisHands-on Exercise – Plot a histogram, heat map, tree map, funnel chart and others using the same data set, Do market basket analysis on a given dataset
    Dashboards and Stories
    Build and Format a Dashboard (Size, Views, Objects, Legends and Filters), Best Practices for Creative and Interactive Dashboards using Actions, Create Stories (Intro of Story Points, Creating and Updating Story Points, Adding Visuals in Stories, Annotations with Description)Hands-on Exercise – Create a dashboard view, Include objects, legends and filters, Make the dashboard interactive, Create and edit a story with visual effects, annotation, description
    Integration of Tableau with R and Hadoop
    Introduction to R Language, Applications and Use Cases of R, Deploying R on Tableau Platform, Learning R functions in Tableau, Integration with HadoopHands-on Exercise – Deploy R on tableau, Create a line graph using R interface, Connect tableau with Hadoop and extract data

    MSBI SSIS Course Content

    What is BI?
    Introduction to Business Intelligence, understanding the concept of Data Modeling, Data Cleaning, learning about Data Analysis, Data Representation, Data Transformation.
    ETL Overview
    Introduction to ETL, the various steps involved Extract, Transform, Load, using a user’s email ID to read a flat file, extracting the User ID from email ID, loading the data into a database table.
    Working with Connection Managers
    Introduction to Connection Managers – logical representation of a connection, the various types of Connection Managers – Flat file, database, understanding how to load faster with OLE DB, comparing the performance of OLE DB and ADO.net, learning about Bulk Insert, working with Excel Connection Managers and identifying the problems.
    Data Transformations
    Learning what is Data Transformation, converting data from one format to another, understanding the concepts of Character Map, Data Column and Copy Column Transformation, import and export column transformation, script and OLEDB Command Transformation, understanding row sampling, aggregate and sort transformation, percentage and row sampling.
    Advance Data Transformation
    Understanding Pivot and UnPivot Transformation, understanding Audit and Row Count Transformation, working with Split and Join Transformation, studying Lookup and Cache Transformation.
    Slowly Changing Dimensions
    Understanding data that slowly changes over time, learning the process of how new data is written over old data, best practices.Detail explanation of three types of SCDs –Type1, Type2 and Type3, and their differences.
    Overview of Fuzzy Look-up Transformation and Lookup and Term Extraction
    Understanding how Fuzzy Lookup Transformation varies from Lookup Transformation, the concept of Fuzzy matching,
    Concepts of Logging & Configuration
    Learning about error rows configuration, package logging, defining package configuration, understanding constraints and event handlers.

    MSBI SSRS Course Content

    Introduction to SSRS
    Get introduced to the SSRS Architecture, components of SSRS Report Building tool, learning about the data flow in different components.
    Matrix and Tablix Overview
    Understanding the concepts of Matrix and Tablix, working with Text Box, learning about formatting, row/column grouping, understanding sorting, formatting, concepts of Header, Footer, Totals, Subtotals and Page Breaks.
    Parameters and Expression
    Learning about Parameters, filter and visibility expression, understanding drill-through and drill-down, defining variables, custom code.
    Reports and Charts creation
    Introduction to various aspects of Bar Chart, Line Chart, Combination Chart, Shape Chart, Sub Reports
    Dashboard Building
    Learn how to build a Dashboard with Sparklines, Data Bars, Map Charts, Gauge Charts and drilling into reports, the basics of ad hoc reporting.Data Bar, Sparkline, Indicator, Gauge Chart, Map Chart, Report Drilling, What is Ad hoc reporting?
    Reports and Authenticity
    Understanding Report Cache, Authorization, Authentication and Report Snapshot, learning about Subscriptions and Site Security.

    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.
    SSAS Cube
    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.
    Dimensions
    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
    DAX language
    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
    Router Transformation
    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
    Repository Manager
    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.
    Workflow Informatica
    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 targeting
    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
    Database Connection
    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
    LinkedIn Connection
    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
    Cache management
    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
    Extracting Data
    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.

    Data Normalization

    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.

    Analytical Models

    Progression in analytical methods, various types models like summarization, trends, benchmarking, comparative analysis, optimization and predictions.

    MicroStrategy Platform Architecture

    A detailed architecture of MicroStrategy including tools and services, data assets, schemas, metadata, public objects and information delivered via web, desktop and mobile.

    MicroStrategy Architecture Flow

    MicroStrategy data flow architecture, the various types of setup like on-premise, cloud and mobile, understanding the need for data containers, customization using SDK, security for backend data containers and other offerings.

    Connectivity and the Data ecosystems

    Learning about the various backend data support that MicroStrategy offers, seamless integration with relational databases and unstructured data storage.

    Analyzing data

    Learning about the basic components and elements of schema, facts and dimensions, analyzing data and quantifying business elements.

    Measures & Metrics

    Understanding about measures and metrics in a data warehouse schema.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

    Schema Architect

    The significance of architect for the projects, a detailed demo of working with Architect for project, and creation of schema objects like Facts and Attributes.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

    Creating Metrics

    Creation of basic metrics and level metrics, defining metrics using filters, studying the metrics generated by SQL when working with level dimensionality, detailed step by step process to create metrics.Hands-on Exercise – Create basic metrics and level metrics, define metrics using filters

    Creating 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

    Creating Prompts

    Understanding the different ways of creation of Prompts and its various uses.Hands-on Exercise – Create different types of Prompts and use them

    Search Objects

    Learning how to create Search Objects, the usage of Search Objects in Prompts andHands-on Exercise – Create Search Objects, Use search objects in Prompts

    Consolidation
    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
    Custom Groups

    Learning how to create Custom Groups and their distinction from Consolidation Objects, Custom Groups are a consequence of SQL queries and Consolidation Objects are functions of analytical engine, a detailed demonstration of steps needed for SQL query generation in Custom Groups.Hands-on Exercise – Create Custom Groups, Generate SQL query in Custom Groups

    Drill Maps

    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

    Partition mapping

    Understanding partitioning, various type of data partitioning like homogenous and heterogeneous mapping, metadata and warehouse partitioning, a detailed demonstration of creating partition mapping in MicroStrategy.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

    MicroStrategy Web

    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

    Web Dashboard

    Learning about the MicroStrategy Dashboard created using Web Interface, importance of Visual Insight for Self-service Business Intelligence, creating dashboards on web in production environment.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.
    Qlikview Products
    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.
    Data Relationships
    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,

Course Fee:
USD 1228

Course Type:

 Self-Study

Course Status:

 Active

Workload:

 1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Best Practices of MySQL Encryption
Are you new to MyTechLogy?
Click here to learn more

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top