{"id":17222,"date":"2025-01-29T15:12:36","date_gmt":"2025-01-29T13:12:36","guid":{"rendered":"https:\/\/spatialworld.fi\/?page_id=17222"},"modified":"2025-02-05T17:49:04","modified_gmt":"2025-02-05T15:49:04","slug":"17076-2-2-3-2","status":"publish","type":"page","link":"https:\/\/spatialworld.fi\/sv\/17076-2-2-3-2\/","title":{"rendered":"Superset"},"content":{"rendered":"[vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Geospatial Insights Unlocked: Excel Data Integration into Superset using FME.<\/span><\/h1>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][image_with_animation image_url=”17236″ image_size=”medium_large” animation_type=”entrance” animation=”None” animation_movement_type=”transform_y” hover_animation=”none” alignment=”center” border_radius=”none” box_shadow=”none” image_loading=”default” max_width=”75%” max_width_mobile=”default”][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overflow=”visible” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_direction_desktop=”default” column_element_spacing=”default” desktop_text_alignment=”default” tablet_text_alignment=”default” phone_text_alignment=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_backdrop_filter=”none” column_shadow=”none” column_border_radius=”none” column_link_target=”_self” column_position=”default” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” animation_type=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text css=”” text_direction=”default”]\n

Context and Case study<\/strong><\/h2>\n

In today’s booming business intelligence landscape, Superset stands out as a versatile, web-based solution ideal for FME users.<\/p>\n

Despite the prevalence of BI tools, Excel remains a go-to for its flexibility.<\/p>\n

In this tutorial, we’ll show you how to seamlessly integrate Excel data into Superset, unlocking powerful geospatial insights with ease. Using a complex Excel file from Helsinki city as our example, we’ll focus on street winter care survey data, specifically regarding bicycles, to create an insightful dashboard.<\/p>\n

Input Data<\/strong><\/h2>\n

ANSWERS TO THE SURVEY REGARDING WINTER ROUTES MAINTENANCE OF THE CITY OF HELSINKI<\/a><\/p>\n

HELSINKI BICYCLE LANES 2025<\/a><\/p>\n

Main steps<\/h2>\n
    \n
  1. Data Preparation<\/strong>: Read and clean\/adapt a complex Excel file<\/li>\n
  2. Geospatial Analysis<\/strong>: Enrich the data using geospatial analysis techniques<\/li>\n
  3. Superset Preparation<\/strong>: Prepare the data for integration into Superset<\/li>\n
  4. Visualization<\/strong>: Publish the data as charts in Superset, utilizing Deck.gl<\/a> charts for enhanced visualization.<\/li>\n<\/ol>\n

    Data Preparation: Playing with a complex Excel file<\/h3>\n[\/vc_column_text][image_with_animation image_url=”17249″ image_size=”medium_large” animation_type=”entrance” animation=”None” animation_movement_type=”transform_y” hover_animation=”none” alignment=”center” border_radius=”none” box_shadow=”none” image_loading=”default” max_width=”100%” max_width_mobile=”default”][vc_column_text css=”” text_direction=”default”]\n
    \n
    Extract from study Excel<\/em><\/figcaption><\/figure>\n<\/div>\n

    Excel input<\/strong><\/p>\n

    The Excel input comprises data collected from a survey where respondents marked locations they traversed by car, bicycle, or on foot, along with feedback on winter care conditions encountered. Winter care is categorized into three aspects: slippage (stones on ice), snow plowing (pushed to the side), and snow removal. It can considered be good or bad.<\/p>\n

    Evidently generated from a web map survey tool export, the Excel file encompasses:<\/p>\n