Velgro Technologies is one of the best training institute for Datawarehousing modules in Chennai. Datawarehousing Informatica is one of the most technology in demand in the world.We have designed course content and syllabus based on companies requirement .We provide 100% placement oriented , job oriented ,practical oriented Datawarehousing Informatica training in Chennai at Velgro Technologies .We provide morning batches , evening batches and weekend batches in Chennai as per students requirement.Our Datawarehousing training programs covers basic,intermediate,advanced level training in all modules of various technologies in Datawarehousing.Velgro Technologies is rated one of the best institute for Datawarehousing Datastage training in Chennai.

Concepts

• Reasons for data warehousing
• Terminology
• Data warehousing compared to OLTP
• Components of a data warehouse
• The data warehouse lifecycle
• Managing the data warehouse

Data Warehouse Design

• Discussion of how DW database design differs from transactional database design
• Grain
• Fact tables and Dimension tables
• Slowly changing dimension
• Time dimension
• Star and snowflake schema
• Denormalize from OLTP, planned redundancy
• Data marts and conformed dimensions
• Strategies for maintaining the data warehouse
• Metadata in a DW
• Security in a DW

OLAP Reports with Microsoft Excel

• Using Pivot Table Service (PTS) to see the business from different perspectives
• Create a Pivot Table from an OLAP cube
• Drill down, filter, sort, change dimensions
• Change calculations of a data field
• Add calculated fields Create a Pivot Chart from an OLAP cube
• Change PivotChart type
• Add a data table to a PivotChart
• Create Local Cubes
• Create OLAP-enabled web pages

OLAP Cubes Design with SQL Server Analysis Services

• Analysis services components and architecture
• Define dimensions with Dimension Editor
• Dimension levels and hierarchies
• Define cubes and measure with Cube Editor
• Process dimensions and cubes
• Cube storage design
• Create calculated members
• Virtual cubes
• Data Warehouse Partitions
• Implement drillthrough and cube writeback
• Understand Data Transformation Services (DTS)
• Understand Data Extraction, Transformation Loading Services (ETL)

Data Mining

• Introduction to data mining terminology and concepts

Course Duration:  2  to  3 Month, 2 hpd

Contact:  +91  7092284244

Mail:  info@velgrotechnologies.com