Our Work
Select Distinct Case Studies, examples and illustrations of some of our recent projects
| Industry | Technology | Business Solution | Outcome Metrics | Further Information |
|---|---|---|---|---|
|
Beauty (Revolution Beauty) |
SQL Server Data Warehouse, Netsuite Integration, Power BI Reporting |
Implementation of a robust SQL Server data warehouse integrated with Netsuite and Power BI, transforming fragmented data into a single source of truth. |
This centralised reporting system empowered Revolution Beauty with faster insights, improved trust in analytics, and scalable decision-making. |
|
|
Digital Marketing (Linney) |
SQL Server Data Warehouse & Power BI Security |
Implementation of a row-level security in Power BI, ensuring sensitive insights were accessible only to authorised users. |
Linney now benefits from secure, streamlined reporting that protects data integrity while enabling confident, insight-driven action. |
|
|
Social Care (The Richmond Fellowship Scotland) |
Power BI Mentoring |
Supporting Richmond Fellowship Scotland through a seamless migration from Excel to Power BI, offering hands-on mentoring and strategic design support. |
We helped the customer design an approach showed them how to get started and had regular calls to help them overcome sticking points |
|
|
Food Supplements (Living Planet) |
Power BI, Prospect 365 CRM & OData Connector |
By connecting Prospect 365 CRM to Power BI via OData, we delivered interactive sales dashboards with drill-down capabilities. |
Living Planet now can streamline sales reporting, increased interactivity with drill through and drill down and simplified the performance tracking by sales channel. |
Coming soon |
|
Agriculture (Strawson Produce) |
Power BI & Azure Based ERP |
We partnered with Strawson Produce to design and develop Power BI dashboards across manufacturing and distribution workflows |
Our support and mentoring enabled their in-house team to confidently manage and evolve their analytics ecosystem. |
Coming soon |
|
Fashion (Aspinal of London) |
Power BI, SQL Server & Navision |
Aspinal of London gained actionable insights through custom-built Power BI dashboards covering sales, returns, and inventory. |
We provided end-to-end support, from design to mentoring, ensuring their internal team could maintain and expand their reporting capabilities. |
Coming soon |
Revolution Beauty
Improving Data Infrastructure with a data warehouse
Revolution Beauty is a leading cosmetics company that faced a challenge with its data infrastructure.
The core of the business reporting was being served directly from their Netsuite SAAS platform
As a result it was clunky and slow to update. It required specialist skills to service the reporting requirements. Quite simply Revolution Beauty has out grown this approach
The existing data structures lacked the flexibility required to help to drive the business forward. The company was looking for a more targeted approach to gain insights and make data-driven decisions.
Revolution Beauty commissioned Select Distinct to help to build out their data warehouse.
Power BI Security
Controlling access to sensitive data
Select Distinct were appointed to provide consultancy for a large digital marketing company
The company wanted to restrict access to information based on the roles of the users
We demonstrated how access can be controlled both within their SQL environment and within Power BI reports using row level security
The client was quickly able to adapt their environment to ensure that sensitive data was kept secure
Power BI Coaching
Supporting and upskilling in house teams
Select Distinct provided remote support for a client within the social care sector
The client had a base level of skill in house and needed to be able to call upon expertise on a flexible basis to help their team overcome some of the complexities they faced
They were migrating reporting from Excel to Power BI and needed a light touch remote and flexible resource to support them when things got complicated
We provided the client with a regular contact over a number of weeks. The client brought all of their challenges to the call and we helped them solve those challenges in real time, cost effectively via teams calls
The client in house team learned a great deal from trying, getting stuck and then being shown a solution. With our help they have a higher level of ability and confidence to tackle more challenges on their own