Pro Data Mashup for Power BI
Powering Up with Power Query and the M Language to Find, Load, and Transform Data
| Price | $51.08 - $52.45
|
| Rating |  |
| Author | Adam Aspin |
| Publisher | Apress |
| Published | 2022 |
| Pages | 485 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484285778 |
| ISBN-13 | 9781484285770 |
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 book also explains the use of Direct Query and Live Connect to establish instant connections to databases and data warehouses and avoid loading data.
The book provides detailed guidance on techniques for transforming inbound data into normalized data sets that are easy to query and analyze. This covers data cleansing, data modification, and standardization as well as merging source data into robust data structures that can feed into your data model. You will learn how to pivot and transpose data and extrapolate missing values as well as harness external programs such as R and Python into a Power Query data flow. You also will see how to handle errors in source data and extend basic data ingestion to create robust and parameterized data load and transformation processes.
Everything in this book is aimed at helping you deliver compelling and interactive insight with remarkable ease using Power BI's built-in data load and transformation tools.
- Adam Aspin (8 books)
Similar Books
Expert Data Modeling with Power BI, 2nd Edition
by Soheil Bakhshi
This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create full-fledged data models using Power BI confidently. In this new, fully updated edition, you'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models t...
Price: $53.99 | Publisher: Packt Publishing | Release: 2023
Introducing Charticulator for Power BI
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
Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI 
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
Power Query for Power BI and Excel
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: $27.99 | Publisher: Apress | Release: 2014
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
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 Reza Rad
Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing a...
Price: $40.88 | Publisher: Apress | Release: 2018
Pro Power BI Desktop, 3rd Edition
by Adam Aspin
Deliver eye-catching and insightful business intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features of Microsoft's continually evolving visualization product. New in this edition is help with storytelling - adapted to PCs, tablets, and smartphones - and the building of a data ...
Price: $55.83 | Publisher: Apress | Release: 2020
Building Dynamics CRM 2015 Dashboards with Power BI
by Steve Ivie
Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales an...
Price: $44.99 | Publisher: Packt Publishing | Release: 2015