This project aims to develop a user-friendly Streamlit application that utilizes the Google API to extract information on a YouTube channel, stores it in a MongoDB database, migrates it to a SQL data warehouse, and enables users to search for channel details and join tables to view data in the Streamlit app.
Skills used -> Python, Web Scraping, NoSQL, MongoDB, SQL, MySQL Workbench, Youtube Data API, API integration, Data Scraping, ETL, Data Processing, Data Lake, Data Warehousing, Streamlit, Web Application Development, Data Analysis, Plotly, Data Visualization.
A User-Friendly Tool Using Streamlit and Plotly. This project aims to develop a streamlit application for data visualization and dashboard for the PhonePe pulse data containing various metrics and statistics.
Skills used -> Github cloning, Python, Pandas, MySQL, Streamlit, Plotly, Dashboard, Insight Generation, Business Insights, Dashboard Development, Data Visualization.
Project will analyze energy usage and greenhouse gas (GHG) emissions of Ontario's Broader Public Sector (BPS) organizations, leveraging a comprehensive database of reported data. We aim to identify trends,
assess conservation effectiveness, and pinpoint areas for improvement, informing data-driven strategies to achieve climate change mitigation goals within the BPS.
Skills used -> Power BI, Power Query, DAX, Python, EDA, Data Analysis, Data Cleaning, Data visualization.