Power BI – GUIDE

Lab 1

Overview

VanArsdel is a company that manufactures and sells sporting goods. The company
has offices in the United States (US) and several other countries. Its sales
comprise of US sales and International sales. VanArsdel’s sales come from its
owned manufactured products, as well as other manufacturers’ products.

VanArsdel's US office stores the sales data on an Access database. VanArsdel

International sales transactions are available as comma separated (CSV) files.
They could be generated daily, either manually by someone, or automatically by an
automated process. They are available in a dedicated folder. These CSV files have
the same column structure as the sales table for the US sales that comes from the
SQL Database.

You want to perform analysis on VanArsdel's worldwide sales data for the year
2000 to 2015. You need to bring all these data into Power BI Desktop before you
can perform any analysis. Finally, you want to compare VanArsdel's country sales
with the country population. You need to import the country population data from a
less structured Excel report to Power BI.

LAB OVERVIEW
This lab comprises of three exercises:

1. In the first exercise, you will import data to Power BI Desktop from an
Access database file.

2. In the second exercise, you will import data from CSV files which resides in
a file folder. You will append this new data to the corresponding existing data that
comes from the Access Database.

3. In the third exercise, you will import data to Power BI Desktop from an Excel
file that is less structured.

Before starting this lab, you should review the Power BI Desktop Data
Transformations module in this course. Then, if you have not already done so,
follow the instructions in the Set up the Lab Environment section of this course to
set up the lab environment.
 WHAT YOU'LL NEED
 A computer with the latest version of Power BI Desktop installed on it.

 A copy of the Access Database containing VanArsdel's US sales data.

 4 CSV files, containing VanArsdel’s international sales data:

o CA Sales.csv

o FR Sales.csv

o DE Sales.csv

 MX Sales.csv

 An Excel file containing country population data.

NOTE: If you are having issues with the direct link, head over to the github
repository and download from
there. https://github.com/MicrosoftLearning/Analyzing-Visualizing-Data-PowerBI

Connecting to an Access Database for the first time

If you are connecting to an Access database for the first time, you might need to
install the Access redistributable package.

 If you have a 32 bit machine, you need to install the 32 bit Power BI Desktop
and the 32 bit redistributable of Access.

 If you have a 32 bit Office installed (regardless of your machine), you need
to install the 32 bit Power BI Desktop and the 32 bit redistributable of Access.

 Otherwise, you can install the 64 bit Power BI Desktop and the 64 bit
redistributable of Access.

 Follow the link provided by Power BI Desktop when trying to connect to the
Access database.

For more information , you can see:

Microsoft Access Database Engine: https://aka.ms/edx-dat207x-made
Power BI: https://aka.ms/edx-dat207x-pbi01
 Resolving issues importing Access and .XLS files in Power BI
Desktop: https://docs.microsoft.com/en-us/power-bi/desktop-access-database-
errors

Exercise 1- Import Data from Access Database

 Marcar esta página

Lab Steps
VanArsdel's US office stores the sales data on an Access database. You will need
to perform analysis on that data, but before you can do so, you need to import the
data to Power BI Desktop and perform some transformations.

IMPORTANT! Before you start, if your locale settings is not English (United
States), you might want to change this, since the data you will import is based on
this locale. This is covered in "Changing Locale".

1. Download the VanArsdel's Access database. Extract the file to

“C:\DAT207x”. You can use other folders, but if you are going to use the starter file
provided at each lab instead of your own file, then it is recommended to use the
absolute path given above in order to successfully perform the schedule refresh in
Lab 4.

NOTE: If you are having issues with the direct link, head over to the github
repository and download from
there. https://github.com/MicrosoftLearning/Analyzing-Visualizing-Data-PowerBI

2. Click Start.
3. Type Power BI Desktop.
4. Click Get data.
5. Click Access database, and click Connect.
6. Navigate to C:\DAT207x, click PowerBI.accdb, and click Open.
7. Select bi_date, bi_geo, bi_manufacturer, bi_product,
and bi_salesFact and click Edit.
8. In Queries, select bi_salesFact.
9. Select the Date column.
10. Click the Transform ribbon.
11. In the Any Column group, select Data Type and select Date.
12. Click the drop-down button at the top of the Date column.
13. Click Date Filters and click After.
14. In the first Enter or select a value field, type 12/31/1999 if you are using
DD/MM/YYYY dates and 31/12/1999 if you are using DD/MM/YYYY dates and
click OK.
15. In Queries, select bi_Date.
16. Select the Date column.
17. Click the Transform ribbon.
18. In the Any Column group, select Data Type and select Date.
19. Click the drop-down button at the top of the Date column.
20. Click Date Filters and click After.
21. In the first Enter or select a value field, type 12/31/1999 if you are using
DD/MM/YYYY dates and 31/12/1999 if you are using DD/MM/YYYY dates and
click OK.
22. Rename the queries as follows:

 In Queries, right click bi_date, click Rename, replace the text with Date, and

press Enter.

 In Queries, right click bi_geo, click Rename, replace the text with Locations, and

press Enter.

 In Queries, right click bi_manufacturer, click Rename, replace the text

with Manufacturers, and press Enter.

 In Queries, right click bi_product, click Rename, replace the text with Products,

and press Enter.

 In Queries, right click bi_salesFact, click Rename, replace the text with Sales,

and press Enter.

1. Click the Home ribbon.

2. Click Close and Apply.

3. Click Data and explore the imported data in the Data View.

Lab Questions 1
5.0/5.0 points (graded)

Answer the following question by reviewing the imported data in Power BI Desktop.
(Hint: Use the Data view).
How many rows were imported from the Date query?
5844
  correcto 

5844 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 2
5.0/5.0 points (graded)

How many rows were imported from the Locations query?

99618
  correcto 

99618 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 3
5.0/5.0 points (graded)

How many rows were imported from the Manufacturer query?

14
  correcto 

14 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 4
5.0/5.0 points (graded)
 How many rows were imported from the Products query?
2412
  correcto 

2412 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 5
5.0/5.0 points (graded)

How many rows were imported from the Sales table?

9985368
  correcto 

9985368 

Exercise 2- Import Data from a Folder Containing

CSV Files
 Marcar esta página

Continue with your Power BI file from the previous exercise. You want to create a
Query for the International sales and append the Query to the Query from US
Sales.

1. Download the zip file containing VanArsdel's international sales data.

Extract the file to “C:\DAT207x”. You can use other folders, but if you are going to
use the starter file provided at each lab instead of your own file, then it is
recommended to use the absolute path given above in order to successfully
perform the schedule refresh in Lab 4. You should see 4 CSV files in the
"C:\DAT207x\International" folder.
2. On the Home ribbon, click Get Data, click Folder, and click Connect.
3. In Folder path, type C:\DAT207x\International, and click OK.
4. Click Edit.
5. In QUERY SETTINGS change the name to International Sales.
6. On the Content header, click Combine Files.
7. Click OK.
8. Click File, click Options and settings, and click Options.
9. Click Regional Settings and, in Locale for import, select English (United
States).
10. Click OK.
11. Select the Date column.
12. Click the Transform ribbon.
13. In the Any Column group, select Data Type and select Date.
14. Click Replace current.
15. Click the drop-down button at the top of the Date column.
16. Click Date Filters and click After.
17. In the first Enter or select a value field, type 12/31/1999 if you are using
DD/MM/YYYY dates and 31/12/1999 if you are using DD/MM/YYYY dates and
click OK.
18. In Queries, select Sales.
19. On the Home ribbon, click Append Queries.
20. Select International Sales and click OK.
21. On the Add Column ribbon, click Custom Column.
22. In New column name type Country Name.
23. To replace null values with USA, in Custom column formula, type the
following formula and click OK:

=if [Country] = null then "USA" else [Country]

1. Right-click the header of the Country column and click Remove.

2. Click the Home ribbon.

3. Click Close & Apply.

4. Click Data and explore the imported data in the Data View.

Lab Questions 1
4.0/4.0 points (graded)

