Types aggregate

Course content: "Teradata Admin Track" Teradata Architecture and other essentials Introduction What is Teradata and role of Teradata in Data Ware housing industry, Evolution of Teradata DW, Significant characteristics of Teradata, Advantages of Teradata over other RDBMS Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc...). Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index) Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations. (CLIQUE, CLUSTER, RAID, LOCKS and JORNALS) Advanced Teradata SQL HELP, SHOW, EXPLAIN, Define and execution of Macros, Date calculations, data type conversion, Case, COALESCE, sample, Ranking, Qualify, CSUM, MSUM, MDIFF, MAVG, WITH, WITH BY. Others (Optional) Unix Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects General phases of a Development project. Documents required in each phase DBA Teradata DBA basics and responsibilities Initial Teradata Databases Administrative User Owners, Parents and Children Creating New Users and Databases Transfer of Ownership DELETE/DROP Statements User and Security Management Understand the Heirarchy,Teradata Administrator tool usage to perform creation of users, databases, Identify spaces, skew of databases, Moving spaces and accesses, And all the practicals to perform of all coming up topics. The Data Dictionary Updating Data Dictionary Tables Supplied Data Dictionary Views Restricted Views Suffix Options with Views Selecting Information about Created Object Children View, Databases View, Users View, Tables View Columns View, Indices View Capacity management and planning Spaces and types of tables - PERM, SPOOL, TEMP space terminology, Derived,Volatile, Global temporary tables. Identify current space usage and estimate the space requirments for the applications. Users, Accounts, and Accounting Creating and Using Account IDs Using Account IDs with Logon Dynamically Changing an Account ID Account Priorities Account String Expansion Access Rights Privileges/Access Rights Implicit, Automatic, and Explicit Rights GRAND and REVOKE accesses, GIVE command System Views for Access Rights Inheriting Access Rights, Transfer access rights, Delete or Drop / user or database Roles and Profiles What is a role, Advantages of Roles, Access Rights Using a Role, Implementing Roles, Nesting of roles, views for roles, Profiles, implementing Profiles, Teradata password control Work load management and Priority scheduler Levels of Workload Management, Priority Scheduler Architecture, and concepts Access logging and Query logging Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View Performance monitoring (PMON) Resource usage, Session Management User session Info, SQL & Explain Steps Archive and Restore and copy Archive and restore data using ARCMAIN utility, Different levels of archiving and restoration, HUT locks, Revalidate references after restoration View point The Demo of view point portlets (which is new tool for DBAs having the features of PMON, TDMANAGER and TASM Performance tuning Explain plan, Statistics and Join strategies Explain plan and recommandations. Significance of collecting statistics Other indexes, and techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress. Course Content: Teradata Dev Track History and Architecture Introduction OLTP, OLAP systems, Dataware house and Data Marts, Dimenssion modeling, Schemas, What is Teradata and role of Teradata in DW, Evolution of Teradata DW, Advantages of Teradata over other RDBMS Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc…). Database structure Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index) Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE, CLUSTER, RAID, LOCKS and JORNALS) Spaces and types of tables Different levels of accessing the objects granting the Privileges and locking mechanism SQL ASNI SQL Brief introduction of Relational concepts, understanding users, databases, tables, vies, index, macro etc. Sub query, corelated query, Data types, Joins, Arthimatic functions Teradata SQL Explore teradata specifc SQL statements such as show, help,explain..SET operations, Aggregate functions, Sring functions, Aliasing,FORMAT, conversion of the datatypes. Advanced Teradata SQL Define and execution of Macros, Date calculations, Case, COALESCE, sample, Ranking, Qualify, CSUM, MSUM, WITH, WITH BY. Client utilities SQL Assistant Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT BTEQ Functinality,operations, exectuion and limitations FAST LOAD Functinality, Different phases, exectuion, restartability and limitations FAST EXPORT Functinality, Different phases, exectuion, restartability and limitations MULTI LOAD Functinality, Different phases, exectuion, restartability and limitations Performance tuning Explain plan & Statistics & Understanding Explain plan and recommandations. Significance of collecting statistics Other techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress Others (Optional) Unix Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects General phases of a Development project. Documents required in each phase

OBIEE 11g, OBIEE 10g, Siebel Analytics,Obia Dac Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions(SCD) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

Description for "Oracle OBIEE corporate training in India" OBIEE 11g, OBIEE 10g, Siebel Analytics,Obia Dac sadguru technologies 040-- Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions(SCD) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

Description for "Oracle OBIEE corporate training in India" OBIEE 11g , OBIEE 10g , Siebel Analytics ,Obia Dac Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions( SCD ) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

​Description for "Oracle OBIEE corporate training in India" OBIEE 11g , OBIEE 10g , Siebel Analytics ,Obia Dac sadguru technologies 040-40154733-8179736190 Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions( SCD ) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

