Spread Knowledge

Data Warehousing - CS614 - VU Video Lectures

View Video
987 Views
Rated 3
Why Data Warehousing?, The Need For A Data Warehouse, Crisis Of Credibility.
View Video
706 Views
Rated 3
What Is A Data Warehouse?.
View Video
514 Views
Rated 3
What Is A Data Warehouse?, How Is It Different? Why Keep Historical Data? Deviation From The PURIST Approach.
View Video
452 Views
Rated 3
Typical Queries , Putting The Pieces Together Why This Is Hard?, High Level Implementation Steps.
View Video
445 Views
Rated 3
Types And Typical Applications Of A Data Warehouse, Telecommunications Data Warehouse, Typical Applications Of A Data Warehouse, Major Issues.
View Video
413 Views
Rated 3
Normalization.
View Video
478 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
474 Views
Rated 3
Splitting Tables, Pre-Joining, Adding Redundant Columns, Derived Attributes.
View Video
409 Views
Rated 3
Storage Issues, Pre-Joining, Performance Issues, Pre-Joining, Adding Redundant Columns.
View Video
509 Views
Rated 3
Online Analytical Processing, Facts & Dimensions, OLAP FASMI Test.
View Video
457 Views
Rated 3
Multidimensional Online Analytical Processing, Cube Operations, MOLAP Implementation Issues.
View Video
431 Views
Rated 3
Relational OLAP, ROLAP And Space Requirement, Performance Vs. Space Trade-Off.
View Video
440 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
492 Views
Rated 3
The Process Of Dimensional Modeling. The Process Of Dimensional Modeling, Choosing The Grain, Choose Facts, Choose Dimensions.
View Video
398 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
504 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
384 Views
Rated 3
Issues Of Extract Transform Load, Complexity Of Required Transformations.
View Video
421 Views
Rated 3
Data Extraction & Transformation, Extracting Changed Data, Major Transformation Types.
View Video
432 Views
Rated 3
Data Cleansing, Lighter Side Of Dirty Data, 3 Classes Of Anomalies, Syntactically Dirty Data, Automatic Data Cleansing.
View Video
505 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
422 Views
Rated 3
Introduction To Data Quality Management (DQM), Total Quality Management (TQM), Cost Of Data Quality Defects.
View Video
489 Views
Rated 3
Quantifying Data Quality, Data Quality Assessment Techniques, Data Quality Validation Techniques.
View Video
436 Views
Rated 3
The House Of Quality Data Model, How To Improve Data Quality?, Misconceptions On Data Quality.
View Video
458 Views
Rated 3
Parallelism, When To Parallelize?, Speed-Up & Amdahl’s Law, Brief Intro To Parallel Processing, Shared Nothing RDBMS & Partitioning.
View Video
360 Views
Rated 3
Hardware Techniques, Speed-Up Calculation, Partitioning & Queries, Skew In Partitioning.
View Video
378 Views
Rated 3
Conventional Indexing Techniques, B-Tree Indexing, Hash Based Indexing.
View Video
606 Views
Rated 3
Special Indexing Techniques.
View Video
374 Views
Rated 3
Nested-Loop Join, Sort-Merge Join, Hash-Based Join.
View Video
407 Views
Rated 3
A Brief Introduction To Data Mining (DM), Data Mining Vs. Statistics.
View Video
372 Views
Rated 3
What Can Data Mining Do?, MARKET BASKET ANALYSIS.
View Video
440 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
382 Views
Rated 3
Layout The Project, Implementation Strategies, Development Methodologies.
View Video
387 Views
Rated 3
Goal Driven Approach, The Road Map Ralph Kimball’s Approach.
View Video
371 Views
Rated 3
Technical Architecture Design, Technology Track, Analytic Applications Track, Deployment, Maintenance And Growth.
View Video
401 Views
Rated 3
Five Signs Of Trouble, Eleven Possible Pitfalls, Top 7-Key Steps For A Smooth DWH Implementation.
View Video
397 Views
Rated 3
Implementation Life-Cycle.
View Video
379 Views
Rated 3
Agri-Data Warehouse, Economic Threshold Level ETL_A, A Simplified ERD Of The Agri System.
View Video
375 Views
Rated 3
Data Acquisition & Cleansing, Why The Issues?, Decision Support Using Agri-DWH.
View Video
352 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
391 Views
Rated 3
Web Warehouse Dimensions, Clickstream, Proxy Servers.
View Video
389 Views
Rated 3
Data Transfer Service (DTS).
View Video
409 Views
Rated 3
Lab Data Set.
View Video
431 Views
Rated 3
Extracting Data Using Wizard.
View Video
392 Views
Rated 3
Data Profiling.
View Video
363 Views
Rated 3
Data Transformation & Standardization.