|
|
|
|
| LEADER |
05957nmm a2200481 u 4500 |
| 001 |
EB002207497 |
| 003 |
EBX01000000000000001344698 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
240503 ||| eng |
| 050 |
|
4 |
|a QA76.9.I52
|
| 100 |
1 |
|
|a Zavarella, Luca
|
| 245 |
0 |
0 |
|a Extending Power BI with Python and R
|b perform advanced analysis using the power of analytical languages
|c Luca Zavarella ; foreword by Rajat Talwar
|
| 250 |
|
|
|a Second edition
|
| 260 |
|
|
|a Birmingham, UK
|b Packt Publishing Ltd.
|c 2024
|
| 300 |
|
|
|a 814 pages
|b illustrations
|
| 505 |
0 |
|
|a Cover -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Where and How to Use R and Python Scripts in Power BI -- Technical requirements -- Injecting R or Python scripts into Power BI -- Data loading -- Data transformation -- Data visualization -- Using R and Python to interact with your data -- Python and R compatibility across Power BI products -- Summary -- Test your knowledge -- Chapter 2: Configuring R with Power BI -- Technical requirements -- The available R engines -- The CRAN R distribution -- The Microsoft R Open distribution and MRAN
|
| 505 |
0 |
|
|a Includes bibliographical references and index
|
| 505 |
0 |
|
|a Multi-threading in MRO -- Choosing an R engine to install -- The R engines used by Power BI -- Installing the suggested R engines -- The R engine for data transformation -- The R engine for R script visuals on the Power BI service -- What to do when the Power BI service upgrades the R engine -- Installing an IDE for R development -- Installing RStudio -- Installing RTools -- Linking Intel's MKL to R -- Configuring Power BI Desktop to work with R -- Debugging an R script visual -- Configuring the Power BI service to work with R -- Installing the on-premises data gateway in personal mode
|
| 505 |
0 |
|
|a Chapter 4: Solving Common Issues When Using Python and R in Power BI -- Technical requirements -- Avoiding the ADO.NET error when running a Python script in Power BI -- The real cause of the problem -- A practical solution to the problem -- Avoiding the Formula.Firewall error -- Incompatible privacy levels -- Indirect access to a data source -- The easy way -- Combining queries and/or transformations -- Encapsulating queries into functions -- Using multiple datasets in Python and R script steps -- Applying a full join with Merge -- Using arguments of the Python.Execute function
|
| 505 |
0 |
|
|a Sharing reports that use R scripts in the Power BI service -- R script visuals limitations -- Summary -- Test your knowledge -- Chapter 3: Configuring Python with Power BI -- Technical requirements -- The available Python engines -- Choosing a Python engine to install -- The Python engines used by Power BI -- Installing the suggested Python engines -- The Python engine for data transformation -- Creating an environment for data transformations using pip -- Creating an optimized environment for data transformations using conda
|
| 505 |
0 |
|
|a Creating an environment for Python script visuals on the Power BI service -- What to do when the Power BI service upgrades the Python engine -- Installing an IDE for Python development -- Configuring Python with RStudio -- Configuring Python with Visual Studio Code -- Working with the Python Interactive window in Visual Studio Code -- Configuring Power BI Desktop to work with Python -- Configuring the Power BI service to work with Python -- Sharing reports that use Python scripts in the Power BI service -- Limitations of Python visuals -- Summary -- Test your knowledge
|
| 653 |
|
|
|a Data mining / Computer programs
|
| 653 |
|
|
|a R (Langage de programmation)
|
| 653 |
|
|
|a Visual analytics / Data processing
|
| 653 |
|
|
|a Analyse visuelle / Informatique
|
| 653 |
|
|
|a Python (Computer program language) / http://id.loc.gov/authorities/subjects/sh96008834
|
| 653 |
|
|
|a Information visualization / Computer programs
|
| 653 |
|
|
|a Visualisation de l'information / Logiciels
|
| 653 |
|
|
|a Exploration de données (Informatique) / Logiciels
|
| 653 |
|
|
|a Business intelligence / Computer programs
|
| 653 |
|
|
|a R (Computer program language) / http://id.loc.gov/authorities/subjects/sh2002004407
|
| 653 |
|
|
|a Python (Langage de programmation)
|
| 700 |
1 |
|
|a Talwar, Rajat
|e writer of foreword
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 490 |
0 |
|
|a Expert insight
|
| 776 |
|
|
|z 9781837639533
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781837639533/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 700
|
| 082 |
0 |
|
|a 001.4/226028566
|
| 082 |
0 |
|
|a 330
|
| 520 |
|
|
|a 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
|