Business Intelligence

Purchase Microsoft 365 and Cloud Management subscriptions for your business for the best in communication, collaboration and productivity
  • Details
  • Thorough assessment that starts with in-depth interviews with business stakeholders compile current strategic analysis needs by business component. Then an analysis of BI technical capabilities to fulfill the business requirements. The maturity Level deliverable will give an overview of current business and technical capabilities and recommendations.
  • Deliverable
  • BI Business Assessment and Guidance
  • Details
  • A one week engagement that analyzes the cross functional processes for impact on executive strategy from which KPIs and metrics to measure the organization's performance can be derived. Based upon requirements a horizontal or vertical analysis can be used to create a mock up of a potential balanced scorecard based on performance perspectives. 
  • Deliverable
  • BI Mapping of Strategic Processes and KPIs
  • Remote technical troubleshooting of technical architecture, RDBMS system, performance monitoring and security to include Kerberos and SSL configurations 
  • Immediate solution development assistance and coaching to overcome challenging requirements
  • Best practice sample development of TSQL, MDX, .NET, models, cube development, reporting templates 
  • Remote hosting and support of corporate data and dashboards
  • Details
  • One week project that focuses on the business intelligence stack from ETL to presentation layer. Analysis includes data cleansing,  governance, standards and best practices, dimensional modeling, semantic layer, OLAP storage, reporting architecture and security. At the end of the engagement recommendations will be made to help improve stability, performance and usability. 
  • Deliverable
  • BI Technical Assessment and Guidance
  • Integration Services and SQL ETL
  • Analysis Services tabular and dimensional OLAP development
  • PerformancePoint dashboards, SharePoint integration and development
  • Reporting Services development
  • PowerPivot, PowerView, Excel and SharePoint integration
  • Kimball dimensional modeling
  • Power BI training and development
  • Executive and Management - key BI concepts, what to expect, how to plan a robust BI initiative, align to organizational strategy and how to execute and support a BI initiativeL
  • Technical Managers - understand key components of architecture, interpreting requirements, providing short and long term value to the business.
  • Data Stewards and BI Developers - how to execute on key tasks and milestones for fulfilling BI vision