Teradata Quality training && coaching in elegent it services 1)Introduction to Teradata Warehount it se Basics Parallel Design and Architecture 2)Data Distribution in Teradata Primary Index and its Types Secondary Index and its Types Partition Primary Index and its Types No Primary Index 3)Teradata Space Perm Space, Spool Space and Temp Space 4)Teradata Data Protection Concept of Transient Journal FALLBACK Clusters Down AMP Recovery Journal (DARJ) RAID CLIQUES 5)Teradata Locks Different Types of Locks and their Compatibility 6)Teradata Utilities Fast Export Fast Load TPUMP Multiload TPT 7)Teradata Utilities Commands SHOW HELP 8)Teradata-Basic SQL SELECT Command Usage of NULL in Comparison Operator Usage of IS NULL and IS NOT NULL Usage of IN and NOT IN Range search – BETWEEN Operator Creating Aliases Derived Columns Usage of GROUP BY, ORDER BY and HAVING CLAUSE 9)Teradata SQL – Five Aggregate Functions Usage of SUM function Usage of AVG function Usage of MIN function Usage of MAX function Usage of COUNT function 10)Teradata SQL – Interrogating Data / Data Transformations Data Formatting CAST NULLIFZERO, ZEROIFNULL and NULLIF COALESCE function CASE function 11)Formatting Date and Time Display Current Date, Time and Timestamp Extract function 12)Teradata SQL – String Manipulation TRIM function SUBSTRING function POSITION function INDEX function Concatenation function 13)Teradata OLAP functions CUMULATIVE function MOVING AVERAGE function Usage of OVER/Partition BY Clause RANK function SAMPLE function RANDOM function 14)Teradata DDL, DML, DCL CREATE TABLE – SET and MULTISET Constraint – UNIQUE and CHECK Data Compression CREATE Table with existing table ALTER, DROP, RENAME a table INSERT, UPDATE, DELETE command 15)Temporary Tables – Volatile and Global Volatile Temporary Table with example Global Temporary Table with example 16)Teradata – View, MACROS and Stored Procedures 17)Displaying TOTALS and SUBTOTALS in Reports Totals and SubTotals Total using WITH Subtotals using WITH BY clause 18)Teradata JOINS Why Joins ? LEFT OUTER JOIN RIGHT OUTER JOIN INNER JOIN CROSS JOIN SELF JOIN Join Strategies: •Duplication – Big Table Small Table •Redistribution – Big Table Small Table •Same AMP Join 19)Join Index – Denormalization in Teradata Single Table Join Index Multi-Table Join Index Aggregate Join Index Sparse Join Index Global Join Index Hash Index 20)Collect Statistics and Explain Collect Statistics Sample Collect Statistics Usage of Diagnostic HELP ON Explain – Decrypting the Optimizer Plan 21)Performance Tuning in Teradata – ‘TIPS and TECHNIQUES’ Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore - .Ph:-/87

COGNOS Course Content Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Cognos Course Detail COGNOS Course Content @ Learning Hub INTRODUCTION TO DATAWARE HOUSING (DWH) • Introduction to DWH • Characteristics of DWH • OLTP Vs OLAP Databases • Different Approaches of DWH (Kimball Vs Inmon) • Data mart Vs Data Warehouse • Fact Table Vs Dimension Table • Types Of Facts • Types Of Dimensions • ETL • Staging Area • Concepts of Schemas (Star schema & Snowflake schema) • CLP Modeling • Industry leading ETL and Reporting tools INTRODUCTION TO COGNOS • About Cognos • 3 – Tier Architecture • Cognos Release (EP series7, Reportnet , Cognos 8.0/8.1/8.2/8.3) and their differences • Features of Cognos 8.4 • Cognos Vs other OLAP tools • Cognos components (Modeling & Reporting) COGNOS CONNECTIONS • Personalize Cognos Connection • Create and manage portals, shortcuts, report views..etc • Running the Report Burn • Scheduling Reports • Various Options in Cognos Connection REPORT STUDIO • Report Studio User Interface • Creating, Save and run reports • Managing Reports. • Creating list, Cross Tab etc. • Report templates, formatting Reports – fonts, style, header, footer, boarder…etc • Filters, Parameters and Prompts • Subtotals and Calculations • Working with Queries • Generating and Creating Prompt Page • Types Of Reports • Types of Prompts • Types of Variables • Query Calculations & Layout Calculations • Filters and Dynamic Filters • Conditional Block • Conditional Formatting • Master Details • Cascading Prompt • Operators • Setting Burst Options • Drill through • Setting Variables • Report Functions • Report Validation • Reports Run with Options • Different types of Reports with various functionalities • Unions • Joins • Components and there properties. QUERY STUDIO • Introduction • About Ad-hoc Reports • Types of Report(List, Cross Tab, Chart Reports & Others) • Applying Filters, Prompts & Calculations • Sorting, Grouping, Sections & Aggregate Functions • Run and Manage reports ANALYSIS STUDIO • Insert Data • Nest Data • Replace Data • Sort Data • Explore Data • Change the measure • Drill down for Details • Hide Items • Insert a calculation • Save a custom set • Define a filter • Compare sets of data • Using Dynamic Context FRAMEWORK MANAGER • About Framework Manager • Framework Manager, Metadata Modeling • Creation of Interface and Usage • Creating Model & Namespace (Layers) • Importing Metadata • Naming convention for objects in a project • Creating Query Subjects & Query Items • Merging Query Subjects • Creating Relationships & Setting Cardinalities • Creating Parameter Maps & Macros • Creating of Model Filters, Prompts & Calculations • Add Business Rules and Set Governors • Assigning package level security • Improving performance • Publishing Package Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in

