DAX has a variety of functions for working with date and time which do not differ much from similar traditional Excel functions. Time Intelligence functions, on the other hand, are a special group of DAX functions that enable calculations in accordance with time periods: years, quarters, months and days. These periods are used as special filters that allow achieving of the results that we quite hardly get by using traditional calculation methods.
3D Maps (PowerMaps) is tool for graphical representation of data in relation to geographical locations on a 3D model of the planet Earth. It is an Excel add-in that is of version 2016 became an integral part application. Based on location data from the Model Excel is connected with Bing maps and finds geographical coordinates on which to draw map charts for given reporting dimensions, such as turnover (sales) or price difference …
When you use Power Query to retrieve data often need to be “purified” before they can continue to be used in the reports. For this purpose you can use a tool called Query Editor. It opens in a separate window, just like Data model, with its own ribbon menus that have a multitude of options for data processing. The following text will be talking about some basic options that allow transformation of data.
Power Query is an Excel add-in that is used to retrieve data from various sources, connecting to them and purging data before we use them to create a report. It manipulates data in a worksheet, managed within structured table, and allows directly adding them the model. First release of Power Query was an optional add-in for Excel. In version 2016 it has become an integral part of the application. This technology is embedded in PowerBI service.
KPI (Key Performance Indicator) is the most common factor that shows the success of the company in any sphere of business, such as financial performance, customer confidence, employee satisfaction, process management … In Power Pivot reports KPI is obtained by comparing the existing measures with a goal value or another measure. When dragged in the report KPI is presented as a value, goal or status indicator (traffic light) showing whether the target is exceeded, realized or unrealized.