Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Oracle Databases Training









Preferred method of contact?

Designing an Effective Data Warehouse

COURSE TYPE

Practitioner

Course Number

2191

Duration

4 Days

Enroll

About This Course: 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 this course, you gain the skills needed to develop an effective data warehouse solution.

You Will Learn How 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

Course Outline

  • Introduction to Data Warehousing
  • Identifying data warehouse components
  • Analyzing failed installations
  • Top-down vs. bottom-up approach
  • Selecting the appropriate technique for your environment
  • Establishing Dimensional Modeling

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
  • Building the Data Warehouse

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
  • Leveraging BI for Data Analysis

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
  • Deploying a Complete Data Warehouse Solution

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
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Nov 7 - 10 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 15 - 18 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 13 - 16 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 10 - 13 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 17 - 20 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 21 - 24 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 14 - 17 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 2 - 5 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 16 - 19 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 13 - 16 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 26 - 29 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 15 - 18 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 29 - Sep 1 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“Our experience with AnyWare was extremely positive. The engineering students who attended online felt they had received the same high-quality presentation as those who participated in the classroom and, more importantly, the same rich lab experience they have come to expect from a Learning Tree Course.”

- R. Eldridge, Director, Services Education
EMC Corporation

Prev
Next