PowerBI Using Python

Description

Project consists of pulling financial data from the web (Yahoo Finance via yfinance) in PowerBI using Python. This project demonstrates different ways to utilize Python to visualize data in PowerBI.

Languages and Utilities Used

• Python: pandas / yfinance
• Matplotlib
• Seaborn

Environments Used

• MacOS
• Microsoft PowerBI via VM

Program walk-through:

Bringing in Data via Python:


Python Script to bring in data from Yahoo Finance:


Data:


Creating a Line/Area graph to show Close price over time for AAPL:


Creating a Boxplot/Violin for AAPL:


Creating Histogram for AAPL:


Creating a Scatterplot (Year, Quarter, Month, Day):


Adjusting the TICKER symbol to Alter data in Graphs(from AAPL to TSLA):