Power BI has for some time been equipped with feature that enables it to analyze data, and then on the basis of them it is proposed to create appropriate visuals. From recent time such option exists in Excel, and for the time being it can only be used by Office 365 subscribers. This option is called Ideas. Let’s look at how Excel can offer you clues to help you get the most out of your data!
The Ideas option is located in the Home ribbon. To be able to use it, you need to first create a table with some data. In this example, we have selected a simple table with the names of countries in the region and related sales. If we select data, and then click on Ideas, the menu will open on the right side of the screen where Excel suggests what you can do with them. It could be a suggestion to create a chart, a Pivot chart, and so on. By selecting the appropriate option, you add to a worksheet a graphic interpretation based on the selected data.