How to connect CMD Group to Microsoft Power Pivot

Discover how to connect CMD Group to Microsoft Power Pivot and how to integrate CMD Group with other data sources to build an organization-wide data model.

WITH DATA VIRTUALITY PIPES
Replicate CMD Group into a target storage and analyze it with Microsoft Power Pivot.
How to connect CMD Group to Microsoft Power Pivot with Pipes


About CMD Group

CMD Group, formerly Reed Construction Data and Construction Market Data, is a provider of business information for the North American construction industry. The CMD Group tracks data of different projects per year and provides monthly analysis and data for all aspects of the construction industry in Canada and the US. CMD also provides a detailed view of construction activity, including historical data, current-year projections and a five-year forecast. Their research helps customers to create forecasts and plan tactical marketing strategies.

About Microsoft Power Pivot

Power Pivot is a Microsoft Excel ad-in that transforms Excel into a Self-Service BI platform. Power Pivot extends the capabilities of Mirosoft Excel to import larger amounts of data from multiple sources into a single Excel workbook. Users can create more sophisticated data models and run more comprehensive analyses.

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to CMD Group, Microsoft Power Pivot and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.