Spread Knowledge

Data Warehousing - CS614 - VU Video Lectures

View Video
1687 Views
Rated 3
Why Data Warehousing?, The Need For A Data Warehouse, Crisis Of Credibility.
View Video
1268 Views
Rated 3
What Is A Data Warehouse?.
View Video
1047 Views
Rated 3
What Is A Data Warehouse?, How Is It Different? Why Keep Historical Data? Deviation From The PURIST Approach.
View Video
915 Views
Rated 3
Typical Queries , Putting The Pieces Together Why This Is Hard?, High Level Implementation Steps.
View Video
924 Views
Rated 3
Types And Typical Applications Of A Data Warehouse, Telecommunications Data Warehouse, Typical Applications Of A Data Warehouse, Major Issues.
View Video
898 Views
Rated 3
Normalization.
View Video
963 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
990 Views
Rated 3
Splitting Tables, Pre-Joining, Adding Redundant Columns, Derived Attributes.
View Video
869 Views
Rated 3
Storage Issues, Pre-Joining, Performance Issues, Pre-Joining, Adding Redundant Columns.
View Video
1023 Views
Rated 3
Online Analytical Processing, Facts & Dimensions, OLAP FASMI Test.
View Video
943 Views
Rated 3
Multidimensional Online Analytical Processing, Cube Operations, MOLAP Implementation Issues.
View Video
900 Views
Rated 3
Relational OLAP, ROLAP And Space Requirement, Performance Vs. Space Trade-Off.
View Video
941 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
1545 Views
Rated 3
The Process Of Dimensional Modeling. The Process Of Dimensional Modeling, Choosing The Grain, Choose Facts, Choose Dimensions.
View Video
853 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
981 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
839 Views
Rated 3
Issues Of Extract Transform Load, Complexity Of Required Transformations.
View Video
846 Views
Rated 3
Data Extraction & Transformation, Extracting Changed Data, Major Transformation Types.
View Video
916 Views
Rated 3
Data Cleansing, Lighter Side Of Dirty Data, 3 Classes Of Anomalies, Syntactically Dirty Data, Automatic Data Cleansing.
View Video
1614 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
903 Views
Rated 3
Introduction To Data Quality Management (DQM), Total Quality Management (TQM), Cost Of Data Quality Defects.
View Video
1166 Views
Rated 3
Quantifying Data Quality, Data Quality Assessment Techniques, Data Quality Validation Techniques.
View Video
924 Views
Rated 3
The House Of Quality Data Model, How To Improve Data Quality?, Misconceptions On Data Quality.
View Video
915 Views
Rated 3
Parallelism, When To Parallelize?, Speed-Up & Amdahl’s Law, Brief Intro To Parallel Processing, Shared Nothing RDBMS & Partitioning.
View Video
784 Views
Rated 3
Hardware Techniques, Speed-Up Calculation, Partitioning & Queries, Skew In Partitioning.
View Video
844 Views
Rated 3
Conventional Indexing Techniques, B-Tree Indexing, Hash Based Indexing.
View Video
1087 Views
Rated 3
Special Indexing Techniques.
View Video
803 Views
Rated 3
Nested-Loop Join, Sort-Merge Join, Hash-Based Join.
View Video
883 Views
Rated 3
A Brief Introduction To Data Mining (DM), Data Mining Vs. Statistics.
View Video
824 Views
Rated 3
What Can Data Mining Do?, MARKET BASKET ANALYSIS.
View Video
910 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
795 Views
Rated 3
Layout The Project, Implementation Strategies, Development Methodologies.
View Video
820 Views
Rated 3
Goal Driven Approach, The Road Map Ralph Kimball’s Approach.
View Video
801 Views
Rated 3
Technical Architecture Design, Technology Track, Analytic Applications Track, Deployment, Maintenance And Growth.
View Video
991 Views
Rated 3
Five Signs Of Trouble, Eleven Possible Pitfalls, Top 7-Key Steps For A Smooth DWH Implementation.
View Video
823 Views
Rated 3
Implementation Life-Cycle.
View Video
818 Views
Rated 3
Agri-Data Warehouse, Economic Threshold Level ETL_A, A Simplified ERD Of The Agri System.
View Video
918 Views
Rated 3
Data Acquisition & Cleansing, Why The Issues?, Decision Support Using Agri-DWH.
View Video
819 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
814 Views
Rated 3
Web Warehouse Dimensions, Clickstream, Proxy Servers.
View Video
801 Views
Rated 3
Data Transfer Service (DTS).
View Video
833 Views
Rated 3
Lab Data Set.
View Video
863 Views
Rated 3
Extracting Data Using Wizard.
View Video
789 Views
Rated 3
Data Profiling.
View Video
802 Views
Rated 3
Data Transformation & Standardization.