(Ebook) Extending Power BI with Python and R: Perform advanced analysis using the power of analytical languages, (2nd Edition) by Luca Zavarella ISBN 9781837635863, 9781837639533, 1837635862, 1837639531

(Ebook) Extending Power BI with Python and R: Perform advanced analysis using the power of analytical languages, (2nd Edition) by Luca Zavarella ISBN 9781837635863, 9781837639533, 1837635862, 1837639531

Ingest, transform, manipulate, and visualize your data beyond Power BI's capabilitiesKey FeaturesDiscover best practices for using Python and R in Power BI by implementing non-trivial codeEnrich your Power BI dashboards using external APIs and machine learning modelsCreate any visualization, as complex as you want, using Python and R scriptsBook DescriptionWith 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.What you will learnPerform complex data manipulations not possible by default in Power BIApply data anonymization and data pseudonymization in Power BILog data and load large datasets in Power BI using Python and RExtract insights from your data using linear optimization and other…