{"id":3659,"date":"2025-02-15T11:08:15","date_gmt":"2025-02-15T11:08:15","guid":{"rendered":"https:\/\/erikap.co.uk\/?page_id=3659"},"modified":"2026-03-08T15:07:25","modified_gmt":"2026-03-08T15:07:25","slug":"home","status":"publish","type":"page","link":"https:\/\/erikap.co.uk\/","title":{"rendered":"Home"},"content":{"rendered":"

[et_pb_section fb_built=”1″ fullwidth=”on” admin_label=”Page Header” _builder_version=”4.27.4″ background_image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2024\/07\/pexels-rdne-7413936-scaled.jpg” parallax=”off” hover_transition_delay=”50ms” hover_transition_speed_curve=”ease-in” global_colors_info=”{}”][et_pb_fullwidth_header title=”Hi I’m Erika” text_orientation=”center” admin_label=”Hero Section” _builder_version=”4.27.4″ 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

Welcome to my portfolio. I’m a passionate data analyst specializing in Power BI and interactive dashboards, transforming data into visual stories that drive decision-making.<\/span><\/p>\n

[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Projects” _builder_version=”4.27.4″ custom_padding=”90px||90px|” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ 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″ 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″ 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.16″ 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

Case Studies<\/h1>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.27.5″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”45px|||” locked=”off” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”Accounts Payable Insights Part Two” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQxMzgifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/02\/pexels-kampus-8428063-scaled.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” hover_enabled=”0″ use_circle=”off” use_circle_border=”off” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Power BI\u00a0<\/span><\/h6>\n

The next stage of this project will extend the analytical foundation with a focus on visual design, usability, and enterprise data management concepts, including role-based access and Row-Level Security (RLS).<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”Accounts Payable Insights Part One ” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQwODAifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/01\/pexels-martabranco-30337930-2.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” use_circle=”off” use_circle_border=”off” locked=”off” global_colors_info=”{}”]<\/p>\n

Power BI\u00a0<\/span><\/h6>\n

This first part documents the end-to-end build of an invoice processing report \u2014 from defining the business questions to preparing the dataset, modelling a clean star schema, and creating core DAX measures that power the KPIs and trends.<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”Exploring Invoice Amounts with Linear Regression” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQxNDgifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/02\/pexels-peng-louis-587527-1643489-scaled.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” use_circle=”off” use_circle_border=”off” locked=”off” global_colors_info=”{}”]<\/p>\n

Excel\u00a0<\/span><\/h6>\n

A small analytics project exploring the relationship between invoice processing time, delays, and invoice values using Excel regression and Power BI visualisation.<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][et_pb_heading title=”Early Projects” _builder_version=”4.27.5″ _module_preset=”default” title_text_align=”center” global_colors_info=”{}”][\/et_pb_heading][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ _builder_version=”4.27.5″ _module_preset=”default” filter_saturate=”0%” filter_brightness=”99%” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”What’s for Dinner” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQwMTAifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/pexels-karolina-grabowska-4199098-scaled.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” locked=”off” global_colors_info=”{}”]<\/p>\n

SQL & Phyton<\/span><\/p>\n

A fun data project where I used Python and SQL to clean a messy recipe dataset and explore what meals you can cook with the ingredients you already have. Smart, queries and everyday data magic.<\/span><\/div>\n
<\/div>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Legal Financial & Billing ” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM5NDEifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/02\/pexels-kampus-8441784-scaled.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” use_circle=”off” use_circle_border=”off” locked=”off” global_colors_info=”{}”]<\/p>\n

Power BI<\/span><\/h6>\n

This is an interactive Power BI dashboard for tracking revenue, overdue invoices, and billing efficiency in legal services. It features financial insights, payment tracking, and revenue forecasting to support better decision-making.<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Legal Business Project” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM4NjkifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/02\/pexels-asphotograpy-106344-scaled.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” use_circle=”off” use_circle_border=”off” global_colors_info=”{}”]<\/p>\n

Power BI<\/span><\/h6>\n

I created an interactive dashboard for this project that provides real-time insights into key legal services metrics, including total cases, open cases, and revenue. Dynamic filters and visuals help track performance and support data-driven decisions.<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Airbnb Berlin ” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM5ODQifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/pexels-markusspiske-179942-scaled.jpg” admin_label=”Project” _builder_version=”4.27.4″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”75%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” use_circle=”off” use_circle_border=”off” locked=”off” global_colors_info=”{}”]<\/p>\n

SQL & Power BI<\/span><\/h6>\n

Discover my latest data project exploring Airbnb listings in Berlin.<\/span>
Using <\/span>SQL in BigQuery and <\/span>Power BI includes\u00a0detailed information about thousands of listings, such as location, price, availability, room types, and reviews.<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_4,1_4,1_4,1_4″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”1_4″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Fitness Data Analytics” url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM2NzkifX0=@” image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2024\/07\/pexels-tima-miroshnichenko-5928318-scaled.jpg” admin_label=”Project” _builder_version=”4.27.5″ _dynamic_attributes=”url” header_font=”Montserrat||||” header_font_size=”24px” header_line_height=”1.3em” body_font_size=”16px” body_line_height=”1.8em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” child_filter_saturate=”0%” animation_style=”fold” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_fold=”10%” locked=”off” global_colors_info=”{}”]<\/p>\n

R Programming<\/span><\/h6>\n
<\/span><\/div>\n
This project analyzes <\/span>Fitbit tracker data to provide actionable insights for optimizing <\/span>health and well-being. It transforms raw data into meaningful visualizations, empowering users to make data-driven decisions for a healthier lifestyle.<\/span><\/div>\n
<\/div>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” background_color=”rgba(0,0,0,0.04)” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_icon font_icon=”||fa||400″ icon_color=”#0C71C3″ icon_width=”35px” url=”http:\/\/www.linkedin.com\/in\/erikap423″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_icon][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Welcome to my portfolio. I’m a passionate data analyst specializing in Power BI and interactive dashboards, transforming data into visual stories that drive decision-making.Case Studies Power BI\u00a0 The next stage of this project will extend the analytical foundation with a focus on visual design, usability, and enterprise data management concepts, including role-based access and Row-Level […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-3659","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/3659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3659"}],"version-history":[{"count":61,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/3659\/revisions"}],"predecessor-version":[{"id":4171,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/3659\/revisions\/4171"}],"wp:attachment":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}