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
Try now
image.devices-Singapore 2x
Cover for Learn Data Warehousing in 24 Hours

Learn Data Warehousing in 24 Hours

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

Others also enjoyed ...

  1. Data as a Product: How to Provide the Data That the Company Needs
    Data as a Product: How to Provide the Data That the Company Needs Brian Murray
  2. Building Psychological Safety on Your Team
    Building Psychological Safety on Your Team Tom Henricksen
  3. Data Management
    Data Management Introbooks Team
  4. Learning from Data
    Learning from Data Introbooks Team
  5. Agile Manifesto: Unleashing Innovation, Collaboration, and Adaptive Excellence in Modern Development Practices
    Agile Manifesto: Unleashing Innovation, Collaboration, and Adaptive Excellence in Modern Development Practices Daniel Green
  6. (L)earn Bitcoin: Become Financially Sovereign
    (L)earn Bitcoin: Become Financially Sovereign Anita Posch
  7. Product Management for Beginners: Mastering the Fundamentals of Building Great Products
    Product Management for Beginners: Mastering the Fundamentals of Building Great Products James Ferry
  8. Mastering Megatrends: Understanding and Leveraging the Evolving New World
    Mastering Megatrends: Understanding and Leveraging the Evolving New World John Naisbitt
  9. A Joosr Guide to... Creativity, Inc by Ed Catmull: Overcoming the Unseen Forces That Stand in the Way of True Inspiration
    A Joosr Guide to... Creativity, Inc by Ed Catmull: Overcoming the Unseen Forces That Stand in the Way of True Inspiration Joosr
  10. Lean Business Plan Explained
    Lean Business Plan Explained Can Akdeniz
  11. Summary of Nate Silver's The Signal and the Noise
    Summary of Nate Silver's The Signal and the Noise IRB Media
  12. The Insider's Guide to Innovation @ Microsoft
    The Insider's Guide to Innovation @ Microsoft Dean Carignan
  13. Strategic Thinking
    Strategic Thinking Timo Santalainen
  14. Igniting the Invisible Tribe: Designing An Organization That Doesn't Suck
    Igniting the Invisible Tribe: Designing An Organization That Doesn't Suck Josh Allan Dykstra
  15. Behavioral Game Theory: Experiments in Strategic Interaction
    Behavioral Game Theory: Experiments in Strategic Interaction Colin F. Camerer
  16. A Joosr Guide to… How Google Works by Eric Schmidt & Jonathan Rosenberg
    A Joosr Guide to… How Google Works by Eric Schmidt & Jonathan Rosenberg Joosr
  17. Impact: Reshaping capitalism to drive real change
    Impact: Reshaping capitalism to drive real change Sir Ronald Cohen
  18. The Bitcoin Big Bang: How Alternative Currencies Are About to Change the World
    The Bitcoin Big Bang: How Alternative Currencies Are About to Change the World Brian Kelly
  19. Disruptive Innovation
    Disruptive Innovation Introbooks Team
  20. Sustainable Investing: What Everyone Needs to Know
    Sustainable Investing: What Everyone Needs to Know H. Kent Baker
  21. strategic marketing book ( English version )
    strategic marketing book ( English version ) Dr. Mostafa Nawareg
  22. The Adventures of an IT Leader
    The Adventures of an IT Leader Richard L. Nolan
  23. The Bible of Influence and Power: 23 Unbreakable Laws to Understand What People Think, How to Change Their Mind and Redirect Actions.
    The Bible of Influence and Power: 23 Unbreakable Laws to Understand What People Think, How to Change Their Mind and Redirect Actions. Halbert Ward
  24. An MBA in a Book: Everything You Need to Know to Master Business - In One Book!
    An MBA in a Book: Everything You Need to Know to Master Business - In One Book! Xander Cansell
  25. Capitalism without Capital: The Rise of the Intangible Economy
    Capitalism without Capital: The Rise of the Intangible Economy Stian Westlake
  26. Cash is King: Maintain Liquidity, Build Capital, and Prepare Your Business for Every Opportunity
    Cash is King: Maintain Liquidity, Build Capital, and Prepare Your Business for Every Opportunity Peter W. Kingma
  27. Revolutionizing Business Operations: How to Build Dynamic Processes for Enduring Competitive Advantage
    Revolutionizing Business Operations: How to Build Dynamic Processes for Enduring Competitive Advantage Tony Saldanha

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.

S$12.98 /month
3 days for free
  • 1 account

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

Try now

Unlimited Bi-yearly

For those who want to listen and read without limits.

S$69 /6 months
14 days for free
Save 11%
  • 1 account

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

Try now

Unlimited Yearly

For those who want to listen and read without limits.

S$119 /year
14 days for free
Save 24%
  • 1 account

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

Try now

Family

For those who want to share stories with family and friends.

From S$14.90/month
  • 2-3 accounts

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

2 accounts

S$14.90 /month
Try now