📄️ 2.1 | Chapter overview
With this chapter I will give a general overview of Power BI, Power Query and most importantly the key components of a typical modern business intelligence solution.
📄️ 2.2 | Power BI
2.2.1 | Overview
📄️ 2.3 | Power Query
Power Query is a data transformation tool built into Power BI and Microsoft Excel. With Power Query, we can connect with various different data sources, extract required data and transform and load it into tables (dimensions and facts) which can be used to build the data model. This automated process is generally referred to as "ETL", whichs stands for extract, transform and load. Preparing data is necessary and important because data in its raw form stored in data sources is rarely in the shape required for a business intelligence solution and its data model architecture.
📄️ 2.4 | Building blocks of a business intelligence solution
2.4.1 | Overview
📄️ 2.5 | Sales demo use-case used in this book (download data)
The focus of this book is the step-by-step development of a close-to-practice use-case with a demo dataset consisting of multiple dimension and fact tables.