The Warehouse

BLOG & REsources

Sep
30
Easily Connect to Any API Source From Matillion ELT

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


Mar
15
Data Integration Roadmap Series - Part Two: Master Data Management

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


Jun
11
Pandata Group Snowflake Partner Announcement


temp-post-image



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

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


Jan
10
THE DATA INTEGRATION PORTFOLIO - PART 1: VIRTUALIZATION

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


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


Nov
07
PANDATA GROUP ANNOUNCES NEW OFFICE SPACE TO COMPLEMENT UNIQUE BUSINESS MODEL

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


Pandata GroupLess

Chicago

WeWork/ Fulton Market

220 N. Green Street

Second Floor

Chicago, IL 60607

Madison

316 W Washington Ave

Suite 525

Madison, Wisconsin 53703

Send Message