1. Open in Excel the file “Power BI
take-home B3.xlsx”.
What kind of company company would keep and use these kind of data? Describe
this in assignment 8.
2. Add three colums:
a. sales office in this
country since,
a date field, indicating since when the company has an office in this country
b.
number of hospitals, a numerical field, indicating the number of hospitals in this country
c.
extra information related to the country that you make up yourself. Examplepolitical
system (Really Important to use Here Political System)
3.
Fill
the three columns with a value for each country. Work efficiently, you can enter
a few values and then copy and paste those, add some other values, copy and
paste, etc. Make sure that several countries have the same data in the column extra
information, for example, if you chose unhealthy national food, then
several countries have hamburger, some other countries have pizza, etc.
Also in the column sales office in this country since several countries should have the same
date, other should have the same month, other should have the same year.
4.
Open
the file in Power BI.
Select in the Navigator “Country Region”.
5.
Create
two different types of charts with different data on your canvas.
Make one dashboard and add these and all following visuals to this same
dashboard on one page.
6.
Add
two different types of slicers to your canvas. The
types of the slicers must be different, you should not create two slicers of
the same type with different data. Changing the data in the slicers must affect
the data in the charts you created in assignment 5.
7.
Add
two more charts of the same type with the same data, but one must be drilled up
to the highest level and one must be drilled down to the lowest level.
8.
Explain
in Word what your canvas displays of this company.
–
First,
briefly describe the company.
– Explain the types of visuals.
Explain what we can learn from the data in the
visuals. Example: “As we can see in the first chart, the majority of the
sales offices were established in 2020.” – if you have data that display
that information.
Use half a page.
