Stay home stay safe-- Due to the Covid-19 outbreak all our course will be conducted online. For more inform please contact-9619341713 / 7045481713

  • +91-9619341713-Airoli/ 7045481713-Mahape/ 7045911713-Kalyan

Learn Basic Data Warehousing

Learn Basic & Advanced Data Warehousing from start for beginner

Courses
Course Overview

Data warehouse as ‘a subject-oriented, integrated, time-variant and non-volatile collection of data.’ Extremely useful for Data Analysts, this data helps them to take business decisions and other data-related decisions in the organization.

Requirements

  • Broad vision
  • Deep technical expertise in one or two areas.
  • Communications skills
  • The ability to analyze data sources
  • An early-warning system

Learn basic Informatica Powercenter Development Training
  • What Is Data Warehouse?
  • Explain OLTP, OLAP
  • Explain Schemas
  • Sql basics and analytical functions
  • Pre-build VMware setup
  • Informatica Client-Server setup guide on personal system
  • What Is Etl?
  • What Is Informatica?
  • Informatica Architecture Overview
  • Explain Informatica PowerCenter Components
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
    • Power Center Admin Console
  • Relational Sources(Data Bases)
  • Files Sources(Flat File, Xml, Cobol)
  • Relational Targets(Data Bases)
  • Files Targets
  • What Is Transformation
  • Type Of Transformation
    • Active Transformations
    • Passive Transformations
  • Ports in informatica
  • Connection setup in designer and workflow manager
  • Expression Transformation
  • Filter Transformation
  • Router Transformation
  • Sorter Transformation
  • Rank Transformation
  • Source Qualifier Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Sequence Generator Transformation
  • SQL Transformation
  • Stored Procedure Transformation
  • Lookup(Different Type Of Lookup) Transformation
  • Transaction control transformation
  • Union Transformation
  • Normalizer Transformation
  • Update Strategy Transformation
  • Slowly Changing Dimension
  • SCD Type-1
  • SCD Type-2(Date, Flag And Version)
  • SCD Type-3
  • Create Reusable Tasks
  • Workflows, Sessions And Worklets
  • Task
  • Session
  • Decision Task
  • Control Task
  • Event Wait Task
  • Timer Task
  • Monitoring Workflows And Debugging Errors
  • Indirect Loading
  • Constraint Based Load Ordering
  • Target Load Plan
  • Worklet, Mapplet
  • Session Properties
  • Reusable Transformation
  • Migration
    • Xml Migration & Folder Copy
  • Scheduling Workflow
  • Parameter and Variables
  • Performance Tuning
  • Partition
  • Informatica Cloud Overview
  • Informatica Cloud Secure Agent and Architecture
  • Creating Connections
  • Data Synchronization Application
  • Data Replication Application
  • Cloud Mapping Designer
  • Task flows
  • Performance and Scalability
  • SQL Beginner Course
  • Unix Basis Commands
  • Real Time Scenarios
