Business Intelligence

We happen to believe there is the ability to approach Business Intelligence more intelligently than most. We know this because we do it with every BI assignment we get.

Back to Our Work

our-approach  
Not surprisingly, when it comes to the actionable visualization of data, you have to see it to believe it. We invite you to explore some of the latest BI projects we’ve completed.

Here’s some notable BI examples

 
Adamas Pharmaceuticals
Adamas is a specialty pharmaceutical company driven to improve the lives of those affected by chronic disorders of the central nervous system (CNS). We achieve this by enhancing the pharmacokinetic profiles of approved drugs to create novel therapeutics for use alone and in fixed-dose combination products.
What we did:
  • Tableau 9.0 Setup
  • Tableau Environment Testing
  • Creation of Tableau reports
  • Creation of Excel Dashboards in conjunction with Power Query and Power Pivot
  • High Level Architecture of an MDM solution
  • High Level Architecture of a Clinical Trial Data warehouse




August Smart Locks
August designs smart home access products and services that are safer than traditional keys, make life easier, and put you in control of your front door from anywhere in the world. With August products, you can create virtual keys to your home and easily grant access to house cleaners, dog walkers, delivery services, guests, friends, and family—and control how long that access lasts—all from your smartphone. August products work together, integrate with other smart devices and services, and are designed to fit naturally and elegantly into the home.


What we did:
  • Data Warehouse Design and Architecture at August Smart Locks
  • Big Data Cloud Storage Evaluation with Amazon Redshift and Rackspace BigData
  • Technology evaluation for Segment and Looker


 
Stella & Dot
Stella & Dot is a modern home-based business that allows women everywhere to style their own career while they enjoy irresistible style for themselves.

stella-&-dot
What we did:
  • SQL Server 2012 Monitoring and Troubleshooting


 
Town of Danville
The Town of Danville is located in the San Ramon Valley in Contra Costa County, California. It is one of the incorporated municipalities in California that uses "town" in its name instead of "city". The population was 42,039 in 2010.

What we did:
  • SQL Server 2008 upgrade to SQL Server 2012
  • Enabling of the various services for SQL server 2012
  • Backup and Replication strategies
  • Best design practices for SQL server clustering to be implemented
  • Migration of artifacts from SQL Server 2008 R2 to SQL Server 2012
  • Windows Server Patch updates and SQL Server patch updates
  • SQL Server 2008 upgrade to SQL Server 2012


 
Golden Gate Bridge Highway and Transportation district
The Golden Gate Bridge, Highway and Transportation District is a special-purpose district that owns and operates three regional transportation assets in the San Francisco Bay Area: Golden Gate Bridge, Golden Gate Transit and Golden Gate Ferry.

What we did:
  • SQL Server 2008 R2 server setup
  • Enabling of the various services for SQL server 2008 R2 based on requirements gathered
  • Disaster Recovery strategy
  • Backup and Replication strategy
  • Best design practices for SQL server clustering to be implemented
  • Windows Server Patch updates and SQL Server patch updates
  • SQL Server Upgrade Recommendations if required


Let’s talk about { SharePoint Deployment Custom Application Development Business Intelligence Solutions IOT }

CONTACT US