UID:
almahu_9949907561302882
Format:
1 online resource (813 pages)
Edition:
2nd ed.
ISBN:
1837635862
,
9781837635863
,
9781837639533
Content:
The latest edition of this book delves deep into advanced analytics, focusing on enhancing Python and R proficiency within Power BI. New chapters cover optimizing Python and R settings, utilizing Intel's Math Kernel Library (MKL) for performance boosts, and addressing integration challenges. Techniques for managing large datasets beyond available RAM, employing the Parquet data format, and advanced fuzzy matching algorithms are explored. Additionally, it discusses leveraging SQL Server Language Extensions to overcome traditional Python and R limitations in Power BI. It also helps in crafting sophisticated visualizations using the Grammar of Graphics in both R and Python. This Power BI book will help you master data validation with regular expressions, import data from diverse sources, and apply advanced algorithms for transformation. You'll learn how to safeguard personal data in Power BI with techniques like pseudonymization, anonymization, and data masking. You'll also get to grips with the key statistical features of datasets by plotting multiple visual graphs in the process of building a machine learning model. The book will guide you on utilizing external APIs for enrichment, enhancing I/O performance, and leveraging Python and R for analysis. You'll reinforce your learning with questions at the end of each chapter.
Note:
Extending power BI with python and R: perform advanced analysis using the power of analytical languages, second edition -- Foreword -- Contributors -- Table of Contents -- Preface -- 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 Beyond the Available RAM in Power BI -- 10. Boosting Data Loading Speed in Power BI with Parquet Format -- 11. Calling External APIs to EnrichYour 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 Statistical Insights: Associations -- 16. Adding Statistical Insights: Outliers and Missing Values -- 17. Using Machine Learning without Premium or Embedded Capacity -- 18. Using SQL Server External Languages for Advanced Analytics and ML Integration in Power BI -- 19. Exploratory Data Analysis -- 20. Using the Grammar of Graphics in Python with plotnine -- 21. Advanced Visualizations -- 22. Interactive R Custom Visuals -- Answers -- Glossary -- Packt page -- Other Books You May Enjoy -- Index.
,
Mode of access: World Wide Web.
Language:
English
Keywords:
Electronic books.
URL:
https://portal.igpublish.com/iglibrary/search/PACKT0007111.html
Bookmarklink
