Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
|Price||$29.28 - $33.99
|Format||Paper book / ebook (PDF)|
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 manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data - and transform it into actionable knowledge.
Prepare and analyze your data the easy way, with Power Query; Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI; Solve common data preparation problems with a few mouse clicks and simple formula edits; Combine data from multiple sources, multiple queries, and mismatched tables; Master basic and advanced techniques for unpivoting tables; Customize transformations and build flexible data mashups with the M formula language; Address collaboration challenges with Power Query; Gain crucial insights into text feeds; Streamline complex social network analytics so you can do it yourself.
by Daniil Maslyuk
Prepare for Microsoft Exam 70-778 - and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the exp...
Price: $31.30 | Publisher: Microsoft Press | Release: 2018
by Chris Webb
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 ...
Price: $31.28 | Publisher: Apress | Release: 2014
by Alberto Ferrari, Marco Russo
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It's meant for rea...
Price: $28.39 | Publisher: Microsoft Press | Release: 2017
by Chris Sorensen
Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. ...
Price: $31.97 | Publisher: Microsoft Press | Release: 2018
by Jaynal Abedin
One of the most important aspects of computing with data is the ability to manipulate it to enable subsequent analysis and visualization. R offers a wide range of tools for this purpose. Data from any source, be it flat files or databases, can be loaded into R and this will allow you to manipulate data format into structures that support ...
Price: $17.99 | Publisher: Packt Publishing | Release: 2014
by Paurush Praveen Sinha
Bioinformatics is an interdisciplinary field that develops and improves upon the methods for storing, retrieving, organizing, and analyzing biological data. R is the primary language used for handling most of the data analysis work done in the domain of bioinformatics.Bioinformatics with R Cookbook is a hands-on guide that provides you wi...
Price: $31.75 | Publisher: Packt Publishing | Release: 2014
by Sanket Thodge
With the ongoing data explosion, more and more organizations all over the world are slowly migrating their infrastructure to the cloud. These cloud platforms also provide their distinct analytics services to help you get faster insights from your data.This book will give you an introduction to the concept of analytics on the cloud, and th...
Price: $31.99 | Publisher: Packt Publishing | Release: 2018
by Karl Pover
While QlikView's data engine complements our thought processes and gives us the ability to rapidly implement insightful data discovery, we must also learn to use proper analytical and data visualization techniques to enhance our ability to make data more presentable.Learning QlikView Data Visualization presents a simple way to organize yo...
Price: $22.99 | Publisher: Packt Publishing | Release: 2013