Summary
In this chapter, we analyzed a complete business case with the Northwind company's example, which could be closely related to the company's real-time problems. We talked about their reporting needs and how they initiated their own BI solution. Then, we had an overview of the BI Maturity Model, and we were able to identify that Northwind is in the initiation stage. After that, we learned how to get the Northwind sample database file and how to set up the ODBC connection on top of this database. Finally, we had an overview of the Northwind database model by introducing orders and inventory information contexts.
In the next chapter, we will build our first Universe using the ODBC connection that we created in this chapter. We will start with only one table in the Universe, and we will expand it as we are moving through the remaining chapters.