14 docs tagged with "tag1"

2.2.1 | Overview

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.1 | Overview

Let's go through some of the data model properties which we can configure.

The date dimension table is a crucial component of our data model and there are certain configurations necessary for it.

In this chapter, we will create a first simple visualization and explore different formatting options and ways to interact with a chart in Power BI.

After creating our first visualization, let's continue with different ways of filtering this chart on the report page.

In this chapter, we will create the first measures using DAX. First, I will explain how the code for a measure is structured. Following that, we will create four basic measures which I use in almost every BI solution in practice.

6.5.1 | Introduction

6.8.x | Workspace architecture

This is a template markdown file.

This is a template markdown file.

- Custom sorting