Course name: Business Intelligence and Emerging Technologies

Instructions:

Note: This is an individual assignment. This means every student must submit their own assignment.

1. Open your "MyFirstPowerBIModel" from Lab 1.

2. On the right pane (the Fields Pane), click Geography.

3. On the left pane, click data.

4. Record the number of rows and columns.

5. Go back to the Fields Pane, click Manufacturer, then data. Record the number of rows and columns.

6. Go back to the Fields Pane, click Product, then data. Record the number of rows and columns.

7. Go back to the Fields Pane, click Sales, then data. Record the number of rows and columns.

Questions:

1. What is the number of rows of Geography?

2. What is the number of columns of Geography?

3. What is the number of rows of Manufacturer?

4. What is the number of columns of Manufacturer?

5. What is the number of rows of Product?

6. What is the number of columns of Product?

7. What is the number of rows of Sales?

8. What is the number of columns of Sales?

9. What is the sum of the number of rows of Geography and the number of rows of Manufacturer?

10. What is the sum of the number of rows of Products and the number of rows of Sales?

Note: Please provide your answers in a pdf file.