Data Warehousing Online Training
Data Warehousing Online Training Course Content:
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