#PASSBAC – Ensuring Compliance of Patient Data with Big Data and BI

Over the past seven years, Ayad Shammout (@aashamout), Principal Business Intelligence Consultant at Beth Israel Deaconess Medical Center (a teaching hospital of Harvard Medical School), and I have worked on a variety of very exciting SQL Server projects including (but not limited to) Healthcare Group Upgrading to SQL Server 2008 to Better Protect 2 Terabytes of Data,  Healthcare Group Improves Availability and Security of Mission-Critical Databases, Healthcare Group to Enhance Information Access with Powerful Business Intelligence Tools, and SQL Server Reporting Services Disaster Recovery Case Study We’ve worked on some pretty hinke ones including the infamous PowerPivot for SharePoint / Windows Authenticated Users…

Rate this:

Power View Tip: Scatter Chart over Time on the X-Axis and Play Axis

As you have seen in many Power View demos, you can run the Scatter Chart over time by placing date/time onto the Play Axis.  This is pretty cool and it allows you to see trends over time on multiple dimensions.  But how about if you want to see time also on the x-axis? For example, let’s take the Hive Mobile Sample data as noted in my post: Connecting Power View to Hadoop on Azure.  As noted in Office 2013 Power View, Bing Maps, Hive, and Hadoop on Azure … oh my!, you can quickly create Power View reports right out…

Rate this:

Connecting Power View to Hadoop on Azure–An #awesomesauce way to view Big Data in the Cloud

The post Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud provided the step-by-step details on how to connect PowerPivot to your Hadoop on Azure cluster.   And while this is really powerful, one of the great features as part of SQL Server 2012 is Power View (formerly known as Project Crescent).  With Power ‘View, the SQL Server BI stack extends the concept of Self Service BI (PowerPivot) to Self service Reporting. Above is a screenshot of the Power View Mobile Hive Sample that is built on top of the PowerPivot workbook created in…

Rate this: