Its very nice article and helpful. While following the steps I realised we can't make use of Lats(generated) and Longs(Generated) in the calculation. Thus we would need a separate Lats and Long columns as a part of data to achieve the same. If its not there you won't be able to achieve the first step.

Create the above all the calculation and drag them to dimensions and make them continuous in type. This are the basic problem I faced. I came to know all this after referring to the workbook link shared.

Is it possible to achieve this with lets just say, using a geographic 'state' or 'zip code' dimension? Very cool example but unfortunately not all my data sets include Latitude and Longitude so achieving this just using a geographical dimension would be really neat!

If you'd like to plot the hexbins with a map on the background, you can add "/[Ratio]" to the end of the formulas. This puts the bins back on the correct coordinates, while also maintaining the bin size used. For example:
HEXBINX([Longitude]*[Ratio],[Latitude]*[Ratio])/[Ratio]

I have implemented the solution Jeffrey gave to show the symbols on a map and it works great. The problem I am having now is that I can't see the underlying data when I click on a specific mark. The goal is to be able to click on the mark and then have a second sheet update with the record list that falls under that mark. Since I can't get the underlying data view to work, I can't update the other sheet. When I click to show underlying data, I get the location of the symbol and a count but the full data is just blank.

I finally solved my own problem. The issue seems to be that the data ends up as a float. As such hexbins that don't land on nice round numbers would fail to show underlying data. So I modified the formulas as such:
round(HEXBINX(round([Longitude]*[Ratio],6),round([Latitude]*[Ratio],6))/((100*[Ratio])/100),6)
round(HEXBINY(round([Longitude]*[Ratio],6),round([Latitude]*[Ratio],6))/[Ratio],6)

Knocking off digits longer than 6 after the decimal allowed it to work. Then I made a sheet with the rows of the records and added it to my dashboard and then used the map as a filter for that sheet so when I click a bin, I see a list of the records right in the dashboard.