Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Extending Power BI with Python and R
Extending Power BI with Python and R

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

Arrow left icon
Profile Icon Zavarella
Arrow right icon
$12.99 per month
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (30 Ratings)
Paperback Mar 2024 814 pages 2nd Edition
eBook
$43.99
Paperback
$54.99
Subscription
Free Trial
Renews at $12.99p/m
Arrow left icon
Profile Icon Zavarella
Arrow right icon
$12.99 per month
Full star icon Full star icon Full star icon Full star icon Full star icon 5 (30 Ratings)
Paperback Mar 2024 814 pages 2nd Edition
eBook
$43.99
Paperback
$54.99
Subscription
Free Trial
Renews at $12.99p/m
eBook
$43.99
Paperback
$54.99
Subscription
Free Trial
Renews at $12.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $15.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Key benefits

  • Discover best practices for using Python and R in Power BI by implementing non-trivial code
  • Enrich your Power BI dashboards using external APIs and machine learning models
  • Create any visualization, as complex as you want, using Python and R scripts

Description

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.

Who is this book for?

This book is for business analysts, business intelligence professionals, and data scientists who already use Microsoft Power BI and want to add more value to their analysis using Python and R. Working knowledge of Power BI is required to make the most of this book. Basic knowledge of Python and R will also be helpful.

What you will learn

  • Configure optimal integration of Python and R with Power BI
  • Perform complex data manipulations not possible by default in Power BI
  • Boost Power BI logging and loading large datasets
  • Extract insights from your data using algorithms like linear optimization
  • Calculate string distances and learn how to use them for probabilistic fuzzy matching
  • Handle outliers and missing values for multivariate and time-series data
  • Apply Exploratory Data Analysis in Power BI with R
  • Learn to use Grammar of Graphics in Python

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Mar 29, 2024
Length: 814 pages
Edition : 2nd
Language : English
ISBN-13 : 9781837639533
Category :
Languages :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $15.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Mar 29, 2024
Length: 814 pages
Edition : 2nd
Language : English
ISBN-13 : 9781837639533
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$12.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 6,500+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$129.99 billed annually
Feature tick icon Unlimited access to Packt's library of 6,500+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$179.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 6,500+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 159.97
The Definitive Guide to Power Query (M)
$54.99
Mastering Microsoft Power BI – Second Edition
$49.99
Extending Power BI with Python and R
$54.99
Total $ 159.97 Stars icon
Visually different images

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Full star icon 5
(30 Ratings)
5 star 96.7%
4 star 3.3%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Federico Pastor Jun 02, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I have had the opportunity to read "Extending Power BI with Python and R" by Luca Zavarella, and it has quickly become an invaluable resource in my professional library. As someone who works extensively in data analysis and business intelligence, this book provides a comprehensive guide to enhancing Power BI's capabilities using Python and R.Luca Zavarella does an excellent job of explaining complex concepts in a clear and accessible manner. The integration of Python and R into Power BI is covered in depth, with practical examples that are easy to follow. This book is perfect for advanced users looking to take their data visualization and analysis to the next level.The step-by-step tutorials, combined with real-world use cases, make this book not only informative but also highly practical. I highly recommend it to anyone seeking to expand their Power BI skills with advanced analytics and custom visuals.
Amazon Verified review Amazon
Keith D. Apr 03, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I recently had the opportunity to dive into an early review copy of "Extending Power BI with Python and R," and I must say, it's a game-changer for data analysts and developers alike. Tailored for individuals familiar with Python and R, this book offers a comprehensive guide to leveraging these powerful languages within the Power BI environment.As someone with prior experience in Python but new to Power BI, I found the early chapters to be incredibly enlightening. The book does an excellent job of introducing the Power BI platform and seamlessly integrating Python and R functionality.One aspect that stood out to me was the clarity of the code examples and the abundance of resources provided to aid in understanding the concepts. The colorful screenshots and diagrams not only add visual appeal but also serve as invaluable aids in comprehending the material.While I'm still working my way through the early chapters, I can already see the immense potential this book holds for unlocking deeper insights from data. Whether you're a seasoned Python/R user looking to expand your toolkit or a newcomer to Power BI seeking to enhance your data visualization skills, this book is a must-have.In conclusion, I highly recommend "Extending Power BI with Python and R" to anyone looking to elevate their data analytics game. With its clear examples, colorful visuals, and wealth of resources, this book is sure to empower you on your data-driven journey.
Amazon Verified review Amazon
Tarang Sep 02, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Being a Beginner Power BI and Python user, I always wanted to understand how to use Power BI along with Python, and this book helps me understand exactly that.This books helps in understanding the below few steps in great detail:How and Where to Use R and Python in Power BIHow to Configure R and Python on Power BIWhat are the common issues you may face while using them in Power BIImporting Data from Different Sources in R and PythonUsing Regular Expressions in Power BILogging Data from Power BI to external sourcesHandling large dataset in Power BI and boosting Data Loading SpeedCalling external API and calculating columns using Complex AlgorithmsBuilding Advanced VisualizationsThis books has definitely helped me upskill my Power BI, R and Python knowledge and I am sure it will help all the users who read the book end to end.I would like to Congratulate Luca Zavarella for this wonderful book and Vignesh Raju 💯🚀🎯📈 for sharing a copy with me for review. Absolutely loved the book :) Worth a Buy :)
Amazon Verified review Amazon
Pauline Apr 01, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
As someone who's just starting out with Python and R, I wasn't sure how I could leverage them with my existing Power BI skills. But "Extending Power BI with Python and R" by Luca Zavarella completely changed that! Here's why it's a fantastic resource for beginners like me:Breaks Down the Barriers: The book explains how Python and R can work with Power BI in a way that's easy to understand, even for someone new to these languages. It doesn't overwhelm you with complex jargon, but instead, breaks down the concepts into manageable steps.Learning by Doing: Forget dry lectures! This book is all about getting your hands dirty with code. The examples and exercises are clear and well-explained, allowing you to follow along and practice the Python and R code within Power BI. It's a fantastic way to learn and solidify your understanding.Levels Up Your Power BI Game: Even with limited Python/R knowledge, I was able to unlock new functionalities in Power BI. The book shows you how to tackle tasks like data cleaning and advanced analysis that were previously out of reach. This newfound ability makes you a more powerful data analyst!Focuses on Practical Applications: Instead of just theory, the book showcases real-life scenarios where these techniques come in handy. This practical approach helps you see how these skills can be applied to your own work, making learning more engaging and relevant.Springboard for Further Learning: The book doesn't just stop at the basics. It provides resources for further exploration of Python and R, allowing you to build upon the foundation you've established. This encourages continuous learning and opens doors to even more advanced data analysis possibilities.Overall, "Extending Power BI with Python and R" is a fantastic resource for beginners like me. It empowers you to take your Power BI skills to the next level by leveraging the power of Python and R. The clear explanations, practical examples, and focus on real-world applications make it a valuable tool for anyone who wants to unlock the full potential of data analysis in Power BI.
Amazon Verified review Amazon
Matvey Osipov May 05, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
If you want to explore using Python or R in Power BI and Power Query, this is a great resource and awesome patterns and techniques you can start with.It goes above and beyond when it comes to examples, explanations, and environment setup (eg. installing Python/R, gateway, etc). It covers some very awesome topics like calling APIs from your Power BI solution using Python/R and setting up ML services in SQL server and using it in your Power BI solution.Bottom line - The amount of great content this book has on this topic is simply amazing!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.