Type Tutoring The Best Informatica Online Training Institute From Hyderabad, India Course Content: DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations User Defined Functions Tasks And Types of Tasks Worklet and Types of Worklets Scheduling Work flow Constraint Based Load Ordering Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading Push Down Optimization PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches Static LookUp Cache Dynamic LookUp Cache Perisistance lookup Cache Shared LookUp Cache ETL UNIT TESTING ETL PERFORMANCE TESTING ETL PERFORMANCE OPTIMIZATION TECHNIQUES TASK IMPLEMENTATIONS Command EMAIL Timer Event Wait Event Raise Decision Assignment Control Worklet Session

INFORMATICA 9 ONLINE TRAINING Informatica is one of the best ETL Tool. Mentors Inn offers a comprehensive portfolio of training on a variety of Informatica solutions. With our expertise in the field of IT training offers you training customized to your needs. INFORMATICA 9 COURSE CONTENT DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture. Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations. User Defined Functions. Tasks And Types of Tasks. Worklet and Types of Worklets. Scheduling Work flow Constraint Based Load Ordering. Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading. Push Down Optimization. PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches. Static LookUp Cache Dynamic LookUp Cache Perisistance lookup Cache Shared LookUp Cache ETL UNIT TESTING ETL PERFORMANCE TESTING ETL PERFORMANCE OPTIMIZATION TECHNIQUES TASK IMPLEMENTATIONS. Command EMAIL Timer Event Wait Event Raise Decision Assignment Control Worklet Session

Informatica Online Training Institute From Pune India DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations User Defined Functions Tasks And Types of Tasks Worklet and Types of Worklets Scheduling Work flow Constraint Based Load Ordering Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading Push Down Optimization PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches Static LookUp Cache Dynamic LookUp Cache Perisistance lookup Cache Shared LookUp Cache

WARM WELCOME FROM VELGRO TECHNOLOGIES!!! We are providing training for DATA WAREHOUSE Training is provided by well experienced (REAL TIME) Faculty!!! Fee structure Course fees: RS./- Data Warehouse The Compelling Need for Data Warehousing • Escalating Need for Strategic Information • Failures of Past Decision-Support Systems • Operational Versus Decision-Support Systems • Datawarehousing—The Only Viable Solution • Datawarehouse Defined • The Datawarehousing Movement • Evolution of Business Intelligence Data Warehouse: The Building Blocks • Review formal definitions of a data warehouse • Discuss the defining features • Distinguish between data warehouses and data marts • Study each component or building block that makes up a data warehouse • Introduce metadata and highlight its significance Trends in Data Warehousing • Data Warehouse Do-Overs • Proliferation of Data Sources • Outsourcing • Hub Versus Relational Databases • Active Data Warehouses • Fusion with CRM • Growing Number of End Users • More Complex Queries • Integrated Customer View • Exploding Data Volumes Planning and Project Management • Phases in project management • Inception • Elaboration • Construction • Transition Defining the Business Requirements • To gain agreement with stakeholders • To provide a foundation to communicate to a technology service provider what the solution needs to do to satisfy the customer’s and business’ needs • To provide input into the next phase for this project • To describe what not how the customer/business needs will be met by the solution Requirements as the driving force for data warehousing • Understand why business requirements are the driving force • Discuss how requirements drive every development phase • Specifically learn how requirements influence data design • Review the impact of requirements on architecture • Note the special considerations for ETL and metadata • Examine how requirements shape information delivery The Architectural Components • Overall Architecture • Data Warehouse Database • Sourcing, Acquisition, Cleanup and Transformation Tools • Meta data • Data Marts • Data Warehouse Administration and Management Infrastructure as the Foundation for Data Warehousing • Understand the distinction between architecture and infrastructure • Find out how the data warehouse infrastructure supports its architecture • Gain an insight into the components of the physical infrastructure • Review hardware and operating systems for the data warehouse • Study parallel processing options as applicable to the data warehouse • Discuss the server options in detail • Learn how to select the DBMS • Review the types of tools needed for the data warehouse • Study the concept and use of data warehouse appliances The Significant Role of Metadata • Find out why metadata is so important • Understand who needs metadata and what types they need • Review metadata types by the three functional areas • Discuss business metadata and technical metadata in detail • Examine all the requirements metadata must satisfy • Understand the challenges for metadata management • Study options for providing metadata Principles of Dimensional Modelling • Clearly understand how the requirements definition determines data design • Introduce dimensional modelling and contrast it with entity-relationship modelling • Review the basics of the STAR schema • Find out what is inside the fact table and inside the dimension tables • Determine the advantages of the STAR schema for data warehouses Dimensional Modelling: Advanced Topics • Discuss and get a good grasp of slowly changing dimensions • Understand large dimensions and how to deal with them • Examine the snowflake schema in detail • Learn about aggregate tables and determine when to use them • Completely survey families of STARS and their application Data Extraction, Transformation, and Loading • Part I: When to build your data warehouse • Part II: Building a new schema • Part III: Location of your data warehouse The Physical Design Process in DWH • Distinguish between physical design and logical design as applicable to the data warehouse • Study the steps in the physical design process in detail • Understand physical design considerations and know the implications • Grasp the role of storage considerations in physical design • Examine indexing techniques for the data warehouse environment • Review and summarize all performance enhancement options • Matching Information to the Classes of Users OLAP in the Data Warehouse • OLAP (Online Analytical Processing) • Overview & Introduction • OLAP Cube • HISTORY of OLAP • OLAP Operations • DATAWAREHOUSE • ARCHITECHTURE Difference between OLAP & • OLTP & TYPES OF OLAP APPLICATIONS OF OLAP • Data Warehousing and the Web • Data Warehouse Deployment • Data Quality: A Key to Success • Data Mining Basics • Growth and Maintenance contact person: SUJITHA Venue Address: #st floor,Gandhi Road, Velachery Email Id:velgrotechnologies at gmail dot com info at velgrotechnologies dot com Website:www dot velgrotechnologies dot com

