Designing an Effective Data Warehouse

( Duration: 4 Days )

Inadequate planning and management of data warehouse projects can lead to failed implementations and dissatisfied stakeholders. A successful data warehousing project involves precise planning and analysis to implement a data store as a basis for the business decision-making process. In Designing an Effective Data Warehouse training course, you will gain the skills needed to develop an effective data warehouse solution.

By attending Designing an Effective Data Warehouse workshop, delegates will learn to:

  • Deploy and maintain a data warehousing project
  • Apply dimensional modeling of the business process to evaluate data
  • Profile data to ensure source data quality
  • Extract, transform and load operational data
  • Employ Business Intelligence (BI) tools to slice and dice data
  • Explore data-mining techniques to provide business value



Introduction to Data Warehousing

  • Identifying data warehouse components
  • Analyzing failed installations
  • Top-down vs. bottom-up approach
  • Selecting the appropriate technique for your environment

Modeling the business process

  • Relating business processes to dimensions with a Bus Matrix
  • Reviewing denormalization techniques to optimize database read performance
  • Identifying the advantages of Star Schemas over Snowflake Schemas
  • Differentiating between normalized and renormalized system design
  • Enabling drill-up and drill-down reporting through the use of hierarchies

Building fact tables

  • Setting the grain of your fact tables to maintain a balance between flexibility and performance
  • Identifying primary keys and foreign keys
  • Tailoring business analysts' needs through the use of summary tables

Creating dimensions

  • Resolving date dimension issues
  • Exploring connections between separate events with conformed dimensions
  • Increasing model flexibility through the use of role-playing dimensions
  • Substituting surrogate keys for natural keys

Architecting the physical database

  • Mapping the logical data model to the physical data model
  • Evaluating hardware considerations
  • Choosing a method of data storage
  • Indexing and materialized views for performance

Ensuring data quality

  • Profiling source data
  • Configuring the database for change data capture
  • Refreshing the data warehouse

Extracting data from multiple sources

  • Connecting to different data sources
  • Databases
  • Spreadsheets
  • Text files

Transforming data during migration

  • Cleansing and scrubbing data
  • Mapping data elements and data types
  • Conforming dimensions and facts

Loading data into a data warehouse

  • Employing a staging database
  • Automating incremental data loading
  • Verifying success for data integrity

Identifying levels in the BI stack

  • Demonstrating SharePoint as a deployment platform
  • Utilizing Excel as a client tool for data analysis
  • Querying data from the OLAP server

Exploring business intelligence tools

  • Multidimensional cubes
  • Slicing and dicing your data
  • Surfacing Key Performance Indicators (KPIs) to evaluate the health of your organization

Taking advantage of industry-standard data-mining techniques

  • Identifying data-mining methodologies
  • Choosing the right data-mining tasks based on organizational needs

Planning for the future

  • Big Data and the impact on traditional data warehousing
  • Supplementing the traditional data warehouse to handle unstructured data
  • Dealing with large data sets via Hadoop

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.