This workflow is Team AST’s solution for the Round of 8 challenge in the KNIME Game of Nodes 2024. Some modifications have been made to the originally submitted workflow.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
US Cellular Towers Coverage
Challenge description:
You work as a data analyst for a large, US-based telco network composed of many different telco companies. In the last 10 years, the network has grown significantly, expanding its customer base and coverage in the country. After such a long expansion period, the management would like to get a comprehensive overview of the situation of the network. Hence, you are tasked with the creation of an interactive, highly customizable and responsive dashboard that communicate key insights. You are responsible to select what insights are worth sharing with the management.
Additionally, the dataset provides information about over 47,000 cellular towers, such as the location, geographic coordinates, ownership, and technical specifications. As such, your dashboard should also include geospatial maps that display areas of the country that are extensively covered by cellular towers as well as those are that are poorly covered, given a customizable coverage distance (e.g., a 20-km area around each tower is considered properly covered).
Finally, on the basis of the insights provided in your dashboard, give three business recommendations to management, so that they can better plan investments for the future growth of the network. Type your recommendations in an annotation.
Key requirement: you must rely on the nodes of the Geospatial Analytics Extension for the preprocessing of geospatial data and the creation of interactive maps: https://hub.knime.com/center%20for%20geographic%20analysis%20at%20harvard%20university/extensions/sdl.harvard.features.geospatial/latest/
Outcome:
An interactive data app to display the network's key insights and the cellular tower coverage of a selected area on a geospatial map.
Deliver your solution as a separate workflow and name it: Solution_Round_8_. Place your solution workflow in the same folder of this challenge workflow.
Teams are strongly encouraged to submit high-quality work in order to improve their chances of getting maximum points. Don't be afraid to go the extra mile! :)
Dataset:
Cellular Towers In USA dataset from Kaggle: https://www.kaggle.com/datasets/jahaidulislam/cellular-towers-in-usa
Deadline:
March 24, 2024 (submission by 11:59 PM CET) **. Check the calendar of the tournament: https://info.knime.com/game-of-nodes
** We will verify the date and time of the latest edits.
KNIME Game of Nodes:
Rules, Assessment Criteria & FAQs: https://info.knime.com/game-of-nodes