Archive for July, 2013

One web, under the internet, flexible enough to deliver content for us all. Sounds great, but in two years we’re all going to have the same site. One web. That’s where we live now. It’s obvious, but I can’t say I’m ecstatic about the design implications. On the one hand, for the vast majority of […]

I’m thrilled to share that for the third time in four years Perficient has been honored with Microsoft’s Health Provider Partner of the Year award.  I can’t tell you how honored we are that the Microsoft Healthcare team has chosen to recognize Perficient’s commitment and expertise in the Healthcare vertical year after year. From the […]

The healthcare IT field is rapidly developing and changing. Emerging technology and updated regulations put pressure on healthcare providers and health plans to stay ahead of the curve. Perficient creates a monthly list that explores some of the current topics and issues in health IT. This list examines the most talked about issues and technologies […]

Last time, we discussed arriving at a BI/DW solution for the problem of source application “Custom Fields.” This time, I want to look at the OLAP design, and the mechanisms that make it work in Analysis Services.  As you may recall, we were working on designing a multi-tenant SaaS analytics application. Our greatest problem was in […]

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 […]

We’re in for some interesting times ahead, as banks big and small start a delicate balancing act.  For banks, there are rewards and sparkling new opportunities beyond their own branches, apps, and channels to partner with other companies: additional customer engagement, value-add retail services, the possibility for increased customer retention and brand recognition.  Services such […]

With the July updates to Windows Azure, some great enhancements have been made to SQL Database. I already talked about one of the great features, “Automated SQL Export.” So now I’ll let you know about another great feature, “Premium Databases.” Since the “Premium” feature is a preview feature you will need to specifically sign up […]

Providers and payers need to exchange or source a lot of data, and the rate of this activity will only increase with implementation of Obamacare and other directives. Given the poor state of metadata management (which makes data sharing much more difficult), the decision to incorporate a new data set into an Enterprise Data Warehouse […]

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 […]

With the July updates/enhancements of Windows Azure some changes have been made to SQL Database. In this article I’m going to talk about Automated SQL Export. Previously you had to manually export your database for backup. Now you can automate the export/backup schedule. If you need a Windows Azure subscription here is the link for […]

In our new Perficient Perspective, “The Driving Force of Social Media in Healthcare,” Dr. Marcie Stoshak-Chavez discusses the increasingly social world of healthcare. In it, she discusses the value of connecting with patients online – but how do healthcare providers begin to establish this relationship? According to PwC’s Health Research Institute, early a third of […]

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 […]