Power Query for Power BI and Excel
|Price||$27.99 - $32.14
|Format||Paper book / ebook (PDF)|
Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems.
4 5 32
by Neil Dunlop
In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft's Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps.While Be...
Price: $18.76 | Publisher: Apress | Release: 2015
by Gil Raviv
Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming m...
Price: $29.28 | Publisher: Microsoft Press | Release: 2018
by Dan Clark
Understanding your company's data has never been easier than with Microsoft's new Power BI package for Excel 2013. Consisting of four powerful tools - Power Pivot, Power View, Power Query and Power Maps - Power BI makes self-service business intelligence a reality for a wide range of users, bridging the traditional gap between E...
Price: $3.99 | Publisher: Apress | Release: 2014
by Adam Aspin
This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The boo...
Price: $51.08 | Publisher: Apress | Release: 2022
by Mark Polino
Accounting systems like Microsoft Dynamics GP 2013 hold a wealth of information. Excel 2013 provides a great tool for linking to, extracting, analysing, and presenting that rich data to help companies make better, faster, and smarter decisions.Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 covers how to get the rich, d...
Price: $24.99 | Publisher: Packt Publishing | Release: 2013
by Penny de Byl
Mathematics is an essential skill when it comes to graphics and game development, particularly if you want to understand the generation of real-time computer graphics and the manipulation of objects and environments in a detailed way. Python, together with Pygame and PyOpenGL, provides you with the opportunity to explore these features un...
Price: $49.99 | Publisher: Packt Publishing | Release: 2022
by Alison Box
Create stunning and complex visualizations using the amazing new Charticulator custom visuals in Power BI. Charticulator offers users immense power to generate visuals and graphics. To a beginner, there are myriad settings and options that can be combined in what feels like an unlimited number of combinations, giving it the unfair label, ...
Price: $49.99 | Publisher: Apress | Release: 2022
by Marco Russo, Alberto Ferrari
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You...
Price: $33.30 | Publisher: Microsoft Press | Release: 2019