Project: Cultural RapportRemember: This course has major project assignments that will be due in weeks 3 and 5. It will take more than a week’s effort to adequately complete them. Plan time to start the research and other work for those assignments earlier than the week in which they are due. This week, read The First Meeting at NTC and The Second Meeting sections of the case study provided in W1 Project. Also, review discussion questions 6 and 8 at the end of the case study document. Do not skip ahead to future sections of the case study or other discussion questions in the document for this week’s work. Many important issues for the case study lie below the surface and require both background research and critical evaluation to uncover. Based on this week’s assigned sections (and all previous assigned sections of the case study), address the following topics:Continuing IssuesBuilding upon the key themes and cues discovered in the week 1 portion of the final project, what cues exist in this week’s assigned portions that provide further insights on the business practice, task/relationship, communication, and structure issues?Cultural AwarenessWhat cues exist that reveal the practices of cultural awareness (present or lacking) in the case? In particular:How can a negotiator recognize needs and concerns of both parties?How can a negotiator identify options and alternatives?What can a negotiator do to understand strengths and weaknesses of both parties?Conflict ManagementWhat conflict management approaches are being used by the parties in the case study?What better conflict management approaches could be used to create an enhanced negotiation environment and outcome?Cultural RapportBased upon the cues within the context of the case study and the research you have completed, provide at least 3 best practices that international negotiators might use to develop cultural rapport. Defend your recommendations with research. Important hint: You might find it helpful to begin each section of the paper by discussing the key themes and cues you observe. Then, do research on those key themes to both broaden and deepen your evaluation of the case and your understanding of the important issues. In the final product, about half your written evaluation of each topic should be research. About half should be application to the case study. Recommendation for the level one headings for the body of your paper: Continuing IssuesCultural Awareness Conflict ManagementCultural Rapport Best PracticesSubmission Details:Submit your evaluation in a four- to five-page Microsoft Word document, using APA style.

