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. 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

    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.

    149 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