Informatica MDM Training
  • Master Data
  • Master Data Management
  • A Reliable Foundation Of Master Reference Data
  • Components of MDM Hub
  • Application Server Tier
  • Database Server Tier
  • Batch Data Process Flow
  • Trust Framework
  • Consolidation Flag
  • Data Mode Elements
  • Data Model
  • Relationships
  • Relationship Types
  • Lookups
  • Global Business Identifier (GB I D) Flag
  • Basic Mappings
  • Complex Mappings
  • Cleansing and Transforming Data
  • Execution Component
  • Testing Mappings
  • Reusable Cleanse Components
  • External Data Cleansing
  • Delta Detection & Audit Trail
  • Rejects
  • Cleanse Match Servers
  • High-Level Stage Process Flow
  • Detailed Stage Process Flow
  • Trust
  • Validation Rule
  • Trust & Validation Rules: Things to note
  • Cell Level Update
  • Allow NULL Update
  • Allow NULL Foreign Key
  • How the Load work
  • Match & Merge Overview
  • Key Activities for Configuring Rules
  • Match/Search Strategy for Base Object
  • Population
  • Match Path, Columns and Match Key
  • Match Rules and Rule Sets
  • Primary Key Match Rules
  • Match Rules using Primary Key Match
  • Match Keys Distribution
  • Merge Settings
  • Match/ Merge Properties: Merge Style Base Object
  • External Match
  • Match Server Architecture
  • Queries & Packages Overview
  • Query
  • Package
  • Batch Viewer
  • Batch Group
  • Executing Stored Procedures
  • Scheduling Considerations
  • Job Status & Job Statistics
  • Data Stewardship
  • Recap: Consolidation Flags
  • Merge Manager
  • Data Manager
  • Unmerge and Tree Unmerge
  • User Objects
  • User Object Registry Tool
  • User Exit & User Exit Procedure
  • Demo User exit procedure (using TOAD)
  • User Exits in the STAGE Process
  • User Exits in the LOAD Process
  • User Exits in the MATCH Process
  • User Exits in the MERGE Process
  • User Exits in the UNMERGE Process
  • Other logs Exit Procedures
  • Enterprise Manager
  • Hub Server Tab
  • Cleanse Servers Tab
  • Environment Report Tab/li>
  • ORS Databases Tab
  • Database Log File
  • Application Server Log
  • Cleanse/ Match Server Logs
  • Console Log
  • Entities & Entity Type
  • H M Relationships
  • H M Hierarchies
  • Hierarchy Management
  • H M Profiles
  • H M Packages
  • Users, Resources, Privileges & Roles
  • Resources
  • Resource Groups
  • Privileges
  • Roles
  • Business Data Director – User Interface
  • Create, Manage, Consume And Monitor
  • Data Model Elements
  • Configuration File
  • Subject Area
  • Subject Area Groups
  • B D D Data Display
  • Relationships
  • Application Validation
  • Importing an Application
  • Match Paths
  • Lookup
  • Cleansing
  • Resources and Privileges
Learn basic ETL Testing Training
  • DBMS And RDBMS
  • What Is Data Warehousing And Necessity Of It?
  • Data Warehousing Architecture
  • OLAP,ROLAP, MOLAP
  • Data Mining
  • Meta Data
  • Tables, Views
  • Constraints
  • Fact And Dimensional Tables
  • Partitioning Of Tables
  • Concepts Of Referential Integrity
  • Concepts Of Modeling
  • Database Schema
  • Concepts Of Normalization
  • Concepts Of Slowly Changing Dimensions
  • Concepts Of Data Mart
  • Full And Incremental Extraction Process
  • Change Data Capture
  • DDL, DML Commands
  • All The Basic Functions (Character Functions, Conversion Functions, Advanced Functions, Mathematical Functions And Date Functions)
  • Joins
  • Practice Sqls For Some Sample Test Scenarios
  • What Is ETL And Importance Of ETL Testing??
  • Creating, Running And Analyzing Sessions/Workflows In Informatica
  • Preparation Of Test Strategy, Test Plan And Estimations
  • Testing Scenarios, Creation Of Test Cases And Scripts
  • Test Case Execution And Defect Tracking And Reporting
  • Validation Of The Report Data With DB And UI Testing
  • Preparation Of Test Data
  • Unit Testing
  • Integration Testing
  • Module Testing
  • System Testing
