{"id":3984,"date":"2025-04-06T19:41:29","date_gmt":"2025-04-06T19:41:29","guid":{"rendered":"https:\/\/erikap.co.uk\/?page_id=3984"},"modified":"2025-04-07T06:21:21","modified_gmt":"2025-04-07T06:21:21","slug":"berlin-airbnb","status":"publish","type":"page","link":"https:\/\/erikap.co.uk\/?page_id=3984","title":{"rendered":"Berlin Airbnb"},"content":{"rendered":"

[et_pb_section fb_built=”1″ fullwidth=”on” admin_label=”Page Header” _builder_version=”4.27.4″ _module_preset=”3c901e30-8c7f-4173-af71-9e53c9b0862a” background_image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/pexels-markusspiske-179942-scaled.jpg” parallax=”off” background_size=”custom” global_colors_info=”{}”][et_pb_fullwidth_header title=”Airbnb Berlin” text_orientation=”center” admin_label=”Hero Section” _builder_version=”4.27.4″ _module_preset=”default” title_font=”Montserrat|on|||” title_font_size=”60px” title_line_height=”1.4em” content_font_size=”22px” content_line_height=”1.8em” subhead_font=”||||” background_color=”rgba(255, 255, 255, 0)” use_background_color_gradient=”on” background_color_gradient_stops=”rgba(58,52,226,0.93) 0%|rgba(73,108,220,0.7) 100%” background_color_gradient_start=”rgba(58,52,226,0.93)” background_color_gradient_end=”rgba(73,108,220,0.7)” custom_button_one=”on” button_one_text_size=”16px” button_one_bg_color=”#6eba01″ button_one_border_width=”2px” button_one_border_color=”#6eba01″ button_one_border_radius=”0″ button_one_letter_spacing=”2″ button_one_font=”Montserrat|||on|” button_one_use_icon=”off” custom_button_two=”on” button_two_text_size=”16px” button_two_border_width=”2px” button_two_border_color=”#ffffff” button_two_border_radius=”0″ button_two_letter_spacing=”2″ button_two_font=”Montserrat|||on|” button_two_use_icon=”off” module_alignment=”left” animation_style=”fade” button_one_text_color_hover=”#6eba01″ button_two_text_color_hover=”#6eba01″ button_one_border_color_hover=”#ffffff” button_two_border_color_hover=”#ffffff” button_one_border_radius_hover=”0″ button_two_border_radius_hover=”0″ button_one_letter_spacing_hover=”2″ button_two_letter_spacing_hover=”2″ button_one_bg_color_hover=”#ffffff” button_two_bg_color_hover=”#ffffff” global_colors_info=”{}” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_one_text_color__hover_enabled=”on” button_one_text_color__hover=”#6eba01″ button_two_text_color__hover_enabled=”on” button_two_text_color__hover=”#6eba01″ button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_one_border_color__hover_enabled=”on” button_one_border_color__hover=”#ffffff” button_two_border_color__hover_enabled=”on” button_two_border_color__hover=”#ffffff” button_one_border_radius__hover_enabled=”on” button_one_border_radius__hover=”0″ button_two_border_radius__hover_enabled=”on” button_two_border_radius__hover=”0″ button_one_letter_spacing__hover_enabled=”on” button_one_letter_spacing__hover=”2″ button_two_letter_spacing__hover_enabled=”on” button_two_letter_spacing__hover=”2″ button_one_bg_color__hover_enabled=”on” button_one_bg_color__hover=”#ffffff” button_two_bg_color__hover_enabled=”on” button_two_bg_color__hover=”#ffffff”]<\/p>\n

SQL & Power BI project<\/p>\n

 <\/p>\n

[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Projects” _builder_version=”4.16″ _module_preset=”default” custom_padding=”90px||90px|” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ _module_preset=”default” background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”45px|0px|45px|0px” custom_width_px=”710px” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” background_position=”top_left” custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_divider color=”#4e5ed0″ divider_weight=”3px” disabled_on=”off|off|off” _builder_version=”4.16″ _module_preset=”default” background_color_gradient_direction=”90deg” max_width=”100px” module_alignment=”center” height=”5px” custom_margin=”||20px|” custom_padding=”||20px|” animation_style=”slide” animation_direction=”bottom” saved_tabs=”all” locked=”off” global_colors_info=”{}”][\/et_pb_divider][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.4″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” global_colors_info=”{}”]<\/p>\n

Berlin Airbnb Data Analysis Project<\/span><\/strong><\/h1>\n

[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” text_font_size=”16px” global_colors_info=”{}”]<\/p>\n

\u00a0https:\/\/github.com\/ErikaWeb\/airbnb-berlin-project<\/a><\/span><\/p>\n

This project explores Airbnb listings data for Berlin using SQL in Google BigQuery<\/strong> and data visualization in Power BI<\/strong>.<\/span><\/p>\n

The dataset, sourced from Inside Airbnb, includes detailed information about thousands of listings such as location, price, availability, room types, and reviews.<\/span><\/p>\n

Project Goals:<\/span><\/strong><\/p>\n