Enterprise Business Intelligence Services

“Some of the new information available from analytics is so valuable – I’ve had a kind of an ‘ah ha’ moment on how have we been operating without this?”

Brooks Health

Our approach to Business Intelligence with Microsoft SQL Server and Azure Applications

The Aspect Business Intelligence Practice is a seasoned, proven group of consultants that specialize in delivering tier one solutions around the Microsoft SQL Server data platform. Established in 2004, the Practice built solutions with SQL 7.0/2000 and DTS. Today, the landscape has become much more diverse and challenging to navigate for customers. Having a trusted advisor like Aspect allows all involved parties to focus on the business problem, rather than the technical challenges.

Business Intelligence Services

Business Intelligence “Health Check”
Aspect performs meetings with BI leadership and reviews the current state of the BI solution. In typical engagements, this involves reviewing the ETL, data warehouse, and Analysis Services cubes for performance bottlenecks, security concerns, and performance/processing enhancements.

Business Intelligence Discovery and Planning Session
Aspect works with both IT and business leadership to create the vision and charter document for a new BI solution. This solution is aimed at primarily focusing on the business drivers of the solution and the mappings into the data that will become the functional specification document.

Business Intelligence Data Warehouse Solution
Aspect performs the build of the star-schema warehouse that contains the data. This solution could be as small as a data mart for a small functional area or encompass the entire organization as part of an enterprise data warehouse. The goal of this solution is to have proper conformed dimensions and corresponding measure groups that can be leveraged either by an OLAP cube, or by a Tabular data model.

Business Intelligence ETL Solution
Aspect builds ETL package to migrate data from platform-to-platform. Aspect uses the latest and most recommended practices for SQL Server Integration Services, making the best use of memory and disk I/O. Typically, customers engage Aspect for this solution for a) data warehouse building ETL; b) data cleansing; c) business process changes.

Business Intelligence Analysis Services Solution
Aspect conducts a full build out of Microsoft SQL Server Analysis Services cubes. This includes dimension, measures, calculated measures and named sets, KPIs, partitions, and security roles. This solution is often the capstone of completing ETL and data warehouse build outs.

Business Intelligence Reporting Services Solution
Aspect works with the client to scope and deliver a set of Microsoft SQL Server Reporting Services reports. This can be as simple as standard row/column based reporting, or as complex as onscreen workflow that really extends the functionality of the Reporting Services product.

PerformancePoint Dashboard / Excel Services / Power View Solutions
SharePoint is often the vehicle that data is presented from the Microsoft SQL Server platform. Aspect has solid expertise in building PerformancePoint dashboards to surface KPIs for executive drill-down. Excel Services are often leveraged for departmental reports and dashboards that need to be shared across functional groups. Power View is a new presentation-ready reporting solution that leverages both PowerPivot data and Microsoft SQL Server Analysis Services Tabular data.

Business Intelligence Microsoft SQL Server 2012 Analysis Services  
Microsoft SQL Server 2012 Analysis Services is offered in traditional OLAP, and the new powerful Tabular format.  The Tabular data solutions leverage relational data sources as inputs and allows for robust query writing via Excel-like DAX functions.  Aspect has deep experience in both the modeling and transforming of data and creation of data structures along with frontend measure creation.

Mentoring and Training Solution
Aspect works with the your IT team to solve specific Business Intelligence (BI) problems during a mentoring session. You identify a list of specific areas that are problematic for your staff. Aspect BI consultants are then brought in to work in tandem with your resources. The outcomes are a solution to a business challenge and over-the-shoulder training for your staff.