Microsoft

Subscribe via Email

Subscribe to RSS feed

Archives

Follow us on Twitter

Posts Tagged ‘SQL’

SharePoint & SQL Server Driving Solutions in Healthcare

by on March 30th, 2012

My colleague Azam Zaidi and I talked about Perficient’s Health BI solution that’s ONC Certified for Meaningful Use Stage 2 & ACO reporting with Microsoft’s Steve Aylward and EHR TV’s Ann Fishman at the HIMSS12 conference.  Health BI is built leveraging SharePoint and SQL Server.   We also discussed how we are seeing increased interest in SharePoint and SQL as lower TCO Solution components in the Healthcare space.

You can watch the video here.

 http://www.ehrtv.com/himss-2012-perficient-liza-sisler-azam-zaidi/

 

Perficient’s #HealthBI at #HIMSS12 in InformationWeek

by on February 24th, 2012

With the HIMSS Annual Conference wrapping up in Las Vegas there are a lot of sore feet and throats (from walking through clouds of smoke). The Perficient team was excited to be invited to demonstrate our ONC certified Meaningful Use Stage 2 and ACO reporting solution, Health BI, in the Microsoft booth.  There was great interest in Health BI throughout the conference, it seemed to resonate with people that because the solution is built leveraging Microsoft’s SQL Server & SharePoint products, it offers a lower TCO solution to Healthcare Providers trying to deliver Healthcare Analytics and reporting.

Perficient's Azam Zaidi demonstrating HealthBI at HIMSS12

InformationWeek’s  Paul Cerrato stopped by to see our Health BI demo and also mentioned us in his Healthcare IT goes StarTrek article for InformationWeek. Here’s what Paul had to say

” The HIMSS conference featured several other powerful clinical analytics programs. Perficient,for instance, which has built its HealthBI suite on Microsoft’s backbone, can handle the performance benchmarks needed to meet both Meaningful Use and Accountable Care Organization (ACO) rules.

HealthBI can generate disease registries for clinical reporting to public health agencies, do business reporting and financial management dashboards for reporting and improving key performance measures, and provide integration with leading financial & clinical applications. In fact, it contains the software tools to help providers meet all 33 quality measures required by Centers for Medicare and Medicaid Service’s final rules to qualify as an ACO.”

The conversations that I participated in on the exhibit floor at the HIMSS12 conference were very focused around Healthcare analytics and the drive towards Accountable Care Organizations. What were the topics that resonated with you at HIMSS12?

 

2012 Microsoft Self-Service BI

by on January 4th, 2012

Expanding on “Microsoft BI –No More Excuses”, I recently updated Denali SQL 2012 (Community Technology Preview CTP3) on my demo machine to work with Microsoft’s latest Self-Service BI (SSBI) tools. The result is a MS 2012 Denali SSBI demo and presentation available now from Perficient’s National MS BI team. Below are the highlights of the full blog post here, with specifics to be expanded in future blogs.

SQL 2012 Breaks SSBI Barriers

2012 MS SSBI has broadened all BI possibilities.  Denali (SQL 2012) breaks any remaining barriers for business and IT to coexist hand in hand for BI or SSBI solutions. It builds on existing BI stack strengths & embraces new territories:

  • SQL 2012 One BI Semantic Model: 2012 SSBI enables BI possibilities throughout your organization—from traditional BI content contribution accessing a variety of data sources easily, to extending BI visualization in support of business case analysis and strategy. Denali’s new semantic BI model allows a free-flow of BI development in all directions, from/to business or IT, and the new tabular model structures of SQL 2012 support a breakthrough for SSBI in 2012.
  • SQL 2012 SSBI is Enterprise-BI Capable. PowerPivot for SharePoint supports PowerPivot queries and the SharePoint component provides specific PowerPivot services, infrastructure, dashboards, web parts, content types, and library templates. SQL Server adds PowerPivot data processing to a SharePoint farm and SharePoint Central Administration provides service administration and oversight for PowerPivot processing in the farm, for IT-managed BI.
  • Power View Breakthrough Visualization: The new Power View visualization analysis reporting tool is a simple and effective mix of business-perspective functionality:
SQL 2012 Power View SSBI

Smart and powerful querying, with zero configuration for filteringPower View conveys business ideas supported by data analysis into a visual story that translates to strategic ideas and tactical decisions for opportunities, business decisions and transactions (revenues, cost-reductions or strategies).

SSBI is a serious catalyst for new organizational BI.

  • Through identification, self-analysis, self-reporting, and presenting BI-sourced data information, a business case often tells the story for decisions and actions. PowerPivot and Power View enable this process. Existing BI and reporting integrate seamlessly with new SQL 2012 Denali SSBI functionalities. Denali’s new semantic BI model allows a free-flow of BI development in all directions, from/to business or IT, and the new tabular model structures of SQL 2012 support a breakthrough for SSBI in 2012.

Strengths of SQL 2012 SSBI:

  • Faster to develop than traditional (multidimensional) BI
  • Less expensive to use in terms of time, resources and skill requirement
  • Great for prototypes on larger multidimensional solutions & reporting
  • Easier to update in terms of having the flexible data model (i.e. PowerPivot) with an application interface (i.e Excel Pivot table, Charts and visualization)
  • Ability for final logic customization via Excel or PowerPivot business logic
  • New interactive visualization with SQL 2012 new Power View analysis tool which operates off PowerPivot data (via SharePoint 2010, SSRS & Silverlight)

Next Steps:

  • Understand the varied benefits and options for SQL 2012 SSBI by getting in tune with SSBI from different role perspectives, including:
    • Businesses requiring robust POC solutions quickly and inexpensively
    • SharePoint Users who collaborate and report business information to analyze with colleagues
    • Database professionals and IT pros partnering with business, and providing monitoring, security and data management control
    • Excel users who analyze multidimensional data in workbooks and PivotTables, to create reporting, visual analysis & BI for business decisions
    • Business people who independently create custom-logic calculation models and are learning Microsoft PowerPivot for this purpose.
    • Anyone requiring a new standard for business case visual presentation with interactive data analysis using Power View.
  • Review the SQL 2012 SSBI possibilities, and then assess your next steps based on need. I am happy to demo SQL 2012 SSBI to provide details or continue your understanding and explore options. Contact me or any member of the Perficient National BI team for a SQL 2012 SSBI demo or other SQL 2012 Denali or BI solution information.