The Warehouse

Pandata Group, a growing provider of cloud-native data and analytics services, has opened its newest office in Cincinnati, Ohio. The expansion is focused on helping regional clients fuel their digital transformation initiatives with exceptional consulting and professional services in data and analytics transformation.

Ohio’s business climate, industries, and geographic location are all viewed as an ideal fit for the Pandata Group story and it’s 3-year strategy to grow across the Great Lakes Region. “Pandata Group is a very special company. We’re highly focused on delivering best-in-class cloud technology to our customers, and on building a vibrant, client-centric cult...

If you are like many ETL developers you’ve struggled with an easy way to source cloud services data via REST API. Although standards are in place for REST API web services protocols, it seems that every vendor has their own variation of them, creating new challenges for each new source. Matillion’s cloud ELT product has long featured an API profile creator that sources from JSON files and creates RSD (Real Simple Discovery, an XML format) scripts for use with API query components. The effectiveness of this approach, however, is only as good as the quality of JSON files provided by the vendor.

Now, with version 1.47, Matillion introduces much more simplified functionality for extra...

When planning your integrated enterprise data environment, it is impossible to understate the importance of master data management. Much has been written about MDM, and it encompasses a broad range of (mostly non-technical) disciplines that are beyond the scope of a single blog entry. Here we will provide a broad overview of the four main areas of MDM to start your journey towards enterprise data governance. We will also examine the relationship between MDM and recent developments around other enterprise management programs such as Product Information Management.

What is master data management? Quite simply it is the administrative oversight of organizational “data as an asset” to...

Pandata Group's partners help us empower our clients and deliver value from data and analytics using the best technology for their particular business needs, which is why we're excited to announce we've added Snowflake to that list. After getting to know the Snowflake team and the ins and outs of their product, we see the immediate value Snowflake can bring to clients in search of a modern data warehousing solution.

Why Snowflake?

• A fully managed, born-in-the-cloud data warehouse that delivers power, flexibility, and simplicity.


• Hosted on Amazon Web Services (AWS), the platform is elastic as you need it to be. Start small and scale as you grow. Conversley you can scale back, on-the-fly, as ...

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...

The challenges facing organizations to integrate and make sense of the plethora of internal and external data continue to grow. Not only is there diversity in data sources, but the requirements from business units involve a mix of batch, real-time, on-demand and virtualized capabilities, often from the same source for different use cases. It is rare to find a "one-stop-shop" solution to these varied data integration needs, so organizations end up with a hodgepodge of redundant, overlapping products, or worse, rely on custom internal coding with no traceability or modularity.

In this series of blog posts, we will examine the "hybrid data integration portfolio" as a planned approach to handling...

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 dev...

Pandata Group is pleased to announce its Madison headquarters has moved to the 316 Building, downtown Madison’s bustling tech hub. The new office is located on the 5th floor and provides a sunlit view of the West Washington Avenue corridor.

Pandata Group built a custom office at a prime location in order to better collaborate with customers and technology partners such as SAP, Microsoft, and Denodo. The company is also opening the space to their clients in addition to their own team members.

“We’re extremely excited about hosting our clients and partners here in Madison!” said Jorel Digman, a managing partner at Pandata Group. He added, “The space is a great examp...