Problem 1: Create the following viz to show a stylized map of the USA.
• Using the Mapping_US Excel file, create the map using a Shapes chart.
o Use a filled square as your mark.
• The number shown in each square (in top map) is the number of distinct donors from each state.
• The Total Gift Amount Received legend should include $0 (for states with no donations).
Hint: use ZN function in calculated field.
• The legend should show the full range of donation amounts from $0 to $3.2 Million.
• Set the tooltip to show the number of donors and the total donated from a given state.
The tooltip should look as follows if the user hovers over a state with no donors.
See Problem 2 on following page.
Problem 2: In this problem, we will duplicate and augment the dashboard/viz from Problem 2. You will need to Advanced_donations_and_giving_Expanded file.
1. Create a parameter that allows the user to state whether to filter by a particular state or use information from the whole country. Call it: Get Information from Largest donor from:
1. Create a calculate field using LOD calculations that finds the Largest Total Donated
o If the user selects a specific state, this amount should the total amount donated by the largest donor in that state.
o If the user selects “Whole Country,” this should be the total amount donated by the largest donor across all states.
2. Create a Worksheet Called Donation
o You will need to filter the data displayed based on what is selected in the parameter. Create a calculated field named Filter Selection
The calculated field will evaluate to True or False.
o Drag the calculated field to the Filter card. Set the Filter to display only True values.
o Select a particular state in the pull down menu of your parameter.
o Place Largest Total Donated in the Text Card. You should then see the largest donation for that state.
3. Notice that your Filter Selection does NOT work if you select ‘Whole Country.” Update the calculated field to be set to True if the state name matches, or if the parameter is set to ‘Whole Country.”
• Once you do this, think carefully whether to show Largest Total Donated as a Measure, Dimension or Attribute.
4. Similarly, create worksheets that have
o Name of largest donor (at state level, or across the whole county)
o Last Donation Date (by largest donor, at state level, or across the whole county)
o Major (of largest donor, at state level, or across the whole county)
For each of these, you will need to use LOD calculations. Note that you can embed LOD calculations in IF Statements.
5. If the user selects a particular state, that state should be highlighted.
6. Construct the Dashboard. Change backgrounds and use containers as needed. See how dashboard will look for Michigan and the whole country below.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
