Data Management Introbooks Team
Listen and read
Step into an infinite world of stories
- Read and listen as much as you want
- Over 950 000 titles
- Exclusive titles + Storytel Originals
- Easy to cancel anytime
Learn Data Warehousing in 24 Hours
- By
- Publisher
- 2 Ratings
3.5
- Language
- English
- Format
- Category
Non-Fiction
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 book
Table content
Chapter 1: What Is Data Warehouse?
What is Data Warehouse?
Types of Data Warehouse
Who needs Data warehouse?
Why We Need Data Warehouse?
Data Warehouse Tools
Chapter 2: Data Warehouse Architecture
Characteristics of Data warehouse
Data Warehouse Architectures
Datawarehouse Components
Query Tools
Chapter 3: ETL Process
What is ETL?
Why do you need ETL?
ETL Process
ETL tools
Chapter 4: ETL Vs ELT
What is ETL?
Difference between ETL vs. ELT
Chapter 5: Data Modeling
What is Data Modelling?
Types of Data Models
Characteristics of a physical data model
Chapter 6: OLAP
What is Online Analytical Processing?
Types of OLAP systems
Advantages and Disadvantages of OLAP
Chapter 7: Multidimensional Olap (MOLAP)
What is MOLAP?
MOLAP Architecture
MOLAP Tools
Chapter 8: OLAP Vs OLTP
What is the meaning of OLAP?
What is the meaning of OLTP?
Difference between OLTP and OLAP
Chapter 9: Dimensional Modeling
What is Dimensional Model?
Elements of Dimensional Data Model
Attributes
Difference between Dimension table vs. Fact table
Steps of Dimensional Modelling
Rules for Dimensional Modelling
Chapter 10: Star and SnowFlake Schema
What is Multidimensional schemas?
What is a Star Schema?
What is a Snowflake Schema?
Difference between Start Schema and Snowflake
Chapter 11: Data Mart
What is Data Mart?
Type of Data Mart
Steps in Implementing a Datamart
Chapter 12: Data Mart Vs Data Warehouse
What is Data Warehouse?
What is Data Mart?
Differences between a Data Warehouse and a Data Mart
Chapter 13: Data Lake
What is Data Lake?
Data Lake Architecture
Key Data Lake Concepts
Maturity stages of Data Lake
Chapter 14: Data Lake Vs Data Warehouse
What is Data Warehouse?
What is Data Lake?
Key Difference between the Data Lake and Data Warehouse
Chapter 15: What Is Business Intelligence?
What is Business Intelligence
Why is BI important?
How Business Intelligence systems are implemented?
Four types of BI users
Chapter 16: Data Mining
What is Data Mining?
Types of Data
Data Mining Process
Modelling
© 2021 PublishDrive (Ebook): 6610000317516
Release date
Ebook: 12 November 2021
Tags
Others also enjoyed ...
- Data as a Product: How to Provide the Data That the Company Needs Brian Murray
- Crash Course Big Data Introbooks Team
- Data Mesh: What Is Data Mesh? Principles of Data Mesh Architecture Brian Murray
- Product Owner Training: Agile Product Ownership with Scrum Jimmy Mathew
- Data Mining and Analytics: Ultimate Guide to the Basics of Data Mining, Analytics and Metrics Alex Campbell
- Scrum Product Owner: 500 Certifications Questions with Answers and Explanations Jimmy Mathew
- 97 Principles for Software Architects: Axioms for software architecture and development written by industry practitioners Multiple Authors
- Data Visualization Guide: Clear Guide to Data Science and Visualization Alex Campbell
- Data Engineering: Analyzing Big Data and Modern Data Phil Gilberts
- Lights Out: An Into Darkness Novel Navessa Allen
4.5 - Harry Potter and the Philosopher's Stone J.K. Rowling4.7
- Fourth Wing (2 of 2) [Dramatized Adaptation]: The Empyrean 1 Rebecca Yarros4.8
- Fourth Wing Rebecca Yarros4.6
- Fourth Wing (1 of 2) [Dramatized Adaptation]: The Empyrean 1 Rebecca Yarros4.7
- A Court of Thorns and Roses (1 of 2) [Dramatized Adaptation]: A Court of Thorns and Roses 1 Sarah J. Maas4.3
- HOW TO WIN FRIENDS & INFLUENCE PEOPLE Dale Carnegie4.3
- Summary of Atomic Habits by James Clear Best Self Audio4.3
- From Blood and Ash (1 of 2) [Dramatized Adaptation]: Blood and Ash 1 Jennifer L. Armentrout4.3
- The 7 Habits On the Go: Timeless Wisdom for a Rapidly Changing World Stephen R. Covey4
- My Weird School Special: Hip, Hip, Hooray! Every Day Is a Holiday! Dan Gutman4.8
- Quicksilver: The Fae & Alchemy Series, Book 1 Callie Hart4.5
- Ikigai: The Japanese Secret Philosophy for a Happy Healthy Long Life With Joy and Purpose Every Day Marie Xue4.2
- Becoming Sherlock - The Red Circle Anthony Horowitz4.4
- How to Read People Like a Book: What Everyone Should Know About Body Language, Emotions and NLP to Decode Intentions, Connect Effortlessly, and Develop Effective Communication Skills Richard Hawkins3.1
Features:
Over 950 000 titles
Kids Mode (child safe environment)
Download books for offline access
Cancel anytime
Most popular
Unlimited
For those who want to listen and read without limits.
3 days for free
1 account
Unlimited Access
Unlimited listening
Cancel anytime
Unlimited Bi-yearly
For those who want to listen and read without limits.
14 days for free
Save 11%
1 account
Unlimited Access
Unlimited listening
Cancel anytime
Unlimited Yearly
For those who want to listen and read without limits.
14 days for free
Save 24%
1 account
Unlimited Access
Unlimited listening
Cancel anytime
Family
For those who want to share stories with family and friends.
2-3 accounts
Unlimited Access
Unlimited listening
Cancel anytime
2 accounts
S$14.90 /monthLanguage and region
English
Singapore
