This project focuses on conducting data analysis using financial data obtained from Yahoo Finance. The workflow encompasses various stages including data acquisition, schema creation in SQL, data upload to MySQL, importing MySQL data into Power BI, data cleaning, and dashboard creation.
- Yfinance
- Pandas (for data manipulation)
- MySQL
- Power BI (for data visualization)
- Utilized Yahoo Finance to download financial datasets relevant to the analysis objectives.
- Designed and implemented a suitable database schema using SQL to organize and structure the acquired data efficiently.
- Uploaded the downloaded financial data into a MySQL database, ensuring data integrity and consistency.
- Connected Power BI to the MySQL database and imported the relevant datasets for analysis.
- Conducted data cleaning processes within Power BI to address missing values, inconsistencies, and outliers, ensuring the quality and reliability of the data.
- Designed and developed interactive dashboards within Power BI to visualize key insights derived from the cleaned dataset. The dashboards provide intuitive representations of the analyzed financial data, enabling stakeholders to make informed decisions.
In conclusion, the created dashboards offer a user-friendly interface for users to explore and understand the underlying trends and patterns within the financial data, facilitating informed decision-making processes. Overall, this project serves as a valuable resource for anyone seeking to harness the power of data analysis.