PERSPECTIVES

BLOGS & NOTES

Aug
15
The Data Integration Portfolio - Part Three: Streaming Data

In previous installments of this series we examined recent trends in data integration, specifically data replication and synchronization, as well as data abstraction through virtualization. Taken individually, all of these approaches are suited for high data latency requirements around historical reporting and trending analysis. In this chapter, we look at real-time streaming data, and how it can complement high-latency data integration approaches to create a complete enterprise data foundation.

Streaming data delivery is often perceived to be the "holy grail" of data integration in that it provides users with immediate and actionable insight into current business operations. In reality, streaming has primarily been utilized in conjunc...


Jun
11
Feb
25
DATA INTEGRATION PORTFOLIO- PART TWO: REPLICATON

In our previous installment on the hybrid data integration portfolio, we looked at the role of data virtualization in a unified, multi-platform approach to creating a managed enterprise data foundation. In this chapter, we examine data replication and synchronization, i.e. the ongoing copying of data (without massaging or transformation) from one physical location to another, usually in conjunction with change data capture (CDC).

Data replication is often considered ETL without the "T", though where ETL is usually a batch-based delivery process, replication is often driven by "update-upon-change". Through this process, the target database only updates when changes occur to the source. Often referred to as "just-in-time" data, this repres...


Jan
18
ENTERPRISE DATA AND ANALYTICS (EDA) FOR HEALTH PLANS

What can EDA do?

EDA is the governed integration of disparate data collection applications, into a centralized “source of truth”, for enhancing business acumen to improve and optimize decisions and performance. EDA allows health plans to easily:

  • Analyze provider performance in order to optimize pay-for-performance

  • Evaluate treatment patterns across providers and better tailor care management program

  • Identify underlying opportunities for health education and intervention with high-risk members

Sustaining fixed EDA support and overhead costs can allow an organization to continue growth and improvement, thus providing an infinite return on investment (ROI).

Why do you need an EDA?

  • How are your patient outcomes improving?

  • Are you doing the same things but expecting different results?

  • Have your past investments become your “legacy” systems?

  • Are you experiencing rising costs, long revenue cycles, and bad debt?

  • Who are the health care provider/vendors that are performing well?

  • What lost economic opportunity (LEO) have you missed?

  • Are you maximizing your ROI?

If you answered yes to any of the above questions, then you need EDA to give you give the best assessment of you organization performance, so that you can make the best decision for your organization. Even the smallest improvement in everyday decision-making can improve corporate perfo...


Dec
28
FOUR ENGAGEMENT MODELS PANDATA GROUP OFFERS TO OUR CLIENTS

Pandata Group works with clients all over the Midwest who have begun the journey of being data-driven. These clients each have different needs, require different resources, and expect different levels of control and responsibility in their relationships with us.

To meet the requirements of each unique client, Pandata Group offers four distinct engagement models, which are frameworks that define collaboration between us and our clients for projects such as data mart implementation or BI application development. We call these engagement models Extended Team, Specialized Team, Managed Product and Managed Services. All four models ensure the right mix of expertise and transparency during the development process.

We will describe Extended...


Sep
15
TWO DV'S IN TANDEM: DATA VAULT AND DATA VIRTUALIZATION

Two DV's in Tandem: Data Vaults and Data Virtualization

There has been growing interest in data vaults as an architecture suited for the archiving and preservation of all enterprise-wide data. The normalized, "hub-and-link" structure is suited for parallel loading from multiple operational systems, and the philosophy of "all the data, all the time", regardless of quality, lends itself to the rapid population of the vault without cumbersome governance and oversight. However, the data vault is ill-suited as a source for reporting and analytic querying, since it separates keys from descriptive metadata, propagates many-to-many joins, and makes no distinction between high-quality and low-quality (or relevant and irrelevant) data. Companies...


Jun
22
YOUR GUIDE TO POWER BI PREMIUM

Who is Power BI premium meant for, does your organization need Power BI premium, and what are the benefits of Power BI premium compared to Power BI Pro?

First, let's cover what doesn't change with Power BI Premium, and the existing options for Power BI users. Power BI Pro Licenses are still $10 a month, and will meet the needs of about 99% of all organizations. Power BI Pro Licenses are necessary for users to share a dashboard and reports. So, if you have 5 business analysts creating Power BI reports and dashboards, and 5 C-level executives and managers who will also be consuming it, you'll need 10 Power BI Pro Licenses.

There are two different User Tiers:

temp-post-image

Feb
06
POWER BI TIP: DYNAMIC TOPN REPORTS IN POWER BI

There’s no doubt that PowerBI is a powerful reporting tool. The method below outlines a pattern that can be used to meet the needs of several end users. In order to create stunning Power BI reports that can allow a user to really dive into the data, you need to know DAX (Data Analysis Expressions.) The trick I’ll outline below is how to create a Dynamic TopN report using DAX, which will take your Power BI reports to the next level. It’s one thing to look at a KPI such as Sales company wide, but what if you want to identify the stores or items that are driving that KPI?

temp-post-image

Oct
10
MEET ALLEN POPPE, PRACTICE DIRECTOR - DIGITAL BUSINESS

Pandata Group is happy to announce that Allen Poppe has joined the company as Practice Director to lead the growth of our newly formed Digital Business practice. With his passion and forethought in technology along with his history working in multiple industries, he is a natural choice to head Pandata Group’s Digital Business practice and keep us at the forefront of thought leadership in the space.

We think you should get to know Allen and his role at Pandata Group. We’ve included a brief interview with Allen to highlight his goals, strategies, and the big picture perspective that he wants to deliver to local clients.

1.) What area of the Pandata Group will you be focusing on?

A. I am excited to join the Pandata Group and he...