Qlik Sense Training
  • What is QlikSense?
  • Comparing Qlik Sense Desktop with Qlik Sense
  • Installing Qlik Sense Desktop
  • How Qlik Sense varies from QlikView?
  • Starting with QlikSense Desktop
  • Opening an app with QlikSense
  • QlikSense Architecture
  • Navigating in the user interface
  • Data Manager
  • Data Load Editor
  • Data Model Viewer
  • Interacting with the user interface
  • Creating apps and Visualizations
  • Structuring an app with Sheets
  • Different type of Visualizations
  • Dimensions and Measures in a CHART
  • When to use and What Chart to Use
  • Selections in a Visualization
  • Settings and Properties of each Visualization
  • Expressions , Functions and Variables
  • Working with Expression Editor
  • Using Functions in Charts
  • Using Variables in Expressions
  • Set Analysis and Set Expressions
  • Working with Master Items
  • Adding data from files and databases
  • Loading data with the data load script
  • Data Connections
  • Various types of Data loads
  • Profile Data with QlikSense
  • Troubleshooting
  • Qlik Sense Data Architecture
  • Creating Star and Snowflake schemas
  • Creating Star and Snowflake schemas
  • Use of Joins, Keeps, Concatenate etc..
  • Understanding QVD layer
  • Working on synthetic keys and circular references.
  • Qlik Sense Star Schema
  • Link Table
  • Dimensions Table
  • Master Calendar
  • Optimizing data models
  • Best Practices of Data Modelling
  • Data Storytelling
  • Publishing
  • Exporting and Printing
  • Advanced Scripting and Chart Functions
  • Qlik Tips and Techniques
  • Learning about Qlik Sense App and its security features
  • Providing Qlik Sense access to user sets
  • Qlik Sense Security rule code
Qlik View Course
  • 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
  • STAR SCHEMA
  • SNOW FLAKE SCHEMA
  • Difference between STAR and SNOW FLAKE Schema.
  • Other terminologies Cleansing, Purging etc.
  • Database Modeling
  • Designing Methods
  • Logical Designing
  • Physical Designing
  • Introduction of Dimension Modeling
  • Difference between ER-Modeling and Dimension Modeling
  • Implementation of Dimension Model
  • Forward Engineering and Reverse Engineering
  • Introduction of various Database Components
  • OLAP ?OLAP/MOLAP/HOLAP
  • Data structures in QlikView (AQL). • Sample Application walkthrough of QlikView
  • Architecture and components of QV
  • In-memory BI /OLAP
  • Loading data from multiple datasources
  • Script editing
  • Menu Commands and Syntax
  • Handling DATA SOURCE FILES
  • The QWT (Access File example) primary data source
  • The QWT (Access File example with QVD Conversion) secondary data files
  • Script generation
  • Creating a connection to the database
  • Reading tables into QlikView
  • Big data Analytics
  • Connecting of Qlikview with Bigdata hadoop
  • 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)
  • Concatenation
  • Sheet Basics
  • Sheet Objects
  • Text,list,chart,graph
  • Multidimensional,gauges,multibox
  • Calculation and expressions
  • Reporting formats
  • Server setup
  • Publisher
  • Alerts
  • Bookmark
SQL Server BI Tools(SSIS,SSAS,SSRS) Training

SQl Server 2014/16 Integration Servers (SSIS)

  • Over view of Integration Services Solutions
  • Integration Services Tools
  • Creating an integration services solution
  • Using Variables
  • Building and Running a Solution
  • Control flow Tasks
  • Control Flow Precedence Constraints
  • Control Flow Containers
  • Data Flow Sources and Destinations
  • Data Flow Transformations
  • Data Flow Paths
  • Overview of Integration Services Logging
  • Implementing Logging
  • Debugging a package
  • Implementing Error Handling
  • Implementing Checkpoints
  • Implementing Transactions
  • Package Configurations
  • Deploying Packages
  • Implementing key Performance Indicator
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database
  • Configuring Processing Settings
  • Logging ,Monitoring and Optimizing an Analysis Services Solution
  • Backing Up and Restoring an Analysis
  • Services Database

SQl Server 2014/16 Analysis Servers (SSIAS)

  • Overview of Data Anyaysis Solutions.
  • Overview of SQL Server 205 Analysis Services.
  • Developing Anaysis Services Solutions
  • Data Sources And Data Source Views
  • Creating a Cube
  • Configuring Dimensions
  • Define Hierarchies
  • Sorting And Grouping Attributes
  • Working With Measures
  • Working With Measures Groups
  • Analytical MDX Introducation
  • MDX queries MDX vs. SQL
  • MDX Stored Procedures
  • Adding Calculations to a Cube
  • Managing Packages
  • Securing Packages
  • Scheduling Jobs

