Fuzzy Lookup is an Excel add-in created by a Microsoft development team, and can be used for advanced search and comparison of column values in tables. Why does this serve for? For example, in practice, it often happens that, when entering a name and surname, an error occurs or there is no one-way entry. Fuzzy Lookup allows you to compare the column based on the similarity and display the corresponding results in the new table.
PowerBI Desktop application allows you to import data from many sources: file, database, BI solution, “Big“ (unstructured) data, Microsoft “cloud” (Azure), the web page … Given the fact that there is no good report without quality data I think it is appropriate to devote one recipe especially to this problem. Below, I’ll show you how, with the help PowerBI Desktop you can import, purge and combine various data.
In a previous post I talked about the history and gave brief introductory remarks regarding PowerBI service and its “tastes” (PowerBI, PowerBI Desktop, PowerBI Mobile). In the text that follows you will see how to apply on PowerBI service and import data from a desired source. We will connect to data table, taken from ERP solution, and connect to the data you will later use to create the report. Concentrate, the magic begins!
Most of us are using Google Maps, but a few years ago Microsoft also went into the race and created its own version of the maps named after its Bing search engine. From Excel 2016 exists an add-in with the same name that you can use to display charts on maps. It allows you to display data, in a form of charts, positioned on maps that can be customized to the desired report layout.
In the previous “recipe” you could read about add-ins that you can download from the Office Store. One of them is called People Graph, and starting from the 2016 version, it’s a standard part of Excel. People Graph is convenient for showing charts that describe the results of a survey in which a population is being tested. It is used in a very simple way, and it enables the creation of picturesque reports.