Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data

This book provides step-by-step guidance on how to find,load,and transform data from external sources into Power BI for business insights and a competitive edge. It covers connecting to databases,file-based data sources,cloud- and web-based data sources,and using Direct Query and Live Connect. It also covers techniques for transforming inbound data into normalized data sets,pivoting and transposing data,extrapolating missing values,and handling errors. All Power BI users,from beginners to super users,can benefit from the techniques explained in this book to enhance their data preparation skills and leverage external data sources in their analytics.

Format: Paperback / softback
Length: 485 pages
Publication date: 26 August 2022
Publisher: APress

This comprehensive book is a must-have for anyone looking to extract data from external sources and seamlessly integrate it into Power BI for valuable business insights and a competitive edge. It covers a wide range of data connectivity options, including connecting to corporate databases like Azure SQL and SQL Server, as well as file-based data sources, cloud-based data sources, and web-based data sources.

Moreover, the book delves into the powerful features of Direct Query and Live Connect, enabling instant connections to databases and data warehouses without the need for data loading. It provides detailed guidance on techniques for transforming inbound data into normalized data sets that are easy to query and analyze, encompassing data cleansing, data modification, and standardization. You will learn how to pivot and transpose data, extrapolate missing values, and harness external programs like R and Python within a Power Query data flow.

Furthermore, the book addresses the challenges of handling errors in source data and extends basic data ingestion to create robust and parameterized data load and transformation processes. With a focus on delivering compelling and interactive insight with remarkable ease using Power BI's built-in data load and transformation tools, this book is suitable for Power BI users of all levels, from beginners to super users. Whether you are a business analyst, data scientist, or dashboard designer, this book will empower you to unlock the full potential of your data and drive meaningful business decisions.

Weight: 957g
Dimension: 254 x 178 (mm)
ISBN-13: 9781484285770
Edition number: 1st ed.