SQl Server Reporting Services(SSRS)

  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools
  • Creating A Basic Table Report
  • Formatting Report Pages
  • Calculating Values
  • Interactive Navigation
  • Displaying Data
  • Defining Report Data
  • Using Parameters and Filters
  • Using parameter lists
  • Defining Report Data
  • Using Parameters and Filters
  • Using parameter lists
  • Creating report models
  • Using report builder
  • Publishing report
  • Executing reports
  • Creating cached instances
  • Creating snapshots and report history
  • Introduction to report subscriptions
  • Creating report subscriptions
  • Managing report subscriptions
  • Server administration
  • Performance and reliability monitoring
  • Administering report server databases
  • Security administration
  • Querying for server information using a web service
  • Automating report management
  • Rendering reports
  • Creating custom code
  • Introduction to SQL server
  • Introduction to T-SQL
  • Constraints
  • Joins
  • Functions
  • Views
  • Indexes
  • Stored Procedures
  • Cursors
  • Triggers

Difference Between ORACLE & SQL Server

SQL Queries

Learn Basic Informatica Cognos Training
  • What is Business Intelligence
  • Why is BI important and where can we use it
  • Components of BI
  • Business Intelligence Roadmap
  • 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
  • Introduce Cognos 10.1 BI
  • Examine the different studios in Cognos 10.1 BI
  • Identify the different data sources within the studios
  • Highlight key capabilities of Cognos 10.1 BI
  • Understand Cognos multi layered architecture
  • Create and modify a data source
  • Create database backups
  • Understand roles users and groups
  • Specify permission settings
  • What is Cognos connection
  • Examine Cognos connection UI elements – create a URL, Login, Logoff
  • Entry properties: General Properties, Permission, Report, Query, Analysis, Job, Agent
  • Navigation - Public and Private Folder
  • Open reports with report name, Go to links, Run reports from a view
  • Run Reports – Prompt Pages, Printing a report and Open in excel
  • View the run history of a report and historical reports
  • Closing and creating quick links to reports – my folder
  • Personalize Cognos connection
  • Backups – 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
  • Introduction to framework manager
  • Framework manager basics
  • User interface, navigation, objects
  • Planning the project and data model, framework manager workflow
  • Naming conventions for objects in a project
  • Designing project
  • Create project
  • Importing metadata from one and more sources
  • Exporting metadata
  • Data sources
  • Working with data source connections
  • Create and modify data sources
  • Improve performance by setting query processing type
  • Preparing relational metadata for use in reports
  • Verifying relationships
  • Working with dimensions
  • Working with query
  • Subjects – data, model and stored procedure query subject
  • Working with query items- set usage and aggregate property
  • Making metadata available to report authors
  • Verify model
  • Set governors
  • Improving performance
  • Create and modify package
  • Controlling access to metadata
  • Explore package publish package
  • Guideline for modelling metadata
  • Best practices – presentation and database layers
  • Merge metadata
  • Perform calculations and filer
  • 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
  • Introduction to Analysis Studio
  • Creating a basic analysis
  • Working with data in crosstab
  • Exploring data
  • Limiting data
  • Calculating data
  • Sharing data
  • Introduction to report studio
  • Report studio user interface
  • Creating, save and run reports
  • Report templates
  • Managing reports
  • Types of reports
  • List reports
  • Crosstab reports charts
  • Formatting a report
  • Report layout guidelines
  • Fonts, styles, header, footer and orders
  • Insert objects
  • Swap columns and rows
  • Working with data
  • Filters, parameters and prompts
  • Sorting and grouping
  • Subtotals and calculations
  • Working with queries/Working with reports
  • Managing changes in the package
  • Conditional formatting
  • Drill-through reports
  • Drill-up / drill-down reports
  • Master-detail reports
  • Scheduling reports
