Internship Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Internship Description
Job Description:
- Extract data from database using SQL
- Manage & Sort Data in Microsoft PowerBI & Google Data Studio
- Create dashboards for reporting and analysis purpose
- Re-iterate based on feedback and new data
The intern will learn:
- How to handle big data in SQL
- Data about a real business
- How to derive real value from analysis
Application Deadline: 23 March 2020
Internship Start date: 24 March 2020
Duration: Flexible
Internship Requirements
- Must know: SQL, PowerBI, Google Data Studio
- Must be able to commit to 20 hours a week minimum to the office in Greek Campus, Tahrir Square
- Must own their own laptop
- You must submit the following assignment to be considered for the position
- Assignment: Data Analyst SQL
- Task: Create a dashboard that visualizes weather data. The key insight we want to give to the user is which month in the year they should travel to a city for a holiday in the future.
- We want to tell the user about temperature, humidity, rainfall, wind speed, UV etc.
- Top Tip: The weather data will be historical, but the user will be travelling in the future… how do you handle this?
- Data: Use open source public weather data available online.
- Tools: The dashboard must be created using Google Data Studio. How you handle the data is up to you.
- Top Tip: The main outcome of the dashboard should tell the user a city and a month. Eg Cairo, April. How will you ask the user about their preferences? Think about a UI/UX you can use in Google Data Studio to make this an interactive dashboard.
Similar opportunities
- Microsoft SQL Server Database ...The Micro, Small & Medium Enterprise Development Agency - Dokki, Giza4 days ago