Best Informatica training institute in hyderabad india DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations User Defined Functions Tasks And Types of Tasks Worklet and Types of Worklets Scheduling Work flow Constraint Based Load Ordering Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading Push Down Optimization PMCMD Utility PMREP Utility Incremental Aggregation

J Meter Course Content Introduction: Overview of Performance Testing Performance Testing Concepts Performance Testing Types Why to use performance Testing tool? What is JMeter? Running JMeter: JMeter's Classpath Using a Proxy Server Non-GUI Mode Distributed Mode Introduction to Elements of JMeter Test Plan: Thread Group Controllers Samplers Logic Controllers Listeners Timers Assertions Configuration Elements Pre-Processor Elements Post-Processor Elements Building a Test Plan: Adding and Removing Elements Loading and Saving Elements Configuring Tree Elements Running a Test Plan Adding Users: Adding Default HTTP Request Properties Adding Cookie Support Adding HTTP Requests Adding Post-Processor for Correlation Adding a Listener to View/Store the Test Results Saving the Test Plan Running the Test Plan Recording Tests Using JMeter: Creation of Thread Group Adding HTTP Proxy Server Configuring HTTP proxy server Configuring the browser for recording the test script Capturing the test steps using JMeter Handling the dynamic server values: Handling User Sessions with URL Rewriting Using a Header Manager Handling the dynamic server values Parameterize the user sessions Parameterize with test data: Identifying the test data on AUT Open a csv file with JMeter Reading the data from CSV files Using the parameters in JMeterTests Adding Assertions to the test script: Validating the response data related issues Validating the response size related issues Validating the threshold for the server response times Running the tests and analyzing the Assertion results Building a Monitor Test Plan: Adding Server Adding HTTP Requests Adding Constant Timer Adding a Listener to View/Store the Test Results Adding Monitor Results Saving the Test Plan Running the Test Plan Running Mutiple Scripts with JMeter: Creating multiple test thread groups Calling the multiple thread groups from a test plan Configuring the threads groups with respetive users numbers and ratios Running the load test for multiple thread groups from a Single Test Analyze the user group specific issues Analyze the Test plan specific issues for all user groups Reporting and Analyzing the Results: Adding the Assertion Results and monitoring Configuring and Generating the Distribution Graph Configuring and Generating the Graph Full Results Generating the Monitor Results Saving the data through Simple Data Writer Configuring and Generating the Spline Visualizer Generating the Aggregate Graph for multi group test Generating the Aggregate Report for multi thread group test Generating the Summary Report Best Practices: Limit the Number of Threads Where to Put the Cookie Manager Where to Put the Authorization Manager Reducing resource requirements BeanShell server Distributed Testing Thanks&Regards Elegant IT Services, #nd Floor, Varthur main road, Opp Safal Fresh, Near Railway Fly Over,Maratha halli, Bangalore - .

JMETER ONLINE TRAINING,CORPORATE TRAINING,JOB SUPPORT AND INTERVIEW SUPPORT BY SOFTWARE EXPERTS FOR FREE DEMO contact us: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 1+214-628-3894 Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided JMETER COURSE CONTENT (we can modify the course agenda as per your requirement) Introduction • Overview of Performance Testing • Performance Testing Concepts • Performance Testing Types • Why to use performance Testing tool? • What is JMeter? • Running JMeter in distributed and standalone mode • Detailed explanation about Elements of JMeter • Building a Test Plan and Web Test Plan • Working with Default HTTP Request Properties • Adding Cookie Support, HTTP Requests, Post-Processor for Correlation • Adding a Listener to View/Store the Test Results • Running the Test Plan • Creation of Thread Group and • Adding and Configuring HTTP proxy server • Configuring the browser for recording the test script • Recording the AUT test steps using JMeter • Handling User Sessions with URL Rewriting • Handling the dynamic server values • Parameterize the user sessions • Parameterizing the tests using csv file • Validating the response data, size, threshold and response time related issues • Running the tests and analyzing the Assertion results • Adding Constant Timer and Monitor Results • Adding a Listener to View/Store the Test Results • Creating and Calling the multiple thread groups from a test plan • Configuring the threads groups with respective users numbers and ratios • Running the load test for multiple thread groups from a Single Test • Analyze the user group specific issues, • Analyze the Test plan specific issues for all user groups • Adding the Assertion Results and monitoring, • Configuring and Generating the Distribution Graph • Configuring and Generating the Graph Full Results • Generating the Monitor Results • Saving the data through Simple Data Writer • Configuring and Generating the Spline Visualizer • Generating the Aggregate Graph for multi group test • Generating the Aggregate Report for multi thread group test • Generating the Summary Report • Overview on working with WebServices and ODBC testing using JMeter FOR More Details contact us: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 1+214-628-3894

