{"id":4335,"date":"2026-05-13T06:20:26","date_gmt":"2026-05-13T06:20:26","guid":{"rendered":"https:\/\/erikap.co.uk\/?page_id=4335"},"modified":"2026-05-25T20:21:05","modified_gmt":"2026-05-25T20:21:05","slug":"projects","status":"publish","type":"page","link":"https:\/\/erikap.co.uk\/?page_id=4335","title":{"rendered":"Projects"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; admin_label=&#8221;Hero&#8221; _builder_version=&#8221;4.27.6&#8243; background_image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/02\/pexels-kampus-8441784-scaled.jpg&#8221; custom_padding=&#8221;0px|0|0px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_header title=&#8221;Projects&#8221; text_orientation=&#8221;center&#8221; module_id=&#8221;contact&#8221; _builder_version=&#8221;4.27.6&#8243; title_font=&#8221;Share Tech||||||||&#8221; title_text_align=&#8221;center&#8221; title_font_size=&#8221;80px&#8221; title_line_height=&#8221;1.2em&#8221; content_font=&#8221;Open Sans||||||||&#8221; content_text_align=&#8221;center&#8221; content_font_size=&#8221;18px&#8221; content_line_height=&#8221;1.8em&#8221; background_color=&#8221;rgba(0,0,0,0)&#8221; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_direction=&#8221;140deg&#8221; background_color_gradient_stops=&#8221;rgba(0,72,114,0.9) 0%|rgba(41,17,96,0.8) 100%&#8221; background_color_gradient_start=&#8221;rgba(0,72,114,0.9)&#8221; background_color_gradient_end=&#8221;rgba(41,17,96,0.8)&#8221; parallax=&#8221;on&#8221; parallax_method=&#8221;on&#8221; custom_button_one=&#8221;on&#8221; button_one_text_size=&#8221;15px&#8221; button_one_bg_color=&#8221;#ffa727&#8243; button_one_border_width=&#8221;15px&#8221; button_one_border_color=&#8221;#ffa727&#8243; button_one_border_radius=&#8221;100px&#8221; button_one_letter_spacing=&#8221;5px&#8221; button_one_font=&#8221;Open Sans|700||on|||||&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;10vw||10vw||true&#8221; custom_padding_tablet=&#8221;100px||100px||true&#8221; custom_padding_phone=&#8221;|||&#8221; custom_padding_last_edited=&#8221;on|desktop&#8221; title_font_size_tablet=&#8221;60px&#8221; title_font_size_phone=&#8221;36px&#8221; title_font_size_last_edited=&#8221;on|phone&#8221; content_font_size_tablet=&#8221;&#8221; content_font_size_phone=&#8221;16px&#8221; content_font_size_last_edited=&#8221;on|phone&#8221; button_one_text_size_tablet=&#8221;&#8221; button_one_text_size_phone=&#8221;&#8221; button_one_text_size_last_edited=&#8221;on|desktop&#8221; button_one_border_color_hover=&#8221;#ff8a3d&#8221; button_one_border_radius_hover=&#8221;100px&#8221; button_one_letter_spacing_hover=&#8221;5px&#8221; button_one_bg_color_hover=&#8221;#ff8a3d&#8221; global_colors_info=&#8221;{}&#8221; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;on&#8221; button_one_border_color__hover=&#8221;#ff8a3d&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_one_border_radius__hover_enabled=&#8221;on&#8221; button_one_border_radius__hover=&#8221;100px&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_one_letter_spacing__hover_enabled=&#8221;on&#8221; button_one_letter_spacing__hover=&#8221;5px&#8221; button_two_letter_spacing__hover_enabled=&#8221;off&#8221; button_one_bg_color__hover_enabled=&#8221;on&#8221; button_one_bg_color__hover=&#8221;#ff8a3d&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221;]<\/p>\n<p data-start=\"268\" data-end=\"354\">Real-world Excel, Power BI and SQL projects focused on finance and business reporting.<\/p>\n<p>[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; specialty=&#8221;on&#8221; padding_top_1=&#8221;0px&#8221; padding_top_2=&#8221;0px&#8221; padding_bottom_1=&#8221;0px&#8221; padding_bottom_2=&#8221;0px&#8221; padding_top_bottom_link_1=&#8221;true&#8221; padding_top_bottom_link_2=&#8221;true&#8221; admin_label=&#8221;Button Bar&#8221; _builder_version=&#8221;4.27.6&#8243; background_color=&#8221;rgba(255,255,255,0)&#8221; inner_width=&#8221;100%&#8221; inner_max_width=&#8221;100%&#8221; custom_margin=&#8221;-36px|||&#8221; custom_padding=&#8221;0||||false|false&#8221; hover_enabled=&#8221;0&#8243; use_custom_width=&#8221;on&#8221; width_unit=&#8221;off&#8221; custom_width_percent=&#8221;100%&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;View Services&#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQzMzIifX0=@&#8221; content_max_width=&#8221;1100px&#8221; content_max_width_last_edited=&#8221;off|desktop&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Open Sans|700||on|||||&#8221; header_font_size=&#8221;14px&#8221; header_letter_spacing=&#8221;5px&#8221; header_line_height=&#8221;2em&#8221; body_font=&#8221;||||||||&#8221; background_color=&#8221;#2573f9&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_direction=&#8221;90deg&#8221; background_color_gradient_stops=&#8221;#ffffff 0%|#2573f9 100%&#8221; background_color_gradient_start=&#8221;#ffffff&#8221; background_color_gradient_end=&#8221;#2573f9&#8243; text_orientation=&#8221;right&#8221; background_layout=&#8221;dark&#8221; custom_padding=&#8221;20px|40px|12px|40px|false|true&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;left&#8221; animation_intensity_slide=&#8221;5%&#8221; border_radii=&#8221;||100px|100px|&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; specialty_columns=&#8221;2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_row_inner column_structure=&#8221;1_2,1_2&#8243; custom_padding_last_edited=&#8221;on|desktop&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;0|25%|0|0px|true|false&#8221; custom_padding_tablet=&#8221;|10%||10%||true&#8221; custom_padding_phone=&#8221;&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column_inner type=&#8221;1_2&#8243; saved_specialty_column_type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_button button_text=&#8221;contact&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;14px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2573f9&#8243; button_bg_color_gradient_direction=&#8221;90deg&#8221; button_bg_color_gradient_stops=&#8221;#ffa727 0%|#FF8A3D 100%&#8221; button_bg_color_gradient_start=&#8221;#ffa727&#8243; button_bg_color_gradient_end=&#8221;#FF8A3D&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;100px&#8221; button_letter_spacing=&#8221;5px&#8221; button_font=&#8221;Open Sans|700||on|||||&#8221; button_use_icon=&#8221;off&#8221; custom_padding=&#8221;23px|24px|23px|24px|true|true&#8221; animation_style=&#8221;slide&#8221; animation_direction=&#8221;left&#8221; button_border_radius_hover=&#8221;100px&#8221; button_letter_spacing_hover=&#8221;5px&#8221; button_bg_color_hover=&#8221;#3980f9&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; button_text_size__hover_enabled=&#8221;off&#8221; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_text_color__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_border_width__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_border_color__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;off&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_border_radius__hover_enabled=&#8221;on&#8221; button_border_radius__hover=&#8221;100px&#8221; button_one_border_radius__hover_enabled=&#8221;off&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_letter_spacing__hover_enabled=&#8221;on&#8221; button_letter_spacing__hover=&#8221;5px&#8221; button_one_letter_spacing__hover_enabled=&#8221;off&#8221; button_two_letter_spacing__hover_enabled=&#8221;off&#8221; button_bg_color__hover_enabled=&#8221;on&#8221; button_bg_color__hover=&#8221;#3980f9&#8243; button_one_bg_color__hover_enabled=&#8221;off&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; button_url=&#8221;#contacts&#8221;][\/et_pb_button][\/et_pb_column_inner][et_pb_column_inner type=&#8221;1_2&#8243; saved_specialty_column_type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Videos&#8221; _builder_version=&#8221;4.16&#8243; min_height=&#8221;1673.5px&#8221; custom_padding=&#8221;100px|0px|54px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.6&#8243; text_font=&#8221;Share Tech||||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.02)&#8221; text_font_size=&#8221;100px&#8221; text_line_height=&#8221;0.2em&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;Share Tech||||||||&#8221; header_2_font_size=&#8221;48px&#8221; header_2_line_height=&#8221;1.4em&#8221; custom_margin=&#8221;||30px||false&#8221; custom_margin_tablet=&#8221;||0px|&#8221; custom_margin_phone=&#8221;&#8221; custom_margin_last_edited=&#8221;on|tablet&#8221; text_font_size_tablet=&#8221;80px&#8221; text_font_size_phone=&#8221;60px&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;36px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>INSIGHTS<\/p>\n<h2>Projects<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;Accounts Payable Insights Part Two&#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQxMzgifX0=@&#8221; image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/02\/pexels-kampus-8428063-scaled.jpg&#8221; admin_label=&#8221;Project&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Montserrat||||&#8221; header_font_size=&#8221;24px&#8221; header_line_height=&#8221;1.3em&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.8em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; child_filter_saturate=&#8221;75%&#8221; animation_style=&#8221;fold&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_fold=&#8221;10%&#8221; use_circle=&#8221;off&#8221; use_circle_border=&#8221;off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><span style=\"color: #0c71c3;\">Power BI\u00a0<\/span><\/h6>\n<p style=\"text-align: left;\"><span>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<p style=\"text-align: left;\">[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_blurb title=&#8221;Accounts Payable Insights Part One &#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQwODAifX0=@&#8221; image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/01\/pexels-martabranco-30337930-2.jpg&#8221; admin_label=&#8221;Project&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Montserrat||||&#8221; header_font_size=&#8221;24px&#8221; header_line_height=&#8221;1.3em&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.8em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; child_filter_saturate=&#8221;75%&#8221; animation_style=&#8221;fold&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_fold=&#8221;10%&#8221; use_circle=&#8221;off&#8221; use_circle_border=&#8221;off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><span style=\"color: #0c71c3;\">Power BI\u00a0<\/span><\/h6>\n<p style=\"text-align: left;\"><span>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<p style=\"text-align: left;\">[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_blurb title=&#8221;Exploring Invoice Amounts with Linear Regression&#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjQxNDgifX0=@&#8221; image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/05\/pexels-kindelmedia-7054415-scaled.jpg&#8221; admin_label=&#8221;Project&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Montserrat||||&#8221; header_font_size=&#8221;24px&#8221; header_line_height=&#8221;1.3em&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.8em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; child_filter_saturate=&#8221;75%&#8221; animation_style=&#8221;fold&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_fold=&#8221;10%&#8221; use_circle=&#8221;off&#8221; use_circle_border=&#8221;off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><span style=\"color: #0c71c3;\">Excel\u00a0<\/span><\/h6>\n<p style=\"text-align: left;\"><span>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<p style=\"text-align: left;\">[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;Airbnb Berlin &#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM5ODQifX0=@&#8221; image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/pexels-markusspiske-179942-scaled.jpg&#8221; admin_label=&#8221;Project&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Montserrat||||&#8221; header_font_size=&#8221;24px&#8221; header_line_height=&#8221;1.3em&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.8em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; child_filter_saturate=&#8221;75%&#8221; animation_style=&#8221;fold&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_fold=&#8221;10%&#8221; use_circle=&#8221;off&#8221; use_circle_border=&#8221;off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><span style=\"color: #0c71c3;\">SQL &amp; Power BI<\/span><\/h6>\n<p style=\"text-align: left;\"><span>Discover my latest data project exploring Airbnb listings in Berlin.<\/span><br data-start=\"186\" data-end=\"189\" \/><span>Using <\/span>SQL in BigQuery<span> and <\/span>Power BI includes<span>\u00a0detailed information about thousands of listings, such as location, price, availability, room types, and reviews.<\/span><\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_blurb title=&#8221;Legal Business Project&#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM4NjkifX0=@&#8221; image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/02\/pexels-asphotograpy-106344-scaled.jpg&#8221; admin_label=&#8221;Project&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Montserrat||||&#8221; header_font_size=&#8221;24px&#8221; header_line_height=&#8221;1.3em&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.8em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; child_filter_saturate=&#8221;75%&#8221; animation_style=&#8221;fold&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_fold=&#8221;10%&#8221; use_circle=&#8221;off&#8221; use_circle_border=&#8221;off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><span style=\"color: #0c71c3;\">Power BI<\/span><\/h6>\n<p style=\"text-align: left;\"><span>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<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_blurb title=&#8221;Legal Financial &#038; Billing &#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM5NDEifX0=@&#8221; image=&#8221;https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/02\/pexels-kampus-8441784-scaled.jpg&#8221; admin_label=&#8221;Project&#8221; _builder_version=&#8221;4.27.6&#8243; _dynamic_attributes=&#8221;url&#8221; header_font=&#8221;Montserrat||||&#8221; header_font_size=&#8221;24px&#8221; header_line_height=&#8221;1.3em&#8221; body_font_size=&#8221;16px&#8221; body_line_height=&#8221;1.8em&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; child_filter_saturate=&#8221;75%&#8221; animation_style=&#8221;fold&#8221; animation_direction=&#8221;bottom&#8221; animation_delay=&#8221;100ms&#8221; animation_intensity_fold=&#8221;10%&#8221; use_circle=&#8221;off&#8221; use_circle_border=&#8221;off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><span style=\"color: #0c71c3;\">Power BI<\/span><\/h6>\n<p style=\"text-align: left;\"><span>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<p style=\"text-align: left;\">[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.27.6&#8243; text_font=&#8221;Share Tech||||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.02)&#8221; text_font_size=&#8221;100px&#8221; text_line_height=&#8221;0.2em&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;Share Tech||||||||&#8221; header_2_font_size=&#8221;48px&#8221; header_2_line_height=&#8221;1.4em&#8221; custom_margin=&#8221;||30px||false&#8221; custom_margin_tablet=&#8221;||0px|&#8221; custom_margin_phone=&#8221;&#8221; custom_margin_last_edited=&#8221;on|tablet&#8221; text_font_size_tablet=&#8221;80px&#8221; text_font_size_phone=&#8221;60px&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;36px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>INSIGHTS<\/p>\n<h2 data-section-id=\"1uwmra0\" data-start=\"723\" data-end=\"769\">Need a similar dashboard for your business?<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;16px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p data-start=\"771\" data-end=\"840\">Let&#8217;s discuss how I can help turn your data into actionable insights.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;off|desktop&#8221; admin_label=&#8221;Footer&#8221; _builder_version=&#8221;4.27.6&#8243; background_enable_image=&#8221;off&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;120px|0px|120px|0px|true|false&#8221; custom_padding_tablet=&#8221;10vw||10vw||true&#8221; custom_padding_phone=&#8221;5vw||5vw||true&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row use_custom_gutter=&#8221;on&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; use_custom_width=&#8221;on&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_contact_form title=&#8221;Send a message&#8221; success_message=&#8221;Thanks for reaching out \u2014 I\u2019ll get back to you soon.&#8221; submit_button_text=&#8221;send message&#8221; module_id=&#8221;contacts&#8221; _builder_version=&#8221;4.27.6&#8243; form_field_background_color=&#8221;rgba(0,0,0,0)&#8221; title_level=&#8221;h2&#8243; title_font=&#8221;Share Tech||||||||&#8221; title_font_size=&#8221;50px&#8221; title_line_height=&#8221;1.2em&#8221; form_field_font=&#8221;Open Sans|700|||||||&#8221; form_field_letter_spacing=&#8221;2px&#8221; form_field_line_height=&#8221;1.8em&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;15px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#ffa727&#8243; button_border_width=&#8221;10px&#8221; button_border_color=&#8221;#ffa727&#8243; button_border_radius=&#8221;100px&#8221; button_letter_spacing=&#8221;5px&#8221; button_font=&#8221;Open Sans|700||on|||||&#8221; button_use_icon=&#8221;off&#8221; hover_enabled=&#8221;0&#8243; button_text_size_last_edited=&#8221;off|desktop&#8221; border_color_all=&#8221;rgba(0,0,0,0.1)&#8221; border_width_bottom=&#8221;2px&#8221; form_background_color=&#8221;rgba(0,0,0,0)&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_contact_field field_id=&#8221;Name&#8221; field_title=&#8221;Name&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; button_text_size__hover_enabled=&#8221;off&#8221; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_text_color__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_border_width__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_border_color__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;off&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_border_radius__hover_enabled=&#8221;off&#8221; button_one_border_radius__hover_enabled=&#8221;off&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_letter_spacing__hover_enabled=&#8221;off&#8221; button_one_letter_spacing__hover_enabled=&#8221;off&#8221; button_two_letter_spacing__hover_enabled=&#8221;off&#8221; button_bg_color__hover_enabled=&#8221;off&#8221; button_one_bg_color__hover_enabled=&#8221;off&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Email&#8221; field_title=&#8221;Email Address&#8221; field_type=&#8221;email&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; button_text_size__hover_enabled=&#8221;off&#8221; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_text_color__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_border_width__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_border_color__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;off&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_border_radius__hover_enabled=&#8221;off&#8221; button_one_border_radius__hover_enabled=&#8221;off&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_letter_spacing__hover_enabled=&#8221;off&#8221; button_one_letter_spacing__hover_enabled=&#8221;off&#8221; button_two_letter_spacing__hover_enabled=&#8221;off&#8221; button_bg_color__hover_enabled=&#8221;off&#8221; button_one_bg_color__hover_enabled=&#8221;off&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221;][\/et_pb_contact_field][et_pb_contact_field field_id=&#8221;Message&#8221; field_title=&#8221;Message&#8221; field_type=&#8221;text&#8221; fullwidth_field=&#8221;on&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; button_text_size__hover_enabled=&#8221;off&#8221; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_text_color__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_border_width__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_border_color__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;off&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_border_radius__hover_enabled=&#8221;off&#8221; button_one_border_radius__hover_enabled=&#8221;off&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_letter_spacing__hover_enabled=&#8221;off&#8221; button_one_letter_spacing__hover_enabled=&#8221;off&#8221; button_two_letter_spacing__hover_enabled=&#8221;off&#8221; button_bg_color__hover_enabled=&#8221;off&#8221; button_one_bg_color__hover_enabled=&#8221;off&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221;][\/et_pb_contact_field][\/et_pb_contact_form][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_social_media_follow _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_social_media_follow_network social_network=&#8221;linkedin&#8221; url=&#8221;http:\/\/www.linkedin.com\/in\/erikapapaibi&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#007bb6&#8243; global_colors_info=&#8221;{}&#8221; follow_button=&#8221;off&#8221; url_new_window=&#8221;on&#8221;]linkedin[\/et_pb_social_media_follow_network][\/et_pb_social_media_follow][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Real-world Excel, Power BI and SQL projects focused on finance and business reporting.INSIGHTS ProjectsPower 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 Security (RLS). Power BI\u00a0 This first part documents the end-to-end build of [&hellip;]<\/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-4335","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4335","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=4335"}],"version-history":[{"count":60,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4335\/revisions"}],"predecessor-version":[{"id":4547,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4335\/revisions\/4547"}],"wp:attachment":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}