Extending Power BI with Python and R. Perform advanced analysis using the power of analytical languages - Second Edition

With this updated second edition, you'll not only learn how to configure the Power BI environment to run Python and R scripts at peak performance—you'll also become familiar with the appropriate solutions to the most common problems you may encounter. Extending Power BI with Python and R explores data ingestion and data transformation extensions before moving on to focus on data enrichment and data visualization. You'll learn how to ingest data larger than available memory, import data from external sources, and transform data using complex algorithms, as well as implementing personal data de-identification methods such as pseudonymization, anonymization, and masking in Power BI. You'll find out how to call external APIs to enrich your data much faster, and address I/O performance issues using Python and R. Next, you'll learn advanced Python and R techniques to perform in-depth analysis and extract valuable information using statistics and machine learning. You'll also get to grips with the key statistical features of data sets by plotting multiple visual graphs in the process of building a machine learning model. Your knowledge will be tested through questions and answers at the end of each chapter.

By the end of this book, you’ll be able to enrich your Power BI data models and unlock valuable insights using Python and R.