• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Python Episode 1 – A New hope

August 21, 2018   Self-Service BI

With the release of Python inside Power BI, we, the Power BI team have come together to show you some of our favorite 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 visualizations. You can even expand your Power BI reports further by bringing in sophisticated machine learning and AI.

5 Python Packages to try out;

Here is a list of some our favorite Python packages you can use today inside Power BI; A demo Power BI File showcasing all the visual examples along with their python scripts can be found here (the examples were build using anaconda);

Seaborn – built on top of the default matplotlib plotting library, seaborn offers a great extension to the matplotlib library allowing you to generate more complex plots quickly. Let’s take a look at an example from the bike rental demand dataset. If you wish to create a swarm plot of the bike demand categorized by season., it just takes a few simple lines of code.

9c979fd1 beee 476b 97d6 2a4d508a69a6 Python Episode 1 – A New hope

d83a97c0 d137 42cc a60c 181c57d1ef32 Python Episode 1 – A New hope

Altair – a declarative library to generate plots. unlike other libraries which require you to create the legend, axis and labels. Altair aim is to alleviate some of these pain points and focus on the plot itself rather than specify every single element of the chart. By default, the axis/legend are generated based on the data you pass to the plotting function. Below is an example generated in PBI. Note: interactive visuals are not yet supported in PBI, if you would like interactive python visuals please do vote for this feature

77b41c54 73db 4421 91f1 9ee2308a0c7e Python Episode 1 – A New hope

Scikit-Learn– a python library to perform machine learning over your data. Using Power BI, you can now use the many python libraries to create your own machine learning models and easily operationalize them within your Power BI reports. One of the things you may want to do first is generate a matrix chart showing the correlations/histogram between each pairwise variables

51941a75 9059 4311 8d15 e4681b0bbc38 Python Episode 1 – A New hope

FlashText – a performant library for searching and replacing words within a text column. Below is a diagram showing the relative performance of FlashText vs Regex. Finding keywords or replacing values can now be done in minutes rather than hours.

9f89abdb dc17 4b72 82de e929dde971b6 Python Episode 1 – A New hope

PyFlux & Pendulum – Make date time parsing a thing of the past with pendulum. This package coupled with PyFlux allows you to generate some awesome time series analysis

If you missed the link earlier, all the example visuals can be found here, follow me at @mohaali45. Happy scripting

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Episode, Hope, Python
  • Recent Posts

    • Derivative of a norm
    • TODAY’S OPEN THREAD
    • IBM releases Qiskit modules that use quantum computers to improve machine learning
    • Transitioning to Hybrid Commerce
    • Bad Excuses
  • Categories

  • Archives

    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited