2019’s Best Data Warehousing Books PDF, Notes, Course Data and Tutorials
Here you will get access to free Best Data Warehousing Books PDF, Notes and courses that will help you to boost your DATA Mining skills.
Introduction to Data Warehousing
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data in one single place that are used for creating analytical reports for workers throughout the enterprise
The data stored in the warehouse is uploaded from the operational systems (such as marketing or sales). The data may pass through an operational data store and may require data cleansing for additional operations to ensure data quality before it is used in the DW for reporting.
This Outline Will be similar with your University 2019 Course Outline for Data Warehousing Subject.
Introduction of the business context for data warehousing and decision support systems. Differences between TPS and DSS environments. Data extraction, transformation and loading (ETL and ELT), Data warehouse Architecture. Data Marts. Differentiate Data Marts and Data Warehouse. Data Warehouse Design Methodology: De-normalization and Dimensional Modeling. Online analytical processing (OLAP) and data aggregations. Indexing techniques used in data warehousing. Hardware and software systems consideration for data warehousing. Data warehouse maintenance.
Best Recommended Data Warehousing Books PDF, Tutorials and Notes for Universities:
Here is detailed list of best Data Warehousing Books for Universities:
Data Warehousing Fundamentals, 2nd Edition, Paulraj Ponniah
Building the Data Warehouse, 4th Edition, W. H. Inmon,
The Data Warehouse Toolkit, 2nd Edition Ralph Kimball and Margy Ross
Data Warehousing Video Tutorials
Data Warehousing Tutorial Videos by Edureka
Data Warehousing by VU Tube
Data warehouse and data mining by Last Moment Tuitions
All the data is extracted from HEC official website. The basic purpose for this to find all course subjects data on one page.