It provides advanced interactivity through the use ofĪ Power View report is only a special type of Excel worksheet, and you can have many reports in an Excel file. Not only that, but it is incredibly fast and highly intuitive. Power View is a dynamic analysis and presentation tool that lets you create professional-grade Whether you want or need to use Power Query at all will depend on the complexity of the source data and whether or not you need to cleanse and shape the data first. It is worth noting that you can load data into PowerPivot directly without using Power Query. Create KPIs (Key Performance Indicators) to allow benchmarking.Add hierarchies to enhance the user experience and guide your users through complex data sets.Create calculations and prepare the core metrics that you want to use in your analyses and presentations.Enrich the data model by applying coherent names and data types.This data model will then be used by Power View, Power Map, and the Power BI natural language querying engine. More specifically, it allows you to Create a data model by joining tables to develop a coherent data structure from multiple separate sources of data. Power Query lets you import data and make it useable PowerPivot then takes over and lets you extend and formalize the cleansed data. Indeed, many people refer to the Excel Data Model when they talk about data in PowerPivot. PowerPivot is essentially the data store for your information. With Power Query, you can mash up your own data so that it is the way you want it and is ready to use as part of your self-service BI solution. There was a time when these processes required dedicated teams of IT specialists. Cleanse your data to make it reliable and easy to use.
Shape data into the columns and records that suit your uses.Merge data from multiple sources into a coherent structure.This covers corporate databases to files, and social media to big data. Import data from a wide variety of sources.Power Query allows you to do many things with source data, but the four main steps are likely to be Once your data is selected, cleansed, and transformed into a coherent table, you can then place it in an Excel worksheet, or better still, load it directly into PowerPivot, which is a natural source for data when you are using Power View and Power Map. It allows you to discover, access, and consolidate information from varied sources. Power Query is one of the most recent additions to the self-service BI toolkit. Self-Service Business Intelligence Universe. This is because self-service business intelligence is designed to be flexible and respond to a variety of needs.įig 1. Indeed, you may find that you use them independently or in certain combinations. You may find that you do not need all these products all the time.
Power Map-To show your data from a geographical perspective.Power View-To display your results interactively.PowerPoint-To model data and carry out all necessary calculations.Power Query-To import and transform data.
This consists of Excel (inevitably) and four add-ins thatĪllow you to import, model, prepare, and display your analyses. At the core of Microsoft’s self-service BI is the Excel BI Toolkit.