Details zum E-Book

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

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

Luca Zavarella

E-book
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.
  • 1. Where and How to Use R and Python Scripts in Power BI
  • 2. Configuring R with Power BI
  • 3. Configuring Python with Power BI
  • 4. Solving Common Issues When Using Python and R in Power BI
  • 5. Importing Unhandled Data Objects
  • 6. Using Regular Expressions in Power BI
  • 7. Anonymizing and Pseudonymizing your Data in Power BI
  • 8. Logging Data from Power BI to External Sources
  • 9. Loading Large Datasets Also Beyond the Available RAM in Power BI
  • 10. Optimizing the Loading Time of Referenced Queries in Power BI
  • 11. Calling External APIs To Enrich Your Data
  • 12. Calculating Columns Using Complex Algorithms: Distances
  • 13. Calculating Columns Using Complex Algorithms: Fuzzy Matching
  • 14. Calculating Columns Using Complex Algorithms: Optimization Problems
  • 15. Adding Statistics Insights: Associations
  • 16. Adding Statistics Insights: Outliers and Missing Values
  • 17. Using Machine Learning Without Premium or Embedded Capacity
  • 18. Using the SQL Server Extensibility Framework's R and Python engines with Power BI
  • 19. Exploratory Data Analysis
  • 20. Using the Grammar of Graphics in Python
  • 21. Advanced Visualizations
  • 22. Interactive Custom Visuals in R
  • 23. Infrastructural Review
  • Titel: Extending Power BI with Python and R. Perform advanced analysis using the power of analytical languages - Second Edition
  • Autor: Luca Zavarella
  • Originaler Titel: Extending Power BI with Python and R. Perform advanced analysis using the power of analytical languages - Second Edition
  • ISBN: 9781837635863, 9781837635863
  • Veröffentlichungsdatum: 2024-03-29
  • Format: E-book
  • Artikelkennung: e_3us0
  • Verleger: Packt Publishing