Datastage Training
  • Introduction of Data warehousing
  • Purpose of Data warehouse
  • DW Architecture
  • Data warehouse vs. OLTP Applications
  • Data Mart
  • Introduction of Data Modeling
  • Entity Relationship(ER) Model
  • Fact and Dimension Tables
  • Logical Modeling
  • Physical Modeling
  • Schemas – Star Schema & Snowflake Schemas
  • Fact less Fact Tables
  • Introduction of Extraction, Transformation and Loading (ETL)
  • Types of available ETL Tools
  • Key tools in the ETL market
  • Windows server
  • Oracle
  • .NET
  • Datastage ✔5X2 & 8x
  • Server jobs & Parallel jobs
  • Administrator client
  • Designer client
  • Director client
  • Import/export manager
  • Multi-client manager
  • Console for IBM Information server
  • Web console for IBM information server
  • Introduction to Datastage
  • IBM Information server Architecture
  • IBM Data Quality Architecture
  • Enterprise Information Integration
  • Web Sphere Data stage Components
  • About Web Sphere Data stage Designer
  • Partitioning Methods
  • Partitioning Techniques
  • Designer Canvas
  • Central Storage
  • Job Designing
  • Creating the Jobs
  • Compiling and Run the Jobs
  • Exporting and importing the jobs
  • Parameter passing
  • System (SMP) & Cluster system (MPP)
  • Importing Methods (Flat file, Txt, Xls and Database files)
  • OSH Importing Method
  • Databases Stages
  • Oracle Database
  • Dynamic RDBMS
  • ODBC
  • SQL Server
  • Teradata
  • Sequential File
  • Dataset
  • Lookup File set
  • Peek
  • Head
  • Tail
  • Row Generator
  • Column Generator
  • Slowly changing dimension stage
  • Slowly changing dimensions implementation
  • Aggregator
  • Copy
  • Compress
  • Expand
  • Filter
  • Modify
  • Sort
  • Switch
  • Lookup
  • Join
  • Marge
  • Change Capture
  • Change Apply
  • Compare
  • Difference
  • Funnel
  • Remove Duplicate
  • Surrogate Key Generator
  • Pivot stage
  • Transformer
  • Shared Containers
  • Local Containers
Ab Initio Training
  • Understanding GDE
  • Understanding Co-op System
  • Understanding EME/Application hub
  • Record formats, DML, Transform functions, Key specifiers
  • Dataset components/ Table components/Program components
  • Layout
  • Parametersy
  • Validating the graphs and understanding the error messages
  • Component Overview-Editors
  • Record Format Editors
  • Expression Editors
  • Transform Editors
  • Key Specifier Editors
  • Package Editors
  • Variable Editors
  • Input file
  • Output File
  • Intermediate file
  • Lookup files and Lookup Functions
  • Filter by expression
  • Dedup sorted
  • Reformat
  • Aggregate
  • Scan
  • Rollup
  • Join
  • Match sorted
  • Normalize
  • Denormalize Sorted
  • Understanding Multifiles
  • Understanding Parallelism
  • Data Parallelism
  • Component Parallelism
  • Pipeline parallelism
  • Broadcast
  • Partition by key
  • Partition by expression
  • Partition by round robins
  • Partition by range
  • Partition by load balance
  • Gather
  • Concatenate
  • Interleave
  • Merge
  • Understanding Database Configuration
  • Input Table
  • Output Table
  • Run SQL
  • Truncate Table
  • Update Table
  • Join with DB
  • Redefine Format
  • Gather Logs
  • Replicate
  • Run Program
  • Trash
  • Check Order
  • Compare Records
  • Validate Records
  • Generate Record
  • Create Data
  • Compute Checksum
  • Tagging
  • Branching
  • Checkin-Checkout
  • Locking
  • Common projects
  • Dependency analysis/Impact analysis
  • Generic Graphs/Reusable Graphs
  • Conditional components
  • Concept of Phases and check point
  • M Commands
  • Air Commands
  • Configuration Variables
  • Environment Variables