Superstore Sales Analysis Part 1 GuidePlease send me the two different part in different excel and word document. Thank youWelcome! We've just poached you from the Superfone sales analytics team to work for us, here at SuperSTORE. And we have some Superstore sales for you to analyze! Our data includes nearly 10,000 orders with quite a few columns of information.You'll need to do a bit of data wrangling, and then we’d like you to produce some pivot tables, visual cues, and charts, to help us get a better understanding of the top sources of our sales and profits — and any problem areas we may have.DownloadDownload the starter file:Superstore_Orders_2015-18.xlsxSetupStart by creating and naming a fresh copy of the file. Then get the worksheet of data formatted to make it easy to work with.1.Copy the file and change the file name to:Yourlastname_ Superstore.xlsx2.Open the file and format the column widths to fit the data – or slightly wider (or narrower if relevant) to make it easier to read.WranglingLet’s do a little wrangling to prepare for the analysis!1.Format the Order Date and Ship Date columns to the date format mm/dd/yyyy — as this will give us a consistent number of digits for all dates when we load the data into the database.2.Reformat the Customer Names so that they are in the format — Lastname, Firstname — together in one single column. (We do not need more columns! We just want last name first.) HINT: Create a new column and use Flash Fill to do this! Then delete the old column.3.Format the Sales to the Accounting $ format, and then set the number of decimals to two.4.Format Discount as percentages.5.Notice that our Profit amount per order often includes fractions of pennies. Let’s keep track of that while formatting it as money. So, format the Profit column to Accounting $, and set the number of decimals to four.6.Finally, sort these orders by Date rather than by Row ID.Here are two screenshots of my result:Columns A-KColumns L-UNow we’re ready to start analyzing! AnalysisWe will begin analyzing this data by creating 5 pivot tables that will summarize the data in useful ways. Create the following new sheets to analyze our data:Sales by Customer1.Create a pivot table with the following data and formatting:a.Rows contain Customer Names.(There are 793 customers!)b.Columns needed: Sales, Quantity, Discount, Profitc.Arrange Discount so that it comes after Profit.d.Format Sum of Sales to Accounting with 2 digits.e.Change Sum of Discount to Average of Discount. Hint:f.Format Sum of Profit as Accounting, with two decimals (not four — as we don’t need that precision for this report).g.Format Average Discount to Percentages, with two decimals.h.Rename the column headings to be shorter:i.Customerii.Ordersiii.Total Salesiv.Total Profitv.Avg Discounti.Increase the column header font size to 12.j.Make the column header row taller to add white space.k.Add a title to the top row of the worksheet, and apply the Heading 1 style to that row.Your sheet should now look very much like this:2.This pivot table is long! Let’s add visual cues: Use Conditional Formatting to accomplish the following:a.Orders: Apply the Green – White color scale to this column (but not to the Grand Total row at bottom!)b.Total Sales: Apply the Green – White color scale to this column (but not to the Grand Total row at bottom!)c.Total Profit: There are some negative profit numbers, which we want to highlight in red. So apply the Green – White – Red color scale to this column (but not to the Grand Total row at bottom!).d.Avg Discount: Higher discount indicates danger. So apply the Red – White – Green color scale to this column (but not to the Grand Total row at bottom!).Your results should look very much like this:And the last rows should look very much like this:Scroll through your work, and observe the power of this fully operational pivot table!!Then on to the next pivot table!Sales by StateNow let’s build a similar pivot table to view the same data by State instead of Customer.1.Copy the Sales by Customer worksheet.2.Replace Customer with State in the pivot table.3.Update the worksheet heading and title in the tab.4.Adjust the formatting of the pivot table. (For instance, the State column heading may need to be resized to 12pt font.)5.Set up conditional formatting for Orders, Sales, and Avg Discount as they are on the Sales by Customer pivot table.Again, we can see that these conditionally formatted tables are pretty useful!Now, on to …Sales by Category (and Sub-Category)We need a chart that summarizes total sales by category. To do this, we’ll first create a pivot table and then a horizontal bar chart.1.Create a new worksheet with a heading and pivot table, formatted much like above, with the following information:a.Rows: Category, with Sub-Category below.b.Values: Salesc.Be sure to choose the Outline Report Layout, format columns, update heading names, etc.2.Now visualize the data by adding a bar chart (horizontal bar chart).a.Add the chart to the side of the pivot table, size it appropriately, apply a good chart design style.b.Give the chart a heading that matches the worksheet title and tweak design details.When done, it should look something like this. (The pivot table should look just like it, and the chart should be similar to it.)Profit by CategoryNow let’s create something similar for Profit.1.Make a copy of the above worksheet, and change it to show Profit rather than Sales.2.Adjust and update the text and formatting of the pivot table, chart, and worksheet heading as needed.Notice that some of the bars will go negative (for negative profits)! That’s actually helpful — we need to see this. (We can worry about making things more readable later. Don’t sweat it for this assignment.)Time to celebrate! That’s it for this assignment!SubmitWhen complete, submit your Excel workbook: Yourlastname_Superstore.xlsx(No screenshots or Word document required for this assignment!)Superstore Analysis PART 2 GuideWe want to glean some additional insights from our Superstore data. We need you to create a few new pivot tables and charts!Begin With …Make a copy of your completed file from the first Excel Superstore assignment.Name this new file: Yourlastname_Superstore_PART2.xlsxAdd New WorksheetsAdd the following new worksheets. Format them as you did the others.Sales & Profit by RegionCreate a pivot table and bar chart:Rows with regionsDisplaying Total Sales and Total ProfitUsing the clustered bar chart to display both Sales and ProfitSales & Profit by StateCreate a pivot table:Rows in a hierarchy, with States organized under RegionDisplaying Total Sales and Total ProfitUsing conditional highlighting to indicate:ohighest salesolowest and highest profit Sales & Profit by QuarterCreate a pivot table and line chart similar to this:Sales by MonthCreate a pivot table and line chart similar to this:SubmitWhen complete, submit your Excel workbook: Yourlastname_Superstore_PART2.xlsx(No screenshots or Word document required for this assignment!)Discussion: Superstore Analysis Parts 1 & 2Use this discussion board to share tips, recommendations, and discussion regarding the projects in this module. To foster dialogue, I'm requiring everyone to post something -- whether a question, a reflection, or feedback to other users.Here are recommended ideas to prompt your contributions:Have you gotten stuck? You're undoubtedly not alone. Please describe your problem and include screenshots if relevant.Can you provide help in response to another student's question? If so, please do!Did you discover any helpful tips in this process? Please share it. Provide relevant screenshots, links, etc.

Tourism is often one of the largest economic drivers for a local economy. According to the Desert Sun Newspaper, in an article posted on May 23, 2014, titled Events drove $5.8B tourism industry to record levels (Links to an external site.)Links to an external site.."In 2013, more than 180,000 attended the Coachella Valley Music and Arts Festival, with about 45,000 attending Stagecoach: California’s Country Music Festival. The combined 2013 regional economic impact of the events exceeded $254 million"Directions:After reading the article (link above), GO to various tourist websites (example, visithawaii.org). Then find at least two travel/tourism related articles. Analyze these sites for cultural aspects and their marketing strategies. Then analyze the articles for cultural aspects.Finally, in a 1 page response discuss what you found, incorporating answers the following for each source of information analyzed. What kind of cultural information is presented? Who is the intended audience for the website/ article? How are the host communities portrayed? Are the host communities portrayed as welcoming or retreating from tourists? Why?