Business Intelligence

Business Intelligence

Our focus is to provide Business Intelligence and Performance management solutions; as specialists in this area we have a proven methodology of implementing solutions so that you, the customer, can avoid trial and error implementations with costly consequences.

We also specialize in implementing solutions using Microsoft-based solutions such as Performance Point Server 2007, Microsoft Office Share Point Services 2007 (MOSS) and SQL 2005. The reason is to utilize your current investment in these technologies and reduce your total cost of ownership of solutions that are traditionally very costly to implement.

Custom Application Development and Integration

Companies generally have a mix of applications in their environment but have difficulty exchanging information between applications or integrating data for reporting requirements from various systems. We have proven experience in providing custom application integration solutions. Our well-qualified staff design and implement custom application integration solutions using Microsoft technologies.

Staff Augmentation

Technical Projects require staff with specific skills to contribute towards the success of the project. We provide companies with experienced developers, solution architects, database administrators, project managers and quality assurance associates.

Our Microsoft Business Intelligence Offerings

This is the area we focus on primarily in terms of our client offerings. We have skills in all areas of the Business Intelligence Solution Stack, Data Warehousing, ETL, Reporting, Analytics and Performance Management.

When implementing such a comprehensive solution it is best to have one software vendor facilitate complete integration of all areas of Business Intelligence. To that end Microsoft Business Intelligence provides the most time and cost effective software and development environment.

Microsoft Business Intelligence offers a complete and integrated software offering that supports the entire organization. It is a full-featured suite of server, client, and developer products that seamlessly integrate with each other.

This provides easy to use information directly where individuals work, collaborate, and make decisions.

With SQL Server 2005, Microsoft Office 2007 system, along with the capabilities found in Microsoft Office SharePoint Server 2007 and Performance Point Server 2007, Pivotal Solutions covers the spectrum of Data Warehousing, ETL, reporting analytics and performance management solutions. This provides a complete integrated, cost effective Business Intelligence solution stack.

SQL 2005 is an integrated platform with two working environments in SQL 2005, Business Intelligence Development Studio and SQL Server Management Studio. Business Intelligence Development Studio contains project templates to develop:

Data Warehousing

SQL Server 2005 is a scalable, reliable database capable of supporting multiple terabytes of data required for the implementation of large Data Warehousing applications. SQL 2005 provides features such as table partitioning, analytic functions, star join query optimizations. SQL 2005 also provides high availability with SQL Clustering which is now available in the standard version of the product. This reduces the cost of high-end database implementations.


SQL Server Integration Services (SSIS) is a world class ETL tool that is a true platform for data integration. SSIS is part of the SQL Server Business Intelligence (BI) platform, which enables the development of end-to-end BI applications.

SSIS supports not only the development of an ETL solution but an entire ETL framework supporting features such as logging, configuration management and notification. SSIS capabilities also extend into Analysis Services allowing the processing of cubes and reports from SSIS packages.


Microsoft SQL Server 2005 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multi-dimensional structures that contain data aggregated from other data sources such as relational databases. For data mining applications, Analysis Services lets you design, create, and visualize data mining models that are constructed from other data sources by a wide variety of industry-standard data mining algorithms. Analysis Services also makes Real-Time BI a reality with features such as Proactive Caching.

The Analysis Service offers a user-friendly model that enables you to understand business names and specify relationships between fields (Product Category – Product Subcategory – Product) so that it is possible for business users to design their own reports without help from IT.

Analysis Services offers tools for personalizing individual users’ reporting experience by only showing them the data that they care about and have permission to see; in addition, Analysis Services can translate data into users’ preferred languages.


SQL Server Reporting Services is natively integrated with .NET report services and is part of whole Microsoft BI solutions. It is designed to provide one of the most comprehensive BI and reporting solutions on the market today.

Reporting Services in SQL Server 2005 provides enterprise reporting capabilities and addresses a new audience of business users who want to interact with data in an ad hoc fashion as well as create their own reports from scratch and share them with others.

SQL Server 20005 Reporting Services has many improvements in the areas of report design, processing, and interactivity. There are also improvements to performance and scalability.

SSRS provides enhanced integration with other components within SQL Server 2005 including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Management Studio. Reporting Services also has tighter integration with Microsoft SharePoint Products and Technologies, enabling reports to easily participate in corporate portal scenarios.

Reporting Services provides unparalleled reporting integration into the Visual Studio development environment. In addition, freely redistributable Microsoft Windows and ASP.NET controls make it easy to embed reporting in both server-based and client-based applications.

SQL Server 2005 Reporting Services includes Report Builder, a new ad hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports without deep technical understanding of the underlying data sources.

Microsoft Office SharePoint Server 2007

Microsoft SharePoint Server 2007 delivers centralized access to information. SharePoint portal server makes it easy to create live, interactive business intelligence (BI) portals that assemble and display business-critical information from disparate sources, using integrated BI capabilities such as dashboards, Web Parts, scorecards, key performance indicators (KPIs), and business data connectivity technologies. Centralized Report Center sites give users a single place for locating the latest reports, spreadsheets, or KPIs.

Excel Services runs spreadsheets and performs calculations on a Web server, delivering results to users through a browser and to other applications through a Web services API.

Office 2007 (Excel 2007)

Excel 2007 provides great Analysis features and integrates with SSAS. With Pivot tables and visualization feature set, Excel 2007 is a great tool for Analysis.

Key Performance Indicators, calculations, conditional formatting and actions are just a few examples of business logic that you can define once in Analysis Services and then expose automatically in Excel Pivot Tables. Part of the beauty of this is that all users see the same thing in their Pivot Tables because the formatting, for example, is calculated in one place – on the server.

When analyzing data in Analysis Services, all the business logic is centrally managed in one analytical model so that every user will see the same numbers, calculated using the same business logic. Any changes made to the model will immediately be available to all Excel PivotTable users when they update their report.

Performance Point Server:
Microsoft Office Performance Point Server 2007 is a complete Performance Management (PM) application providing Score carding, Analytics and Planning for enterprise and mid-market customers. Office Performance Point Server 2007 enables businesses to improve their performance by providing all employees with the ability to measure manage and align their activities to company strategy using the familiar and easy-to-use Microsoft Office environment they already know and use every day.

Performance / Dashboards:
Business scorecard manager or BSM along with Office 2007, MOSS 2007, SSAS, SSIS and SSRS provides a complete, robust end-to-end BI development environment on Microsoft stack.

Deep Insight and Good Context

Collaborative Business Management and Action

End User Empowerment

Extensible Solution