Customers, Invoices, Expenses, DepositsĪfter getting these raw data tables, pipeline converts it into DataFrame, then writes/updates it into Airtable.It fetches all the below raw tables after making requests to QuickBooks API – Data Pipeline(QuickBooks to Airtable) – We have built a Data Pipeline in Python that uses quickbooks API( ) to get raw data tables from QuickBooks and uses Airtable API ( ) to write/update data in Airtable.Our SolutionĬollecting data tables from data sources : All visuals in dashboards should automatically update without any intervention to make it fully integrated. Then create useful visualisation and dashboards based on plan and feedback from the executive team. This Quickbook and Airtable real time data has to go to the powerBI service ( ). O Marketing Data Analytics Base (Google Ads, Facebook Ads) The following databases with multiple data table has to be fetched from Airtable – Airtable : An online database hybrid platform for creating and sharing relational databases with friendly user interfaces.The following data/tables has to be fetched from Quickbooks – QuickBooks : An accounting software that accepts real-time business payments, manage and pay bills, manage organisation’s deposits/expenses, customers ,and payroll functions.Project Descriptionįor building a fully integrated BI Platform, the data has to come from the following sources to feed it to PowerBI – Organization Size: 100+ Project Objectiveīuild a fully Integrated BI Platform in PowerBI using native connectors and APIs(QuickBooks and Airtable) to pull real time data from many sources. Services: e-commerce, retail business, marketing Client: A leading marketing firm in the USA
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |