PAS

Business Analytics 1 – Material with highest sales

Exercise Over all years, which product had the highest sales in USD. What was the amount?

Task Find the product that had the highest USD sales. (Hint, Use Revenue USD, Prod Descr)

Hint: Place Revenue USD in Rows (Accounts), Place Prod Descr in Columns (Dimensions).

Place your answer and a screen shot of your results here.

Answer: _________

Business Analytics 2 – Total revenue in 2015

Exercise What was the total revenue USD in 2015? Time 10 min Zeist 10 Min.

Task Display -using a column chart- the total sales revenue in year 2015.

(Click on “More” (3 dots) on the top menu bar; and click on “Chart” to continue). Hints:

1. Report the revenue by adding the Revenue USD to account

2. Add the Year to dimension.

3. Filter the Year dimension to refer only to year 2015.

Place your answer and a screen shot of your results here.

Answer: _________

Business Analytics 3 – Customer with over 10 million dollars purchase in 2018

Exercise Which customer(s) had purchased goods over 10 million dollars in 2018?

Task Using a horizontal bar chart- which customers(s) had achieved a purchase proportion over 10 million dollars in year 2018. How much was their total purchases?

Hints:

1. Add the Revenue USD to account.

2. Add the Customer Descr to dimension.

3. Add Year to Color

4. Filter the Year dimension to refer only to the year 2018.

5. From Settings, select Show Data Labels in order to see data labels directly on the chart.

6. Sort the Revenue USD measure Ascending.

Place your answer and a screen shot of your results here.

Rocky Mountain Bikes

Business Analytics 4 – Products with no sales in the last 5 years

Exercise Which product(s) had no sales data during the last 5 years of data?

Task Using a text table- which product(s) had no sales data in 2015 thru 2019?

Hints:

1. Use a table

2. Add the Revenue USD to accounts.

3. Add Product Descr to Rows (Dimensions).

4. Add Year to Columns.

Place your answer and a screen shot of your results here.

Answer: ___________

Business Analytics 5 – Quantity of materials sold per year

Exercise Show the quantity of materials sold per year.

What was the quantity of air pumps sold in 2018? Time 10 min

Task Using any choice of graph- show the quantity of air pumps sold in 2018

Hints:

Business Analytics 6 – Annual revenue trends in US & Germany

Exercise For the US and Germany, are the annual revenue trends similar?

Task Using an donut chart- display the revenue (not revenue USD) acquired by each year in both the US and Germany, then compare both results,

What was the 2018 revenue and % of total revenue for Germany (DE)?

What was the 2018 revenue and % of total revenue for the US?

Hints:

1. Add Revenue to account.

2. Add the Year to dimensions.

3. Add Country to Color.

Business Analytics 7 – Seasonality

Exercise Seasonality in revenue is important in any business.

Task Using a line chart show monthly revenues USD achieved across all years. What month has the least revenue and what is the amount?

1. Report the revenue by adding the Revenue USD to account.

2. Add Month to dimensions.

Place your answer and a screenshot of your work here.

Answer: _________

Business Analytics 8 – Total revenue per customer

Exercise What customer has given GBI the most revenue USD over all the years. What is that amount?

Task Using a tree map- show the total revenue USD achieved by each user per year sorted from the smallest revenue to the highest. What was the revenue for highest buyer?

Hints:

1. Report the revenue by adding the Revenue USD to accounts field.

2. Add the Customer Descr dimension into the X-Axis field.

3. From Settings, select Show Data Labels in order to see data labels directly on the chart.

Place your answer and a screenshot of your work here.

Answer: ___________

Business Analytics 9 – Most purchased product

Exercise What was the most purchased product by Rocky Mountain Bikes? How much did they purchase over all the years?

Task Using a horizontal bar chart- show in USD the product most purchased by Rocky Mountain Bikes.

1. Report the revenue by adding the Revenue USD account to the Y-Axis field.

Place your answer and a screenshot of your work here.

Answer: _______

Business Analytics 10 – Total revenue by country

Exercise What was the most sold product by revenue, in both the US and Germany?

Task Using any chart you like to show the revenue (revenue, not USD revenue) for the US and Germany. Your screen shot should be sorted from highest to lowest showing the one product that sold the most in the US and Germany over all the years.

What was the product? (ProdDescr)?

What was the total revenue for US?

What was the total revenue for Germany?

Hints:

1. Report the revenue by adding the Revenue account to the Y-Axis field.

2. Add the product Description dimension to the X-Axis field.

Place your answer and a screenshot of your work here.

Answer: ____________

Professional Touring Bike (red)