Datplan DataPullDatplan
|
Microsoft Power QueryMicrosoft
|
|||||
Related Products
|
||||||
About
Datplan DataPull is a privacy-first Windows data integration and reporting application for accountants, finance teams and consultants. It connects to authorised QuickBooks Online, Xero, HubSpot and Companies House data, then downloads supported records into the user’s local Windows reporting environment. Datplan prepares structured fact-and-dimension tables, drag-and-drop dashboards, CSV and JSON exports, reconciliation information and BI setup files for Power BI, Excel, Tableau and Qlik. It supports full and incremental synchronisation plus scheduled refreshes on supported plans. Source datasets are stored locally rather than in a Datplan-operated cloud analytics warehouse. The Windows app is free to download with demo data; live-source connections use paid plans.
|
About
Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources. Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data. Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs—all with an easy to use, engaging, no-code experience. Power Query supports hundreds of data sources with built-in connectors, generic interfaces (such as REST APIs, ODBC, OLE, DB and OData) and the Power Query SDK to build your own connectors.
|
|||||
Platforms Supported
Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook
|
Platforms Supported
Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook
|
|||||
Audience
Accountants, bookkeepers, finance teams, financial analysts, reporting consultants, BI professionals and businesses that need a no-code way to extract, structure and reuse accounting or CRM data for dashboards, Excel, Power BI and recurring management reporting.
|
Audience
Businesses that need a data transformation and data preparation engine to improve their data analysis and decision-making
|
|||||
Support
Phone Support
24/7 Live Support
Online
|
Support
Phone Support
24/7 Live Support
Online
|
|||||
API
Offers API
|
API
Offers API
|
|||||
Screenshots and VideosNo images available
|
Screenshots and Videos |
|||||
Pricing
$7
Free Version
Free Trial
|
Pricing
No information available.
Free Version
Free Trial
|
|||||
Reviews/
|
Reviews/
|
|||||
Training
Documentation
Webinars
Live Online
In Person
|
Training
Documentation
Webinars
Live Online
In Person
|
|||||
Company InformationDatplan
Founded: 2017
www.datplan.com
|
Company InformationMicrosoft
Founded: 1975
United States
powerquery.microsoft.com/en-us/
|
|||||
Alternatives |
Alternatives |
|||||
|
|
|
|||||
|
|
||||||
|
|
||||||
|
|
|
|||||
Categories |
Categories |
|||||
Integrations
QuickBooks Online
Acterys
Amazon Redshift
Appfigures
Asana
Automation Anywhere
Azure Costs
Data Virtuality
Databricks
IBM Informix
|
Integrations
QuickBooks Online
Acterys
Amazon Redshift
Appfigures
Asana
Automation Anywhere
Azure Costs
Data Virtuality
Databricks
IBM Informix
|
|||||
|
|
|