All Categories
Get it between 2024-05-14 to 2024-05-21. Additional 3 business days for provincial shipping.
Unlike popular belief, Data Warehouse is not a single tool but a collection of software tools. A data warehouse will collect data from diverse sources into a single database. Using Business Intelligence tools, meaningful insights are drawn from this data.The best thing about “Learn Data Warehousing in 1 Day" is that it is small and can be completed in a day. With this e-book, you will be enough knowledge to contribute and participate in a Data warehouse implementation project.The book covers upcoming and promising technologies like Data Lakes, Data Mart, ELT (Extract Load Transform) amongst others. Following are detailed topics included in the bookTable contentChapter 1: What Is Data Warehouse?What is Data Warehouse?Types of Data WarehouseWho needs Data warehouse?Why We Need Data Warehouse?Data Warehouse ToolsChapter 2: Data Warehouse ArchitectureCharacteristics of Data warehouseData Warehouse ArchitecturesDatawarehouse ComponentsQuery ToolsChapter 3: ETL ProcessWhat is ETL?Why do you need ETL?ETL ProcessETL toolsChapter 4: ETL Vs ELTWhat is ETL?Difference between ETL vs. ELTChapter 5: Data ModelingWhat is Data Modelling?Types of Data ModelsCharacteristics of a physical data modelChapter 6: OLAPWhat is Online Analytical Processing?Types of OLAP systemsAdvantages and Disadvantages of OLAPChapter 7: Multidimensional Olap (MOLAP)What is MOLAP?MOLAP ArchitectureMOLAP ToolsChapter 8: OLAP Vs OLTPWhat is the meaning of OLAP?What is the meaning of OLTP?Difference between OLTP and OLAPChapter 9: Dimensional ModelingWhat is Dimensional Model?Elements of Dimensional Data ModelAttributesDifference between Dimension table vs. Fact tableSteps of Dimensional ModellingRules for Dimensional ModellingChapter 10: Star and SnowFlake SchemaWhat is Multidimensional schemas?What is a Star Schema?What is a Snowflake Schema?Difference between Start Schema and SnowflakeChapter 11: Data MartWhat is Data Mart?Type of Data MartSteps in Implementing a DatamartChapter 12: Data Mart Vs Data WarehouseWhat is Data Warehouse?What is Data Mart?Differences between a Data Warehouse and a Data MartChapter 13: Data LakeWhat is Data Lake?Data Lake ArchitectureKey Data Lake ConceptsMaturity stages of Data LakeChapter 14: Data Lake Vs Data WarehouseWhat is Data Warehouse?What is Data Lake?Key Difference between the Data Lake and Data WarehouseChapter 15: What Is Business Intelligence?What is Business IntelligenceWhy is BI important?How Business Intelligence systems are implemented?Four types of BI usersChapter 16: Data MiningWhat is Data Mining?Types of DataData Mining ProcessModelling