[et_pb_section fb_built=”1″ fullwidth=”on” admin_label=”Page Header” _builder_version=”4.27.5″ _module_preset=”3c901e30-8c7f-4173-af71-9e53c9b0862a” background_image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/01\/pexels-martabranco-30337930-2.jpg” hover_enabled=”0″ global_colors_info=”{}” title_text=”cincilla” background_video_mp4=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/02\/cincilla.mp4″ sticky_enabled=”0″][et_pb_fullwidth_header title=”Accounts Payable Insights” text_orientation=”center” admin_label=”Hero Section” _builder_version=”4.27.5″ _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” custom_margin=”||1px|||” 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
Visual Design, Usability & Security (RLS)<\/span><\/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=”6px||6px||true|” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ _module_preset=”default” background_size=”initial” background_position=”top_left” background_repeat=”repeat” width=”64.7%” 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.5″ _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%” locked=”off” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” global_colors_info=”{}”]<\/p>\n This report is based on a fictional UK charity, Cats & Paw Care, created to reflect a realistic accounts payable environment within the animal welfare sector.<\/p>\n Cats & Paw Care works with a wide range of suppliers, including veterinary services, food and medication providers, property and facilities partners, as well as IT and legal services. As with many charities, timely invoice processing is essential to ensure smooth operations and uninterrupted care delivery.<\/p>\n The dataset and company scenario are fully fictional but inspired by real-world finance operations, allowing the project to focus on practical, business-relevant analytics while remaining portfolio-safe.<\/p>\n [\/et_pb_text][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 [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” locked=”off” global_colors_info=”{}”]<\/p>\n After completing the initial data preparation phase \u2014 which involved cleaning, transforming, and modelling the raw AP dataset, along with building key DAX measures \u2014 this visual layer brings the insights to life through an interactive, user\u2011friendly Power BI report.<\/span><\/p>\n The goal of this stage was to translate the underlying data model into a clear, intuitive set of visuals that help finance teams monitor performance, diagnose delays, and understand vendor behaviour at both a high level and a detailed, invoice\u2011level view.<\/span><\/p>\n [\/et_pb_text][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.5″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” custom_padding=”0px|||||” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” locked=”off” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” locked=”off” global_colors_info=”{}”]<\/p>\n This stage focused on making the report feel calm, readable, and decision-ready. I used a light background, subtle borders, consistent spacing, and a limited colour palette to keep attention on the story rather than on decorative elements. Visual hierarchy was designed to work at a glance: headline KPIs at the top, trends and drivers in the middle, and detailed vendor-level information at the bottom.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/03\/Screenshot-2026-02-20-131649.png” title_text=”Screenshot 2026-02-20 131649″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.5″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” custom_padding=”0px|||||” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” locked=”off” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” locked=”off” global_colors_info=”{}”]<\/p>\n Each KPI is supported with context so it\u2019s not \u201cjust a number\u201d. For volume metrics (Invoices, Backlog) I used MoM\/YoY percentage change, while for rate metrics (Overdue %, Delayed %) I used <\/span>percentage-point (pp) movement to avoid misleading interpretations. For operational performance, I added an <\/span>Avg Processing Days target and clearly displayed variance (e.g., days over\/under target) to turn the dashboard into an action-oriented tool.<\/span><\/p>\n [\/et_pb_text][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.5″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” custom_padding=”0px|||||” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” locked=”off” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” locked=”off” global_colors_info=”{}”]<\/p>\n The main page is designed for quick scanning, with trend tabs to switch the focus between key metrics. To keep the report uncluttered while still supporting investigation, I added a <\/span>drill-through page<\/strong> for vendor-level analysis. From a vendor or chart selection, users can open a detail view showing KPI context, delay reasons, processing-time trends, and invoice-level records\u2014helping them move from insight to root cause in seconds.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2026\/03\/Screenshot-2026-02-20-131707.png” title_text=”Screenshot 2026-02-20 131707″ _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.5″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” custom_padding=”0px|||||” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” locked=”off” global_colors_info=”{}”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” locked=”off” global_colors_info=”{}”]<\/p>\n \u00a0To demonstrate enterprise-ready governance, I implemented a <\/span>mock Row-Level Security (RLS) model based on Department access. A security mapping table (User\/UPN \u2192 DepartmentID) filters the Department dimension, which then filters invoice data across the report. In testing (View as role), different users can only see the departments they are authorised to access (e.g., an IT user sees IT only). This simulates a realistic multi-department reporting environment while keeping the dataset fictional.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMTA4MCIgaGVpZ2h0PSI1NDAiIHZpZXdCb3g9IjAgMCAxMDgwIDU0MCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4KICAgIDxnIGZpbGw9Im5vbmUiIGZpbGwtcnVsZT0iZXZlbm9kZCI+CiAgICAgICAgPHBhdGggZmlsbD0iI0VCRUJFQiIgZD0iTTAgMGgxMDgwdjU0MEgweiIvPgogICAgICAgIDxwYXRoIGQ9Ik00NDUuNjQ5IDU0MGgtOTguOTk1TDE0NC42NDkgMzM3Ljk5NSAwIDQ4Mi42NDR2LTk4Ljk5NWwxMTYuMzY1LTExNi4zNjVjMTUuNjItMTUuNjIgNDAuOTQ3LTE1LjYyIDU2LjU2OCAwTDQ0NS42NSA1NDB6IiBmaWxsLW9wYWNpdHk9Ii4xIiBmaWxsPSIjMDAwIiBmaWxsLXJ1bGU9Im5vbnplcm8iLz4KICAgICAgICA8Y2lyY2xlIGZpbGwtb3BhY2l0eT0iLjA1IiBmaWxsPSIjMDAwIiBjeD0iMzMxIiBjeT0iMTQ4IiByPSI3MCIvPgogICAgICAgIDxwYXRoIGQ9Ik0xMDgwIDM3OXYxMTMuMTM3TDcyOC4xNjIgMTQwLjMgMzI4LjQ2MiA1NDBIMjE1LjMyNEw2OTkuODc4IDU1LjQ0NmMxNS42Mi0xNS42MiA0MC45NDgtMTUuNjIgNTYuNTY4IDBMMTA4MCAzNzl6IiBmaWxsLW9wYWNpdHk9Ii4yIiBmaWxsPSIjMDAwIiBmaWxsLXJ1bGU9Im5vbnplcm8iLz4KICAgIDwvZz4KPC9zdmc+Cg==” _builder_version=”4.27.5″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_image][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.5″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” custom_margin=”||1px|||” custom_padding=”0px|||||” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” locked=”off” global_colors_info=”{}”]<\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.5″ _module_preset=”default” text_font_size=”16px” locked=”off” global_colors_info=”{}”]<\/p>\n \u00a0To extend the project beyond reporting, I applied a basic regression model to examine whether processing time and delay status help explain invoice amount variability.<\/p>\n [\/et_pb_text][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":" Visual Design, Usability & Security (RLS) Project ContextThis report is based on a fictional UK charity, Cats & Paw Care, created to reflect a realistic accounts payable environment within the animal welfare sector. Cats & Paw Care works with a wide range of suppliers, including veterinary services, food and medication providers, property and facilities partners, […]<\/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-4138","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4138","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=4138"}],"version-history":[{"count":8,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4138\/revisions"}],"predecessor-version":[{"id":4174,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4138\/revisions\/4174"}],"wp:attachment":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Project Context<\/span><\/h1>\n
Introduction<\/span><\/h1>\n
Visual Design<\/span><\/h1>\n
KPI storytelling (MoM \/ YoY + targets)<\/span><\/h1>\n
Interactivity & drill experience<\/span><\/h1>\n
Row-Level Security (Mock RLS scenario)<\/span><\/h1>\n
Next Stage<\/h1>\n