Section 4 Dataset

Dataset in PowerBI vocabulary is: the set of queries that the user will perform in order to import all of his data tables and all the transformations that will take place before data can be ready for the model and visualization.

We will perform 2 queries to create 2 data tables:

Table 1 (nyc_taxi_21) : will include NYC TLC data. https://github.com/Mkassem16/NycTaxiPBI/blob/main/queries/nyc_taxi_21.pq
Table 2 (Calendar) : Calendar table that will control the date dimension https://github.com/Mkassem16/NycTaxiPBI/blob/main/queries/Calendar.pq

4.1 Step 1

Getting data through Blank query get data

4.2 Step 2

Choose Advanced editor get data

4.3 Step 3

Get the query of Table 1 from the provided link and paste it here instead of what is already there get data ## Step 4

Make sure that query name is nyc_taxi_21 get data

4.4 Step 5

Get the query of Table 2 from the provided link and paste it here instead of what is already there get data

4.5 Step 6

Make sure that query name is Calendar get data

4.6 Step 7

Double check queries names as its important for Measures created through DAX, Then click close & apply get data