SiliconIndia > Training Institutes > Anax
Anaeducation is part of ANAX Technologies Pvt. Ltd.
Ana Education is founded in Year 2006 and is run by highly qualified professionals with over 12 years of experience designing and building enterprise level Datawarehousing and Business Intelligence Solutions for corporates across the globe.
Our trainers and consultants are veterans of the Datawarehousing/Business Intelliglence industry bringing their expertise and implementation experience into the classroom. We, at Ana Education, are your career guide to give you a solid base with Datawarehousing and Business Intelligence training and project implementation, which gives you an advantage of a lucrative and fulfilling career.
Whatever stage you are at in your career, as a fresher from college, looking for a career switch, a promotion in your job or setting up your business consultancy, we give you the foundation and training to achieve your career goals. We are flexible and personalised with our training modules to suit your pace and schedule.
Our expertise is our dedicated team of trainers, who are consultants/implementation specialists with leading Datawarehousing / Business Intelligence project.
We look forward to open multiple franchisee at multiple location. For more details, feel free to contact us at enquiry@anaconsultancy.com
We offer training on all the tools, which are part of datawarehousing and business intelligence.
......................................................................................................................................................................................
We conduct training on topics such as
• PLSQL : Basic and Advanced
Erwin Data Modelling
Informatica : Basic and Very Advanced
DataStage
Business Objects
Cognos
Qlikview
Greenplum as Massively Parallel Processing
Database
......................................................................................................................................................................................
Architect Training Includes
Creation of Data Mapping
Requirement Gathering
High Level Design Preparation
Capacity Planning
Hardware and Software Configurations
Implementing Proof of Concepts
Project Methodology Implementation
SMP, OLTP, MPP, OLAP
Best approach
Licencing
......................................................................................................................................................................................
Find below the contents of Datawarehousing Concepts, which is a prerequisitie to learn any Datawarehousing or Business Intelligence tool:
   
Contact counselors
-----------------------------------------------------------------------
*Name  
*Email  
*Ph/mob  
*Location  
Message  
*Type the characters you see in the picture
Contact Us
Corporate Office: Mumbai
ANAX Technologies Pvt Ltd
S-3, 105, Vedant Commercial Complex,
Near Kores Road, Wartak Nagar
Thane- West 400606, Maharashtra, India.
Phone: +91 22 3220 9098, +91 90043 92652 Fax: +91 22 3220 9098
-----------------------------------------------------------------------
Regd Office : Delhi
ANAX Technologies Pvt Ltd
E-558, 2nd Floor, Palam Extn.
Ramphal Chowk, Sector-7, Dwark
New Delhi - 110075
Phone: +91 95608 55886, +91 11 4563 8041
-----------------------------------------------------------------------
Branch: Aurangabad
ANAX Technologies Pvt Ltd.
G-6, N5, Cidco, Jalna Road
Aurangabad - 431005, Maharashtra
Phone: +91 93210 61848
-----------------------------------------------------------------------
For Enquiry
For Sales
For Staffing
For Support
For enquiry
:
:
:
:
:
enquiry@anaconsultancy.com
sales@anaconsultancy.com
hr@anaconsultancy.com
support@anaconsultancy.com

anaconsultancy@gmail.com
DataWarehousing Introduction
  • Concepts
  • Definition
  • Types of Datawarehouse
  • Why and how to Implement Datawarehouse
  • OLTP vs Datawarehouse
  • Different approaches
  • Star / Snowflake / Galaxy Schema
  • Conformed Dimension
  • Factless Facttable
  • Identifying the best approach for implementation based on multiple criteria
  • Operational Data Store
  • Types of OLAPs
  • Which OLAP to use and when
  • Dimension and Fact Tables
  • Types of Dimension Tables and Measures
  • Normalization Types: 1st, 2nd, 3rd, 4th, 5th Normal Form
  • Pros and cons of normalization and denormalization
  • Identification and implementation of Granualarity
  • Repository, Catalogue, Metadata. Is this same or different
  • ETL/ELT/ETLT Architecture
  • Online Analytical Processing (OLAP)
  • Multi dimension Database (MDDB) / Cubes and its Functions
  • OLTP v/s OLAP systems
  • Analysis and Reporting
  • Aggregates
  • ETL (Extraction Transformation Load)
  • Data Aggregation
  • Data Cleansing
  • Data Dictionary
  • Data Extract
  • Designing Datawarehouse
  • Designing Business Intelligence
  • Benefits and high level features of Datawarehouse
  • What is Business Intelligence
  • Know about Business Intelligence applications
  • Business Intelligence applications activities
  • Why Business Intelligence?
  • Benefits of Business Intelligence
  • Business Intelligence Architecture
  • What is the main difference between Data warehousing and Business Intelligence?
  • Our Office
...........................................................................................................................................................................................................................................................................................