FACTORY ESCAPE GAME

Megacorp Toy Factory

start

ESCAPE ROOM

THE MISSION

The executive board at Megacorp has decided to sell the private toy company. A competing toy company SASBro is considering purchasing Megacorp to expand their presence in the market. The executives at SASBro have enabled a team to assess and determine if they should acquire Megacorp. Part of the acquisition requires a review of the company’s production, profit, and distribution. You have been hired on as a consultant to help the team develop an interactive report to review each of these metrics. You will work with different team members to create the report.

megacorp. part 1. investigate

Find the clue you need to keep moving forward

QUESTION 1/4

2.2 million rows, 32 columns

How many rows and columns are in the MEGACORP2020 table?

2.4 million rows, 30 columns

QUESTION 2/4

Default aggregation is Sum, which is not appropriate for rates.

What is the aggregation for Unit Reliability and Unit Yield (rate)? Are these aggregations appropriate?

Default aggregation is Sum, which is appropriate for rates.

QUESTION 3/4

How many date data items are in the table?

QUESTION 4/4

How many unique values does Product Line have?

megacorp. part 2 prepare

Find the clue you need to keep moving forward

HANDS ON!

Activity 1. Change Product ID and Day of Week to category.

Activity 2. Rename Unit Reliability to Unit Reliability (avg) and change the aggregation to Average.

HANDS ON!

Activity 3. Convert to geography data items: Use Region Latitude and Region Longitude to change Facility Region to a geography data item. Use State Latitude and State Longitude to change Facility State to a geography data item. Use City Latitude and City Longitude to change Facility City to a geography data item. Hide all the Latitude and Longitude data items since their information is encompassed in new data items.

HANDS ON!

Create the Product Hierarchy data item containing Product Brand, Product Line, and Product, respectively. After completing the above, create a page with the following: Automatic chart using Unit Reliability Automatic chart using Facility City Automatic chart using Product Hierarchy

PART 2. PREPARE. Which image is the most similar to the once you have?

OPTION 1

OPTION 2

OPTION 3

megacorp. part 3. explore

Find the clue you need to keep moving forward to Part 3. Explore. Create a table to answer the following:

QUESTION 1/3

East, South and North

What are the regions in Megacorp?

East, North, South, West

West and South

QUESTION 2/3

0.6192, weak relationship

Part 3. Explore. Examine the relationship between Facility Age, Unit Age, Unit Capacity, Unit Downtime, and Unit Yield (actual). What is the degree of correlation between Unit Capacity and Facility Age?

0.6394, strong relationship

0.6194, strong relationship

QUESTION 3/3

• $23,871,222.01

Part 3. Explore. Examine profits by Product Brand and Product Line What is the profit for the Toy brand for all years?

• $23,871,222.05

• $23,872,222.05

megacorp. part 4. report

Find the clue you need to keep moving forward. Part 4. Report

As you create your final report, remember to create organized pages with specific information on each page. Titles and additional text about the page contents and controls available will help your report’s navigability. Follow these requirements when building:

• For all pages in the report, a viewer should be able to choose a range of years displayed.
• Leadership wants to see both the total profit value, as well as the profit by year.Include a geographical representation of the regions, states, and cities using drill-down functionality that shows the profits and other details for each level.
• They want an analysis of profits by products produced, showing the analysis for Product Brand and Product Line.
• The directors occasionally want to see details about a specific location, a specific product, or both. The answers to these questions should be available at any level for locations or products. Typical information requested includes profits, capacity, targets, and actual quantities produced. Create a page that provides this content and can be viewed only upon request (AKA hidden page- but word it better).

part 4. report

QUESTION 1/4

2008-2020

2008-2022

After completing your report, provide the answers to the following: What is the range of years?

2009-2020

2008-2015

QUESTION 2/4

51M

32M

What is the total profit?

75M

48M

QUESTION 3/4

Florida

Iowa

Which state is the “North” facility region bubble displayed within?

Virginia

Kentucky

QUESTION 4/4

How many tabs/pages does leadership see when viewing the report (i.e. not in edit mode)?

megacorp

Find the clue you need to keep moving forward

so..what's your recommendatioN?

SASBro executives are waiting for you

START OVER?

Are you sure you want to go out?

You will lose progress

exit

back

Uh oh!

Factory malfunction

try again