[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\/2025\/02\/pexels-kampus-8441784-scaled.jpg” parallax=”off” background_size=”initial” hover_transition_speed_curve=”ease-in” global_colors_info=”{}”][et_pb_fullwidth_header title=”Legal Business ” text_orientation=”center” admin_label=”Hero Section” _builder_version=”4.16″ 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
Interactive Dashboard by Power BI<\/p>\n
<\/p>\n
[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Projects” _builder_version=”4.16″ 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.27.4″ 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
[\/et_pb_text][et_pb_text admin_label=”Projects Section Subtitle” _builder_version=”4.27.4″ text_font_size=”16px” text_line_height=”1.9em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” max_width=”710px” module_alignment=”center” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” link_option_url=”https:\/\/www.youtube.com\/watch?v=7QNgqq154gE” global_colors_info=”{}”]<\/p>\n
Explore 12 months of business performance at a glance! This interactive Power BI dashboard transforms data into an engaging story, revealing month-to-month trends and hidden insights.<\/p>\n
Top Highlights:<\/strong> This dashboard is designed to make data come alive, empowering smarter decisions and sparking new ideas.<\/p>\n <\/p>\n<\/div>\n \n [\/et_pb_text][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/01\/Screenshot-2026-01-25-191014.png” title_text=”Screenshot 2026-01-25 191014″ align=”center” _builder_version=”4.27.5″ _module_preset=”default” width=”100%” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_image][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/01\/Screenshot-2026-01-25-191143.png” title_text=”Screenshot 2026-01-25 191143″ align=”center” _builder_version=”4.27.5″ _module_preset=”default” width=”100%” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” text_font_size=”16px” text_line_height=”1.9em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” text_orientation=”center” max_width=”710px” module_alignment=”center” custom_margin=”75px|||||” custom_padding=”0px|||||” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” global_colors_info=”{}”]<\/p>\n <\/p>\n \u2705 Designed a Star Schema Data Model<\/strong> \u2013 Created a structured fact-dimension relationship<\/strong> to optimize performance and reporting. [\/et_pb_text][et_pb_video _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_video][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/02\/Image-23-02-2025-at-19.45.jpg” title_text=”Image 23-02-2025 at 19.45″ admin_label=”Data Model” _builder_version=”4.27.5″ _module_preset=”default” max_width=”100%” module_alignment=”center” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n Star Schema Data Model<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row disabled_on=”off|off|off” _builder_version=”4.27.4″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”45px|||” box_shadow_style=”preset1″ box_shadow_blur=”29px” box_shadow_spread=”8px” box_shadow_color=”rgba(0,0,0,0.03)” locked=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_post_nav in_same_term=”off” _builder_version=”4.27.4″ _module_preset=”default” title_font=”|600|||||||” title_text_color=”gcid-cec232a7-b6b7-44dd-8069-e0b6a3a379a8″ title_font_size=”21px” custom_padding=”5px|5px|5px|5px|true|true” border_radii=”on|2px|2px|2px|2px” border_style_bottom=”inset” box_shadow_style=”preset4″ box_shadow_blur=”10px” box_shadow_color=”rgba(0,0,0,0.07)” global_colors_info=”{%22gcid-cec232a7-b6b7-44dd-8069-e0b6a3a379a8%22:%91%22title_text_color%22%93,%22gcid-a674551e-c023-4666-82b8-b7448e713885%22:%91%22title_text_color%22%93}”][\/et_pb_post_nav][\/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)” locked=”off” 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":" Interactive Dashboard by Power BI Legal Services Interactive DashboardExplore 12 months of business performance at a glance! This interactive Power BI dashboard transforms data into an engaging story, revealing month-to-month trends and hidden insights. Top Highlights:\u2728 KPI Cards front and center\u2014keeping you up to speed on Revenue, Total Cases, Open Cases, and Closed Cases.\u2728 Slicers […]<\/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-3869","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/3869","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=3869"}],"version-history":[{"count":19,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/3869\/revisions"}],"predecessor-version":[{"id":4075,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/3869\/revisions\/4075"}],"wp:attachment":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\u2728 KPI Cards<\/strong> front and center\u2014keeping you up to speed on Revenue, Total Cases, Open Cases, and Closed Cases.
\u2728 Slicers & Bookmarks<\/strong>\u2014your personal control panel for instant exploration and tailored insights.
\u2728 Decomposition Tree<\/strong>\u2014because every detail matters! Dive deep and uncover patterns you didn\u2019t know existed.<\/p>\n<\/h4>\n
<\/span><\/div>\n<\/div>\n
\u2705 Developed an Interactive Dashboard<\/strong> \u2013 Integrated multiple visuals, including KPI cards, bar charts, line charts, and decomposition trees<\/strong> to explore legal case performance.
\u2705 Implemented Advanced DAX Measures<\/strong> \u2013 Built calculations for total revenue, case closure rates, lawyer workload, and dynamic time filters<\/strong>.
\u2705 Enabled Dynamic Time Analysis<\/strong> \u2013 Created a custom time slicer<\/strong> and dynamic line chart<\/strong> to track trends across different periods.
\u2705 Utilized a Decomposition Tree<\/strong> \u2013 Provided drill-down insights into case volume and revenue distribution by lawyer, case type, and client location<\/strong>.
\u2705 Ensured Data-Driven Decision Making<\/strong> \u2013 Designed the dashboard to help legal firms optimize resources and improve service delivery.<\/p>\n