Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities.
Excel Power Query & Power Pivot For Dummies is the ideal resource for any professional whose daily operations foster a data intensive environment. Some examples could include Sales Managers, Data Analysts, Business Operations Analysts, Administrative Assistants, Office Managers, Government Employees, Manufacturing Managers, Engineers, Scientists and more.
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of more than a dozen books on advanced business analysis with Microsoft Access and Excel. He has more than 16 years' experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. He has written many other Excel books for Wiley, including Excel Macros For Dummies and Excel Dashboards & Reports For Dummies.