|
|
|
You Will Learn How To
- Architect a robust data warehouse solution
- Ensure a targeted solution by identifying appropriate stakeholders and requirements
- Apply dimentional modeling to improve business decisions
- Extract, transform and load operational data based on organizational needs
- Employ Business Intelligence (BI) tools to slice and dice data
- Deploy, maintain and monitor an end-to-end data warehousing project
Course BenefitsInadequate 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.
Who Should AttendAnyone interested in implementing a data warehouse solution in their organization, and those who need to re-engineer an existing data warehouse. Prior experience with a data warehousing implementation and/or databases is helpful but not required.
Workshop CourseA continuing case study provides you with the skills to design, plan and implement a data warehouse roadmap. Exercises and workshop activities include:
- Analyzing the design to identify common flaws
- Collecting and analyzing business requirements
- Completing a database design using a modeling tool
- Designing facts and dimensions
- Extracting, transforming and loading data
- Employing Key Performance Indicators
- Assessing the impact of change requests
Course 2191 ContentIntroduction to Data Warehousing
- Identifying data warehouse components
- Analyzing failed installations
- Determining stakeholders
- Developing a roadmap for project implementation
Preparing an Implementation Plan
Establishing a foundation
- Program vs. project requirements
- Scoping the project and evaluating business justification
- Comparing Agile vs. waterfall methodologies
Monitoring progress of the roadmap
- Tracking stages and communicating milestones
- Managing project expectations
- Assessing risk and mitigation plans
Analyzing Organizational Data Requirements
Determining business requirements
- Assessing the business problem
- Validating organizational goals
- Identifying expected outcomes
Soliciting user requirements
- Choosing diverse participants
- Ranking feedback based on value to the enterprise
Establishing Dimensional Modeling
Modeling the business process
- Star and Snowflake schema
- OLTP vs. OLAP
- Multidimensional cubes
- Hierarchies
Comparing modeling techniques
- Inmon and the relational approach
- Kimball and the dimensional approach
- Selecting the appropriate technique for your environment
Evaluating the model
- Creating fact tables and dimensions
- Pivoting data in Excel to answer business questions
Building the Data Warehouse
Architecting the Physical Database
- Mapping the logical data model to the physical data model
- Evaluating hardware considerations
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 Business Intelligence 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
- Enumerating the components of the data tier
Exploring business intelligence tools
- Drill down through multidimensional hierarchies
- Surfacing Key Performance Indicators (KPIs) to evaluate the health of your organization
Deploying a Complete Data Warehouse Solution
Managing system deployment and support
- Assembling the testing group
- Organizing a pilot project
Taking advantage of industry standard tools and techniques
- Identifying available data warehousing tools
- Choosing the right tool based on organizational needs
- Adopting best practices
Planning for growth
- Controlling change management
- Choosing a method of data storage
- HOLAP
- MOLAP
- ROLAP
|
<< Back to Oracle Database Course List
Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
|
|
|
Training Dates
 | Most events below can be taken in-class or live, online from your home or office with AnyWare. |
For AnyWare enrollments, please register at least 7 days prior to the start of the course.
More Dates and Locations.
|
Tuition for Course 2191 (4 Days)
|
|
Bring this or any Learning Tree Course on-site to your location!
|
|
"I have to say that my Learning Tree Course experience was terrific! The sequencing of the content was exceptional, with lessons logically ordered for clarity. The instructor also did a great job of handling questions without derailing or delaying the course."
– B. Lakenan
Business Analyst
Arbitron, Inc.
|
|
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