JMETER HANDS-ON ONLINE TRAINING,CORPORATE TRAINING BY HANDS-ON SOFTWARE TRAINERS FOR FREE DEMO contact: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 214-628-3894 Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided JMETER Course Content (we can customize the course Curriculum as per your requirements) • Overview of Performance Testing • Performance Testing Concepts • Performance Testing Types • Why to use performance Testing tool? • What is JMeter? • Running JMeter in distributed and standalone mode • Detailed explanation about Elements of JMeter • Building a Test Plan and Web Test Plan • Working with Default HTTP Request Properties • Adding Cookie Support, HTTP Requests, Post-Processor for Correlation • Adding a Listener to View/Store the Test Results • Running the Test Plan • Creation of Thread Group and • Adding and Configuring HTTP proxy server • Configuring the browser for recording the test script • Recording the AUT test steps using JMeter • Handling User Sessions with URL Rewriting • Handling the dynamic server values • Parameterize the user sessions • Parameterizing the tests using csv file • Validating the response data, size, threshold and response time related issues • Running the tests and analyzing the Assertion results • Adding Constant Timer and Monitor Results • Adding a Listener to View/Store the Test Results • Creating and Calling the multiple thread groups from a test plan • Configuring the threads groups with respective users numbers and ratios • Running the load test for multiple thread groups from a Single Test • Analyze the user group specific issues, • Analyze the Test plan specific issues for all user groups • Adding the Assertion Results and monitoring, • Configuring and Generating the Distribution Graph • Configuring and Generating the Graph Full Results • Generating the Monitor Results • Saving the data through Simple Data Writer • Configuring and Generating the Spline Visualizer • Generating the Aggregate Graph for multi group test • Generating the Aggregate Report for multi thread group test • Generating the Summary Report • Overview on working with WebServices and ODBC testing using JMeter FOR FREE DEMO contact: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 214-628-3894

Level 1: Introduction to PHP Installation Php Variables with all data types Type casting in php PHP operators in php Conditional statement Loop control PHP array Single dimensional array, Multi dimensional array Foreach loop for array Program with array String Handling in php Joining and Splitting String Comparing Strings Matching and replacing substrings Introduction to Regular Expressions Character sets and classes Repetition Subexpressions Counted Subexpressions Anchoring to the Beginning or End of a string Branching with Regular expression Matching Literal Special Characters Reviewing the Special Characters Matching and replacing substring with Regular Expressions Splitting string with Regular expressions Level 2: Introduction to Php functions Important Php string function Important Php array function Important mysql function Date & time function in php How to create user defined function Using parameters Understanding scope Returning values Calling by value versus calling by reference Implementing recursion Reusing codes Include,Require,Include_once,Require_once Level 3: Php File Handling Php Creating & Deleting a file Reading & Writing text files Working with directories in PHP Checking for existence of file Determining file size Opening a file for writing, reading or appending Writing Data to the file Reading Characters Using other useful file functions Level 4: Introduction to server variables Get,Post,Request,Files Small program with file upload What Session Control is? Understanding Basic Session Functionality What is a Cookie? Setting Cookies with PHP Using Cookies with Sessions Deleting Cookies Starting a Session Registering Session variables Using Session Variables Destroying the variables and Session Level 5: Php My-SQL Database Database Creation Creating Tables & Fields in MySQL Overview of Data Types in MySQL Introduction to SQL Executing DDL & DML Queries in MySQL Environment Database Normalization Introduction to Joins (Inner, left, right, etc.) Grouping & Aggregate Functions Sub Queries We are also providning training on java,.net,php,android, web desinging & grpahic desining. Dange Chowk Office: CNC WEB WORLD Sr. No. 51/2, Office No. -1, Landmark: Opp. Pandit Petrol Pump, On Hinjewadi Road Thergaon, Dange Chowk, Pune Swargate Office: 2nd Floor, Office No.202, Modi Plaza, Landmark: Opp.Laxmi Narayan Theatre

Introduction to Business Objects New features in SAP BO BI 4.0. Data Warehousing Architecture. Business Objects Architecture. SAP BO Data Modelling SAP BO ER Modelling SAP BO Dimensional Modelling Dimensional Tables. Fact Tables. other types of Dimension Tables Conformed Dimension Tables Junk Dimension Tables De generative Dimension Table Schema Star Schema Snowflake Schema Galaxy Schema Slowly Changing Dimensional Tables. Fact Table. Fact less Fact Table. SAP BO Different group of Facts or Measures Bridge tables.a Lookup Tables. Top Down Approach SAP BO Bottom Up Approach ODS SAP BO Data Mart Dependent Data mart. SAP BO Independent Data Mart Staging Area Granularity Normalization De normalization OLTP OLAP Types of OLAPs Oracle 10g (SQL) SAP BO Introduction to,Oracle Database,data category,SQL Statements,DDL – Data Definition Language, DML – Data Manipulation Language,DQL – Data Query language,DCL – Data Controlling language, TCS – Transaction Controlling Language. Built-in functions SAP BO Character objective,Numeric Functions,Data Activity,alteration Functions,Aggregate Functions. Joins SAP BO Inner attach,Left Outlying add,Right exterior Join,complete outer Join,Concubine Join, Self Join,generally Join. Set Operators Union,Union All,Intersect,Minus. ​Thanks & Regards Learners ERA, USA: India: + UK: +

