Build PowerBI data source from JSON API

$30-250 CAD

Lukket

Slået op

over 1 år siden

$30-250 CAD

Betales ved levering

I have a powerBI project with three different data sourcing and then i need to create a table containing all information merged by LINE CODE + PART NUMBER. First data source: FTP containing a CSV with LINE CODE AND PART NUMBER to display in table with some information Second data source: Copy /Paste table of equivalence for LINE CODE VS BRAND CODE Thirs data source: JSON API that will authentificate with an API key and will use second data source to make these query for all lines of first data source: { "getAutoCarePartApplications": { "brandCode": "VARIABLE BRAND CODE", "partNumber": "VARIABLE PART NUMBER", "vehicleTypeIds": [ 5, 6 ], "baseVehicleFacets": { "enabled": true } } } The response will look like this: { "total": 18376, "baseVehicles": { "total": 6857, "counts": [ { "count": 63, "baseVehicleId": 118751, "year": 2012, "makeId": 13, "makeName": "Subaru", "modelId": 62, "modelName": "Impreza", "vehicleTypeId": 5, "vehicleTypeName": "Car" }, { "count": 61, "baseVehicleId": 122437, "year": 2013, "makeId": 13, "makeName": "Subaru", "modelId": 62, "modelName": "Impreza", "vehicleTypeId": 5, "vehicleTypeName": "Car" }, { "count": 61, "baseVehicleId": 128524, "year": 2014, "makeId": 13, "makeName": "Subaru", "modelId": 62, "modelName": "Impreza", "vehicleTypeId": 5, "vehicleTypeName": "Car" Then i want it to display in a collumn on that format: Subaru Impreza 12-14, other vehicle year to year etc...

Power BI

JSON

API

Projekt-ID: 34351688

Om projektet

19 forslag

Projekt på afstand

Aktiv 2 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

19 freelancere byder i gennemsnit $205 CAD på dette job

@datascientist90

I'm a senior Python & ML developer and owner & founder of Dedeoglu Dev Company. Kindly send me a message to get in touch with me, Thanks, Yusuf.

$550 CAD på 6 dage

5,0

(1 bedømmelse)

4,3

@nixtech

Hello Sir I can make a call to API, fetch data and dislay in requested format in a table. I am willing to start right away Please check my profile for work and experience. Regards Hardeep

$160 CAD på 1 dag

5,0

(9 anmeldelser)

4,3

@anasdsoul08

Hello Sir, -- I am Anas, a data analytic with very good skills in data visualization including dashboard with both static and dynamic graphs in Power Bi, Excel and Google Data Studio. So I can achieve this task perfectly, So if you are interested in my offer, please feel free to contact me to discuss the details. I can help you , I am available and can start now Regards Anas

$245 CAD på 3 dage

5,0

(17 anmeldelser)

4,0

@RabbitFreelancer

Hello, I carefully read the job description and really got interested in this position. I'm interested in talking more about this position. Sincere regards.

$240 CAD på 7 dage

5,0

(1 bedømmelse)

4,0

@topgradeclubltd

Hi, Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert Dominic and i hope to cooperate with you on your project . CERTIFIED EXPERT IN LISTED PROJECT SKILLS & REQUIREMENTS, After KEENLY reading your description and being in possession of all CLEARLY STATED REQUIRED SKILLS (JSON, Power BI and API) as this is my area of PROFESSIONAL SPECIALISATION having the above QUALIFICATIONS, i hereby humbly request you to consider my bid for QUALITY and PROFESSIONAL work. ###// No timeline & Quality Excuses// Unlimited Revisions// 100% SATISFACTION GUARANTEED### Message Me We Discuss More About The Project. incase the project is deleted please hire me directly using the following link; https://www.freelancer.com/u/topgradeclubltd THANK-YOU & WELCOME.

$250 CAD på 5 dage

0,0

(0 anmeldelser)

0,0

@achillesitachi

Hi, I have understood a part of the requirement and assume it's not just powerquery that you need help but also in building the dashboard as well. I will be able to work on this project in the next 3 days and would like to understand your requirements in detail such as user story and data source details.

$140 CAD på 3 dage

0,0

(0 anmeldelser)

0,0

@teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa

$180 CAD på 2 dage

0,0

(0 anmeldelser)

0,0

@minatharwat46

I'm excited to work with you This is a very common request. I can automate this for you now. I've done this hundreds of times.

$80 CAD på 1 dag

0,0

(0 anmeldelser)

0,0

@ujjwal1996

Hi, I have read the project requirement and understand that I will have to create a table containing all information which is to be merged by line code and part numbers from 3 different data sources. I have been working on Power BI since the past 5+ years and can help you with the work and deliver quality work within 2-3 days. Looking forward to work on long-term basis, let's discuss further over chat. Thanks!

$225 CAD på 1 dag

0,0

(0 anmeldelser)

0,0

@ep01teccod

We are experts for more than 7 years in the field of business intelligence. Our team is a winner of InterSystems Grand Prix 2022 with our application of Water Conditions in Europe. We work with different platforms to create analytical graphs, BI dashboards and tableau We have clients in different fields, such as financing, banking, healthcare, education, as our apps can fit into any kind of business.

$250 CAD på 7 dage