Microsoft Business Intelligence Tools for Excel Analysts
This book has been written to introduce the business analyst to the rich toolset and capabilities that can be utilized to create more effective source and incorporate large datasets that can enable them to save time and even their reporting process will become simple.
It will introduce step by step about the BI tools like power pivot, SQL server and share point and even provide guidance about the movement of data backward and forward between these tools and excel. Even it provide information about the leverage of these databases, how to slice the data into several views to know about the different visibility prospective, creating eye catching visualizations and dashboards. Automate retrieval and integration of SQL server and about publishing dashboards and reports to the web.
Even readers may grasp about the usage of the SQL server’ built in functions for the analysis of the large amount of data, power pivot tables to access and report OLAP data and to create powerful mechanisms for reporting.
This has been written for the excel analysts to enhance their skills for the excel data analysis with this Microsoft business intelligence stack. Even readers can learn about the power query and power view along with the power pivot which can be helpful for enhancing their efficiency in data handling and analyzing.