Analysis Tools

Power BI and Powerview are business analytics tool helps you to gain insight into your data by displaying that data in amazing and easy to understand reports. It displays the data in the form of Charts and other views so as to simplify complex information in such a way as to better understand the data. It can connect to numerous data sources and It simplifies data analysis by creating personalized dashboards for ease of use. Power BI is a standalone application that uses Excel and Other Data Sources to create dashboards for viewing complex data. Powerview is an ADDIN that comes with Excel 2013 or 2016

PowerPivot is an add-in for Microsoft Excel 2010 to 2016 that enables you to import numerous of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance. (Description as per Microsoft Website)

Power Map for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways. A power map lets you discover insights you might not see in traditional two-dimensional (2-D) tables and charts. With Power Map, you can plot geographic and temporal data on a 3-D globe or custom map, show it over time, and create visual tours you can share with other people. (Description as per Microsoft Website)

Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more. Power Query being used to create a workbook that connects to external data, transforms data, and creates a data model. With Power Query, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. (Description as per Microsoft Website)