Spread Knowledge

Data Warehousing - CS614 - VU Video Lectures

View Video
1242 Views
Rated 3
Why Data Warehousing?, The Need For A Data Warehouse, Crisis Of Credibility.
View Video
934 Views
Rated 3
What Is A Data Warehouse?.
View Video
736 Views
Rated 3
What Is A Data Warehouse?, How Is It Different? Why Keep Historical Data? Deviation From The PURIST Approach.
View Video
624 Views
Rated 3
Typical Queries , Putting The Pieces Together Why This Is Hard?, High Level Implementation Steps.
View Video
628 Views
Rated 3
Types And Typical Applications Of A Data Warehouse, Telecommunications Data Warehouse, Typical Applications Of A Data Warehouse, Major Issues.
View Video
600 Views
Rated 3
Normalization.
View Video
662 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
643 Views
Rated 3
Splitting Tables, Pre-Joining, Adding Redundant Columns, Derived Attributes.
View Video
578 Views
Rated 3
Storage Issues, Pre-Joining, Performance Issues, Pre-Joining, Adding Redundant Columns.
View Video
725 Views
Rated 3
Online Analytical Processing, Facts & Dimensions, OLAP FASMI Test.
View Video
636 Views
Rated 3
Multidimensional Online Analytical Processing, Cube Operations, MOLAP Implementation Issues.
View Video
594 Views
Rated 3
Relational OLAP, ROLAP And Space Requirement, Performance Vs. Space Trade-Off.
View Video
603 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
1236 Views
Rated 3
The Process Of Dimensional Modeling. The Process Of Dimensional Modeling, Choosing The Grain, Choose Facts, Choose Dimensions.
View Video
548 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
680 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
520 Views
Rated 3
Issues Of Extract Transform Load, Complexity Of Required Transformations.
View Video
564 Views
Rated 3
Data Extraction & Transformation, Extracting Changed Data, Major Transformation Types.
View Video
592 Views
Rated 3
Data Cleansing, Lighter Side Of Dirty Data, 3 Classes Of Anomalies, Syntactically Dirty Data, Automatic Data Cleansing.
View Video
763 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
594 Views
Rated 3
Introduction To Data Quality Management (DQM), Total Quality Management (TQM), Cost Of Data Quality Defects.
View Video
677 Views
Rated 3
Quantifying Data Quality, Data Quality Assessment Techniques, Data Quality Validation Techniques.
View Video
607 Views
Rated 3
The House Of Quality Data Model, How To Improve Data Quality?, Misconceptions On Data Quality.
View Video
617 Views
Rated 3
Parallelism, When To Parallelize?, Speed-Up & Amdahl’s Law, Brief Intro To Parallel Processing, Shared Nothing RDBMS & Partitioning.
View Video
494 Views
Rated 3
Hardware Techniques, Speed-Up Calculation, Partitioning & Queries, Skew In Partitioning.
View Video
551 Views
Rated 3
Conventional Indexing Techniques, B-Tree Indexing, Hash Based Indexing.
View Video
804 Views
Rated 3
Special Indexing Techniques.
View Video
517 Views
Rated 3
Nested-Loop Join, Sort-Merge Join, Hash-Based Join.
View Video
570 Views
Rated 3
A Brief Introduction To Data Mining (DM), Data Mining Vs. Statistics.
View Video
527 Views
Rated 3
What Can Data Mining Do?, MARKET BASKET ANALYSIS.
View Video
587 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
509 Views
Rated 3
Layout The Project, Implementation Strategies, Development Methodologies.
View Video
529 Views
Rated 3
Goal Driven Approach, The Road Map Ralph Kimball’s Approach.
View Video
494 Views
Rated 3
Technical Architecture Design, Technology Track, Analytic Applications Track, Deployment, Maintenance And Growth.
View Video
544 Views
Rated 3
Five Signs Of Trouble, Eleven Possible Pitfalls, Top 7-Key Steps For A Smooth DWH Implementation.
View Video
532 Views
Rated 3
Implementation Life-Cycle.
View Video
520 Views
Rated 3
Agri-Data Warehouse, Economic Threshold Level ETL_A, A Simplified ERD Of The Agri System.
View Video
564 Views
Rated 3
Data Acquisition & Cleansing, Why The Issues?, Decision Support Using Agri-DWH.
View Video
526 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
556 Views
Rated 3
Web Warehouse Dimensions, Clickstream, Proxy Servers.
View Video
525 Views
Rated 3
Data Transfer Service (DTS).
View Video
537 Views
Rated 3
Lab Data Set.
View Video
594 Views
Rated 3
Extracting Data Using Wizard.
View Video
523 Views
Rated 3
Data Profiling.
View Video
535 Views
Rated 3
Data Transformation & Standardization.