Python, the programming language widely used by statisticians, data scientists, and data analysts, has now been integrated into Microsoft's Power BI Desktop. This update was announced by way of a feature preview in the August 2018 release of Power BI.
Amanda Cofsky, Program Manager with Microsoft Power BI Desktop, announced in the official blog that once the user enabled the feature in the preview settings, they could use Python to do data cleansing, analysis, and visualisation, among others.
"The first integration experience we added is the ability to run Python scripts directly in Power BI Desktop to create your data model... The Python integration in the Query Editor lets you perform data cleansing using Python and perform advanced data shaping and analytics in your data, including completion of missing data, predictions, and clustering, just to name a few. Lastly, you can use Python to create new visuals on your report. Just like R visuals, the Python visuals will update with data refreshes and cross-filtering. However, the visual itself is not interactive," wrote Cofsky.
— Power BI (@MSPowerBI) August 9, 2018
"With the release of Python inside Power BI, we, the Power BI team have come together to show you some of our favourite python packages. Python is a great addition to the Power BI family by providing you the ability to perform quick data transformation or plot cool data visualisations. You can even expand your Power BI reports further by bringing in sophisticated machine learning and AI," wrote another programme manager Mohammad Ali the blog.
Microsoft has also supplied a demo Power BI file with working examples of popular Python packages used to create visualisations and transformations for a sample data set. Included examples feature the Seaborn, Altair, Scikit-learn, FlashText and PyFlux/Pendulum.
Register for our upcoming events:
- Meetup: NVIDIA RAPIDS GPU-Accelerated Data Analytics & Machine Learning Workshop, 18th Oct, Bangalore
- Join the Grand Finale of Intel Python HackFury2: 21st Oct, Bangalore
- Machine Learning Developers Summit 2020: 22-23rd Jan, Bangalore | 30-31st Jan, Hyderabad
Enjoyed this story? Join our Telegram group. And be part of an engaging community.
Provide your comments below
What's Your Reaction?
Prajakta is a Writer/Editor/Social Media diva. Lover of all that is 'quaint', her favourite things include dogs, Starbucks, butter popcorn, Jane Austen novels and neo-noir films. She has previously worked for HuffPost, CNN IBN, The Indian Express and Bose. You can reach her at firstname.lastname@example.org