A few years ago, Excel, which comes as part of a Microsoft 365 subscription, got the Ideas option. Now this option has been improved and is called Analyze Data. It enables, with the help of artificial intelligence, simple and fast data analysis to generate tables, pivot tables or charts according to user questions, which help user to visualize data in appropriate business reports.
For several years now, Power BI and Excel have been developing side by side with the idea that analysts do not save all their tables exclusively on a local computer, OneDrive or SharePoint repositories, but that they can also download them from Power BI reports that are published on the company’s tenant. If you use a Microsoft365 subscription that is connected to a company account, you can easily retrieve such tables.
When making reports, users often create measures using complex DAX expressions. Because of this, they often use some external tools to prepare and analyze the created measures. For this reason, the Power BI development team added, in addition to the three existing ones, one more view within the Power BI Desktop application. It enables the creation and analysis of complex DAX measures.
Power Query (which has been the go-to tool for importing data into Excel for some time now) has a new option! Rereiving data from PDF documents has been around for a long time, and now you can also pick up tables from an image or image on the clipboard. So, if someone sends you an invoice that they took a photo of via Viber or WhatsApp, you don’t have to enter the data manually.
Structured tables (Tables) make it much easier for us to work with data. When we convert a range of data into a table and then give it a suitable name, we can easily access each column by specifying its name or a combination of table and column names. By entering a formula in the first cell, it is automatically updated in remaining cells within the column. And what if we don’t want that? What should we do if we need to use the current row value?