FINANCIAL OVERIVEW DASHBOARD

Note2: : Direct link to Power BI app view - here.

FEATURES

• Market Cap. (Updated Daily)

• Historical Stock Price data from Yahoo (Updated Daily)

• Azure SQL DB

  
  

OVERVIEW

• Create a Dashboard for YUM BRANDS to represent its financial position and monitor key financial information for decision-making.

  
  

CHALLENGES

• Manual collection of data from spreadsheets and pdf.

• Periodic Refresh in POWER BI when using external web sources.

  
  

PROJECT WORKFLOW

METHODOLOGY

• Exploratory Data Analysis and Dashboard.

GITHUB REPOSITORY

• https://github.com/UniNash/YUM-Brands-.git

  GitHub Repository contains:

  1. Datasets

  2. Documentation

  3. Python code

  4. POWER BI .pbix file

TOOLS IN PLAY

1. POWER BI

2. MS EXCEL

   
   

DATA PROCESS, MANAGEMENT AND STORAGE

CONNECTING TO AZURE SQL

• Connection documentation is available in repository.