Market_Analysis_Project

Problem Statement

The objective of this project is to assess the market trends associated with enlisted companies by providing stakeholders with a comprehensive understanding of how the market evaluates a company, including insights into its business performance, profitability, and growth prospects. Key financial metrics considered in this analysis encompass Market Capitalization, Revenue, Earnings, P/E Ratio, and the number of employees within the companies. The data utilized for this evaluation has been sourced from the Global Ranking Website. Approximately 5000 data have been extracted from the aforementioned source.

Later tha data has been pre-processed,manipulated and molded (removing $/ B /M signs) as per project's needs. The pertinent data then populated in Tableau to create visulaization. For that files from final_data are joined on 'company name'. Three dashboards have been made which depicts the followings:

1. Demonstrating world wide P/E ratios of the pharmaceutical catagory - map
2. Maximum revenue generated country wise - symbol map
3. Revenue Vs earning of automakers and e-commerce category - scatter plot
4. Market cap Vs P/E ratio of automakers and e-commerce category- scatter plot
5. Manipultion ratio of China and Japan and their earnings - symbol map
6. No. of Employees impact on revenue - scatter plot
7. Canada Vs Israel Market Cap - bar plot

You can visit the dashboard here

Intersting findings from the dashboards:

1. Indian companies have the highest P/E ratio on Pharmaceutical catagory.

2. Amazon produces maximum revenue based on all catagories.

3. Revenue to Earning proportion of 'Amazon' doesn't justify even after generating the highest revenue.

4. Even though Amazon has the highest market capitalization, Tata Motor has more P/E ratio than Amazon having so much less market cap.

5. Japanese automaking companies have huge manipulation ratio. This parameter is indicating employees exploitaion metric since we are dividing the earnings by #emplyees. More the manipulation ratio, more the workload on employees; more they are exploitated to produce more earnings of the company.

6. More employees doesn't mean more revenue. Mc Donalds with half the highest empolyees of rank, is producing second largest revenue.

7. Canada is ruling compare to Israel based on market cap.

Build From Source:

1. Clone the repo

git clone https://github.com/TabassumTanzim/Market_Analysis_Project.git

2. Initialize and activate virtual environment

virtualenv --no-site-packages venv
source venv/bin/activate

3. Install dependecies

pip install -r requirements.txt

4. Download chromedriver from here
5. You can find the source codes from selenium scrapper
6. You will get the scraped data from here
7. For data manipulation and concatenation of csv files refer to this folder
8. Finally you will get the resultant data in this directory