Confidential client, name withheld under NDA

Multi-Tenant Web App: Secure Database and Seamless Mobile Experience

Quick answer: A multi-tenant .NET Core platform on Azure SQL Elastic Pool gives each client an isolated database, role-based access and KPI dashboards on any screen. Bacancy Technology built this for a US performance management platform.

Outcomes deliveredDelivered January 2020 to October 2020 by a team of 2 developers
40%

Faster new client onboarding

Isolated databases on Elastic Pool

30%

Less manual reporting effort

Scheduled dashboard email subscriptions

35%

More dashboard use on mobile

Responsive, mobile-friendly UI

Client name withheld under NDA. To honour our non-disclosure agreement and compliance obligations, we describe this client by industry and region only. The project scope, technology and outcomes are shared without details that could identify them.

About the Client

The client is a US data-driven performance management platform that helps organizations monitor, analyze and act on critical metrics in real time. Its interactive dashboards help teams manage large projects with many information sources.

The client needed secure client onboarding, with a separate database and data management for each client. It also needed a smooth experience on mobile devices, which proved a complex challenge.

Our team worked from January 2020 to October 2020. It built a multi-tenant web application on .NET Core and Azure SQL Elastic Pool, with role-based access and reliable database isolation. A responsive interface now works across screen sizes. Users also get customizable dashboards, Google Maps integration and dashboard email subscriptions.

Client type
Performance management platform
Industry
Information Technology
Location
USA
Team
2 developers
Timeline
January 2020 to October 2020
Project size
Non-disclosable

Challenges & Solutions

Our .NET developers built tenant isolation and mobile access into one Azure-hosted platform.

Challenge 1: Onboarding clients securely with isolated databases

The client needed secure client onboarding, with an individual database and separate data management for each client.

Solution: Our developers built a role- and permission-based access system on .NET Core. Azure SQL with Elastic Pool gives every tenant its own isolated database and lets the platform scale as clients join.

Challenge 2: Delivering a smooth experience on mobile devices

Dashboards had to work well on phones and tablets as well as desktops.

Solution: Our team applied responsive design and mobile-friendly UI and UX practices, so dashboards adapt to every screen size.

How the Platform Works

The client multi-tenant KPI dashboard platform built on .NET and Azure

Core Features

  • Global and custom dashboardsStart from shared templates or build dashboards per team.
  • Dynamic dashboard renderingCharts and visuals update as the underlying metrics change.
  • Dashboard email subscriptionsScheduled tasks send dashboards to users by email.
  • Views and filter managementUsers save views and filter data their own way.
  • Google Maps integrationLocation-based metrics shown on a map.
  • Mobile-friendly accessResponsive dashboards on any screen size.

The Stack Behind the Platform

Backend
.NET Core MVC
Frontend
HTML | JavaScript
Database
Microsoft SQL Server | Azure SQL Elastic Pool
Cloud
Azure Web App
Integrations
Google Maps

Ready to start?

2500+ projects delivered by Bacancy Technology

Get access to an experienced team of developers and engineers from Bacancy Technology, handpicked to ace your goals. Kickstart within 48 hours, no-risk trial.

Book A 30 Min Call
14+Years of business experience
1458+Happy customers
30+Countries with happy customers
1050+Agile-enabled employees

More Case Studies

View All Case Studies