Learn basic Tableau Training
  • Why Tableau? Why Visualization?
  • Level Setting & Terminology
  • Getting Started & creating some powerful visualizations quickly
  • The Tableau Product Line
  • Things you should know about Tableau
  • Connecting to Data and introduction to data source concept
  • Working with data files versus database server
  • Understanding the Tableau workspace
  • Dimensions and Measures
  • Using Show Me!
  • Tour of Shelves (How shelves and marks work)
  • Building Basic Views
  • Help Menu and Samples
  • Saving and sharing your work
  • Marks
  • Size and Transparency
  • Highlighting
  • Working with Dates
  • Date aggregations and date parts
  • Discrete versus Continuous
  • Dual Axis / Multiple Measures
  • Combo Charts with different mark types
  • Geographic Map Page Trails
  • Heat Map
  • Density Chart
  • Scatter Plots
  • Pie Charts and Bar Charts
  • Small Multiples
  • Working with aggregate versus disaggregate data
  • Analyzing
  • Sorting & Grouping
  • Aliases
  • Filtering and Quick Filters
  • Cross-Tabs (Pivot Tables)
  • Totals and Subtotals Drilling and Drill Through
  • Aggregation and Disaggregation
  • Percent of Total
  • Working with Statistics and Trend lines
  • Working with String Functions
  • Basic Arithmetic Calculations
  • Date Math
  • Working with Totals
  • Custom Aggregations
  • Logic Statements
  • Options in Formatting your Visualization
  • Working with Labels and Annotations
  • Effective Use of Titles and Captions
  • Introduction to Visual Best Practices
  • Combining multiple visualizations into a dashboard
  • Making your worksheet interactive by using actions and filters
  • An Introduction to Best Practices in Visualization
  • Publish to Reader
  • Packaged Workbooks
  • Publish to Office
  • Publish to PDF
  • Publish to Tableau Server and Sharing over the Web
  • Scenario-based Review Exercises
  • Best Practices
Learn basic Microstrategy Training
  • Business Intelligence
  • BI Architecture
  • MicroStrategy
  • Product Overview
  • Intelligence Server
  • MicroStrategy Desktop
  • MicroStrategy Web
  • MicroStrategy Office
  • MicroStrategy Architect
  • MicroStrategy Object manager
  • MicroStrategy Enterprise manager
  • MicroStrategy Command manager
  • MicroStrategy SDK
  • History
  • System Requirements
  • Hardware
  • Software
  • Metadata
  • Object Types stored in Metadata
  • Project Source
  • Project
  • Project Creation Assistant
  • Create Project
  • Adding Tables using warehouse catalog
  • Project Layers
  • Features
  • Facts Creation in Architect
  • Attributes Creation in Architect
  • Attribute Relations in Architect
  • User hierarchies in Architect
  • Update Project Schema
  • Additional Concepts in Architect
  • Partition Mapping
  • Transformations
  • Report
  • Report Components
  • Report Types
  • Report Services Document
  • HTML Documents
  • OLAP Services
  • View Filters
  • Derived Metrics
  • Derived Elements
  • Dynamic Aggregation
  • Formatting a Report
  • Thresholds
  • Renaming Row and Column headers
  • Hiding a metric column
  • Banding
  • Auto-styles
  • Analyzing Data
  • Sorting
  • Searching
  • Outlining
  • Page-By
  • Pivoting Data
  • Report Limits
  • Calculating Data
  • Answering Question about Data
  • Report Filters
  • Hierarchies
  • Drilling
  • Refresh data on the report
  • Report Cache
  • Answering Report Prompts
  • Table of Features
  • Create sample report
  • Report Builder
  • Navigating through Desktop
  • Report Editor Interface
  • Project objects
  • Attributes
  • Metrics
  • Filters
  • Prompts
  • Templates
  • Custom Groups & Consolidations
  • Drill Maps
  • Reports
  • Creating new report
  • Basic Report
  • Graphs
  • Free Form SQL and Query Builder
  • VLDB Properties
  • Report Service Documents
  • MicroStrategy Architecture
  • MicroStrategy Metadata
  • What happens when Intelligence Server starts?
  • Intelligence Server job processing
  • Processing Report Execution
  • Processing Object Browsing
  • MicroStrategy User Model
  • MicroStrategy Users
  • MicroStrategy User Groups
  • Controlling access to objects: Permissions
  • Controlling access to functionality: Privileges
  • Defining sets of privileges: Security Roles
  • Modes of Authentication
  • Managing and verifying your licenses
  • Caching
  • Scheduling
  • Clustering
Tera Data DBA Training
  • Parsing Engine(PE)
  • Request and Response Parcel
  • Access Module Processors (AMPs)
  • Bynet
  • Data access Handling
  • TD Config Utilities
  • Config and Reconfig
  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes
  • Data dictionary
  • Parsing Engine
  • System Views
  • Database Views
  • DBC Users View
  • Indices View
  • All Temp Tables View
  • Using DBC AMP Usage
  • Using DBC Table Size
  • Logon and Logoff Tracking.
  • Access rights (Auto,implicit,Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • DBC.RoleInfo and DBC.ProfileInfo
  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging
  • TD Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC.sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views
  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager
  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • TD manager Dynamic Utilization Charting
  • Locking Logger
  • Starting DB Window
  • QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK
  • Archive and Recovery Statements
  • Recovery vs. FastLoad
  • Invoking Archive
  • Restart Log
  • ANALYZE Statement
  • Archive
  • Database DBC Archive
  • Indexes option
  • Database DBC Archive
  • Archive and Recovery (ARC) Examples
  • Restore
  • Copy
  • Copying Tables
  • Build
Microsoft Power BI
  • Explain about Data Warehouse?
  • Core concept of Data Warehouse
  • Need for DWH
  • Understanding Data Warehouse Concept
  • Data Warehouse Design and Architecture
  • Explain on different types of Schema
  • OLTP vs OLAP
  • Dimensional and Fact Table design
  • Explain on Star Schema
  • Explain on Snow Flake Schema
  • Introduction to Power BI
  • Architecture of Power BI
  • Component of BI
  • Understanding on Basic concept on Power BI
  • Pre-requisite to Install Product
  • Install Product on OS
  • Verify Install
  • Configure/Customize of Microsoft Power BI
  • Explain of Integration Services
  • Overview of BI Services
  • Explain on Live Dashboards
  • Interactive Reports
  • Data Visualization
  • Understanding on Power BI Desktop
  • Connect to Multiple Data sources
  • Live Connectivity with SQL Analysis server
  • Using Query Editor
  • Data Loading on Individual Tables
  • How to Transform data with Query Editor
  • Cleaning Formatted / Unformatted Data
  • Explain on Manage Data Relationships
  • Create Calculated Columns
  • How to Optimizing Data Models
  • Show to Create Calculated Tables
  • Explorer on Time-Based Data
  • Overview of Visualization
  • Create Simple Visualization
  • Explorer to use Map Visualizations
  • Combination Charts
  • Create and apply format Slicers
  • Use Funnel and Waterfall Charts
  • Create basic Reports and explorer on Reports
  • Apply Styles in Shapes, Text Fields, and Images on Reports
  • Style on Page Layout and Formatting
  • Interactions between Visualization
  • How to Customize Reports for summarization and Category
  • Z-order of Report Elements
  • Create Table and Matrices
  • Build Bar, Pie, Line and Scatter Charts from Loaded Data
  • Overview of BI and Excel
  • Import data in Excel files
  • Explorer on Table Analysis Tools in Excel
  • Identifying Data Groups
  • Introduction to Power Query and Power Map
  • Explorer on Discover and Import data
  • How to Transform, Merge and Filter Data
  • Grouping and Aggregating Data
  • Analysis with Power Map
  • How to Create Map-Based Graph
  • Create Heat and Region Maps
  • Analyzing changes over Time
  • Overview of Publish and Sharing
  • How to Publish Reports to Power BI Service
  • Import and Export Power BI
  • Manual Republish
  • How to Create Group in Power BI
  • Create/Edit Content Pack
  • Publish Report to Web from Power BI
  • Overview of DAX
  • Type of DAX Calculation
  • Different kind of Functions in DAX
  • Explain on DAX Operators
  • Create Calculation in Power Pivot
  • Measures vs Attributes
  • How to Create Common Aggregates
  • Table Relationship with DAX
  • How to Create KPIs
Case Studies on Microsoft Power BI

Discussion with Interview Question and Best Practices on Microsoft Power BI