In today's world, there is a growing need for data warehousing and data processing. The goal of data warehousing is to have a company's historical data in one place and make analysis and business decisions based on these data. The challenge that is commonly mentioned when working with data is the fact that the data is remote from each other and resides in different documents or different databases. The need to merge the remote data into a single database has become a priority for many businesses today. One of the main benefits of data warehousing for businesses or clients is the ability to perform data analytics. Data analysis leads to making quality business decisions that contribute to the presence and growth of the company in today's competitive business environment. The topic of this paper is the process of data warehousing and the illustration of this process using the example of building a simple data warehouse. In the first part of this paper, the existing literature on data warehousing is reviewed and all the steps required to create and work with data warehouse are mentioned and discussed in detail. Also, two approaches to data warehousing, Inmon's and Kimball's model, are compared and their similarities and differences are evaluated. The second part of the paper deals with a practical example, which aims to bring closer and explain the construction of a data warehouse using the data of a fictitious company called Adventure Works Cycles as an example. The whole process of data warehousing is shown, i.e. this part starts with the representation of the data in the relational database and ends with the representation of the data suitable for analysis by the end- users. The technology and tools that have been used in this paper are modern tools from Microsoft that allow for quick and easy construction of data warehousing.