Download all active companies house data API to power BI
- or -
Post a project like this680
£150(approx. $188)
- Posted:
- Proposals: 11
- Remote
- #3586489
- Awarded
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
Azure | PowerBI | SQL | SSIS | SSAS | Tableau | Javascript | Jquery | MVC .Net Core | EF Core | .Net Core API | ASP.Net |
Ranchi
Python, OpenAI, ChatGPT |Microsoft Fabric| Synapse| SQL Server, Snowflake ❄️, Postgres, MySQL| Power BI, Tableau, Domo | Azure, AWS, GCP| SSIS, Alteryx |AirFlow|AirByte|DBT| DevOps
Bay Minette
Data Analysis, Machine Learning, Deep Learning,OpneCV (Computer Vision), OCR, Automation, Data Processing & Conversion, Python Developer
New Delhi
1691021281422194671422748042767311325042752704885973964634423466048216864949
Description
Experience Level: Entry
This needs to be done, for a Flat fee of £150
I am looking for a power BI developer to download 600 records per query, from Companies House, ideally a function, including 20 different live API-Keys, thus allowing 1200 records in one Query, the results to be downloaded .
An Excel list of all active companies IDs in various tabs ., to use as a Lookup to enable power BI download
I want the Excel process to be easy , Excel has , its seems, a 1million + line limit in each a Excel tab, so multiple tabs grouping by different category maybe be needed, to get by Excel limitations.= ID groups etc
An Excel version of the power BI
The object of this project, is to have an Excel look Up of all active companies IDs , and use this to download Companies house data in power BI & Excel Data = ID Sic Codes company_name annual_return date_of_cessation undeliverable_registered_office_address registered_office_address.care_of registered_office_address.locality registered_office_address.address_line_1 registered_office_address.postal_code registered_office_address.address_line_2 registered_office_address.country registered_office_address.region accounts.next_made_up_to accounts.accounting_reference_date.day accounts.accounting_reference_date.month accounts.next_due accounts.next_accounts.period_end_on accounts.next_accounts.due_on accounts.next_accounts.overdue accounts.next_accounts.period_start_on accounts.last_accounts.period_end_on accounts.last_accounts.made_up_to accounts.last_accounts.period_start_on accounts.last_accounts.type accounts.overdue type last_full_members_list_date jurisdiction date_of_creation has_been_liquidated etag company_status has_insolvency_history has_charges confirmation_statement.next_due confirmation_statement.next_made_up_to confirmation_statement.last_made_up_to confirmation_statement.overdue registered_office_is_in_dispute has_super_secure_pscs can_file status Previous_Co_Names
I am looking for a power BI developer to download 600 records per query, from Companies House, ideally a function, including 20 different live API-Keys, thus allowing 1200 records in one Query, the results to be downloaded .
An Excel list of all active companies IDs in various tabs ., to use as a Lookup to enable power BI download
I want the Excel process to be easy , Excel has , its seems, a 1million + line limit in each a Excel tab, so multiple tabs grouping by different category maybe be needed, to get by Excel limitations.= ID groups etc
An Excel version of the power BI
The object of this project, is to have an Excel look Up of all active companies IDs , and use this to download Companies house data in power BI & Excel Data = ID Sic Codes company_name annual_return date_of_cessation undeliverable_registered_office_address registered_office_address.care_of registered_office_address.locality registered_office_address.address_line_1 registered_office_address.postal_code registered_office_address.address_line_2 registered_office_address.country registered_office_address.region accounts.next_made_up_to accounts.accounting_reference_date.day accounts.accounting_reference_date.month accounts.next_due accounts.next_accounts.period_end_on accounts.next_accounts.due_on accounts.next_accounts.overdue accounts.next_accounts.period_start_on accounts.last_accounts.period_end_on accounts.last_accounts.made_up_to accounts.last_accounts.period_start_on accounts.last_accounts.type accounts.overdue type last_full_members_list_date jurisdiction date_of_creation has_been_liquidated etag company_status has_insolvency_history has_charges confirmation_statement.next_due confirmation_statement.next_made_up_to confirmation_statement.last_made_up_to confirmation_statement.overdue registered_office_is_in_dispute has_super_secure_pscs can_file status Previous_Co_Names
AMA U.
100% (2)Projects Completed
5
Freelancers worked with
5
Projects awarded
63%
Last project
27 May 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies