JupiterR Synergetic Solutions JupiterR
 Synergetic
 Solutions

Sahi Pro  Authorised Reseller
               &
    Training Partner





     JupiterR Synergetic Solution's Workshop On

BI (ETL / Data Warehouse) Testing

5 Days Duration
 
Program Overview & Benefits

Managing a business in today's dynamic world has never been easy. The challenge is to do more with less and to make better decisions than competitors. Having constant access to current, actionable information has become need of time. The best decisions are made when all the relevant data is available and the best possible source for that data is a well-designed data warehouse.

A data warehouse is a database that is specifically designed to produce information for reporting and analysis. "Reporting and analysis" can be anything from listings of sales figures, to hi-tech dashboards, email alerts, ad-hoc reporting and drill-up, drill-down analytics. Data is extracted periodically from the applications that support business processes and copied onto special dedicated computers. There it can be validated, reformatted, reorganized, summarized, restructured, and supplemented with data from other sources. The resulting data warehouse becomes the main source of information for report generation, analysis, and presentation through ad-hoc reports and dashboards.

 
Program Objectives
At the end of the workshop, you will be able to:
  • understand data warehouse structures and architectures
  • implement a successful process for data warehouse testing
  • create basic queries to return data from a database
  • create queries to join data from multiple tables
  • utilize different filtering commands to narrow data results
  • make use of different aggregate SQL functions
  • manipulate and format data returned from queries
Suggested Audience
  • Manual Testers
  • Automation Engineers
  • Quality Assurance Analysts
  • Developers
  • Project Managers
  • anyone involved with providing software quality for data warehouses
Pre-Requisites
  • Knowledge of Manual Testing
  • Knowledge of SQL
Program Contents
  • 1. Data Warehousing Concepts
    • Data Warehouse Concepts, Design.
    • Need of Data Warehouse.
    • Introduction to OLTP, ETL and OLAP Systems.
    • Data Warehousing Architecture.
    • Dimensional Modeling.
    • Data Marts and ODS.
    • Star Schema and Snowflake Schema.
    • SCD (slowly changing dimension).
    • Types of Fact and Dimension Tables.
  • 2. SQL Concepts
    • Introduction to Oracle.
    • Basic Concepts in SQL.
    • Data Types.
    • Select statement usage.
    • Joins.
    • Sub Queries.
    • Performance Tuning Tips & Tricks.
  • 3. ETL Testing - Introduction
    • Introduction to ETL.
    • ETL Architecture.
    • What is the use of testing?
    • What is quality & standards?
    • Responsibilities of ETL Tester.
    • Sub Queries.
    • Performance Tuning Tips & Tricks.
 
  • 4. ETL Testing - Procedure
    • Steps in DWH Testing
    • Prerequisites of DWH Testing.
    • Levels of DWH Testing
    • The Data Warehousing process
    • Coverage of ETL Testing
    • How DWH Testing is Different from Application Testing?
    • Challenges in DWH Testing
  • 5. Testing Methodologies.
    • ETL Testing WorkFlow Process.
    • How to Prepare the ETL Test Plan.
    • How to design the Testcases in ETLTesting.
    • How to report the Bugs in ETL Testing.
    • ETL Testing Responsibilities.
    • How to detect the bugs through database queries.
    • ETL Performance Testing
  • 6. BO and Reports
    • Overview
    • Reports Testing Process
    • Components of BO Testing
  • 7. Query and tools
    • Informatica, Datastage, Cognos etc.
  • 8. Conclusion
Registration & Contact Details
Registration Fees: Contact Us
(Includes Veg Lunch, Coffee/Tea, Training Materials)

Note:
100% Advance payment is required to confirm the seat. Payment can be made through Cheque/DD in favour of "JupiterR Synergetic Solutions", payable at Bangalore.

Discounts Scheme
5% Discount for early Bird Registrations
  (15 Days in advance of the program date)
5% Discount on Task Force of 4 to 7
10% Discount on Task Force of 8 and above

Note:
Only one discount is applicable at a time.
JupiterR Synergetic Solutions
2nd Stage, BTM Layout, Bangalore - 560076, INDIA
Website: www.JSSinfotech.com
Email: info@JSSinfotech.com

Contact: Ravi
Hand Phone: 09535 555779
Email: info@JSSinfotech.com

Get in Touch jssinfotech jssinfotech

Data Warehouse Testing, Data Warehouse Testing Corporate Training, Data Warehouse Testing Trainers in India, Data Warehouse Testing Corporate Training in Bangalore, Data Warehouse Testing Corporate Training in Mysore, Data Warehouse Testing Corporate Training in Mumbai, Data Warehouse Testing Corporate Training in Pune, Data Warehouse Testing Corporate Training in Hyderabad, Data Warehouse Testing Corporate Training in Chennai, Data Warehouse Testing Corporate Training in Kolkata, Data Warehouse Testing Corporate Training in Noida, Data Warehouse Testing Corporate Training in Delhi, Data Warehouse Testing Corporate Training in Gurgoan, Data Warehouse Testing Corporate Training in Coimbatore, Data Warehouse Testing Corporate Training in NCR, Data Warehouse Testing Corporate Training in Nagpur,Data Warehouse Testing Corporate Training in Chandigarh, Data Warehouse Testing Corporate Training in Cochin, Data Warehouse Testing Corporate Training in Thailand, Data Warehouse Testing Corporate Training in South Africa, Data Warehouse Testing Corporate Training in Malaysia, Data Warehouse Testing Corporate Training in Singapore, Data Warehouse Testing Corporate Training in Philippines, Data Warehouse Testing Corporate Training in Indonesia, Data Warehouse Testing Corporate Training in Australia, Data Warehouse Testing Corporate Training in Brunei, Data Warehouse Testing Corporate Training in Kuwait, Data Warehouse Testing Corporate Training in Mexico, Data Warehouse Testing Corporate Training in China, Data Warehouse Testing Corporate Training in Egypt, Data Warehouse Testing Corporate Training in Jordon, Data Warehouse Testing Corporate Training in UAE, Data Warehouse Testing Corporate Training in Nepal, Data Warehouse Testing Corporate Training in Sri Lanka, Data Warehouse Testing Corporate Training in Bangladesh, Data Warehouse Testing Corporate Training in Maldives, Data Warehouse Testing Corporate Training in Luxembourg, Data Warehouse Testing Corporate Training in Qatar, Data Warehouse Testing Corporate Training in Kenya, Data Warehouse Testing Corporate Training in Oman, Data Warehouse Testing Corporate Training in Saudi Arabia, Data Warehouse Testing Corporate Training in Macau, Data Warehouse Testing Corporate Training in Hong Kong, Data Warehouse Testing Corporate Training in Kuala Lumpur, Data Warehouse Testing Corporate Training in Dubai, Data Warehouse Testing Corporate Training in Colombo, Data Warehouse Testing Corporate Training in Nigeria, Data Warehouse Testing Corporate Training in Johannesburg, Data Warehouse Testing Corporate Training in Bangkok, Data Warehouse Testing Corporate Training in Manila, Data Warehouse Testing Corporate Training in Jakarta, Data Warehouse Testing Corporate Training in Japan, Data Warehouse Testing Corporate Training in Cambodia, Data Warehouse Testing Corporate Training in Bahrain, Data Warehouse Testing Corporate Training in Abu Dhabi, Data Warehouse Testing Corporate Training in Muscat, Data Warehouse Testing Corporate Training in Lagos, Data Warehouse Testing Corporate Training in Durban, Data Warehouse Testing Corporate Training in Nairobi, Data Warehouse Testing Corporate Training in Mauritius, Data Warehouse Testing Corporate Training in Dhaka, Data Warehouse Testing Corporate Training in Kathmandu, Data Warehouse Testing Corporate Training in United Arab Emirates, Data Warehouse Testing Corporate Training in Bhutan, Data Warehouse Testing Corporate Training in Laos, Data Warehouse Testing Corporate Training in Turkey, Data Warehouse Testing Corporate Training in Istanbul, Data Warehouse Testing Corporate Training in Russia, Data Warehouse Testing Corporate Training in Moscow, Data Warehouse Testing Corporate Training in Myanmar, Data Warehouse Testing Corporate Training in Rangoon, Data Warehouse Testing Corporate Training in South Korea, Data Warehouse Testing Corporate Training in New Zealand, Data Warehouse Testing Corporate Training in Wellington, Data Warehouse Testing Corporate Training in Mongolia, Data Warehouse Testing Corporate Training in Kazakhstan, Data Warehouse Testing Corporate Training in Uzbekistan, Data Warehouse Testing Corporate Training in Riyadh, Data Warehouse Testing Corporate Training in Tokyo, Data Warehouse Testing Corporate Training in Pretoria, Data Warehouse Testing Corporate Training in Cape Town, Data Warehouse Testing Corporate Training in Sydney, Data Warehouse Testing Corporate Training in Canberra, Data Warehouse Testing Corporate Training in Austria, Data Warehouse Testing Corporate Training in Vienna, Data Warehouse Testing Corporate Training in Melbourne, Data Warehouse Testing Corporate Training in Bandar Seri Begawan, Data Warehouse Testing Corporate Training in Amman, Data Warehouse Testing Corporate Training in Male, Data Warehouse Testing Corporate Training in Abuja, Data Warehouse Testing Corporate Training in Phnom Penh, Data Warehouse Testing Corporate Training in Manama, Data Warehouse Testing Corporate Training in Port Louis, Data Warehouse Testing Corporate Training in Turkmenistan, Data Warehouse Testing Corporate Training in Doha - We are experts in providing Data Warehouse Testing Corporate Training in Bangalore, India. Data Warehouse Testing Workshop, Data Warehouse Testing Workshop in Bangalore, Data Warehouse Testing Workshop in Mysore, Data Warehouse Testing Workshop in Mumbai, Data Warehouse Testing Workshop in Pune, Data Warehouse Testing Workshop in Hyderabad, Data Warehouse Testing Workshop in Chennai, Data Warehouse Testing Workshop in Kolkata, Data Warehouse Testing Workshop in Noida, Data Warehouse Testing Workshop in Delhi, Data Warehouse Testing Workshop in Gurgoan, Data Warehouse Testing Workshop in Coimbatore, Data Warehouse Testing Workshop in NCR, Data Warehouse Testing Workshop in Nagpur,Data Warehouse Testing Workshop in Chandigarh, Data Warehouse Testing Workshop in Cochin, Data Warehouse Testing Workshop in Thailand, Data Warehouse Testing Workshop in South Africa, Data Warehouse Testing Workshop in Malaysia, Data Warehouse Testing Workshop in Singapore, Data Warehouse Testing Workshop in Philippines, Data Warehouse Testing Workshop in Indonesia, Data Warehouse Testing Workshop in Australia, Data Warehouse Testing Workshop in Brunei, Data Warehouse Testing Workshop in Kuwait, Data Warehouse Testing Workshop in Mexico, Data Warehouse Testing Workshop in China, Data Warehouse Testing Workshop in Egypt, Data Warehouse Testing Workshop in Jordon, Data Warehouse Testing Workshop in UAE, Data Warehouse Testing Workshop in Nepal, Data Warehouse Testing Workshop in Sri Lanka, Data Warehouse Testing Workshop in Bangladesh, Data Warehouse Testing Workshop in Maldives, Data Warehouse Testing Workshop in Luxembourg, Data Warehouse Testing Workshop in Qatar, Data Warehouse Testing Workshop in Kenya, Data Warehouse Testing Workshop in Oman, Data Warehouse Testing Workshop in Saudi Arabia, Data Warehouse Testing Workshop in Macau, Data Warehouse Testing Workshop in Hong Kong, Data Warehouse Testing Workshop in Kuala Lumpur, Data Warehouse Testing Workshop in Dubai, Data Warehouse Testing Workshop in Colombo, Data Warehouse Testing Workshop in Nigeria, Data Warehouse Testing Workshop in Johannesburg, Data Warehouse Testing Workshop in Bangkok, Data Warehouse Testing Workshop in Manila, Data Warehouse Testing Workshop in Jakarta, Data Warehouse Testing Workshop in Japan, Data Warehouse Testing Workshop in Cambodia, Data Warehouse Testing Workshop in Bahrain, Data Warehouse Testing Workshop in Abu Dhabi, Data Warehouse Testing Workshop in Muscat, Data Warehouse Testing Workshop in Lagos, Data Warehouse Testing Workshop in Durban, Data Warehouse Testing Workshop in Nairobi, Data Warehouse Testing Workshop in Mauritius, Data Warehouse Testing Workshop in Dhaka, Data Warehouse Testing Workshop in Kathmandu, Data Warehouse Testing Workshop in United Arab Emirates, Data Warehouse Testing Workshop in Bhutan, Data Warehouse Testing Workshop in Laos, Data Warehouse Testing Workshop in Turkey, Data Warehouse Testing Workshop in Istanbul, Data Warehouse Testing Workshop in Russia, Data Warehouse Testing Workshop in Moscow, Data Warehouse Testing Workshop in Myanmar, Data Warehouse Testing Workshop in Rangoon, Data Warehouse Testing Workshop in South Korea, Data Warehouse Testing Workshop in New Zealand, Data Warehouse Testing Workshop in Wellington, Data Warehouse Testing Workshop in Mongolia, Data Warehouse Testing Workshop in Kazakhstan, Data Warehouse Testing Workshop in Uzbekistan, Data Warehouse Testing Workshop in Riyadh, Data Warehouse Testing Workshop in Tokyo, Data Warehouse Testing Workshop in Pretoria, Data Warehouse Testing Workshop in Cape Town, Data Warehouse Testing Workshop in Sydney, Data Warehouse Testing Workshop in Canberra, Data Warehouse Testing Workshop in Austria, Data Warehouse Testing Workshop in Vienna, Data Warehouse Testing Workshop in Melbourne, Data Warehouse Testing Workshop in Bandar Seri Begawan, Data Warehouse Testing Workshop in Amman, Data Warehouse Testing Workshop in Male, Data Warehouse Testing Workshop in Abuja, Data Warehouse Testing Workshop in Phnom Penh, Data Warehouse Testing Workshop in Manama, Data Warehouse Testing Workshop in Port Louis, Data Warehouse Testing Workshop in Turkmenistan, Data Warehouse Testing Workshop in Doha - We are experts in providing Data Warehouse Testing Workshop in Bangalore, India. Data Warehouse Testing Training, Data Warehouse Testing Training in Bangalore, Data Warehouse Testing Training in Mysore, Data Warehouse Testing Training in Mumbai, Data Warehouse Testing Training in Pune, Data Warehouse Testing Training in Hyderabad, Data Warehouse Testing Training in Chennai, Data Warehouse Testing Training in Kolkata, Data Warehouse Testing Training in Noida, Data Warehouse Testing Training in Delhi, Data Warehouse Testing Training in Gurgoan, Data Warehouse Testing Training in Coimbatore, Data Warehouse Testing Training in NCR, Data Warehouse Testing Training in Nagpur,Data Warehouse Testing Training in Chandigarh, Data Warehouse Testing Training in Cochin, Data Warehouse Testing Training in Thailand, Data Warehouse Testing Training in South Africa, Data Warehouse Testing Training in Malaysia, Data Warehouse Testing Training in Singapore, Data Warehouse Testing Training in Philippines, Data Warehouse Testing Training in Indonesia, Data Warehouse Testing Training in Australia, Data Warehouse Testing Training in Brunei, Data Warehouse Testing Training in Kuwait, Data Warehouse Testing Training in Mexico, Data Warehouse Testing Training in China, Data Warehouse Testing Training in Egypt, Data Warehouse Testing Training in Jordon, Data Warehouse Testing Training in UAE, Data Warehouse Testing Training in Nepal, Data Warehouse Testing Training in Sri Lanka, Data Warehouse Testing Training in Bangladesh, Data Warehouse Testing Training in Maldives, Data Warehouse Testing Training in Luxembourg, Data Warehouse Testing Training in Qatar, Data Warehouse Testing Training in Kenya, Data Warehouse Testing Training in Oman, Data Warehouse Testing Training in Saudi Arabia, Data Warehouse Testing Training in Macau, Data Warehouse Testing Training in Hong Kong, Data Warehouse Testing Training in Kuala Lumpur, Data Warehouse Testing Training in Dubai, Data Warehouse Testing Training in Colombo, Data Warehouse Testing Training in Nigeria, Data Warehouse Testing Training in Johannesburg, Data Warehouse Testing Training in Bangkok, Data Warehouse Testing Training in Manila, Data Warehouse Testing Training in Jakarta, Data Warehouse Testing Training in Japan, Data Warehouse Testing Training in Cambodia, Data Warehouse Testing Training in Bahrain, Data Warehouse Testing Training in Abu Dhabi, Data Warehouse Testing Training in Muscat, Data Warehouse Testing Training in Lagos, Data Warehouse Testing Training in Durban, Data Warehouse Testing Training in Nairobi, Data Warehouse Testing Training in Mauritius, Data Warehouse Testing Training in Dhaka, Data Warehouse Testing Training in Kathmandu, Data Warehouse Testing Training in United Arab Emirates, Data Warehouse Testing Training in Bhutan, Data Warehouse Testing Training in Laos, Data Warehouse Testing Training in Turkey, Data Warehouse Testing Training in Istanbul, Data Warehouse Testing Training in Russia, Data Warehouse Testing Training in Moscow, Data Warehouse Testing Training in Myanmar, Data Warehouse Testing Training in Rangoon, Data Warehouse Testing Training in South Korea, Data Warehouse Testing Training in New Zealand, Data Warehouse Testing Training in Wellington, Data Warehouse Testing Training in Mongolia, Data Warehouse Testing Training in Kazakhstan, Data Warehouse Testing Training in Uzbekistan, Data Warehouse Testing Training in Riyadh, Data Warehouse Testing Training in Tokyo, Data Warehouse Testing Training in Pretoria, Data Warehouse Testing Training in Cape Town, Data Warehouse Testing Training in Sydney, Data Warehouse Testing Training in Canberra, Data Warehouse Testing Training in Austria, Data Warehouse Testing Training in Vienna, Data Warehouse Testing Training in Melbourne, Data Warehouse Testing Training in Bandar Seri Begawan, Data Warehouse Testing Training in Amman, Data Warehouse Testing Training in Male, Data Warehouse Testing Training in Abuja, Data Warehouse Testing Training in Phnom Penh, Data Warehouse Testing Training in Manama, Data Warehouse Testing Training in Port Louis, Data Warehouse Testing Training in Turkmenistan, Data Warehouse Testing Training in Doha - We are experts in providing Data Warehouse Testing Training in Bangalore, India.