Through Interdent, we developed a complete Business Intelligence App with Textual and Visual Reporting.
InterDent was founded over 30 years ago by a group of dentists who realized that they could better focus on patient care if they retained business professionals to provide administrative and business support. Today, under the brands “Gentle Dental” and “SmileKeepers,” InterDent provides business services to approximately 200 practices in eight states including Arizona, California, Hawaii, Kansas, Nevada, Oklahoma, Oregon and Washington.
Interdent uses Legacy mainframe system in its clinics to manage electronic patient data, insurance processing and automate dental clinical management. Each day the data is synced back to the head office. They needed a reliable technology partner who can automate the reporting and the management doesn’t have to rely on the Excel sheets anymore. Classic Informatics took up the challenge and ensured the on time delivery of the application.
We helped develop a complete Business Intelligence app with textual & visual reporting which facilitates better decision making, improved business performance, at every level. Complex ETL processes were designed to build data warehouse. .NET, C# and Microsoft BI stack was used to develop and pull data from 20+ legacy systems providing real-time dashboards.
We came up with a phased approach which addressed immediate concerns as well as met long term requirements.
A dashboard application was developed which allowed key management personnel to view critical reports aiding budgetary decisions and performance evaluations quicker than before.
Remodeled and redesigned the ETL and database warehouse to improve data consistency and import times from the legacy applications.
Enhanced the Dashboard application with a series of textual and visual reports
After the implementation of three key phases, the users requested for new reports frequently as well as requested changes in some of the existing periods. Agile methodology was adapted to ensure that we respond to business needs as quickly as needed.
The dashboard was a result of several BI technologies working behind the scene. The source of data for the dashboard is a legacy mainframe system. Microsoft SQL Server 2008 Integration Services (SSIS) is used as an extract, transform, and load (ETL) tool, Microsoft SQL Server 2008 Analysis Services provides data mining functionality, and SQL Server 2008 Reporting Services provides report generation capabilities. There are many third party components which form part of the solution.
|Server||Windows 2008 Server, IIS 6.0|
|Core Technologies||Microsoft .Net 4.0, Entity Framework, LinQ|
|3rd Party||Telerik, Soft Artisans, ExperPDF|
|Database||ETL, Data Warehouse, SSIS, MS SQL 2008, SSRS 2008|
|IDE and SCM||Visual Studio TFS|
Today, Interdent has a complete Dashboard and Business Intelligence application which facilitates better decision making, improved business performance, access at every level and many more benefits.
Get your intranet application developed today! Talk to our healthcare application specialists or drop us a line.
After taking some time to understand each other’s working style, the teams have collaborated effectively, with Classic’s team producing excellent results.
Classic Informatics navigate offshore coordination problems skillfully and provide prompt responses. Customers can expect an experience strategic partner with valuable project insights.
Classic Informatics delivers solid code within tight deadlines. I’m impressed by their speed. They also offer affordable pricing and easy collaboration.
Through their high-level execution, flawless customer support, and responsive approach, Classic Informatics delivered a website that effectively generates income.
Their responsiveness complemented their project management style. Expect a team receptive to feedback and dedicated to fulfilling needs.