Spread Knowledge

Data Warehousing - CS614 - VU Video Lectures

View Video
1588 Views
Rated 3
Why Data Warehousing?, The Need For A Data Warehouse, Crisis Of Credibility.
View Video
1190 Views
Rated 3
What Is A Data Warehouse?.
View Video
970 Views
Rated 3
What Is A Data Warehouse?, How Is It Different? Why Keep Historical Data? Deviation From The PURIST Approach.
View Video
838 Views
Rated 3
Typical Queries , Putting The Pieces Together Why This Is Hard?, High Level Implementation Steps.
View Video
849 Views
Rated 3
Types And Typical Applications Of A Data Warehouse, Telecommunications Data Warehouse, Typical Applications Of A Data Warehouse, Major Issues.
View Video
825 Views
Rated 3
Normalization.
View Video
889 Views
Rated 3
What Is De-Normalization?, Why De-Normalization In DSS?, How De-Normalization Improves Performance?, Four Guidelines For De-Normalization, Areas For Applying, De-Normalization Techniques, Five Principal De-Normalization Techniques.
View Video
911 Views
Rated 3
Splitting Tables, Pre-Joining, Adding Redundant Columns, Derived Attributes.
View Video
800 Views
Rated 3
Storage Issues, Pre-Joining, Performance Issues, Pre-Joining, Adding Redundant Columns.
View Video
950 Views
Rated 3
Online Analytical Processing, Facts & Dimensions, OLAP FASMI Test.
View Video
859 Views
Rated 3
Multidimensional Online Analytical Processing, Cube Operations, MOLAP Implementation Issues.
View Video
826 Views
Rated 3
Relational OLAP, ROLAP And Space Requirement, Performance Vs. Space Trade-Off.
View Video
850 Views
Rated 3
Dimensional Modeling, The Need For ER Modeling?, Why ER Modeling Has Been So Successful?, What Is Data Model?, Quantifying Space Requirement.
View Video
1467 Views
Rated 3
The Process Of Dimensional Modeling. The Process Of Dimensional Modeling, Choosing The Grain, Choose Facts, Choose Dimensions.
View Video
780 Views
Rated 3
Classification Of Aggregation Functions, A Fact-Less Fact Table, Handling Multi-Valued Dimensions?, Creating A Current Value Field, Pros And Cons Of Handling, Junk Dimension.
View Video
905 Views
Rated 3
Extract Transform Load (ETL), Types Of Data Extraction, Logical Data Extraction Physical Data Extraction, Data Transformation, Significance Of Data Loading Strategies.
View Video
768 Views
Rated 3
Issues Of Extract Transform Load, Complexity Of Required Transformations.
View Video
772 Views
Rated 3
Data Extraction & Transformation, Extracting Changed Data, Major Transformation Types.
View Video
835 Views
Rated 3
Data Cleansing, Lighter Side Of Dirty Data, 3 Classes Of Anomalies, Syntactically Dirty Data, Automatic Data Cleansing.
View Video
1485 Views
Rated 3
Why Data Duplicated?, Problems Due To Data Duplication, Formal Definition & Nomenclature, Basic Sorted Neighborhood (BSN) Method, Limitations Of BSN Method.
View Video
824 Views
Rated 3
Introduction To Data Quality Management (DQM), Total Quality Management (TQM), Cost Of Data Quality Defects.
View Video
1069 Views
Rated 3
Quantifying Data Quality, Data Quality Assessment Techniques, Data Quality Validation Techniques.
View Video
844 Views
Rated 3
The House Of Quality Data Model, How To Improve Data Quality?, Misconceptions On Data Quality.
View Video
844 Views
Rated 3
Parallelism, When To Parallelize?, Speed-Up & Amdahl’s Law, Brief Intro To Parallel Processing, Shared Nothing RDBMS & Partitioning.
View Video
716 Views
Rated 3
Hardware Techniques, Speed-Up Calculation, Partitioning & Queries, Skew In Partitioning.
View Video
775 Views
Rated 3
Conventional Indexing Techniques, B-Tree Indexing, Hash Based Indexing.
View Video
1012 Views
Rated 3
Special Indexing Techniques.
View Video
725 Views
Rated 3
Nested-Loop Join, Sort-Merge Join, Hash-Based Join.
View Video
807 Views
Rated 3
A Brief Introduction To Data Mining (DM), Data Mining Vs. Statistics.
View Video
744 Views
Rated 3
What Can Data Mining Do?, MARKET BASKET ANALYSIS.
View Video
828 Views
Rated 3
Supervised Vs. Unsupervised Learning, Data Structure In Data Mining, How Clustering Works?, Clustering Vs. Cluster Detection, The K-Means Clustering.
View Video
722 Views
Rated 3
Layout The Project, Implementation Strategies, Development Methodologies.
View Video
747 Views
Rated 3
Goal Driven Approach, The Road Map Ralph Kimball’s Approach.
View Video
729 Views
Rated 3
Technical Architecture Design, Technology Track, Analytic Applications Track, Deployment, Maintenance And Growth.
View Video
863 Views
Rated 3
Five Signs Of Trouble, Eleven Possible Pitfalls, Top 7-Key Steps For A Smooth DWH Implementation.
View Video
751 Views
Rated 3
Implementation Life-Cycle.
View Video
740 Views
Rated 3
Agri-Data Warehouse, Economic Threshold Level ETL_A, A Simplified ERD Of The Agri System.
View Video
822 Views
Rated 3
Data Acquisition & Cleansing, Why The Issues?, Decision Support Using Agri-DWH.
View Video
744 Views
Rated 3
Reasons For Web Warehousing, Drawbacks Of Traditional Web Searches, How Client Server Interactions Take Place?, Low Level Web Traffic Analysis, High Level Web Traffic Analysis, Web Traffic Record.
View Video
744 Views
Rated 3
Web Warehouse Dimensions, Clickstream, Proxy Servers.
View Video
728 Views
Rated 3
Data Transfer Service (DTS).
View Video
760 Views
Rated 3
Lab Data Set.
View Video
788 Views
Rated 3
Extracting Data Using Wizard.
View Video
719 Views
Rated 3
Data Profiling.
View Video
730 Views
Rated 3
Data Transformation & Standardization.