Type Computer SAP BO Course Content: call +91- 1) INTRODUCTION TO SAP BO AND DATA WAREHOUSING OLTP vs. OLAP Types of OLAP Data mart/Data warehouse Life cycle Star/Snow/Extended Star schema design 2) DATABASE CONCEPTS Views/Materialized Views Date/Time Functions Conversion functions Derived table & Stored Procedure 3) ARCHITECTURAL OVERVIEW Client tier components Application tier components Intelligence tier Processing tier Data tier Security management Information flow 4) UNIVERSE DESIGN Understanding Business Objects Universes Creating the Course Universe Building the Universe Structure Creating Dimension Objects Creating Measure Objects Resolving Loops in a Universe Resolving SQL Traps Using List of Values Applying Restrictions on Objects Using @Functions with Objects Using Hierarchies Deriving Tables & Indexes Working with Aggregate Awareness Designing Advanced Objects Creating Predefined Condition LOVs & Joins Securing Universes Implementing Universe Life Cycle Mgmt Maintaining & Optimizing Universes Creating Universe from Other Data sources 5) WEB INTELLIGENCE Understand concepts of Web intelligence Create Web Intelligence documents with Queries Restrict data returned by a query Design a report Enhance the presentation of data in reports Format a report Calculate data with formulas and variables Use multiple data sources Analyze data Manage and share Web Intelligence documents Work with Advanced Query techniques Work with calculation contexts Create formulas with character & date string functions Use “If” logic Work with additional reporting techniques Create hyperlinks 6) Xcelcius/DASHBOARD BUILDER Understanding Dashboard Manager Setting Up Dashboard Manager Creating Metrics Automating Dashboards with Rules Creating Analytics Creating Personal Dashboards Creating Corporate Dashboards Guiding Dashboard Navigation 7) ADMINISTRATION Understand the Business Objects Enterprise interface & architecture Manage Business Objects Enterprise content Secure Business Objects Enterprise content Secure application security Schedule content Publish reports Identify Business Objects Enterprise architecture Perform common server management tasks Manage the Business Objects Enterprise servers 8) WEBI-RICH CLIENT Installing Web Intelligence Rich Client Web Intelligence Rich Client working modes Launching Web Intelligence Rich Client To set user preferences in Web Intelligence Rich Client Working with documents Working with universes in Web Intelligence Rich Client Accessing Web Intelligence from Info View Working with queries in Web Intelligence Rich Client Working with reports 9) UNIVERSE BUILDER & QUERY BUILDER Universe Builder basics Building universes from XML metadata sources Updating XML metadata source universes Exporting a universe to a XML file format 10) SECURITY IMPLEMENTATION Creating Secured users & group Creation secured connections Creation of Secured objects Creation of security at Table, Column &row level Creation of secured restriction set and mapping to users or groups 11) IMPORT WIZARDPUBLISHING WIZARD Using Import wizard Creation of BIAR Migrating the BO objects From one CMS TO ANOTHER CMS Migrating the objects from one domain to another (dev/stage/Prod) Backup & Maintenance Deployment OVERVIEW OF SAP BO 4.1 Comparison of SAP BO 3.x & 4.x For free Demo call +91 OBIEE, INFORMATICA, ODI, HADOOP,SAP BO, FICO, HANA, SD, MM, BPC, PM, ABAP online training also provided

Data Stage Course Content at Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Data Stage Data Stage Course Content at Learning Hub Contents • Introduction about Data Stage • Difference between Server Jobs and Parallel Jobs • Difference between Pipeline Parallelisms • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto) • Configuration File • Difference between SMP/MPD architecture • Data Stage Components (Server components/Client Components) • Package Installer Data Stage Administrator • Creating project, Editing project and Deleting project • Permissions to user • .Apt Config file • Environment variable creation, permission Data stage director • Introduction to Data stage Director • Job status View • View logs • Scheduling • Batches Creation Designer • Introduction about Designer • Repository • Palatte • Types of Links • File Stages • Sequential File • Data set File • Lookup file set • Difference between Sequential file/Dataset/File set • Database stages • Dynamic RDBMS • Oracle Enterprise • ODBC Enterprise • Stored Procedure Processing stages • Change Capture (Caption) • Compare stage • Difference Stage • Aggregate Stage • Transformer Stage • Surrogate Generator Stage • Join Generator Stage • Merge Generator Stage • Lookup Generator Stage • Difference between join/Lookup/Merge • Difference between join/Lookup • Remove Duplicates • Switch • Pivot • Modify • Funnel Debugging stage • Head • Tail • Pea • Row Generator • Column Generator • Sample • Job Parameters Manager • Introduction About Data stage Manager • Importing the Job • Exporting the Job • Importing Table Definition • Importing Flat File Definition • Routines Containers • Difference between Local Container and Shared Container • Local Container • Shared Container Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in Data Stage Online Training, Data Stage Class Room Training, Data Stage Training in Magarpatta City, Data Stage Jobs and Placement, Data Stage Remote Support, Data Stage Online Help,Data Stage Videos training, Data Stage training by Learning Hub, Fast track classes in Data Stage, Best Data Stage training institutes in Pune, Best Faculty in Data Stage, Best online Faculty in Data Stage, Professional classroom training in Data Stage, Professional online training in Data Stage,Data Stage Certification, Data Stage training in Dubai, Data StageTraining in Melbourne, Data Stage Training in Dubai, Data Stage Training, Data Stage Training,Data Stage Training, Data StageOnline Training, Data Stage certfication and suppor

