An FSA regulated business required a more consumable Complaints Log to consolidate their complaints process and enable statistical reporting to their clients to fulfil new FSA requirements. Being a small, local, business, their budget was limited. Utilising their existing tools, an Excel spreadsheet was developed to include data constraints, lookups, cell locking and conditionally formatted cell highlighting ensuring an easy user experience with a high level of data quality. Storing the Complaints Log on SharePoint enables collaboration, change tracking and access control. A Power BI Report connects to the Complaints Log providing MI and exports for their clients.
Search
About
Happily escaped the Corporate grind and dreary UK weather to my happy place in the sun!
I now help businesses with simple to use, low cost solutions to their process, administration and data headaches.
I can streamline your processes, build templates, automation and websites using common tools which ensures you are not locked into me going forwards. Everything I deliver is fully owned by you, including WordPress Websites, Excel Apps, Automation and any associated custom coding.
I also provide consultancy and training in all aspects of Data and Getting the Most out of your MS365 Subscription.
Archive
Categories
Recent Posts
Gallery











