Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




Data Warehousing and BI Certification

This web-based training course on Data Warehousing and BI Certification Course functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


Data Warehousing is a simple collection of data from multiple sources to give a good understanding to organizations at the time of strategic decision making. The main purpose of Data Warehousing is to provide people with a good understanding of the current business picture. Business Intelligence and Data Warehousing are very much related to each other. Business Intelligence refers to an established set of techniques and methodologies that help organizations in making critical and strategic decisions. Data Warehousing is basically used to eliminate all the data and performance issues. Business Intelligence usually processes information in a data warehouse. It is the task of Business Intelligence applications to united all sorts of data and presents it in a usable business information that can later help in tactical and strategic decision making.


Introduction to Dataware Housing

  • Core Concept-BI is the cube
  • Example cube as seen using Excel Pivot Table
  • Demonstrating of SSRS with cube as a Data Source

OLAP Modeling

  • Modeling source schemas-Star and Snowflake Schema
  • Understanding dimensional modeling-Dimensions (Type 1,2,or 3) or rapidly changing
  • Understanding fact (measures) and cube modeling

Using SSAS in Data Tools

  • Understanding the development environment
  • Creating Data Sources and Data Source Views
  • Creating cubes-using the UDM and the cube Build Wizard
  • Refining Measures and Dimensions

Intermediate SSAS

  • KPIs
  • Perspectives
  • Translations-cube metadata and Currency Localizations
  • Actions-regular, drill-through and reporting

Advanced SSAS

  • Using Multiple Fact Tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions, Fact(degenerate)dimensions, Role-playing dimensions, write back dimensions
  • Modeling changing dimensions-Dimension Intelligence Wizard
  • Using the Add Business Intelligence Wizards-write-back, semi-additive measures,time intelligence,account intelligence

Cube Storage and Aggregation

  • Storage topics-Basic aggregations
  • Advanced Storage Design-MOLAP,ROLAP,HOLAP
  • Partitions-relational and Analysis Services Partitions
  • Customizing Aggregation Design-Processing Design
  • Rapidly changing dimensions/ROLAP dimensions
  • Welcome to the Real Time-Proactive Caching
  • Cube Processing options
  • Audits and UBO

Beginning MDX(All Basics)

  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Most-used Functions & Common tasks
  • New MDX functions

Intermediate MDX

  • Adding Calculating members
  • Adding Scripts
  • Adding named sets

SSAS Administration

  • Best practices-health monitoring
  • XMLA scripting (SQL Server Management Studio)
  • Other Documentation methods
  • Security-roles and permissions

With the passage of time, the advancements made in Data Warehousing and Business Intelligence have assisted organizations in collecting and analyzing gigantic amounts of information that helps in making data-driven decisions. In the age of the customer-centered digital world, Business Intelligence has become a necessity for organizations. The utilization of data analytics, big data, data mining has helped businesses deliver quicker and better business solutions. For a business to survive in the long run, it's Business Intelligence needs to continuously evolve with the passing time.
For learners Data Warehousing and Business Intelligence has a great scope because there is an increasing demand for this concept among organizations all over the world. A Data Warehousing and Business Intelligence Certification training can turn tables for you in your professional career.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright© 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.