Using aggregation Importing Aggregated Tables into Repository Modeling aggregate tables to speed processing Using variables Presentation Variables Repository variables Session variables Initialization Blocks Multiuser Environment (MUD) Overview on Multiuser Environment (MUD) How to create projects in MUD Checkout and checkin of projects Modeling time series data Types of SCDS Using of time series functions Modeling extension tables Purposes of extension tables Modeling extension tables for fact and dimensions Oracle BI Security

Table AU Corse Topics A)Introduction and Overview. •Why Tableau? Why Visualization? •Level Setting – Terminology •Getting Started – creating some powerful visualizations quickly •The Tableau Product Line •Things you should know about Tableau B)Getting Started •Connecting to Data and introduction to data source concepts •Working with data files versus database servers •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 C)Concepts and Options when Connecting to Data •Joining multiple tables •Data Blending •Copy and Paste •Data Extracts •Custom SQL •Publishing and Re-using Data Connections •Understand how to deal with data changes in your data source such as field addition, deletion or name change •Re-using and sharing data connections – the concept of meta data •Working with multiple connections in the same workbook D)Analysis •Creating Views 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 E)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 Trendlines F)Getting Started with Calculated Fields •Working with String Functions •Basic Arithmetic Calculations •Date Math •Working with Totals •Custom Aggregations •Logic Statements G)Formatting •Options in Formatting your Visualizations •Working with Labels and Annotations •Effective Use of Titles and Captions •Introduction to Visual Best Practices H)Building Interactive Dashboards •Combining multiple visualizations into a dashboard •Making your worksheet interactive by using actions and filters •An Introduction to Best Practices in Visualization I)Sharing Workbooks •Publish to Reader •Packaged Workbooks •Publish to Office •Publish to PDF •Publish to Tableau Server and Sharing over the Web

B. Arch is a five year graduate program in Architecture, design and structure of building covering the sociological, systematic and environmental aspects. The course seeks the students having skills like drawing, writing, exploration of the given topic, practical and managerial ability in identifying and solving problems and architectural presentation etc. The subjects for the Bachelor of Architecture include Mathematics, CADD, Urban Economics and Sociology History of Architecture and Interior Design etc. Promote immediately we have 140 seats in St.Peters with only 1lk donation r u there · Candidates should have passed 12th standard or equivalent examination with a minimum aggregate of 60% marks with Mathematics and English as subjects of study. · 50% marks with M.P.C can try n close. (Donation may range from 2Lk to 5Lk.) · Candidates should have passed National Aptitude Test in Architecture (NATA). · Students appeared for 10+2 examination in March /April are eligible to apply. · Candidates who have studied in Regular, Full Time and Formal Education are alone eligible to apply Advantages or Benefits of B. Arch Architecture is a profession for the people who have talents in artistic and aesthetic. There is always a demand for good architects so as to utilize the entire construction space in building projects. B. Arch course curriculum The B. Arch program is of 5 years and is alienated into two phases. The first phase covers the three year full time course and 20 weeks internship at any professional organization or building sites. The second phase is characterized with the preparation research paper, design thesis and also conduct seminars. The second phases is for a duration of 2 years and it can be consider as the more practical based approach of the theory part. The student is evaluated in each ten semesters and the degree is awarded at the end of the tenth semester. The academic covers the areas of arts which deals with the designing parts, drawing, fine arts etc. The other subjects for a B. Arch student are from engineering, humanities, and technology and expertise practice of architecture. B. Arch Specializations The specialization areas of the Bachelor of Architecture includes the following, Green Architecture. Landscape Architecture. Museum Architecture. Naval Architecture. Theatre Architecture. What to do after B. Arch? The students who want to do further studies in the field is to chose M. Arch after B.Arch. The higher studies option after B. Arch is Master of Technology in Construction of Project Management (M.Tech – CPM) Master of Technology in Environmental Planning (M.Tech – EP) Master of Technology in Housing (M.Tech. - HSG) Master of Technology in Infrastructure Planning (M.Tech – IP) Master of Technology in Urban and Regional Planning (M.Tech. - URP) Postgraduate Diploma Programme in Design (PGDPD) Job and Career options for B.Arch Employment Areas Architecture and Building Development Firms. Department of Post and Telegraph. Department of Railways. Job Types Architectural Technician. Architectural Theoretician. Architectural Conservator. Architectural Engineer. Since our county is in the developing phase more and more residential and non-residential constructions are needed every year. Admissions for B.Arch engineering Venu reddy: Contact information: ,040-. F.No.103,PrashantiRamTowersNearSaradhiStudioRoad,Ameerpet,Hyderabad Telangana, India

Tableau Advanced Online Training In Hyderabad India Tableau Course Description This course is designed for the beginner to intermediate-level Tableau user. It is for anyone who works with data – regardless of technical or analytical background. This course is designed to help you understand the important concepts and techniques used in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. D.Srinivas Contact Us' + Introduction and Overview •Why Tableau? Why Visualization? •Level Setting – Terminology •Getting Started – creating some powerful visualizations quickly •The Tableau Product Line •Things you should know about Tableau 2.Getting Started •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 3.Analysis Creating Views •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

