Linkedin Project
This is one of 5 projects in a volunteer program called "JunDatyst" - a project to help junior data analysts gain professional experience and produce data analysis project.
This is a unique project that analyzes the profession of Data Analyst in Israel on Linkedin's platform. All the data in this project is real information from profiles of Data Analysts in Israel. The dataset represents 679 real Data Analyst profiles in Israel witch scraped with c++ scraping tool during Jun 2022 - May 2022.
Platforms :
- Database - Linkedin
- Data Analysis – Snowflake Data Warehouse
- Visualization - Power BI
The project consists :
- Project Overview & Explanation - PDF
- Raw Data - CSV
- Business Questions - Excel
- Conclusions & Visualization - Power BI Dashboard + Online
- SQL queries - divided to Views (Snowflake Datawarehouse) - at the bottom of this document.
Team leader : Ilay Damari
Team members : Nofar Hakmon, Ido Kahlon, Ayelet Biton
| Level | Explnation |
|---|---|
| Data Scraping | Download C++ Program for Scraping and specify the profiles fron Data Analysts in Israel, Upload the data to Snowflake Data Warehouse and create Schemes and Views |
| Data Cleaning | Using SQL functions we adjust the data and the table to a better way we can use and query the data for our business questions |
| Classify Business Questions | Asking and finding right questions to better understand the needs and the proffestion of Data Analyst in Israel |
| Data Analysis | Query the data using SQL functions in Snowflake platform for finding conclusions |
| Visualization | Connecting our Data Warehouse on Snowflake to Power BI and creating dashboard and graphs for presenting our conclusions |
We had a great time and learned a lot about Data!
From the difficulty of clearing the data, the ELT Proccess to Snowflake and finding the conclusions !
Thank you for Reading!