SIZ Approved Course | Data Warehousing And Data Mart | Lecture 03 | Meaning of Data Warehousing and Data Mart/Features and Important. By @goodybest
Good Day Excellence Members Of @siz-official!
I trust everyone is great! I wish you all a wonderful week. Once again welcome to my blog! Today, I will be taking us on my third lectures; Data warehousing. In our previous lectures, we've learned what data mining is, application of data mining, how data mining works, stages of data mining, process and techniques of data mining. Here goes the link to first and second lectures in case you missed it.
LECTURES | Link |
---|---|
Lecture 01 | Post |
Lecture 02 | Post |
Data warehousing includes the combinations of technology, methodologies tools and techniques, user management system and data manipulation systems.
What is Data Warehouse:
it is the collection of data usually current and historical from multiple databases that the organization can use for analysis and decision making.
WAREHOUSE: A warehouse is a subject oriented integrated, time-vibrant and non volatile collection of data in support of Management's decision making
- It is currently hold important position into the Market concerning the organization It is done for. It capture huge area in the present economy.
- it support management decision making process.
- it brings about the concept of data storage and synchronization according to the need of the data, some that has not been before.
- it brings key sets of data about or used by the organization into one place.
- Data source
- data loaders/data base management system (DBMS)
- query and analysis tools
Bringing together of so much data warehouse makes analysis difficult. To address this problem, an organization must use what we called Data Marts.
Is the grouping of related data together and separated from the main body of data in the data warehouse. Data marts are designed to be made available to specific set of users. For example, data about manufacturing may be gathered into a data Mart and be made accessible to the production department. On the other hand Human resources data can be gathered together and form another Data mart and be made available to the human resources employees. This approach makes it easier for each group or part of an organization to access the data they need.
There are significant and unique properties of data warehousing, some of that major ones are as follows;
DECISION MAKING SUPPORT: it provides a great support in the decision making process because it's core components involve all e major plans, methodologies and techniques that will be implemented to achieve the goal. Conceptualized and compiled form of data is nicely helpful in taking quick and accurate decisions.
Subject orientation: this warehousing is subject oriented data that is gathered from different sources and it has different background and applicational secularities. This helps in smoothing the company's regular operations because grounded knowledge about all required is available with the help of warehousing.
Integration: integration is another important and fundamental characteristics of warehouse. The data gathered from different sources are merged after compiling it in a single database which is dynamically and diversely applicable.
Time flexibility: it safe time because data stored at the warehouse are identified through the specific time period, according to the need of the data.
5)Non volatile form of data: it is one of the finest way to preserve the entire knowledge of the effective utilization in the future. The data stored here remain stable and safe. This makes data more reliable.
Mass storage: data can be stored in the large quantities according to the size of the warehouse. It depends on the organization, what kind of data and the amount of data they require to store for future use.
Accurate and grounded: data stored at the warehouse are accurate and grounded containing all the practically possible theories and techniques involved in preserving the data makes it discrete, effective and multi-dimentional.
This is where our lectures will end for today.
We've learn what data warehousing and data Mart is, these two very essential for any organization because it makes decision making of management easier and faster because accurate and easy data accessibility is available through data warehousing and Mart.
Our next lecture will highlight the need for data warehousing and data Mart. Thanks for reading through! See you in our next lectures.
CC:
@siz-official
@cryptokraze
@vvarishayy
@suboohi
![Polish_20211019_085851521.png](https://steemitimages.com/640x0/https://cdn.steemitimages.com/DQmd3rb4uubutXv2hYB8vKChx1ns11mxnxEre2gJ31gqy4o/Polish_20211019_085851521.png)
This is beautiful, i have learn something new.
I'm glad you liked it thanks for visiting my blog dear
Good one post dear friend keep it up bro and keep learn with our steem fellows and friends.
Regards, faran Nabeel
I really appreciate your nice commendations! Thanks for visiting dear.
This is lovely,I have learned something from your content:Data Warehouse is the collection of data usually current and historical from multiple databases that the organization can use for analysis and decision making.
Absolutely! Thanks for visiting dear, i really appreciate your nice commendations and I'm glad you find this post useful!
You are welcome.
Great work
God bless you
Thank you so much! I really appreciate your effort and I wish you God's blessings too