Data Integration and Analytics

The Data Integration and Analytics (DIA) team is about all things data. We are responsible for the identification, evaluation, and integration of all business data at UNC Kenan-Flagler. Our mission is to provide faculty and staff a single stop for insightful data, reporting and analytics to support their business needs.

Enterprise Data and Integration

Our team has built and are managing an enterprise data warehouse (EDW). This is a central data repository housing historical and current data in one system that can be used for reporting, data analytics, and business intelligence (BI). Using our ETL tool, we pull, cleanse, consolidate and store data from over 22 sources. Our EDW is the foundation upon which operational reporting, data visualization, AI and BI can now sit.

Data Visualization

We provide consultation and development support for your data visualization needs. Data visualization is the term used to describe all of the ways people transform data into visual representations. Patterns, trends and correlations that might go undetected in text-based data can be exposed and recognized easier with data visualization software.
Tableau is the visualization tool we have deployed for use at Kenan-Flagler. With interactive visualization, faculty and staff will be able to use Tableau to create dashboards and infographics. If you have Data Visualization needs or would like to explore the possibilities on new and advanced ways to visualize and dashboard your business data, please reach out to our team.

Open access to Tableau is not available at this time, but if you would like to request access, please follow the link below:

Data Analytics and Business Intelligence (BI)

Business Intelligence is a set of methodologies, processes, architectures and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical and operational insights and decision-making. By helping our staff apply BI to their dataset, our team hopes to offer new levels of insight around that dataset leading our programs in better decision-making. Stay tuned to exciting services soon to be released in this area.

Operational Reporting

Operational reporting is intended to support the day-to-day activities in the traditional reporting formats. The DIA team will to continue offering support of existing operational reports well as provide consultative services and guidance to stakeholders who have new or modified reporting needs.

Enterprise CRM Management

The DIA team, in collaboration with our program partners, is responsible for managing some of our core enterprise level CRMs. We assure production readiness, security and accessibility to these applications. We are happy to consult with key stakeholders of these systems to assist with dashboards, reporting, or other custom functionality your team. Examples of these tools are Salesforce, Slate, and 12Twenty.