I am working on a collegiate level project. I would like find an ArcGIS product where I could map out my memberships (3k members) for a company named Deep Blue Sail. I have three membership plans, (Prime, Plus, Standard) where I collected revenue from 2012-present in a static excel file.
1. I would like to click in a particular state and have it display my revenue and expenses for 2017. I already have a static excel spreadsheet for this, however all my locational data is in lat/log.
2. Then if I clicked on a state not only would show my the state details of revenue/expenses, but then I could drill down to the county level and see my revenue and expense by different levels of color gradients. Again all of my locational data is in lat/long, so I'm sure I'll have to convert them to county FIPS codes. If there's a conversion program in ArcGIS, please provide a link.
3. Lastly, I would like to see a line graph next to the map and I want my data to simultaneously display results and have them linked. In other words, when I press on a state level such as California it would give me info as described in the first two paragraphs, and it would also include my yearly sales since 2009 to present on a line graph next to the map. I need to understand the historical context of my California revenues and expenses.
Which product can do this? Some of them ... all of them? ArcGIS online? ArcGIS Business Analyst, ArcGIS Insights, ArcGIS Power BI?