Spyder VS plotly

IDE-wise, I find Spyder to be the most R-like. If you are comfortable with R Studio, maybe check it out.

For anyone else who hadn’t heard of Spyder: https://www.spyder-ide.org/

Spyder

Spyder - a popular editor for scientific work, the default option if you get the Anaconda implementation of Python which includes many packages used in science and engineering fields

I also have a fondness for Spyder, which was my first non-IDLE IDE experience. It is heavily geared toward scientific computing.

Github: https://github.com/plotly/plotly.py

First we need to install the Plotly. To create some very dynamic graphics, this tool helps a lot.

my good dude wake up and smell the plotly. Knowing the ins and outs of matplotlib is helpful but doing interactive stuff with jupyter I always use plotly.

Plotly documentation (https://plotly.com/python/)

I don´t know your workflow, but I use 2 markdown based presentations: obsidian advance slides and Quarto presentations. The former is a plugin for Obsidian, which is the software I use to take all my notes, write my thesis, etc., so It makes it extremely easy to make presentations since all my information is in Obsidian. In the other hand, Quarto is a publishing system (articles, presentations, websites books) that can be easily integrated with python and R. This makes it supper convenient for showing my data to my PI since I can analyze my data and at the same time make a presentation for the data. Besides this, Quarto also integrates with my Zotero library, so I can insert citations. Lastly, one thing that made my Quarto presentations infinitely better that the powerpoints, Is that I can insert interactive graphs with plotly, so when I'm showing my data, my PI is able to explore the data inside the presentation.

Plotly GitHub repository: https://github.com/plotly/plotly.py

I'm using plotly.py now. This is why I love this community.

Depending on the nature of your reporting requirements, you could output a formatted Excel document with Python and a library such as openpyxl, and shove that into your SharePoint environment. This would be less dynamic than PBI reports can be, but may be sufficient. If you want viz as well, you can use something like ggplot or Plotly. Again, less dynamic than PBI for the same effort.