Python in Power BI visuals and in M
Art Tennick
??3 US Patents in BI??technical editor 4 Packt Power BI books??author 20 computer books??Power BI??Analysis Services??Python/R in Power BI??Paginated??MDX DAX SQL Python R TMDL??ex-university SQL lecturer??35 years in BI
Python (scikit-learn) in both graphics and embedded in Power Query M for the table - graphics are matplotlib/seaborn, table is pandas dataframe - the table and the confusion matrix are sliceable by the Chiclet - the power of 8 Python scikit-learn machine learning algorithms boosting your Power BI capabilities - how to predict and target sales accurately! Here is the pbix (you will need to click Show Details on any possible errors and install the missing Python packages mentioned - I used Anaconda Python, which is recommended for machine learning, it comes with SQL Server 2017 or can be downloaded separately for free):
The confusion matrix and table adjust to the algorithm selected in the slicer - the column chart does not as it shows all 8 algorithms by design. All the Python you need and the SQL is in the pbix. You will need Adventure Works DW in SQL Server (you will have to adjust server and database names, possibly). You also need these two settings (or just the second after Python comes out of preview):
