Excel Power Query and PowerPivot For Dummies [Lingua inglese] - Brossura

Alexander, Michael

Brossura

ISBN 10: 111921064X ISBN 13: 9781119210641

Casa editrice: For Dummies, 2016

Riassunto

Today’s data environment demands more from business analysts than ever before. The volume and types of data sources with which an analyst works reach far beyond the relatively small amount of data encountered just a few years ago.  Analysts find themselves spending valuable time cleaning, shaping and integrating disparate data from an ever increasing array of data sources.  It’s becoming increasingly important for business analysts to expand their skill-set from the one dimensional spreadsheet to new territory like relational databases, data integration, and multidimensional reporting.

 Microsoft has addressed these data processing woes with the release of the new Power BI toolset.  This toolset includes two tools that have been embedded into Excel 2016 as native functionality:  PowerPivot and Power Query. These new power tools provide analysts a set of easy-to-use features for automating the steps needed to integrate a wide array of data sources into Excel reporting models.Excel Power Query & PowerPivot For Dummies will introduce readers to this new set of tools and reporting capabilities that can be leveraged to more effectively source and incorporate “big data” Business Intelligence and Dashboard reports. Not only can these tools allow Excel analysts to save time and simplify their processes, they will also enable them to substantially enhance their data analysis and reporting capabilities.

Su questo libro

L'autore

Michael Alexander is a Microsoft Certified Application Developer and a Microsoft MVP. He has written numerous books on advanced business analysis with Microsoft Access and Excel. His tutorial website, www.datapigtechnologies.com, provides tips on Excel and Access for the Microsoft Office community.

Dalla quarta di copertina

Learn to:

• Extract data from databases and external files for use in Excel reporting
• Create powerful interactive reporting mechanisms and dashboards
• Integrate Power Query with Power Pivot to create truly robust Business Intelligence

The Excel guide that no serious data cruncher should live without!

Want to familiarize yourself with the rich set of tools and reporting capabilities available in Excel? Look no further! Inside, you'll discover how Power Pivot 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.

• Rev up your reporting ? fire up Power Pivot, build table relationships, and create robust pivot table reporting using multiple data sources
• Formulate a plan ? find out how to add formulas to Power Pivot reports and get the know-how to share your BI solutions with others
• When in doubt ? get the lowdown on Power Query, from choosing where to load Query results to refreshing and managing queries?and everything in between
• Can't we all just get along? ? discover how to make Queries work together, build your own Query functions, and make marvelous magic with M Query language
• Get what you need ? transform your way to better data by adding Query filters, filling in blank spaces and empty values, splitting and merging columns, and transposing and pivoting data

Open the book and find:

• How to create your own database right in Excel
• Ways to make pivot tables that use multiple data sources
• How to scrape websites and import hard-to-reach data with Power Query
• Tricks to simplify and automate data cleanup and transformation
• How to create your own powerful formulas and functions to go beyond simple data imports

Dettagli dell?edizione

• Editore: For Dummies
• Data di pubblicazione: 2016
• ISBN 10: 111921064X
• ISBN 13: 9781119210641
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 282