What Is a Data Warehouse?

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 81

  • @365DataScience
    @365DataScience  4 роки тому +2

    🚀Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sGBk7a

  • @optimisticnilhist
    @optimisticnilhist 4 роки тому +151

    A data warehouse is a single source of truth. It contains all the data of a company. It is a source of information. The features of the data warehouse are:
    1. Non Volatile: meaning data once stored will not go away.
    2. Summarized: The data is processed, segmented and stored so that analytics tool can use them
    3. Time Variant: It stores data for a period of time. It also contains historical data.
    4. Integrated: It has work with various analytics and reporting tools.
    5. Subject Oriented: Its stores data related to a subject.
    Data Warehouses are used for analysis and reporting and various analysis and reporting tools use data from the warehouse.

  • @ahmadrdadi8631
    @ahmadrdadi8631 4 роки тому +6

    the idea of a place that have a subject standard with history .can expanded to a lot of things like personal life . amazing !

  • @KalyanS
    @KalyanS 4 роки тому +2

    In datawarehusing we call it as single source but in MDM we call it as best version of truth. good content

  • @pobodjjd
    @pobodjjd 3 роки тому +4

    Simple, Clear and Accurate!

    • @tinanonn5957
      @tinanonn5957 3 роки тому

      What is the exact university specialization to study data warehouse

  • @ambikeya_tech
    @ambikeya_tech 6 місяців тому

    Great insights on data warehousing! Understanding its role in centralizing and analyzing large datasets is crucial for informed decision-making. Thanks for sharing this valuable information!

  • @aishwaryamurali450
    @aishwaryamurali450 2 роки тому

    Great Explanation in just 3 minutes ! woah !!!!

  • @atharvjadhav5992
    @atharvjadhav5992 2 роки тому +5

    You said that data warehouse is the single source of truth. But if the company has some other data which they want to store elsewhere then how and why would data warehouse be the single source of truth??

    • @IQuickscopeCA
      @IQuickscopeCA 2 роки тому +2

      Because that's their fault for not using the data warehouse. Not the data warehouse fault for not being given it.
      If a company wishes to store data in more than one place it's essential to either have a copy in the warehouse or sync the two up.
      If a company doesn't wish to do this, then it's just bad practice not the fault of the warehouse.

  • @juhimansinghani4279
    @juhimansinghani4279 3 роки тому +7

    This is amazing...and so easy to digest for someone who is new to the terms

  • @razibbaf
    @razibbaf Рік тому

    Excellent! Very good! Keep it up!

  • @slotstipstricks6016
    @slotstipstricks6016 4 роки тому +2

    Data warehousing is really one of the hottest topics in data science

  • @javaddsales7279
    @javaddsales7279 3 роки тому +3

    so... is it like a personal software or something of a company that allows access to its data? like, what does it "look" like?

    • @ravenswood118
      @ravenswood118 3 роки тому +2

      I'm also wondering this and I don't know why it's so hard to find the answer to this on the net.

    • @elyousfiomar3972
      @elyousfiomar3972 2 роки тому

      Apache Hive is an example of a data warehouse software.

  • @GodIsWithin3
    @GodIsWithin3 Рік тому

    Thank you!

  • @KESHA1982
    @KESHA1982 2 роки тому

    that was really funny explaining, thanks)

  • @KalyanS
    @KalyanS 3 роки тому +4

    Higly informative and excellent presentation.

  • @NikitaSharma-bs4gg
    @NikitaSharma-bs4gg 2 роки тому +1

    0:58 yesss

  • @hajarsaleh223
    @hajarsaleh223 2 роки тому

    thank you this was v. helpful

  • @Dipanki-c7k
    @Dipanki-c7k Місяць тому

    Which software you are using to edit videos

  • @exquisite___
    @exquisite___ 4 роки тому

    Explained well pal

  • @kingraidi1578
    @kingraidi1578 2 роки тому

    To my knowledge the aspect of summarized refers more to a higher level DW/ Data mart, right? The base DW should naturally have a very granular level in order to enable as many different operations on top as possible.

  • @ravenswood118
    @ravenswood118 3 роки тому +19

    I've watched 2833875 videos explaining what a data warehouse is and I still don't know if it's physical or just a drive

    • @tinanonn5957
      @tinanonn5957 3 роки тому

      What is the exact university specialization to study data warehouse

    • @collegehustler2001
      @collegehustler2001 2 роки тому +27

      Bro it's simple don't worry . Every data will be stored in database using DBMS (Database Management System or any other software) Software in a hard drive storage. These databases are then stored in a data warehouse . Databases are like books and data warehouse is a rack . Imagine you are placing all those books in a rack .

    • @ravenswood118
      @ravenswood118 2 роки тому +2

      @@collegehustler2001 IS IT PHYSICAL OR JUST A DRIVE

    • @collegehustler2001
      @collegehustler2001 2 роки тому +1

      @@ravenswood118 I think you don't have basics my brother hard drive means it's a physical device where you can store software or any data

    • @SnapThority
      @SnapThority 2 роки тому

      @@ravenswood118 WHY THE FUCK WOULD WE BE TALKING ABOUT A PHYSICAL WAREHOUSE IN A COMPUTER SCIENCE TOPIC WTF IS WRONG WITH YOU

  • @rahuldey6369
    @rahuldey6369 3 роки тому

    What if I want to retrieve different versions of the data, like I may need to have some previous dataset which was modified by now. Can I retrieve it from a data warehouse?

  • @shahzebmehdi1809
    @shahzebmehdi1809 4 роки тому

    Many thanks

  • @dhanushsivajaya1356
    @dhanushsivajaya1356 3 роки тому

    Thankyou sir

  • @MuhammadSaeed-uv6ls
    @MuhammadSaeed-uv6ls 4 роки тому +1

    Please make a video on how to become data analyst/scientist or business analyst in Pakistan?

  • @advokat-elzhana-kostadinova
    @advokat-elzhana-kostadinova 4 роки тому

    Great video!

  • @khadijamahmoud9069
    @khadijamahmoud9069 4 роки тому

    thanks !!!

  • @tinanonn5957
    @tinanonn5957 3 роки тому

    What is the exact university specialization to study data warehouse

  • @angelgray8899
    @angelgray8899 3 роки тому +2

    Thank you for this 💖

  • @SimonaDobreva
    @SimonaDobreva 4 роки тому

    very helpful explanation

  • @malakwaseem1166
    @malakwaseem1166 3 роки тому

    What is historical data in data warehousing?

  • @vladimirninov1614
    @vladimirninov1614 4 роки тому +2

    Very informative. Thanks for the great content.

  • @keelanparkes2630
    @keelanparkes2630 4 роки тому

    Love it!

  • @avayavinson6880
    @avayavinson6880 4 роки тому +2

    Very informative content as always!

  • @m.s.d2656
    @m.s.d2656 4 роки тому

    Do u hv data warehouse course or certification?

  • @mohmmadhussein3997
    @mohmmadhussein3997 2 роки тому

    really final final is so true 😂

  • @Cahangir
    @Cahangir Рік тому

    thanks

  • @Eaxillier
    @Eaxillier 3 роки тому

    yes

  • @suzannahwynn9740
    @suzannahwynn9740 4 роки тому

    Nice!

  • @abdurrahmankhyaal8270
    @abdurrahmankhyaal8270 2 роки тому +1

    Good

  • @raptyaxa5771
    @raptyaxa5771 2 роки тому +4

    So... it's a database?

    • @TECHNICALSALMAN123
      @TECHNICALSALMAN123 5 місяців тому +1

      Yes, Kind of! Only Used for Analytics and No Modification are allowed.

  • @envt
    @envt 2 роки тому

    Dwh is per definition not the single source of truth as it usually makes copy of data. The source of the data is always the truth and not the copy.

  • @vijax21
    @vijax21 4 роки тому

    Does 365 Data Science have any Data Governance and Data Stewardship course?

  • @LiveKitchenDinu
    @LiveKitchenDinu 3 роки тому +1

    superbbbbbb

  • @w1cecilia954
    @w1cecilia954 2 роки тому

    data warehouse
    final final really final ???
    what is the single source of data truth
    subject oriented: only interested data
    integrated: common standard
    time variant: historical data
    nonvolatile: can not be changrd or deleted
    summarized

  • @ahmedjguirim7237
    @ahmedjguirim7237 3 роки тому

    i'd go {final , final1, final2 ..}

  • @chinmaygaikwad7690
    @chinmaygaikwad7690 Рік тому

    Why you are telling that data warehousing is hardest topic in your intro.🤔

  • @MuhammadSaeed-uv6ls
    @MuhammadSaeed-uv6ls 4 роки тому +1

    I guess there is a data insecurity for competitive markets and buyers in data warehousing bcz no one should be willing to share final spreadsheets,am I correct?

  • @sobatbale4569
    @sobatbale4569 4 роки тому

    We needs practice, not just a teori

  • @_rd_kocaman
    @_rd_kocaman 3 роки тому

    The single source of truth is god. God is information of all kinds.

  • @danielkim1324
    @danielkim1324 8 місяців тому

    Is it just me or does he sound like Frodan

  • @shatwmhamad5438
    @shatwmhamad5438 3 роки тому

    👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻

  • @남재희-z4u
    @남재희-z4u 4 роки тому +1

    기호팍............
    더 이상 이런 과제는
    내지 말아주세요
    미워할거야............

  • @katy6402
    @katy6402 3 роки тому

    Lullaby

  • @mehdicharife2335
    @mehdicharife2335 Рік тому

    Offensively wrong and time-wasting.