Data to Decisions

Automation, Integration, Analytics, Reports & Dashboards

Import and Analyze MS Access Data Using Flow Analytics

Overview This blog post provides a worked example of how to import and analyze Microsoft Access Data

Overview

This blog post provides a worked example of how to import and analyze Microsoft Access Data. We learn how to use the Access Database integration interface to consume the sample Northwind database into Flow. A step-by-step walkthrough is provided which details how to denormalize the various relational tables into a consolidated flattened set for analysis. We learn how to apply generic expressions to compute new data points on the fly. Finally, we learn how to leverage Flow's multidimensional analysis engine to compute hypercubes and summarize the data.

How to Import and Analyze MS Access Data Using Flow Analytics

 

 

Comments are closed