Reporting Tool Migration to SQL Platform
SSRS-based Reporting Engine Development for Ease of use
Development of Ad-hoc Reporting Framework
-
Reporting Tool
Background Situation
A large ISV based out of North America was looking for migrating its reporting tool within its existing ERP product to a more user-friendly and latest technology.
Challenge
One of the biggest challenges in this was the proprietary technology used in building the ERP product. The technology was not compatible with SQL Server BI technology.
Moving to new technology also meant migrating existing 250+ reports.
Nitor Solution
First of all, Nitor team spent time in understanding the business process and how exactly the end users use the tool for creating new reports. Then the team chose to build the add-on tool using .NET 3.5. For migrating the existing reporting framework, the team decided to use SQL Platform because of its robust and scalable reporting solutions.
With the new technology, Nitor migrated all the existing reports (over 250) to the new platform and then managed the complete product for support and enhancement for extended time.
Technology and Tools
SQL Server 2005 .NET 3.5 SSRS (designers) SOA
Business Benefits
A more user-friendly reporting solution using the latest technology. With the smart composite solution offered by Nitor, the whole ERP solution need not be upgraded to new technology.
Tags
Reporting Tool
-
Report Development
Background Situation
A large IT services company based in bay area wanted to make it easy to create accurate reports for its large team of analysts working in Finance and Operations.
Challenge
This team used traditional Excel environment for reporting. This caused lot of manual work and scope for manual error. Because of the traditional environment, the team was unable to create multiple reports accurately in lesser time.
Nitor Solution
Nitor understood that the organization needs to have an automated way in which data can be gathered from multiple sources and presented to the analysts’ team so that they can generate quick reports.
Nitor used the complete SQL Server 2008 BI technology stack to create a Data Warehouse (Staging Database). It integrated data coming from multiple data bases (ERP, Accounts System) and designed over 100 reports using the SSRS technology. With access to more than 100 ready report formats and useful data, the analysts were able to produce highly useful reports very accurately and in much lesser time.
Technology and Tools
.NET 3.5 SSRS / SQL Server BI Technology SharePoint
Business Benefits
Higher productivity of analysts’ teams with lesser errors in report creation. Access to more information in user-friendly format enabled the management in taking informed decisions.
Tags
Report Development, Reporting
-
Ad-hoc Reporting
Background Situation
A North America based large ISV wanted to create a solution for end-users to help them create ad-hoc reports using multiple back-end databases.
Challenge
The company wanted to develop the solution as a product so it was looking for a development partner who not only understands Business Intelligence paradigm but also understands product development. The company was also specific on the use of Microsoft technologies.
Nitor Solution
With the product development expertise, Nitor helped the company right from product ideation, requirements planning, scalable and SOA based architecture development, development & coding, product testing and packaged deployment. The thorough understanding of Business Intelligence domain helped Nitor in coming up with a crisp definition for the product.
Technology and Tools
.NET 3.5 SQL Server BI Technology Install-shield for product packaging
Business Benefits
One-stop solution for all needs of product development – right from ideation to product packaging and deployment – this helped in faster go-to-market. User-friendly, robust and scalable robust reporting solution using latest Microsoft technology helped the end-users in faster analytic report design.
Tags
Ad-hoc Reporting, Report Development, Reporting