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
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
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
Microsoft Power BI Complete Reference
by Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell
Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life.In this Learning Path, you will learn to create powerful interactive reports by visualizing...
Price: $49.99 | Publisher: Packt Publishing | Release: 2018
Up and Running with DAX for Power BI
by Alison Box
Take a concise approach to learning how DAX, the function language of Power BI and PowerPivot, works. This book focuses on explaining the core concepts of DAX so that ordinary folks can gain the skills required to tackle complex data analysis problems. But make no mistake, this is in no way an introductory book on DAX. A number of the top...
Price: $43.59 | 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
by Dan Clark
Analyze company data quickly and easily using Microsoft's powerful data tools. Learn to build scalable and robust data models, clean and combine different data sources effectively, and create compelling and professional visuals.Beginning Power BI is a hands-on, activity-based guide that takes you through the process of analyzing your...
Price: $30.64 | Publisher: Apress | Release: 2020