Hi !
Today I’ll switch to Excel to share some of the other amazing AI features embedded in Microsoft Office: Excel Ideas.
Excel Ideas is this new tool we have in Excel which will allow us to get some insights about the selected information in a worksheet. In order to use this tool, we need to select a set of data and click the [Ideas] button in the Ribbon.
In order to write this post, I downloaded a sample set of spatial data from SpatialKey (see references). The sample insurance file contains 36,634 records in Florida for 2012 from a sample company that implemented an agressive growth plan in 2012. There are total insured value (TIV) columns containing TIV from 2011 and 2012, so this dataset is great for testing out the comparison feature. This file has address information that you can choose to geocode, or you can use the existing latitude/longitude in the file.
Once I selected the full set of Data, is nice to see the following insights
If you are a PowerBI user, this type of information and analysis will be familiar. To me is nice to see that we have this capabilities in a single click in a popular tool like Excel.
There are over +40 insights and it’s nice to browse them and find that in Miami Dade County, the site deductible is higher for Steel Frame and Reinforced Concrete constructions.
With 2 click we can analyze some Open Data related to traffic on Ontario and see how the traffic slowly increases in Hwy 69.
An amazing tool inside Excel to quickly get insights on our data.
Happy coding!
Greetings @ Toronto
El Bruno
References
My posts
El Bruno 
5 comments