Are you look for Tableau Online Training Course then take a gander at RStrainings, it gives best Online training by incredibly qualified trainers. Rstrainings gives all the live long day particular support organization. RStrainings gives free indicating sessions and live affiliation sessions. Briefly about Course: Introduction and Overview, Getting Started, Analysis, Creating Views, 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.

Look Here, Abinitio Online training gave through RStrainings by experienced trainers with effective training. It gives job oriented course substance, live scenarios and particular support. Our training organization center gives occupation masterminded course content and effective affiliation. Briefly about Course: Introduction to Abinitio, Abinitio Architecture, Graph Programming, Introduction to.dat and.dml files Partition Components, Braod Cast, Partition by Expression, partition by range, partition by community, partition by percentage, partition by Round Robin, Departition Components, Concatenate, Gather, Interleave, Merge, Multifile System(MFS), Types of parallelism, Layouts, Sort Components, Sort, Sort with in groups, Sample, Partition by key and sort, Transform Components, Filter by expression, Aggregate, Scan, Rollup, Denormalize Sorted, Normalize, Reformat, Match sorted, Dedup sorted.

Look Here, Abinitio Online training gave through RStrainings by experienced trainers with effective training. It gives job oriented course substance, live scenarios and particular support. Our training organization center gives occupation masterminded course content and effective affiliation. Briefly about Course: Introduction to Abinitio, Abinitio Architecture, Graph Programming, Introduction to.dat and.dml files Partition Components, Braod Cast, Partition by Expression, partition by range, partition by community, partition by percentage, partition by Round Robin, Departition Components, Concatenate, Gather, Interleave, Merge, Multifile System(MFS), Types of parallelism, Layouts, Sort Components, Sort, Sort with in groups, Sample, Partition by key and sort, Transform Components, Filter by expression, Aggregate, Scan, Rollup, Denormalize Sorted, Normalize, Reformat, Match sorted, Dedup sorted. Feel free to contact: Mobile No:

Abinitio Successful sap Training in elegant it services 2. Abinitio Architecture 3. Graph Programming 4. Introduction to.dat and.dml files 5. Partition Components a. Braod Cast b. Partition by Expression c. partition by range d. partition by community e. partition by percentage f. partition by Round Robin 6. Departition Components a. Concatenate b. Gather c. Interleave d. Merge 7. Multifile System(MFS) 8. Types of parallelism 9. Layouts 10. Sort Components a. Sort b. Sort with in groups c. Sample d. Partition by key and sort 9. Transform Components a. Filter by expression b. Aggregate c. Scan d. Rollup e. Denormalize Sorted f. Normalize g. Reformat h. Match sorted i. Dedup sorted 11. Working with Databases 12. Database components a. Run SQL b. Input Table c. Output Table d. Truncate Table e. Update table 13. Phase and check Points 14. Miscellaneous component a. Gather logs b. Run program c. Redefine format d. Trash e. Replicate 15. Dataset Components a. Input File b. Output File c. Lookup File d. Intermediate File 16. FTP Components a. FTP From b. FTP To 17. Compress Components a. Compress Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore - .Ph: -/87

Hurry offer course in Experience Faculty in it industry Abtinio,Abinitio in elegant it services. Introduction to Abinitio 2. Abinitio Architecture 3. Graph Programming 4. Introduction to.dat and.dml files 5. Partition Components a. Braod Cast b. Partition by Expression c. partition by range d. partition by community e. partition by percentage f. partition by Round Robin 6. Departition Components a. Concatenate b. Gather c. Interleave d. Merge 7. Multifile System(MFS) 8. Types of parallelism 9. Layouts 10. Sort Components a. Sort b. Sort with in groups c. Sample d. Partition by key and sort 9. Transform Components a. Filter by expression b. Aggregate c. Scan d. Rollup e. Denormalize Sorted f. Normalize g. Reformat h. Match sorted i. Dedup sorted 11. Working with Databases 12. Database components a. Run SQL b. Input Table c. Output Table d. Truncate Table e. Update table 13. Phase and check Points 14. Miscellaneous component a. Gather logs b. Run program c. Redefine format d. Trash e. Replicate 15. Dataset Components a. Input File b. Output File c. Lookup File d. Intermediate File 16. FTP Components a. FTP From b. FTP To 17. Compress Components a. Compress b. Uncompress c. Gzip d. Gunzip 18. Validate Component a. Check Order b. Generate Records c. Generate Random bytes d. Compare Records e. Compute Check Sum f. Compare Check Sum 19. Translate components a. Record XML b. Write XML 20. Project and Sandbox 21. Performance Tuning Thanks&Regards Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore

Are you look for Tableau Online Training Course then looking at RStrainings, it gives best Online training by incredibly qualified trainers. Rstrainings gives all the live long day particular support organization. RStrainings gives free indicating sessions and live affiliation sessions. Briefly about Course: Introduction and Overview, Getting Started, Analysis, Creating Views, 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. For more details: Mobile No:

Are you look for Tableau Online Training Course then looking at RStrainings, it gives best Online training by incredibly qualified trainers. Rstrainings gives all the live long day particular support organization. RStrainings gives free indicating sessions and live affiliation sessions. Briefly about Course: Introduction and Overview, Getting Started, Analysis, Creating Views, 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. Mobile No: