Assignment Type: Individual Project

A hands-on assessment project to explore the world of data analytics, using Tablaeu Sample Dataset: Sample Superstore Dataset to transform the raw data into meaningful information. The dataset contains product information, customer orders, and regions. The dataset will benefit local suppliers and the offshore industries.

Individual Project Instructions:

1. Open a sample Dataset from Tableau: Example, from:

C:Users<your_name>DocumentsMy Tableau RepositoryDatasources2019.2en_US-US à Select the Sample Superstore Excel file

1. On the left Navigation pane “Connect” to open a File, click on Microsoft Excel – Browse to select the sample dataset from step #2 above: Sample Superstore Dataset: Click Open à Result Displays the Sheet1
2. From Connections: Sample Superstore: Drag Sheets to the working pane –

• Orders
• People
• Returns

1. In the top center Working page, Connection, select Extract -> Add (displays the Sheet 1 – ready for your to do drag and drop to analyze the data)
2. Click on the Sheet1 to open the Data and Analytics page. Rename the Sheet1 to Assessment2
3. On the Pages/Filter/Marks section: Fill in the Columns and Rows
4. Drag to the Rows -> Dimensions

• Example: Category, City, Country, Customer ID, Product Name, Segment

1. Drag to the Columns -> Measures

• Example: Discount, Profit, Quantity, Sales
• Result shows a horizontal bar:

1. Save the horizontal bar screenshot as Assess2-1-horizontal_bar
2. Right click on the Assess2-1-horizontal_bar, select Duplicate to create sheet2

• Rename to Assess2-2-Stacked_bars
• From the right side, Click on Stacked bars to change the graphical display.

1. Repeat same to save total of five additional graphical display as follows:

• Appendix A: Assess2-1 – horizontal bar
• Appendix B: Assess2-2 – stacked bars
• Appendix C: Assess2-3 – text tables
• Appendix D: Assess2-4 – circle views
• Appendix E: Assess2-5 – scatter plots

1. From the right side, try to change selections to get a Highlight Tables in the graphical display.

• Double click to Rename the sheet to Highlight_Tables
• Capture screenshot and save as Appendix F: Assess2-6 – highlight tables

1. Using sample sheets above create your new design of another Dimensions and Measures

• Rename the Sheet to your design name. Capture screenshot and save as Appendix G: Assess2-7 – your name

1. Save all the four sheets, use Snipping Tool to do screen capture of the seven sheets, copy and paste to a word doc, and save.
2. Add an overview about one paragraph to explain each sheet. Save and submit for grading in iLearn. Maximum page about 4-6 pages (title page and Appendixes included).

 

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!
Use Discount Code “Newclient”for a 15% Discount!”

We have Walden University and Capella University nursing practitioners!

Business Finance

Perform a brief 5 forces analysis on the textile industry. For each force, write no more than 1 or 2 sentences to explain the strength of the force. Please state the overall attractiveness of the industry at the end of your answer.

The textile industry consists of firms that manufacture and distribute fabrics for use in clothing, furniture, carpeting and so forth. Several firms have invested heavily in sophisticated manufacturing technology; many lower cost firms in Asia have begun fabric production. Textiles are not branded products. Recently, tariffs on some imported textiles have been implemented. There are numerous firms in this industry, the largest have less than 10 percent market share. Traditional fabric materials (such as cotton and wool) have recently been threatened by the development of alternate chemical based materials (such as nylon and rayon), although many textile companies have begun manufacturing with these new materials as well. Most raw materials are widely available, although some synthetic products may be in periodically in short supply. There are numerous textile customers, but textile costs are usually a large percentage of their final product’s total cost. Many users shop around the world for low prices on textiles.

4

Mini Case Scenario (1)

International cow packers (ICP) is a $12 billion meat processor (slaughter, processing, and packing). Founded in 1943, ICP has grown to become the largest beef and pork processor in the United States (revenues come 90% from beef and 10% from pork), and also has a growing export market to Japan. The company follows a cost strategy, delivering USDA graded meats primarily to the institutional (schools, prisons, hospitals) and supermarket channels. ICP’s entire value chain is organized to deliver volume product at the industry’s lowest per-unit cost. Its supplier industries, primarily cattle and swine feedlots have relatively little power since prices for these raw materials are determined in the commodity markets. While entry barriers to the industry are high due to high minimum start-up costs, industry rivalry is primarily between the three large companies (including ICP) that control 80% of the market for processed meats. The threat of substitutes is high with an increasing trend for consumers to favor poultry and other non-beef proteins. Buyers are also powerful since supermarkets are relatively concentrated at a regional level and end-consumers have ample choices.

1. Based on this scenario, is ICP’s low-cost strategy appropriate for its industry? Why? (2 points)

2. Based on the scenario, what risks is ICP accepting by adopting its low-cost strategy? (2 points)

3. Based on the scenario, what can ICP do to decouple itself from the ups and downs of the pure commodity markets? What specific actions might ICP undertake? (3 points)

5

Mini case scenario (2)

Your friend from high school calls you and asks to borrow $10,000 so that he can open a pizza restaurant in his hometown. He acknowledges that there is a high degree of rivalry in the market, that the cost of entry is low and that there are numerous substitutes for pizza. However, he believes that his pizza restaurant will have some sustained competitive advantages. For example, he is going to have sawdust on his floor, a variety of imported beers, and a late night delivery service.

• Will you lend him the money?
• Why or why not?