How to Use Sankey Chart to Report Business Earnings via Python Plotly? MSFT Case study

Previously on How to Use Sankey Chart to report business earnings via Python Plotly? Part 1, 2, we used AMD’s quarterly income statement to show you how to build a Sankey Chart and how to report these components dynamically by sourcing the data from yahoo finance instead of static numbers. In this article, we are going to present how to export MSFT 10-Q excel and import it into SQLite and visualize it via Sankey Chart.

Microsoft (MSFT) FY24 Q3 Earning Report Viz & MA Analysis

Step 0: Install / Import required packages & mount your google drive & Define reporting date.

!pip install sqlite3
!pip install urllib

import sqlite3
import pandas as pd

from google.colab import drive
drive.mount('/content/drive')

As_Of = '2024-04-24'
Company = 'Microsoft'
Ticker = 'MSFT'
FY = 'FY24'
FQ = 'Q3'

Step 1: Download Earning Excel from Nasdaq.com and extract it from target sheet.

FY24Q3_Link =…