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.

Chapter 7 talked about many concepts pertaining to interpersonal relationships. This assignment covers both chapters. Choose ONE of these movies to watch: On Netflix, you can watch Hitch or the Ugly Truth. On Amazon Prime, you can watch Outsourced or Failure to Launch. These next titles should be available for rent on Google play for $1.99. OR Redbox. Why Did I Get Married (2012) (Links to an external site.) or Free state of Jones (Links to an external site.), Straight out of Compton (Links to an external site.) or Money Monster. (Links to an external site.) You will analyze four aspects of interpersonal relationships and write about them in a two to three page paper using examples from the movie that describe each of the concepts listed below. Integrate the course material and be able to discuss aspects of the relationships you see in the movie using the proper terms.Items to cover in your paper: 1. Knapp and Vangelisti’s stages of relational development - (Chapter 7 - Model of Interaction stages - starting on p. 159) Choose couples in the movie and discuss the coming together and coming apart stages of their relationships.Make sure you name the stage and what is going on during that stage. 2. Supportive and Defensive Behaviors - (Chapter 7 - Relational Climate - see chart on page 173) - give two examples of supportive behaviors and two examples of defensive behaviors that you observed in the movie. Name the behavior, who said it, and what they said or did to demonstrate that behavior3. Relational Dialectics – (Chapter 7 - starting on bottom of page 165) – choose one dialectic you observe in one of the couples. Describe the who, what and how of the dialectic.4. Advice – choose one of the couples and offer at least two pieces of advice about how they could improve their relationship.This paper should include an introductory paragraph with a thesis statement, clearly organized body, and concluding paragraph. Spelling and grammar matter and papers lacking college level writing will receive a lower score.