Lyt når som helst, hvor som helst

Nyd den ubegrænsede adgang til tusindvis af spændende e- og lydbøger - helt gratis

  • Lyt og læs så meget du har lyst til
  • Opdag et kæmpe bibliotek fyldt med fortællinger
  • Eksklusive titler + Mofibo Originals
  • Opsig når som helst
Start tilbuddet
DK - Details page - Device banner - 894x1036
Cover for Learn Data Warehousing in 24 Hours

Learn Data Warehousing in 24 Hours

2 Bedømmelse

3.5

Sprog
Engelsk
Format
Kategori

Fakta

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 (E-bog): 6610000317516

Udgivelsesdato

E-bog: 12. november 2021

Tags

    Andre kan også lide...

    1. Mastering Megatrends: Understanding and Leveraging the Evolving New World
      Mastering Megatrends: Understanding and Leveraging the Evolving New World John Naisbitt
    2. 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
    3. 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
    4. 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
    5. Building Psychological Safety on Your Team
      Building Psychological Safety on Your Team Tom Henricksen
    6. (L)earn Bitcoin: Become Financially Sovereign
      (L)earn Bitcoin: Become Financially Sovereign Anita Posch
    7. 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
    8. THE GREAT STOIC: PHILOSOPHIES, QUOTES AND WISDOM OF STOICISM: Master Stoic Resilience In Modern Life Without Overwhelming Effort
      THE GREAT STOIC: PHILOSOPHIES, QUOTES AND WISDOM OF STOICISM: Master Stoic Resilience In Modern Life Without Overwhelming Effort Steve Allayev
    9. The Business Battlecard: Winning Moves for Growing Companies
      The Business Battlecard: Winning Moves for Growing Companies Paul O'Dea
    10. Evolutionary Intelligence: How Technology Will Make Us Smarter
      Evolutionary Intelligence: How Technology Will Make Us Smarter W. Russell Neuman
    11. A Joosr Guide to... Good to Great by Jim Collins: Why Some Companies Make the Leap - and Others Don't
      A Joosr Guide to... Good to Great by Jim Collins: Why Some Companies Make the Leap - and Others Don't Joosr
    12. Real Life: Construction Management Guide from A-Z
      Real Life: Construction Management Guide from A-Z Jamil Soucar
    13. A Joosr Guide to... Business Adventures by John Brooks: Twelve Classic Tales from the World of Wall Street
      A Joosr Guide to... Business Adventures by John Brooks: Twelve Classic Tales from the World of Wall Street Joosr
    14. Summary of Nick Srnicek's Platform Capitalism
      Summary of Nick Srnicek's Platform Capitalism IRB Media
    15. 10 Golden Stars to Leadership Excellence: Accelerate your leadership development with modern theory and practice to build high-performance teams
      10 Golden Stars to Leadership Excellence: Accelerate your leadership development with modern theory and practice to build high-performance teams Dr Tom Dreyer
    16. Joe Public 2030: Five Potent Predictions Reshaping How Consumers Engage Healthcare
      Joe Public 2030: Five Potent Predictions Reshaping How Consumers Engage Healthcare Chris Bevolo
    17. 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
    18. Conversations That Change Everything: Turn Tension into Triumph: "Elevate your dialogue! Experience dynamic audio lessons designed to transform tension into triumphant conversations."
      Conversations That Change Everything: Turn Tension into Triumph: "Elevate your dialogue! Experience dynamic audio lessons designed to transform tension into triumphant conversations." Blaise Raynor
    19. [EPE Principle] Enter, Perform, Exit: Understanding The Opportunity Cycle
      [EPE Principle] Enter, Perform, Exit: Understanding The Opportunity Cycle Azeez Amida
    20. Summary of Karen Berman's Financial Intelligence
      Summary of Karen Berman's Financial Intelligence IRB Media
    21. The Anatomy of a Turnaround: Transforming an Organization by Prioritizing People, Performance, and Purpose
      The Anatomy of a Turnaround: Transforming an Organization by Prioritizing People, Performance, and Purpose Paul Kusserow
    22. Data Mesh: Comprehensive Guide on How to Become Truly Data-Driven
      Data Mesh: Comprehensive Guide on How to Become Truly Data-Driven Alex Campbell

    Vælg dit abonnement

    • Over 600.000 titler

    • Download og nyd titler offline

    • Eksklusive titler + Mofibo Originals

    • Børnevenligt miljø (Kids Mode)

    • Det er nemt at opsige når som helst

    Den mest populære

    Premium

    For dig som lytter og læser ofte.

    129 kr. /måned
    • 1 konto

    • 100 timer/måned

    • Eksklusivt indhold hver uge

    • Fri lytning til podcasts

    • Ingen binding

    Start tilbuddet

    Unlimited

    For dig som lytter og læser ubegrænset.

    159 kr. /måned
    • 1 konto

    • Ubegrænset adgang

    • Eksklusivt indhold hver uge

    • Fri lytning til podcasts

    • Ingen binding

    Start tilbuddet

    Family

    For dig som ønsker at dele historier med familien.

    Fra 179 kr. /måned
    • 2-6 konti

    • 100 timer/måned pr. konto

    • Fri lytning til podcasts

    • Kun 39 kr. pr. ekstra konto

    • Ingen binding

    2 konti

    179 kr. /måned
    Start tilbuddet

    Flex

    For dig som vil prøve Mofibo.

    89 kr. /måned
    • 1 konto

    • 20 timer/måned

    • Gem op til 100 ubrugte timer

    • Eksklusivt indhold hver uge

    • Fri lytning til podcasts

    • Ingen binding

    Prøv gratis