Tammy Milligan owns a chain of small boutique stores in OH, MI, IL, and IN. She is a big believer in the benefits of business intelligence for measuring progress and making strategic decisions. She has provided you with some sample sales data and would like for you to create a dashboard that will give her an overview of how her business is doing. In this exercise, you will build a data model based on the data provided and create a dashboard, complete with KPIs and a map showing which states are generating the most orders.
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Excel. Open the file named e07ch13_grader_h1_Metrics.xlsx. Save the file with the name e07ch13_grader_h1_Metrics_LastFirst, replacing LastFirst with your Last and First name. 0
2 On the SalesData worksheet tab, add each of the tables to the data model. 10
3 Edit the data model by completing the following tasks on the SalesData2016 worksheet:
Format the PurchaseDate field as *3/14/2001
Format the Price field as Currency 6
4 Create a calculated column to the right of Year with the name Revenue. Use the formula =[Price]*[Quantity] to calculate the revenue generated from each sale. Format the column as Currency. 8
5 In Power Pivot, create a calculated field for sum of revenue in the Calculation Area just below the Revenue column. Copy the calculated field and paste it as text into cell J41 of the SalesData worksheet in the main workbook.
From the Power Pivot window, create a KPI that measures the Sum of Revenue value against the absolute value of $500.00. Maintain the default thresholds of 200 and 400 and select the first set of icon styles.
Create a relationship between SalesData2016 and VolumeByEmp using the EmployeeID field. 6
6 In the Power Pivot window, create a Chart and Table (Horizontal) combination on the MetricsDashboard worksheet in cell B2. In the PivotChart, drag the LastName field from VolumeByEmp to the Axis (Categories) area. Drag the Category field from SalesData2016 to the Legend (Series) area. Drag the Quantity field from SalesData2016 to the Values area to calculate the sum of quantity sold.
Change the chart type to a Stacked Column chart. Apply Style 9 to the PivotChart. Add a Chart Title that reads Category Volume by Employee. Add a Primary Vertical Axis title that reads Sales Volume and hide all field buttons.
Add a Timeline slicer connected to the PivotChart, click the PurchaseDate check box, and position it below the chart. Apply the Light Green, TimelineStyle Light 6 to the slicer. 15
7 Name the PivotTable EmployeeRevGoals. Drag the LastName field from VolumeByEmp to the Rows area. Drag the Sum of Revenue Value field from SalesData2016 to the Values area. Drag the Sum of Revenue KPI Status field to the Values area.
Rename the Row Labels heading in J2 to Employees. Rename the Sum of Revenue heading in K2 to 2016 Revenue. Rename the Sum of Revenue Status heading in L2 as $500 Goal Status. If necessary, resize the column to fit the text. Apply the PivotTable Style, Light Green, Pivot Style Medium 14 to the PivotTable. 22
8 From the Power Pivot window, create a PivotTable on the MetricsDashboard worksheet in cell B25. Drag the State field from OrdersByState to the Rows area and the Orders field to the Values area. Rename the Row Labels heading in B25 to State and the Sum of Orders heading in C25 to Total Orders. 12
9 Apply Light Green, Pivot Style Medium 14 to the PivotTable and name it OrdersByState. 6
10 Insert the Bing Maps App for Office to the MetricsDashboard worksheet. Use the data in the OrdersByState PivotTable to generate circles onto the map. Position the map within the cell range E25:J39. 0
11 Prepare the dashboard for production by hiding the SalesData worksheet. Hide the column and row headings as well as the gridlines on the MetricsDashboard worksheet. 9
12 Minimize the ribbon. Protect the worksheet, allowing only to Use PivotTable & PivotChart and Edit objects. 6
13 Save the workbook, exit Excel, and then submit the file as directed by your instructor. 0
My Sister’s Keeper by Jodi Picoult | Summary and Analysis Disclaimer: This work has been put together by an understudy. This isn’t a case of the work composed by our expert scholastic scholars. You can see tests of our expert work here. Any feelings, discoveries, ends or suggestions communicated in this material are those of the writers and don’t really mirror the perspectives of UK Essays. Distributed: Thu, 14 Dec 2017 Anna Transplant Kidney Characters Anna Fitzgerald Anna is a 13-year-old young lady from a working class family in Rhode Island. Her dad, Brian, is a firefighter, and her mom, Sara, is a housewife who used to be a legal advisor. Her two more seasoned kin are Jesse and Kate. Jesse is a grown-up who has had an agitated past and lives in a condo at the family house. Kate is 16 and has recovered from leukemia, yet the medications have harmed her kidneys, and she needs a kidney transplant. Anna is a characteristic decision for the giver since she was imagined to help Kate medicinally and has made gifts to her for a mind-blowing duration. Anna looks for assistance from a legal advisor, Campbell Alexander, to pick up authority over her body so she can quit being a giver to Kate. Anna is more develop than her age and regularly contemplates profound inquiries regarding her sister’s sickness and her job in it. Anna battles with her choices, and despite the fact that she has her upheavals, she is near her sister, and at the conference, she concedes that it was Kate who influenced her to choose to affect the suit. What appeared to be a narrow minded demonstration of a youngster was extremely the adoration for a sister. Despite the fact that Kate’s ailment has kept her from having a typical life, Anna is near Kate and whatever remains of her family. She is on the contrary side from her mom for the situation, yet they are as yet a nearby mother and girl. Her dad endeavors to take care of her and also Kate, and she bonds with Jesse on the grounds that they both feel like they don’t fit in. Anna’s business association with Campbell develops into a more close to home one. She is with him in the disaster area that at last slaughters her. She donates the kidney while kicking the bucket and at Campbell’s ask. At the meeting, she went to bat for herself and her sister and wound up sparing her sister’s life, in any case. Anna, who had dependably felt imperceptible in her family, winds up being a courageous woman. Campbell Alexander Campbell is the legal counselor Anna Fitzgerald requests to speak to her in her claim against her folks. He appears to be chilly and figuring at first by being resolute about Anna’s case and pandering to the media. He has a guide hound, yet he won’t clarify the creature’s motivation. He influences jokes when individuals to get some information about it. His gentler side is uncovered through Julia, Anna’s gatekeeper promotion litem, and the flashbacks to their adolescent sentiment. He is the result of a rich foundation with guardians who are shallow. His epilepsy and, in this manner, the explanation behind the pooch, is uncovered in court. Despite the fact that he wins the case, he feels for the two sides and when looked with choosing to give Anna’s organs, he ensures Kate is the kidney beneficiary. He cleared out Julia every one of those years prior in light of the fact that he didn’t need her to need to manage his condition, however Julia remains with him. He weds her. Sara Fitzgerald Sara is a legal advisor turned housewife. As Brian’s better half and Kate, Jesse, and Anna’s mom, she does all that she can to keep her family together. She is near her sister, Suzanne, who is a lifelong lady. She needs Suzanne to be her rescuer, and she needs Anna to be Kate’s rescuer. She is completely centered around Kate’s ailment and needs to attempt each treatment conceivable. She either overlooks Jesse or gets furious with him. It is her plan to get pregnant with Anna and for Anna to make gifts. She is stunned when Anna sues her and Brian. Her temper and dedication to Kate make her a commendable enemy to Campbell in the court. At first, Sara can not comprehend why Anna is doing this and alienates herself from Brian, yet after every one of the realities are uncovered at the conference, she comprehends the contentions included and how Anna is her very own individual who can settle on her own decisions and that Kate can settle on her own decisions, as well. She and Brian turn into a more grounded couple, and she makes harmony with Anna before her demise. She was broken by Anna’s demise and sought after her arrival. Through her family, she recuperated. Brian Fitzgerald Brian is a tried and true spouse to Sara and father to Kate, Jesse, and Anna. He is a firefighter who adores his activity. His side interest is space science, and he makes cosmic references that can identify with his very own life. At the point when Anna sues him and his significant other, he is shocked however needs to help Anna. He moves her into the fire station so she can have some separation from the home circumstance. This puts a strain on Brian and Sara’s marriage, and they simply discuss the therapeutic issues. His choice to affirm for Anna at the meeting does not improve the situation. At the meeting, in any case, he alters his opinion and needs Anna to give. Brian is truly tangled on the issue. He isn’t just a protect specialist; he jumps at the chance to save everybody around him, and for this situation, he can’t. Despite the fact that his sister-in-law Suzanne can help the family monetarily, he needs to be the supplier. He is the special case who learns Jesse is the illegal conflagrationist and sets him on the correct way. He develops nearer to his significant other as they figure out how the therapeutic issues have eclipsed their marriage. He builds up a drinking issue after Anna’s demise however overcomes it. Jesse Fitzgerald Jesse is the most established tyke in the Fitzgerald family. After his sister is determined to have leukemia as a little child, he is as yet a youngster himself and frequently needs to surrender occasions for Kate. After Anna’s introduction to the world, he feels futile in light of the fact that he is the kin that can’t help. He carries on in school and is on a descending winding into medications, liquor, taking, and illegal conflagration as he grows up. He endeavors to extend the dissident picture around his family, Julia, and Campbell, however his activities demonstrate his milder side. He gives platelets to Kate secretly. He helps Anna out by taking her to the legal counselor’s office and when visiting Kate. Brian discovers Jesse is the incendiary, and Jesse has an achievement. He behaves recklessly on the grounds that he can control it. Fire is a subject in the book, and Jesse demonstrates the negative side of flame. He turns into a cop and wins a honor. He changes himself from a destroyer to a rescuer. Julia Romano Julia is the gatekeeper advertisement litem relegated to speak to Anna in the consultation. She needs to make a report about which side she bolsters. She was an agitator as a youngster from an extensive, poor family and has transformed into a mindful grown-up. She is near her twin sister. Close careful connections penetrate the book, including Anna and Kate’s and Sara and Suzanne’s. She had a sentiment with Anna’s legal advisor, Campbell Alexander, as a youngster regardless of their class contrasts. She was harmed when Campbell surrendered her. As she works with him on Anna’s case, she is pulled in to him despite the fact that she attempts to oppose it. She is great with Anna and Kate in light of the fact that she converses with them like they are genuine youngsters. At the meeting, she can’t pick a side. She at long last realizes why Campbell abandoned her after he has a seizure at the meeting. When she discovers he has epilepsy, she declines to desert him. They get hitched. Kate Fitzgerald Kate is determined to have leukemia as a little child. At the point when her sibling, Jesse, does not coordinate her for bone marrow gift, their mom Sara has the plan to get pregnant with a child who is a hereditary counterpart for Kate. Anna is conceived, and she gives to Kate on a few events. Kate battles with being an ordinary adolescent and having malignant growth since her appearance is influenced, and her first sweetheart had disease and kicked the bucket. At 16, Kate is malignant growth free, yet the medications have influenced her kidneys, and she needs a kidney transplant. It is accepted Anna will be the giver, yet she records a claim to pick up command over her body so she can quit giving. Anna uncovers at the consultation that Kate was self-destructive and asked her not to give a kidney. Kate needed her sister to be free of commitments to her. The judge rules for Anna, however after Anna bites the dust in a disaster area, Kate gets Anna’s kidney. She recuperates and turns into a move educator. She had disclosed to Julia she needed to be a ballet dancer since she could have command over her body. Duracell Dan He is the vagrant Jesse rewards to keep his illegal conflagration materials. He is with Jesse at one of his flames and reveals to Jesse a vagrant is in the consuming building. This powers Jesse to spare the man. Suzanne Crofton Suzanne is Sara’s more seasoned sister. She is a solitary, vocation lady who carries on with an unexpected life in comparison to Sara. She is a help amid Kate’s ailment and even attempts to help monetarily. Vern Stackhouse Vern is a sheriff and companion of the Fitzgerald family. He serves Sara with papers identified with Anna’s claim. He is around amid the consultation and gives help to the family and Campbell. Isobel Romano Isobel is Julia’s indistinguishable twin sister and flat mate. She had an awful separation and alerts Julia against Campbell. Around the end, Isobel and Campbell appear to go to a comprehension. Items/Places Provision Hospital This is the place Kate is analyzed and has her medicines and different remains. Anna is likewise a patient here as a benefactor. Her introduction to the world and demise happen here. The Fitzgerald House This is the home of the Fitzgeralds where Brian, Sara, Kate, and Anna live. Jesse lives in an abutting flat. The Fire Station This is the place Brian works and where he and Anna live to give Anna some separation from her mom and the case. The housetop is a most loved place to watch the stars. The Locket Brian gives the memento to Anna as a tyke after one of her gifts. It is a thank you present for helping Kate. Thirteen-year-old Anna pitches it at a second hand store to fund-raise for lawyer charges. The Courthouse This is the place the conference is. Campbell and Anna’s mysteries are r>