Operations

Healthcare IT News’ Erin McCann recently reported that Oregon Health & Science University had to again notify patients that their protected health information had been compromised.  From Erin’s post The Oregon Health & Science University has notified 3,044 patients that their protected health information has been compromised after several residents and physicians-in-training inappropriately used Google […]

One of my favorite new features in SharePoint 2013, and no doubt a favorite of our customers, is the drag and drop feature into document libraries. It alleviates the need for the multiple upload control that existed in SharePoint 2010 and reduces users reliance on the Windows Explorer option in a document library. In reality […]

In the past few years, the mobile market has grown significantly, and the use of mobile devices to access the Internet has skyrocketed. Research shows that by 2015, mobile device usage will surpass that of desktop computers being used to surf the web. Of course, when it comes to web design, coping with these rapid […]

Duplicate records are occasionally found in source data. Due to primary key constraints on a target database, only one version of a duplicate source record should be loaded into the target. The following methods demonstrate some of the most efficient ways to deal with duplicate source data. 1. Aggregator Transformation When to use Any time […]

Over the past few years, I have had the privilege of working with some of the world’s largest companies in a variety of industries. One thing in common with all of these engagements was using SQL Server Integration Services (SSIS) as the tool of migrating data for the companies’ business intelligence collateral. I have developed […]

So, have you heard about Power BI yet?  The whiz-bang new cloud-centric BI front end tool from Microsoft?  Well, this video from the 2013 WPC breaks down the story — in a very entertaining manner…  So, having watched, let’s assume we all remember Mariah’s chart-toppers and instead review the greatest hits of the Power BI […]

Healthcare providers are getting pretty good at creating budgets and comparing financial results vs. budgets but just how realistic are these budgets in the first place? Too often enterprise budgets are created with limited insight into the operational data needed to create an accurate picture of the business drivers that affect the financials.   This is […]

We recently had one of our long-time Perficient customers go-live with Microsoft Dynamics CRM 2011 Online (which is part of the Office 365 platform) with great success and ease. After utilizing SharePoint and Exchange online for years, they realized they had reach the limits of SharePoint in managing their day-to-day business and needed more in order […]

Unless you’ve been living under a rock for the last few years, you’re well aware by now that our healthcare system is drastically changing and that initiatives, like moving to across-the-board electronic medical records (EMRs), were pushed for years prior in the stimulus bill. It’s been well documented how much the US spends on healthcare: […]

What Is Data Governance? What is Data Governance? Sometimes it is easier to describe what something is by describing what it is not. This is the approach we will take when describing Data Governance. Data Governance is not: BI Governance because BI Governance deals with an organizations BI Architecture, standards and prioritization requirements. Internet Governance […]

In May of this year, I blogged about IBM’s then up-coming Digital Asset Management integration with MediaBeacon.  IBM  started shipping that product on June 18, 2013 via electronic distribution and July 12 via CD.  You can see the official announcement letter for details. Here is a demo of MediaBeacon working directly with IBM Web Content […]

Larry Bowden kicked off IBM’s webcast today about their new focus on Exceptional Digital Experiences.  In the past couple of years, IBM has introduced the Exceptional Customer Experience suite of products and the Exceptional Employee Experience suite.  These suites combine various IBM products such as WebSphere Portal, Connections, Sametime, etc into pre-configured suites focusing on […]