Answer the following question by reviewing the imported data in Power BI Desktop.
(Hint: Use the Data view).

How many rows were imported from the International Sales query?
797244
  correcto 

797244 
Enviar
 Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 2
4.0/4.0 points (graded)

How many rows are now in the Sales query?

10782612
  correcto 

10782612 

Exercise 3- Import a Less Structured Data from an

Excel File
 Marcar esta página

Continue with your Power BI file from the previous exercise. You want to import an
Excel report containing population data for the countries that VanArsdel operates.

1. Download the zip file containing the Country Population data. (Data is a

subset of the “World Data Bank's Population, total” dataset). Extract the file to
"C:\DAT207x". You can use other folders, but if you are going to use the starter file
provided at each lab instead of your own file, then it is recommended to use the
absolute path given above in order to successfully perform the schedule refresh in
Lab 4.
2. Import the data from the file folder by clicking Get Data, clicking Excel and
clicking Connect.
3. Select C:\DAT207x\Country Population by Year.xlsx and click Open.
4. Select Sheet1 and click Edit.
5. In QUERY SETTINGS change Name to Country Population.
6. On the ribbon, click Remove Rows, click Remove Top Rows, in Number
of rows, type 3, and click OK.
7. On the ribbon, click Use First Row as Headers.
8. Select the 1999 column, hold Shift and select the 2014 column.
9. On the Transform ribbon, click Unpivot Columns.
10. Right-click the Attribute column header and click Rename.
11. Type Year and press Enter.
12. Right-click the Value column header and click Rename.
13. Type Population and press Enter.
14. Click the drop-down button on the Year header, unselect 1999, and
click OK.
15. Click the Year header, on the Transform ribbon click Data Type, and
click Whole Number.
16. Click the Population header, on the Transform ribbon click Data Type, and
click Whole Number.
17. Click the Home ribbon.
18. Click Close & Apply.
19. If you receive an error, close the error, click the Model view, right-click each
relationship connecting Country Population, and click Delete. Now click Apply
changes.
20. Load the data into Power BI Desktop.
21. Explore the imported data in the Data View.

Lab Questions 1
4.0/4.0 points (graded)

Answer the following question by reviewing the imported data in Power BI Desktop.
(Hint: Use the Data view).

How many rows were imported from the Country Population query?
75
  correcto 

75 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 2
4.0/4.0 points (graded)

How many distinct values of the Year column were imported from the Country Population
query?
15
  correcto 

15 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar
 Lab 2

Lab Overview
 Marcar esta página

SCENARIO
VanArsdel is a company that manufactures and sells sporting goods. The company
has offices in the United States (US) and several other countries. Its sales
comprise of US sales and International sales. VanArsdel’s sales come from its
owned manufactured products, as well as other manufacturers’ products.

You have successfully brought the US sales data from the Access database and
the International sales data from a collection of CSV files to Power BI Desktop.
Before you can start analyzing your data, you need to manage the table
relationships within your data model and create new ones if necessary. To do so,
you might need to create calculated columns or calculated tables for the
relationships to be based on.

Once you have all the relationships created, you can create visualizations and start
to analyze the data. However, you need to create additional measures to perform
more advanced analysis with your data, which includes:

 Comparing last year sales and last year YTD sales.

 Comparing sales of VanArsdel's manufactured goods to other manufacturers.

LAB OVERVIEW
In this lab, you will create calculated columns, calculated tables, and create table
relationships in your data model based on the calculated columns and tables you
created. In addition, you will write several DAX expressions to create measures to
be used to analyze VanArsdel’s sales data. Specifically, you will create the
following measures:

 Total Sales: calculates the total sales.

 LY Sales: calculates last year sales.

 Sales Var: calculates sales variance between this year and last year sales.

 Sales Var %: calculates sales variance between this year and last year sales in
percentage.

 YTD Sales: calculates YTD sales.

 LY YTD Sales: calculates last year YTD sales.

 YTD Sales Var: calculates sales variance between this year and last year YTD
sales.

 YTD Sales Var %: calculates sales variance between this year and last year YTD
sales in percentage.

 Total VanArsdel Sales: calculates sales for VanArsdel manufactured goods.

 % Sales Market Share: calculates the percentage of VanArsdel manufactured

goods from the total sales.

Before starting this lab, you should review the Power BI Desktop

Modelling module in this course. Then, if you have not already done so, follow the
instructions in the Set up the Lab Environment section of this course to set up the
lab environment.

WHAT YOU’LL NEED

 A computer with the latest version of Power BI Desktop installed on it.

 The following Power BI Desktop file:

o The “Lab 2 - Starting.pbix” file

Exercise 1- Manage Table Relationships

 Marcar esta página

Power BI Desktop has automatically detected and created table relationships. So

the first step is to ensure all the relationships are properly created, and if not,
create them yourselves.

1. Start with the "Lab 2 - Starting.pbix " file.

2. Open the Lab 2 - Starting.pbix file.

3. In the navigation pane on the left, click Model.

4. Notice that there is a many to one relationship from the ProductID column on

the Sales table to the ProductID column on the Products table.

5. Notice that there is a many to one relationship from the ManufacturerID column on

the Products table to the ManufacturerID column on the Manufacturers table.

6. Drag the Date column on the Sales table to the Date column on the Date table.

 Now you want to create a relationship between the Sales table and the Locations
table. First, you merge the Country and Zip columns in both Sales and Locations
table as a new column, CountryZip. Then, you create a relationship on the
CountryZip column for both tables.

1. In the navigation pane on the left, click Data.

2. In the navigation pane on the right, click Location.

3. On the Modeling ribbon, click New Column.

4. In the formula bar for the new column, type CountryZip = Location[Country] & ",
" & Location[Zip], and press Enter.

5. In the navigation pane on the right, click Sales.

6. On the Modeling ribbon, click New Column.

7. In the formula bar for the new column, type CountryZip = Sales[Country Name] &
", " & Sales[Zip], and press Enter.

8. In the navigation pane on the left, click Model.

9. Drag the CountryZip column on the Sales table to the CountryZip column on

the Locations table.

10. Click Save, to save the Power BI file.

Lab Questions
4.0/4.0 points (graded)

Review the relationship that you have just created on the CountryZip columns.
(Hint: Double-click on the newly created relationship).

What is the cardinality of the relationship?

Many to One

One to One

One to Many
 Many to Many

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions
4.0/4.0 points (graded)

What is the Cross filter direction of the relationship?

Single

Double

Both

Multiple

correcto

Exercise 2- Last Year Comparison

 Marcar esta página

You want to know how much sales (revenue) in total does the VanArsdel have and
to compare this with the figure from the same period last year. You need to create
several calculated measures to help with this comparison. To do so, in either
the Report view or the Data view, right-click the Sales table, click New Measure,
and type in the corresponding DAX formulas for the measure you want to create.
This will create the measures with the Home Table properties set to
the Sales table.

Specifically, you will create the following measures:

1. Total Sales: calculates the total sales. Format this measure as Currency. (Hint:
Check out the SUM function).

2. LY Sales: calculates last year sales. Format this measure as Currency. (Hint: You
might find the CALCULATE and SAMEPERIODLASTYEAR function useful).

3. Sales Var: calculates sales variance between this year and last year sales. Format
this measure as Currency. (Hint: This is simply the difference between Total
Sales and LY Sales).

4. Sales Var %: calculates sales variance between this year and last year sales in
percentage. Format this measure as Percentage. (Hint: This is simply the percentage
of Sales Var from LY Sales. You might find the DIVIDE function useful).

1. If it is not already open, open the Lab 2 - Starting.pbix file.

2. In the navigation pane on the left, click Data.

3. In the navigation pane on the right, click Sales.

4. On the Modeling ribbon, click New Measure.

5. In the formula bar for the new measure, type Total Sales =

SUM(Sales[Revenue]), and press Enter.

6. On the Modeling ribbon, click Format, click Currency, and click Currency

general.

7. On the Modeling ribbon, click New Measure.

8. In the formula bar for the new measure, type LY Sales = CALCULATE([Total
Sales],SAMEPERIODLASTYEAR(‘Date’[Date])), and press Enter.

9. On the Modeling ribbon, click Format, click Currency, and click Currency

general.

10. On the Modeling ribbon, click New Measure.

11. In the formula bar for the new measure, type Sales Var = [Total Sales] - [LY
Sales], and press Enter.

12. On the Modeling ribbon, click Format, click Currency, and click Currency

general.

13. On the Modeling ribbon, click New Measure.

14. In the formula bar for the new measure, type Sales Var % = DIVIDE([Sales Var],
[LY Sales]), and press Enter.

15. On the Modeling ribbon, click Format, and click Percentage.

16. Click Save, to save the Power BI file.

Lab Questions 1
4.0/4.0 points (graded)

Answer the following questions using the measures you created. (Do NOT include
currency symbols or thousands separators). The fastest way to do this is to drag
the measures you created to the Report view and format them as a table
visualization. Do not use any level of filtering to answer the questions.

What is the figure for the Total Sales measure? (to two decimal places)
5127755449.65
  correcto 

5127755449.65 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 2
4.0/4.0 points (graded)

What is the figure for the Sales Var % measure? (to two decimal places)<<
2.74
  correcto 

2.74

Exercise 3- Year to Date

 Marcar esta página

Year-to-date (YTD) is a period starting from the beginning of the current year and
continuing up to the present date. You want to calculate the YTD sales and
compare this with the figure from the same period last year. Specifically, you will
create the following measures:
1. YTD Sales: calculates the YTD sales. Format this measure as Currency. (Hint:
Check out the TOTALYTD function).

2. LY YTD Sales: calculates last year YTD sales. Format this measure as Currency.
(Hint: You might find the CALCULATE and SAMEPERIODLASTYEAR function useful).

3. YTD Sales Var: calculates sales variance between this year and last year YTD
sales. Format this measure as Currency. (Hint: This is simply the difference between YTD
Sales and LY YTD Sales).

4. YTD Sales Var %: calculates sales variance between this year and last year YTD
sales in percentage. Format this measure as Percentage. (Hint: This is simply the
percentage of YTD Sales Var from LY YTD Sales. You might find the DIVIDE function
useful).

Lab Questions 1
4.0/4.0 points (graded)

Answer the following questions using the measures you created. (Do NOT include
currency symbols or thousands separators). The fastest way to do this is to drag
the measures you created to the Report view and format them as a table
visualization. Do not use any level of filtering to answer the questions.

What is the figure for the LY YTD Sales measure? (to two decimal places)
272629284.11
  correcto 

272629284.11 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 2
0.0/4.0 points (graded)

What is the figure for the YTD Sales Var % measure? (enter the absolute value, to two
decimal places)
0.50
  incorrecto 

0.50 
Enviar
 Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Need a Little Help?

If you're stuck, check out the following DAX expressions to calculate similar
measures, but on Units instead of Revenue.

 YTD Total Units: YTD Total Units = TOTALYTD([Total Units],‘Date’[Date])

 LY YTD Total Units: LY YTD Total Units = CALCULATE([YTD Total

Units],SAMEPERIODLASTYEAR(‘Date’[Date]))

 YTD Total Units Var: YTD Total Units Var = [YTD Total Units] [LY YTD Total
Units]

 YTD Total Units Var %: YTD Total Units Var % = DIVIDE([YTD Total Units Var],
[LY YTD Total Units])

Exercise 4- Market Share

 Marcar esta página

VanArsdel’s sales comprise of products manufactured by VanArsdel and other

companies. You want to know how much of these sales are VanArsdel’s own
manufactured products. You decide to show this share in numbers and %.
Specifically, you will create the following measures:

 Total VanArsdel Sales: calculates sales where the products manufacturer is

VanArsdel. Format this measure as Currency. (Hint: Use the CALCULATE function and
filter by Manufacturer).

 % Sales Market Share: calculates the percentage of sales of VanArsdel

manufactured products from the total sales. Format this measure as Percentage.

1. If it is not already open, open the Lab 2 - Starting.pbix file.

2. In the navigation pane on the left, click Data.

3. In the navigation pane on the right, click Sales.

4. On the Modeling ribbon, clickNew Measure.

5. In the formula bar for the new measure, type Total VanArsdel Sales =
CALCULATE([Total Sales],Manufacturer[Manufacturer]=“VanArsdel”), and press
Enter.

6. On the Modeling ribbon, click New Measure.

7. In the formula bar for the new measure, type % Sales Market Share = IF([Total
VanArsdel Sales]=0,0,DIVIDE([Total VanArsdel Sales],[Total Sales],0)), and press
Enter.

8. On the Modeling ribbon, click Format, and click Percentage.

9. Click Save, to save the Power BI file.

Lab Questions 1
4.0/4.0 points (graded)

Answer the following questions using the measures you created. (Do NOT include
currency symbols or thousands separators). The fastest way to do this is to drag
the measures you created to the Report view and format them as a table
visualization. Do not use any level of filtering to answer the questions.

What is the figure for the Total VanArsdel Sales measure? (to two decimal places)
2276898965.01
  correcto 

2276898965.01 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Lab Questions 2
4.0/4.0 points (graded)

What is the figure for the % Sales Market Share measure? (to two decimal places)
44.40%
  correcto 

44.40% 
Enviar
 Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Need a Little Help?

If you're stuck, check out the following DAX expressions to calculate similar
measures, but on Units instead of Revenue.

 Total VanArsdel Units: Total VanArsdel Units = CALCULATE([Total

Units],Manufacturers[Manufacturer]=“VanArsdel”)

 % Units Market Share: % Units Market Share = IF([Total VanArsdel

Units]=0,0,DIVIDE([Total VanArsdel Units],[Total Units],0))

Exercise 5- Optimize the Data Model

 Marcar esta página
Now that you have the table relationships defined and the measures created, you
want to optimize the data model before you create the visualizations.

1. If it is not already open, open the Lab 2 - Starting.pbix file.

2. Ensure both the International Sales and Country Population table are

hidden from the report view using the following steps.

3. In the navigation pane on the left, click Data.

4. In the navigation pane on the right, click the ellipses (…) adjacent
to International Sales and click Hide in report view.

5. In the navigation pane on the right, click the ellipses adjacent to Country
Population and click Hide in report view.

6. Hide the following fields on the Date table from the report view:

 MonthNo

 MonthID

 Month
1. In the navigation pane on the right, click Date, click the ellipses adjacent
to MonthNo and click Hide in report view.

2. In the navigation pane on the right, click Date, click the ellipses adjacent
to MonthID and click Hide in report view.

3. In the navigation pane on the right, click Date, click the ellipses adjacent
to Month and click Hide in report view.

4. Sort the MonthName column by the MonthNo column using the following

step.

5. Click the MonthName column and, on the Modeling ribbon, click Sort by

Column, and click MonthNo.

6. Hide the CountryZip field on the Location table and

the ManufacturerID field on the Manufacturer table from the report view using the
following steps.

7. In the navigation pane on the right, click Location, click the ellipses

adjacent to CountryZip and click Hide in report view.

8. In the navigation pane on the right, click Manufacturer, click the ellipses

adjacent to ManufacturerID and click Hide in report view.

9. Hide the following fields on the Products table from the report view.

 ProductID

 ManufacturerID

 Manufacturer

1. In the navigation pane on the right, click Products, click the ellipses

adjacent to ProductID and click Hide in report view.

2. Click the ellipses adjacent to ManufacturerID and click Hide in report

view.

3. Click the ellipses adjacent to Manufacturer and click Hide in report view.

4. Hide the following fields on the Sales table from the report view.

 ProductID

 Date
 Zip

 Units

 Revenue

 Country Name

 CountryZip

1. In the navigation pane on the right, click Sales, click the ellipses adjacent to
ProductID and click Hide in report view.

2. Click the ellipses adjacent to Date and click Hide in report view.

3. Click the ellipses adjacent to Zip and click Hide in report view.

4. Click the ellipses adjacent to Units and click Hide in report view.

5. Click the ellipses adjacent to Revenue and click Hide in report view.

6. Click the ellipses adjacent to Country Name and click Hide in report view.

7. Click the ellipses adjacent to CountryZip and click Hide in report view.

8. Click Save, to save the Power BI file.

Chapter 3

Knowledge Checks
 Marcar esta página

Question 1
1.0/1.0 point (graded)

Which three fields are available when creating a Pie chart for visualization?

Legend

Group

Details

Values

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Question 2
1/1 point (graded)

 Keyboard Help

PROBLEM
Consider the following
chart: 
  
Drag and drop the fields to the corresponding settings to create the above chart.

Category

, draggable

Segment

, draggable

Zone 1, dropzone
Use this zone to associate an item with the top layer of the triangle.
Year

, draggable

Placed in: Zone 1

Items placed here: Year

Zone 2, dropzone
Use this zone to associate an item with the middle layer of the triangle.
Country

, draggable

Placed in: Zone 2

Items placed here: Country

Zone 3, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Revenue

, draggable

Placed in: Zone 3

Items placed here: Revenue

Zone 4, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Units

, draggable

Placed in: Zone 4

Items placed here: Units

Question 3
1/1 point (graded)

By default, which level of filter behaves the same as a slicer in a report in Power BI
Desktop

Visual level filter

Page level filter

Report level filter

Query level filter

correcto
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 4
1/1 point (graded)

 Keyboard Help

PROBLEM
Consider the following

chart:   Drag and drop

the fields to the corresponding settings to create the above chart.

Year
 , draggable

Segment

, draggable

Units

, draggable

Zone 1, dropzone
Use this zone to associate an item with the top layer of the triangle.
Country

, draggable

Placed in: Zone 1

Items placed here: Country

Zone 2, dropzone
Use this zone to associate an item with the middle layer of the triangle.
Category

, draggable

Placed in: Zone 2

Items placed here: Category

Zone 3, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
No items placed here

Zone 4, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
No items placed here

Zone 5, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Revenue

, draggable

Placed in: Zone 5

Items placed here: Revenue

Zone 6, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
No items placed here
SubmitYou have used 2 of 2 attempts.
Go To BeginningRestablecerShow Answer

REALIMENTACIÓN

Colocó correctamente 3 ítems.

Good work! You have completed this drag and drop problem.
Se ha utilizado el último intento. Su puntaje máximo fué 1.0

Colocó correctamente 3 ítems.

Good work! You have completed this drag and drop problem.

Se ha utilizado el último intento. Su puntaje máximo fué 1.0

Question 5
1/1 point (graded)

 Keyboard Help

PROBLEM
Consider the following
chart: 
  
Drag and drop the fields to the corresponding settings to create the above chart.

Year

, draggable

Country

, draggable

Units

, draggable

Zone 1, dropzone
Use this zone to associate an item with the top layer of the triangle.
Segment

, draggable

Placed in: Zone 1

Items placed here: Segment

Zone 2, dropzone
Use this zone to associate an item with the middle layer of the triangle.
Category

, draggable

Placed in: Zone 2

Items placed here: Category

Zone 3, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Revenue

, draggable

Placed in: Zone 3

Items placed here: Revenue

SubmitYou have used 2 of 2 attempts.
Go To BeginningRestablecerShow Answer

REALIMENTACIÓN

Colocó correctamente 3 ítems.

Good work! You have completed this drag and drop problem.
Se ha utilizado el último intento. Su puntaje máximo fué 1.0

Colocó correctamente 3 ítems.

Good work! You have completed this drag and drop problem.

Se ha utilizado el último intento. Su puntaje máximo fué 1.0

Question 6
1/1 point (graded)

When creating a waterfall chart, which two field options that you need to define?

Category

X Axis

Y Axis

Size

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 7
1/1 point (graded)

Which visualization would you use to show progress toward a particular target?

Bar chart

Scatter chart

Waterfall

Gauge

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 8
1/1 point (graded)

Which of the following shapes are three of the shapes that you can create using the Insert
Shapes feature in Power BI Desktop?
 Flowchart

Triangle

Rectangle

Oval

Knowledge Checks 2
 Marcar esta página

Question 1
1/1 point (graded)

From which two options can you customize your report page layout?

From the Report ribbon, New Page option

From the Report ribbon, Page View option

From the Visualizations, Format option

From the Visualizations, Field option

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión
Question 2
1/1 point (graded)

Which of the following option would you use to modify the interactions flow between
visuals in a Power BI report?

Edit Queries

Arrange

Page Size

Edit Interactions

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 3
1/1 point (graded)

When you make a copy of a page in your report by using Duplicate Page, which
visualizations from the page are duplicated?

All visualizations

Only the selected visualizations

Only visualizations that have filter relationship

 All visualizations, except the static images

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 4
1/1 point (graded)

Which of the following is not an option for Default Summarization?

Sum

Average

Count

Standard deviation

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión
Question 5
1/1 point (graded)

Which four options you can use to modify the Z order of a visualization?

Send to Back

Bring to Front

Bring Forward

Set Transparent

Send Backward

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión
 Exercise 1- Cross-Tabular Report
 Marcar esta página

Let's start with an easy one. You want to show VanArsdel's sales (revenue) and
units for each month and year in a single report. You choose to show this using two
Matrix visualizations.

1. Start with the “Lab 3 - Starting.pbix” file.

2. In the navigation pane on the left, click Report.
3. In the FIELDS list, on the right, click the Sales table.
4. Drag the Total Sales field from the Sales table to the report to create a
chart.
5. In the FIELDS list, on the right, click the Date table.
6. Drag the MonthName and Year fields from the Date table to the chart.
7. In the VISUALIZATIONS list, click Matrix.
8. In the VISUALIZATIONS list, in Rows, select MonthName, in Columns,
select Year, and in Values, select Total Sales.
9. Repeat Step 5 to 10 to add another chart, but this time, display the Total
Units field in place of Total Sales.
10. From the Home ribbon, click Text box.
11. In the text box, type VanArsdel Sales and Units and resize and move the
text box so that it appears as the title of the report.
12. At the bottom of the screen, right-click Page 1, and click Rename Page.
13. Type Sales and Units and press Enter.
 You should have something similar to the below:

14. Click Save, to save the Power BI file.

Lab Questions 1
4/4 points (graded)

Answer the following questions using the report you created. (Do NOT include
currency symbols or thousands separators). Do not use any level of filtering to
answer the questions.
 What is VanArsdel's sales for December 2013? (to two decimal places)
13981765.42
  correcto 

13981765.42 
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Correcto (4/4 puntos)

Revisión

Lab Questions 2
4/4 points (graded)

What is VanArsdel's total units for the March 2013?

42620
  correcto 

42620 

Exercise 2- Part-to-Whole Report

 Marcar esta página

Now that you have the big picture, let's start analyzing the data sales data by
product category, segment and manufacturer.

1. If it is not already open, open the Lab 3 - Starting.pbix file.

2. Create a new report page by clicking New Page (+) at the bottom of the report
view.

3. Drag the Total Sales field from the Sales table to the report and create a chart.

4. Drag the Category and Segment fields from the Products table to the chart.

5. In the VISUALIZATIONS list, click 100% Stacked Bar Chart .

6. In the VISUALIZATIONS list, in Axis, select Category, in Legend,

select Segment, and in Value, select Total Sales.

7. In the VISUALIZATIONS list, click the Format button.

8. Click Data Labels.

9. Set Data Labels to On.

10. Set Value decimal places to 0.

11. Drag the Total Sales field from the Sales table to the report and create another
chart.

12. Drag the Manufacturer field from the Manufacturers table to the chart.

13. Modify the chart to use the Treemap visualization.

14. Drag the MonthName field from the Date table to the report and create another
chart.

15. Modify the chart to use the Slicer visualization.

16. Drag the Year field from the Date table to the report and create a chart.

17. Modify the chart to use the Slicer visualization.

18. Rename the report sheet to Sales Breakdown.

19. Click Save, to save the Power BI file.

You should have something similar to the below:

Lab Question 1
4/4 points (graded)

Answer the following questions using the report you created. (Do NOT include
currency symbols or thousands separators). Do not use any level of filtering to
answer the questions.
In January 2014, what is VanArsdel's sales, from all manufacturers, for Urban category
and Moderation segment? (to two decimal places) (Hint: Try hovering on the chart)
6732251.98
  correcto 

6732251.98 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (4/4 puntos)

Revisión

Lab Question 2
4/4 points (graded)

[Fill in the blank]

Lab Question 2

Answer the following question by using the treemap chart you created.

Drag the Manufacturer name to its appropriate box, 1 for the one with highest, and 4 for
the one with the lowest.
For Total sales in 2015, which are the top 4 manufacturers?

 Abbas

 Aliqui

 Barba

 Currus

 Fama

 Leo

 Natura

 Pirum
  Pomum

 Quibus

 Salvus

 Van

 Arsdel

 Victoria
In May 2015, what are the total sales, from all manufacturers, for Mix category and All
Season segment? (to two decimal places) (Hint: Try hovering on the chart)
859987.07
  correcto 

859987.07 

Exercise 3- Relationship Report

 Marcar esta página

You would like to know more about the relationship between total units and total
sales by category and segment. You choose to analyze this using scatter chart.

1. If it is not already open, open the Lab 3 - Starting.pbix file.

2. Create a new report page by clicking New Page at the bottom of the report
view.
3. In VISUALIZATIONS, click Scatter Chart.
4. Drag the Total Sales, Total Units, and YTD Sales fields from
the Sales table to the chart.
5. Drag the Category and Segment fields from the Products table to the
chart.
6. Drag the Year field from the Date table to the chart.
7. Rename the report sheet to Sales Relationship.
8. Ensure that the following fields are set in the visualization Details:
o Details: Category

o Legend: Segment

o X Axis: Total Sales

o Y Axis: Total Units

o Size: YTD Sales

o Play Axis: Year

9. Click Save, to save the Power BI file.

You should have something similar to the below:

Lab Questions 1
4/4 points (graded)

As you can see, in the year 2015, Moderation segment made the most of
VanArsdel's sales. It is not always the case. Use the Play Axis to investigate.

In which year the Moderation segment first took over as the segment with most sales?
                                                                                                                                                
2009
 
correcto
 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta
 Correcto (4/4 puntos)

Revisión

Lab Questions 2
4/4 points (graded)

What about in terms of Units? In which year the Moderation segment first took over as the
segment with most units?
                                                                                                                                                
2011
 
correcto
 

Exercise 4- Trend Report

 Marcar esta página

Let's do some trend analysis. First let's show a chart to compare Total Sales and
Total Units throughout the years. And then let's show two more charts showing the
Total Sales and Total Units variances throughout the years.

1. If it is not already open, open the Lab 3 - Starting.pbix file.

2. Create a new report page by clicking the New Page icon at the bottom of the report
view.

3. Drag the Year field from the Date table to the report and create the first chart.

4. Drag the Total Sales and Total Units fields from the Sales table to the Year chart.

5. Modify the chart to use the Line and Stacked Column Chart visualization.

6. Ensure that the Year is shown as the Shared Axis, Total Sales is shown as

the Column values, and Total Units is shown as the Line values of the visualization
Details.

7. Create a second chart based on the Waterfall Chart visualization.

8. Drag the Sales Var field from the Sales table to the Sales Var chart.

9. Drag the Year field from the Date table to the Sales Var chart.

10. Create a third chart, also based on the Waterfall Chart visualization.

11. Drag the Total Units Var field from the Sales table to the Total Units Var chart.
12. Drag the Year field from the Date table to the Total Units Var chart.

13. Click the Elipse button on both the Sales Var and Total Units Var charts and sort
by Year ascending.

14. Add a Text Box to the report and enter Yearly Trend as the text.

15. Rename the report sheet to Yearly Trend.

16. Click Save, to save the Power BI file.

You should have something similar to the below:

Lab Question 1
2/2 points (graded)

In which year was the growth of total sales not matched by the growth of total units?
 2005

2006

2007

2008

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (2/2 puntos)

Revisión

Lab Question 2
4/4 points (graded)

Which year saw the biggest drop in total sales?

2007

2008

2009

2010

correcto
Enviar
 Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (4/4 puntos)

Revisión

Lab Question 3
4/4 points (graded)

What about total units? Which year saw the biggest drop in total units?

2007

2008

2009

2010

correcto

Exercise 5- Rank Report

 Marcar esta página

You now want to analyze individual products sales (revenue) and volume (units).
You decide to show these using two bar charts.

1. If it is not already open, open the Lab 3 - Starting.pbix file.

2. Create a new report page by clicking the New Page icon at the bottom of the report
view.

3. Drag the Total Sales field from the Sales table to the report and create a chart.

4. Drag the Product field from the Products table to the chart.

5. Modify the chart to use the Stacked Bar Chart visualization.

6. Ensure that the chart is sorted by Total Sales.

7. Drag the Total Units field from the Sales table to the report and create a new
chart.

8. Drag the Product field from the Products table to the chart.

9. Modify the chart to use the Stacked Bar Chart visualization.

10. Ensure that the chart is sorted by Total Units.

11. Drag the Year field from the Date table to the report and create a new chart.

12. Modify the chart to use the Slicer visualization.

13. Modify the slicer type by clicking the dropdown arrow in the Year chart and
selecting the List option.

14. Add a Text Box to the report and enter Top Products as the text.

15. Rename the report sheet to Top Products.

16. Click Save, to save the Power BI file.

You should have something similar to the below:

Lab Questions 1
4/4 points (graded)
What is the top product in terms of sales for the year 2010?

Maximus UM-92

Maximus UM-43

Maximus UM-70

Maximus UM-11

Maximus UC-69

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (4/4 puntos)

Revisión

Lab Questions 2
4/4 points (graded)

What about in terms of units? What is the top product in terms of total units for the year
2010?

Maximus UM-92

Maximus UM-43

Maximus UM-70
 Maximus UM-11

Maximus UC-69

LAB 4

Knowledge Checks
 Marcar esta página

Question 1
1/1 point (graded)

By default, where does clicking a tile on a Power BI dashboard take you?

To the latest opened report

To the report where the visual was pinned from

To the report that has the same data source

To the Power BI home page

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 2
1/1 point (graded)
When you pin a visual created by the natural language query, to which dashboard is it
pinned?

The last dashboard you visited

The last dashboard you created

A new dashboard

The dashboard you selected in the Pin to dashboard window

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 3
1/1 point (graded)

You want to share a dashboard with your colleague. What are two possible ways to
achieve this goal?

Click the ellipsis next to the dashboard name on the Dashboards list, and then click
Share.

Click Share from the upper right of the dashboard you want to share.

From your browser, click Share.

Right-click anywhere in the dashboard, and then click Share.

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 4
1/1 point (graded)

You are viewing a Power BI dashboard in a browser window. What happens when you
click the Focus mode of a tile?

The tile you selected expands and takes the full space.

The report from which the tile was pinned opens.

The Power BI desktop file gets downloaded.

The Power BI desktop file opens.

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 5
1/1 point (graded)
Which three properties of a tile can you edit in the Power BI dashboard from the Tile
details window?

Title

Subtitle

Destination link

Color scheme

correcto
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 6
1/1 point (graded)

What do you need to append to the URL of a Power BI dashboard in order to open it with
the navigation pane collapsed by default?

?navigationPane=false

?navigationPane=collapsed

?collapseNavigation=true

?collapseNavigation=collapsed
correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 7
1/1 point (graded)

You publish a report from Power BI Desktop to Power BI service. You then make changes
to your local report in Power BI Desktop by adding some visualizations. When do the
changes synchronize to Power BI service?

When you save the Power BI Desktop file

When you click REFRESH NOW in Power BI service

When you re-publish the Power BI Desktop report

When the scheduled refresh is run on Power BI service

correcto
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 8
1/1 point (graded)
What is the purpose of Power BI Personal Gateway?

To enable publishing reports to Power BI service.

To provide a platform for easily consuming and sharing reports.

To provide quick and secure data transfer between Power BI service and on-premises
data sources that support refresh.

To connect and shape data, build robust models, and author well-structured reports.

correcto
 Lab Overview
 Marcar esta página

SCENARIO
VVanArsdel is a company that manufactures and sells sporting goods. The
company has offices in the United States (US) and several other countries. Its
sales comprise of US sales and International sales. VanArsdel’s sales come from
its owned manufactured products, as well as other manufacturers’ products.

You have created reports with VanArsdel's US and International sales data using
Power BI Desktop. Now it's the time to use Power BI service to display this report,
create a dashboard, share it, and set a scheduled refresh for the dataset.

LAB OVERVIEW
In this lab, you will upload a Power BI Desktop report to Power BI service. You will
then pin several visualizations and create a dashboard. You will also use the
natural language queries feature to create and pin new visualizations. To top it off,
you will share this newly created dashboard and set a scheduled refresh so that
the dashboard is always up-to-date.

Before starting this lab, you should review Power BI Service module in this

course. Then, if you have not already done so, follow the instructions in the Set up
the Lab Environment section of this course to set up the lab environment.

WHAT YOU'LL NEED

 A computer with the latest version of Power BI Desktop installed on it.

 The following Power BI Desktop file:

o The “Lab 4 Starting.pbix” file

 Power BI service account (You need to have a work / business email to sign
up for Power BI service)

Exercise 1- Upload PBI Report and Pin

Visualizations
 Marcar esta página
 First, you will upload a Power BI Desktop file to Power BI Service.

1. Start with the "Lab 4 “Lab 4 Starting.pbix” file.

2. On the Home ribbon, click Publish.

3. In Select a destination, select My workspace, and click Select.

4. If prompted, sign in using the account you used to sign up for the Power BI service.

5. Once the report is published, click Got it.

6. Start an Internet browser, go to https://powerbi.microsoft.com, and click Sign in.

7. Sign in using your account.

8. If this is your first time publishing a report to Power BI service, you will notice that
you now have a dataset named Lab 4 Starting and a report named Lab 4 Starting. You
can rename both of these, but let's just leave them be for now.

9. Go to the Lab 4 Starting Report and explore your published report. It looks similar

to the one in Power BI Desktop file. Now you can start creating a dashboard by pinning
some visualizations.

10. Go to the Sales Report tab and pin the chart showing Total Sales by Category
and Segment (100% Stacked Bar Chart). Select to create a New dashboard and name
it VanArsdel Sales.

11. Pin the treemap chart, the scatter chart, and the map visualization from the Sales
Report tab to the VanArsdel Sales dashboard.

12. Go to the Yearly Trend tab and pin the waterfall chart that shows the Sales Var by
Year to the VanArsdel Sales dashboard.

13. Go to the VanArsdel Sales dashboard and review what you have created.

14. Resize and arrange the tiles as necessary.

15. On the top-right, click Web view and click Phone view.

16. Review the phone view.

17. Resize and arrange the tiles as necessary.

You should have something similar to the below:

Question 1
2/2 points (graded)

You want to pin existing visualizations from a report to a dashboard. What two scenarios
can you do when pinning visualizations?

You can pin multiple visualizations to a dashboard but you need to do it one at a time.

You can pin two visualizations to a dashboard by pressing the CTRL key.

You can pin the whole report page to a dashboard in one attempt by pinning a live
page.

You can pin three visualizations to a dashboard by pressing the CTRL key.

correcto
Let's try the natural language query feature and create a few visualizations for your
dashboard.

1. Type the question What is year to date sales in the text box for Q&A.

2. Pin the answer to VanArsdel Sales dashboard.

3. Type the question What is ytd total units.

4. Pin the answer to VanArsdel Salesdashboard.

5. Expand the Fields and Visualizations pane on the right of the screen.

6. Drag the Total Units field from the Sales table to the Color saturation. Notice that

the bar char color saturation changes according to the Total Units for that product.

7. Pin the answer to VanArsdel Sales dashboard.

8. Resize and arrange the tiles as necessary.

You should have something similar to the below:

Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (2/2 puntos)

 Revisión

Question 2
2/2 points (graded)

Now try answering the following question by using the Q&A. What is the total sales for
Germany in 2014?

$4,044,962.47

$6,984,804.82

$3,681,551.21

$6,845,996.87
correcto

Exercise 2- Share Dashboard and Update Report

 Marcar esta página

Let's start sharing your newly created dashboard. For simplicity, let's share the
dashboard to your own email address.

NOTE: Power BI Pro is required for sharing dashboards. If you do not have a
Power BI Pro subscription, you can enroll for a free 60 day trial.

1. Click My Workspace, click Dashboards, and click Van Arsdel Sales.

2. In the VanArsdel Sales dashboard, click the Share button to share your

dashboard.

3. Click Try Pro for free.

4. Click Start Trial, and click Close.

5. Click My Workspace, click Dashboards, and click Van Arsdel Sales.

6. In the VanArsdel Sales dashboard, click the Share button to share your

dashboard.

7. In Grant access to, enter your email address used for Power BI service and
click Share.

8. Check your inbox to see an invite to view this dashboard.

 Question 1
2/2 points (graded)

Let's confirm that you received the dahsboard sharing invitation email. What is the
sender's name?

Microsoft Learning

Microsoft Power BI

Power BI Service

Microsoft BI

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (2/2 puntos)

Revisión

Lab Steps
Once you've uploaded your Power BI Desktop file to Power BI service, you can still
make changes to it, and re-upload the file so that your changes is reflected in
Power BI service.

1. Open the "Lab 4 “Lab 4 Starting.pbix” file.

2. Modify the Total Sales by Category and Segment chart (the one displayed
using “100% stacked bar chart” visualization) on the Sales Report tab to
use Stacked Bar chart visualization instead.
3. Re-publish the file to Power BI service and replace the existing dataset with
this one.
4. Go to Power BI service and review the Lab 4 - Starting Report and
examine whether the change you made is reflected.
 Question 2
1/1 point (graded)

As you can see, when you update a Power BI Desktop file and re-publish it, the report in
Power BI service (that is based on that file) will get updated. What about the Dashboard?
Do pinned visualizations (tiles) get updated when the report is updated?

Yes

No

correcto

Exercise 3- Schedule Data Refresh

 Marcar esta página

So far, the report you uploaded is rather static. That means, if the data in the
Access database changes, the report and dashboard are not updated. You can
install Power BI Personal Gateway and schedule data refresh for on-premises data
sources, such as the Access database, to keep your report and dashboard on
Power BI service up-to-date.

NOTE: Power BI Pro is required to setup scheduled refresh for on-premises data. If
you do not have Power BI Pro subscription you can enroll for a free 60 day trial.

1. On the Power BI website, click My Workspace, click Datasets, click Lab 4 –

Starting, and click the Schedule refresh icon.

2. Power BI Pro is required to setup scheduled refresh for on-premises data. If you do
not have Power BI Pro subscription you can enrol for a 60 day trial.

3. Ensure that you are in the Datasets tab and that the Lab 4 - Starting dataset is
selected.

4. Click Gateway connection and click Install now to download the Power BI

Personal Gateway.

5. When the download is complete, click the On-premises data gateway to begin

installation.

6. Click Next, accept the license terms, and click Install.

7. Sign in using your Power BI account and click Close.

8. In New on-premises data gateway name, type Van Arsdel Sales.

9. In Recovery key and Confirm recovery key, type Pa$$w0rd, and

click Configure.

10. Click Close.

11. Expand Data source credentials and, for Country Population by Year.xlsx,

click Edit credentials.

12. For Privacy level setting for this data source, select Organizational, and

click Sign in.

13. Edit credentials for the Data sources that needs updating.

14. Now you can schedule your data source refresh.

NOTE: If you are using the starter file provided in the beginning of Lab 4, in order
to be able to successfully refresh the data, please ensure that you have the files
from previous labs under the "C:\DAT207x" folder. This is because the files were
developed with this referenced. You might use arbitrary folders in your own
scenario or if you are using your own file throughout the labs.

Question
0/2 points (graded)

Which two frequencies are available for scheduled refresh?

Hourly

Daily

Weekly

Monthly

Yearly

incorrecto
Enviar

Knowledge Checks Lab 5

 Marcar esta página

Question 1
1/1 point (graded)

What do you need to do to prepare an Excel workbook before uploading it to Power BI?

Format all numeric data with two decimal points.

Ensure that the data is following the star schema.

Do nothing because Excel workbooks easily import to Power BI.

Name the Excel worksheet appropriately.

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 2
1/1 point (graded)

What happens when you upload an Excel workbook that has a Power View report to
Power BI?

The Excel Power View report will be converted to a Power BI report.

 The Excel Power View report will not be imported to Power BI.

The Excel Power View report will have the data model imported, but you need to
create the visualizations manually.

The Excel Power View report will be imported as Power BI Dashboard.

correcto
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 3
1/1 point (graded)

What happens when you connect to an Excel workbook that is hosted at OneDrive for
Business from Power BI?

The Excel workbook will be uploaded to Power BI.

The Excel data model will be uploaded to Power BI.

The Excel Report will be created in Power BI.

The Excel Power View report will be converted to a Power BI report.

correcto

Lab Overview
 Marcar esta página
 SCENARIO
VanArsdel is a company that manufactures and sells sporting goods. The company
has offices in the United States (US) and several other countries. Its sales
comprise of US sales and International sales. VanArsdel’s sales come from its
owned manufactured products, as well as other manufacturers’ products.

Some of your colleagues are using Excel as their primary reporting tool. You want
to collaborate with them and use their Excel files using Power BI service.

LAB OVERVIEW
In this lab, you will upload Excel files to Power BI service. First, you will upload an
Excel file containing an Excel table, and create quick visualizations based on that
data. Next, you will upload an Excel file that contains an Excel data model and
Power View report, and use the converted report in Power BI service.

Before starting this lab, you should review Working with Excel module in this
course. Then, if you have not already done so, follow the instructions in the Set up
the Lab Environment section of this course to set up the lab environment.

WHAT YOU’LL NEED

 The following Excel files:

o The “Lab 5 Canada.xlsx” file

o The “Lab 5 USA.xlsx” file

 Power BI service account (You need to have a work / business email to sign up for
Power BI service)

Exercise 1- Upload Excel File with an Excel Table

 Marcar esta página

First, you will upload an Excel file containing an Excel table.

1. Download and extract the the “Lab 5 Canada.xlsx” file. The file contain VanArsdel's
Canada sales. If you have a Microsoft Excel installed, you can open and explore the file
(you don't have to).

2. Go to https://powerbi.microsoft.com and sign in using your account.

3. Click Get Data, select Files and click Get.

4. Select Local file, select Lab 5 – Canada.xlsxfrom the location that you extracted it
to, and click Open.

5. Beneath Import Excel data into Power BI click Import.

6. When the import is complete, click View dataset.

7. Drag Revenue to the report.

8. Drag Year to the Revenue chart.

9. Drag Units to the report as a separate chart.

10. Drag Year to the Units chart.

11. Drag Province to the report as a separate chart.

12. Drag Revenue to the Province chart.

13. Now, answer the following questions by creating visualizations using the skills you
learned in the previous module.

Question 1
1/1 point (graded)

What is the total revenue for Canada in 2014? (to two decimal places)
1674868.34
  correcto 

1674868.34 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 2
1/1 point (graded)

In which year VanArsdel sold the most number of units in Canada?

2006
  correcto 
2006 
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 3
1/1 point (graded)

 Keyboard Help

PROBLEM
Drag the Province to its appropriate box, 1 for the one with highest, and 4 for the
one with the lowest. For VanArsdel's Canada sales (Revenue) in 2012, which are
the top 4 Provinces?

Quebec

, draggable

The first Zone, dropzone

Use this zone to associate an item with the top layer of the triangle.
Ontario

, draggable

Placed in: The first Zone

Items placed here: Ontario

The second Zone, dropzone

Use this zone to associate an item with the middle layer of the triangle.
 Alberta

, draggable

Placed in: The second Zone

Items placed here: Alberta

The third Zone, dropzone

Use this zone to associate an item with the bottom layer of the triangle.
British Columbia

, draggable

Placed in: The third Zone

Items placed here: British Columbia

The fourth Zone, dropzone

Use this zone to associate an item with the bottom layer of the triangle.
Manitoba

, draggable

Placed in: The fourth Zone

Items placed here: Manitoba

SubmitYou have used 2 of 2 attempts.
Go To BeginningRestablecerShow Answer

REALIMENTACIÓN

Colocó correctamente 4 ítems.

Good work! You have completed this drag and drop problem.
Se ha utilizado el último intento. Su puntaje máximo fué 1.0

Colocó correctamente 4 ítems.

Good work! You have completed this drag and drop problem.

Se ha utilizado el último intento. Su puntaje máximo fué 1.0

Question 4
1/1 point (graded)

 Keyboard Help
PROBLEM
Drag the Province to its appropriate box, 1 for the one with highest, and 4 for the
one with the lowest. What about for the year 2013? For VanArsdel's Canada sales
(Revenue) in 2013, which are the top 4 Provinces?

Quebec

, draggable

Zone 1, dropzone
Use this zone to associate an item with the top layer of the triangle.
Alberta

, draggable

Placed in: Zone 1

Items placed here: Alberta

Zone 2, dropzone
Use this zone to associate an item with the middle layer of the triangle.
Ontario

, draggable

Placed in: Zone 2

Items placed here: Ontario

Zone 3, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
British Columbia

, draggable

Placed in: Zone 3

Items placed here: British Columbia

Zone 4, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Manitoba
 , draggable

Placed in: Zone 4

Items placed here: Manitoba

SubmitYou have used 1 of 2 attempts.
Go To BeginningRestablecerShow Answer

REALIMENTACIÓN

Colocó correctamente 4 ítems.

Good work! You have completed this drag and drop problem.
Su mayor puntaje ha sido 1.0

Exercise 2- Upload an Excel File with a Data Model

 Marcar esta página

Now, let's upload an Excel file containing a Data Model and a Power View Report.

1. Download and extract the the “Lab 5 USA.xlsx” file. The file contain VanArsdel's
USAsales. If you have a Microsoft Excel installed, you can open and explore the file (you
don't have to).

2. Go to https://powerbi.microsoft.com and sign in using your account. Note that,

for this exercise, you must use a browser that supports Silverlight such as Internet
Explorer.

3. Click Get Data, select Files and click Get. Select Local file, select Lab 5 –

USA.xlsx from the location that you extracted it to, and click Open.

4. Beneath Upload your Excel file to Power BI click Upload.

5. When the upload is complete click View Workbook, or click Workbooks, and then

click Lab 5 - USA.

6. If the MAKE SELECTION TO PIN pop up appears, click Got it.

7. If you do not already have Silverlight, click Install Silverlight and follow the

installation instructions for Silverlight. Note that the Silverlight installation must be run as
an administrator.

8. Now, answer the following questions by reviewing the Power View1 tab in the Lab

5 USA Report.
Question 1
0/1 point (graded)

Using the Power View1 report, which manufacturer has the most growth in total units
between May and June 2015 (for all categories)?

Aliqui

Currus

Natura

Pirum
correcto

VanArsdel

incorrecto

Explanation
Ensure the Category filter is cleared. Review the Total Units by MonthName and
Manufacturer chart. You can see that for all categories, Pirum has the most growth
in total units between May and June.
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Answers are displayed within the problem

Revisión

Question 2
0/1 point (graded)

What about for only the Youth category? Which manufacturer has the most growth in total
units between May and June 2015, for the Youth category?
 Aliqui

Currus

Natura
correcto

Pirum

VanArsdel

incorrecto

Explanation
Filter the report for the Youth category and observe the Total Units by MonthName
and Manufacturer chart. You can see that Natura has the most growth in total units
between May and June for the Youth category.
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Answers are displayed within the problem

Revisión

Question 3
1/1 point (graded)

Which manufacturer(s) does not have products for the Youth category?

Aliqui

Currus

Natura
 Pirum

VanArsdel

correcto

Note: Make sure you select all of the correct options—there may be more than
one!

Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 4
1/1 point (graded)

 Keyboard Help

PROBLEM
Drag the Manufacturer to its appropriate box, 1 for the one with highest, and 4 for
the one with the lowest. For the Central region in 2015, which are the top 4
Manufacturers (in terms of Total Units)?

Currus

, draggable

Zone 1, dropzone
 Use this zone to associate an item with the top layer of the triangle.
VanArsdel

, draggable

Placed in: Zone 1

Items placed here: VanArsdel

Zone 2, dropzone
Use this zone to associate an item with the middle layer of the triangle.
Natura

, draggable

Placed in: Zone 2

Items placed here: Natura

Zone 3, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Pirum

, draggable

Placed in: Zone 3

Items placed here: Pirum

Zone 4, dropzone
Use this zone to associate an item with the bottom layer of the triangle.
Aliqui

, draggable

Placed in: Zone 4

Items placed here: Aliqui

SubmitYou have used 1 of 2 attempts.
Go To BeginningRestablecerShow Answer

REALIMENTACIÓN

Colocó correctamente 4 ítems.

Good work! You have completed this drag and drop problem.
Su mayor puntaje ha sido 1.0
6 Direct Connectivity

Knowledge Checks
 Marcar esta página

Question 1
1/1 point (graded)

Which three data sources allow you to use direct connection from Power BI?

Azure SQL Database

Azure SQL Data Warehouse

Microsoft Access

SQL Server Analysis Services

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 2
1/1 point (graded)
 When you connect to a model in SQL Server Analysis Service, what is shown in the
Navigator window?

List of tables in the model

List of tables and columns in the model

List of tables, columns, and fields in the model

Summary showing the available dimensions and measures

Lab Overview
 Marcar esta página

SCENARIO
VanArsdel is a company that manufactures and sells sporting goods. The company
has offices in the United States (US) and several other countries. Its sales
comprise of US sales and International sales. VanArsdel’s sales come from its
owned manufactured products, as well as other manufacturers’ products.

Your company has decided to move the Access database to the cloud, by
migrating the VanArsdel's US sales data to a SQL Server database on Azure. You
want to use Power BI Direct connectivity feature to connect directly to the Azure
SQL database.

LAB OVERVIEW
In this lab, you will connect to data hosted on Azure SQL database from Power BI
service and Power BI desktop using direct connectivity.

WHAT YOU’LL NEED

 A computer with the latest version of Power BI Desktop installed on it.

 Power BI service account (You need to have a work / business email to sign up for
Power BI service)
 Exercise 1- Direct Connectivity From Power BI
Desktop
 Marcar esta página

1. Start with a blank Power BI Desktop file.

2. To connect to the Azure SQL database click Get Data, click Azure, click Azure

SQL database, and click Connect.

3. Enter the following information to connect to the SQL Database.

o Server: msedxeus.database.windows.net

o Database: DAT207x01

4. Ensure DirectQuery is selected and click OK.

5. Select Database on the left bar and enter the following information to login and
click Connect.

o Login: PBILogin

o Password: P@ssw0rd

6. Select the bi.salesFact and bi.Date tables and click Load.

7. In VISUALIZATIONS, select Card.

8. Drag the Revenue field from the bi salesFact table to the chart.

9. Create a slicer based on the Slicer visualization.

10. Drag the Year field from the bi Date table to the slicer.

IMPORTANT! If you cannot login, please try the following:

 The data import may take a while depending on the speed of your Internet
provider.

 Ensure you are not behind a firewall.

 Try typing the server details and credentials instead of copy pasting.

Lab Question 1
4/4 points (graded)
 Select year 2015 from the slicer and review the card visualization. What is the total
Revenue for the year 2015?

125.84M

397.5M

4.91bn

251.79M

Exercise 2- Direct Connectivity From Power BI

Service
 Marcar esta página

1. Continue from Exercise 1.

2. Create a chart based on the Card visualization.

3. Drag the Units field from the SalesFact table to the chart.

4. Create a slicer based on the Slicer visualization.

5. Drag the Year field from the Date table to the slicer.

Lab Question 1
4/4 points (graded)

Select year 2015 from the slicer and review the card visualization. What is the total Units
for the year 2015?

11M

222K

427K
 963K

correcto
Enviar
Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (4/4 puntos)

Revisión

Lab Question 2
4/4 points (graded)

What is the total Units for the year 2014?

11M

222K

427K

963K
7 Developer API

Knowledge Checks
 Marcar esta página

Question 1
1/1 point (graded)

Which programming language you would use to create custom visuals?

C#

Java

TypeScript

Python

correcto
Enviar
Ha realizado 2 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
Mostrar Respuesta

Correcto (1/1 punto)

Revisión

Question 2
1/1 point (graded)

What is the extension of a Power BI custom visual file, downloaded from the Power BI
visuals gallery?

.pbix
 .pbivis

.pbiv

.pbiviz

Lab Overview
 Marcar esta página

SCENARIO
VanArsdel is a company that manufactures and sells sporting goods. The company
has offices in the United States (US) and several other countries. Its sales
comprise of US sales and International sales. VanArsdel’s sales come from its
owned manufactured products, as well as other manufacturers’ products.

LAB OVERVIEW
In this lab, you will download Power BI custom visuals from the visuals gallery, and
use them on your reports.

Before starting this lab, you should review Developer API module in this course.
Then, if you have not already done so, follow the instructions in the Set up the Lab
Environment section of this course to set up the lab environment.

WHAT YOU’LL NEED

 A computer with the latest version of Power BI Desktop installed on it.

 The following Power BI Desktop file:

 The “Lab 8 Starting.pbix” file

Exercise- Use Custom Visuals

 Marcar esta página

You have created several reports using the built-in visualizations. Now it's time to
further enhance your reports by using custom visualizations.
1. Go to Power BI visuals gallery: https://aka.ms/edx-dat207x-pbi2

2. In the search bar, type Sunburst, and press Enter.

3. Click Sunburst, click, GET IT NOW, and click Continue.

4. Sign in to your account and click Download for PowerBI.

5. Download the Sunburst visual to your local machine.

6. Open the Lab 8 - Starting.pbix file.

7. From the File menu, point to Import, and click Custom visual from file.

8. Click Import.

9. Navigate to the Sunburst visualization, select it, and click Open.

10. Click OK.

11. Open the Report view and go to the Sales Report tab.

12. Select the Total Sales by Category and Segment visuals, which is based of 100
% Stacked bar chart, and modify it to Sunburst visualization.

Lab Question 1
2/2 points (graded)

How many level(s) of "donut" is created in the Sunburst visual?

One

Two

Three

Four

correcto
Enviar
 Ha realizado 1 de 2 intentosAlgunos problemas tienen opciones como guardar,
restablecer, sugerencias o mostrar respuesta. Estas opciones aparecen después de
oprimir el botón Enviar.
GuardarGuardar Respuesta Mostrar Respuesta

Correcto (2/2 puntos)

Revisión

Lab Steps

1. Go to Power BI visuals gallery: https://aka.ms/edx-dat207x-pbi2

2. Download the Radar chart visual to your local machine. You may have to search
for the visual by typing in Radar in the Search box.

3. Import the RadarChart.pbiviz file downloaded from step 2. You can now use the
Radar chart visualization in this Power BI Desktop file.

4. Open the Report view and create a new tab.

5. Create a chart based on the Radar Chart visualization.

6. Drag the Region field from the Locations table to the chart.

7. Drag the Total Sales field from the Sales table to the chart.

Lab Question 2
2/2 points (graded)

Review the Radar chart visual you created. Which Region has the highest Total sales?

Central

West

East

North

Correcto