Power BI: Hex Maps.

Create a Hex Map using Synoptic Panel which allows you to upload images to the online tool and then define areas of the image that can be segmented within the tool. In this challenge, we will be utilizing a 2019 dataset on US state migration to visualize the movement between US states.

Part of the Power BI Work Out Wednesday Challenges, reference below.

Data Source:

From 2019 Census - State to State Migration Flows. Available on Data.World.

Challenge Requirements

• Either download the Excel data files or utilize the data.world connector from the link, here.
• Load the file named “State_to_State_Migrations_Table_2019.xls”
• Load the file named “State Mapping.xlsx”
• Perform the necessary query steps to match the data found in the final data model.
  
  • Fields: State To, State To Abbr, State From, State From Abbr, Population Moving
  • HINT 1: Why join once, when you can join twice?
  • HINT 2: Do not forget about the District of Columbia. It might disappear if you don’t pay close attention.
• Import the custom visual, “Synoptic Panel by OKViz”.
• Build a Hex Map using one of the default templates to show the states people have moved most commonly from
  
  • Use your own color scheme and have fun with it
  • HINT 1: Only one State To can be evaluated at a time
  • HINT 2: Knowing the order of the population moving by state might help
• Build a bar chart to show the top states people are moving from utilizing the same color scheme as the Hex Map
• Perform final formatting. Match my format or put your own spin on it.

Reference: https://www.workout-wednesday.com/2022/01/21/pbi-2022-w04/

Please look at more fun examples of my skills and projects in my Power BI portfolio.