Closed

Long Term Power BI data analysist with API and data transformation experience

We are a 6 month start up now doing 150K per month. I am the CEO and love technology to drive the business. I now wish to bring the various data sources together and begin to build out a very comprehensive set of dashboards in Microsoft Power BI.

Account: XERO API and or app

Warehose DespatchCloud Open API with documentation

Resource management data - CSV updates

Google Analytics

Privy / Mailchimp API or CSV

Other Google Sheets and Excel files

I will need to someone to be our data analysis/ lead with REAL experience so they can help challenge and shape our objectives.

Must have experience in using APIs to obtain data

Must have experinece in building pretty dashboards :)

Must have experience in transforming data, including scripting and bulding databases to store the data - google or aws or azure

Must be available for multiple points during a working day (UK time)

Must be available for an extended period of time as this is a 6-9 month piece of work (not quite fulltime though)

Must be available to start immediately / almost immediately

We have only just signed up for BI so we have a blank canvas with lots of data we want to turn into insights ;)

The company is SELF FUNDED by me, so I don't have a large hourly budget. I'm looking for someone that would appreciate a commitment to a longer period of work. Part of the team :) I wish I cold pay a million pounds for the best in the market but we are a start up currently not turning a great profit - who knows w

Insights I would like

Exec Summary - High level figures, Sales, Costs, customer base, sign up base, Av order value

Production - Number of orders procecssed per day, average orders processed per hour compared to other days, number of units shipped, number of orders by sales channel

Finance - We can begin to bring in Financial dashboards currently available in Xero

Markting - New customers sign ups, imporessions per month on web site, abandonded carts

The first stages would be to help get the data from its various sources and set some form of automation to obtain updates tot eh date on a daily / hourly basis.

The next would be to offer some basic proof that the data collected can be presented in a professional format and visualisation

The next stage would be to build out a growing list of report requirements that you can build on and work with us so we can supply the data sources in a format you can transform and display.

During any of these stages it would be necessary for you to lead the API Get ata requests. Build the database on Google or AWS. Build scripts to transform the data so it can be easily displayed and manipulated.

In terms of key objectives I would like to start with seeing how many orders we are processing in the warehouse and filter by type

Thank you

Andy CEO

Skills: API, Database Development, Power BI, Database Administration, Software Architecture

See more: long term experience service industry taught meet exceed, looking for a bi lingual english hungarian speaker for long term freelance cooperation with the newsletters department of pmr, power bi rest api authentication, power bi freelance projects, power bi consulting rates, upwork power bi, power bi part time work, power bi developer, power bi consultant, power bi certification, power bi jobs, power bi rest api c#, power bi rest api data source, power bi rest api example, power bi api v2, power bi embedded api, power bi rest api limitations, power bi rest api examples, power bi weather api, power bi push api

About the Employer:
( 0 reviews ) Hemel Hempstead, United Kingdom

Project ID: #27466979

36 freelancers are bidding on average £27/hour for this job

Vlzinch

Hi, Andy! I'm a Data Engineer with considerable experience in data analysis and data visualization (as a key a part of any analytics) for the last decade that allows me to turn massive amounts of data into actionable i More

£35 GBP / hour
(24 Reviews)
7.7
(69 Reviews)
7.1
DebasisB

Hello there, I am interested in the project. I have over 12 years expertise in data Analysis, design, implementation, administration of business intelligence, OLAP, ETL, data warehousing, data mining, DBMS and data M More

£27 GBP / hour
(140 Reviews)
6.9
(20 Reviews)
5.3
(6 Reviews)
5.2
(15 Reviews)
5.1
Xichiza

Hi, I am a senior Data Analyst with over 5 years experience with Power BI and I can help you to build your Power BI Project. I am a Microsoft Certified: Data Analyst Associate : [login to view URL] More

£27 GBP / hour
(14 Reviews)
5.1
jayprihar69

Experienced Power BI Developer with DAX and SQL skills | Available to start | Excellent in communication| Strong analytical skills | Having the relevant technology experience I am interested in working with you on th More

£27 GBP / hour
(5 Reviews)
5.0
aimefx

Hi, I am an expert in Power BI and I am interested to work on your project. Please check my profile and feedbacks for the past project, I am ready to start your project immediately, please send me a message to discuss More

£27 GBP / hour
(16 Reviews)
4.9
akhileshgandhi

Hello, # Power BI data analysist with API and data transformation experience# Have worked on various project, also can show some demo & work sample on chat. [login to view URL] More

£27 GBP / hour
(12 Reviews)
5.4
bdrudra

Hello there, Hope you are doing great. We check your requirement and we can do this task. We are a small but excellent team of SharePoint, PowerApps, PowerBI(Tableau) & .NET developers and designers. We have 7+ year More

£21 GBP / hour
(1 Review)
4.6
(6 Reviews)
3.5
jayantavkumar

Proposal - At the current stage of your requirement, you need to move into MSBI (business intelligence) which will help you to move different source of information into one repository and from there you can generate ma More

£28 GBP / hour
(11 Reviews)
3.7
dataguru2110

Hi I have 10 years of experience in Data Analysis, Data warehousing ,Business Intelligence and certified Power BI Expert. I have built so many Power BI reports and have experience in building report using different da More

£18 GBP / hour
(5 Reviews)
3.7
huseyinaygun

Hi Andy, I have business intelligence reporting experience of 8 years. I developed BI reports and dashboards in Power BI, Tableau, Cognos and Oracle BI. Lately I prepared a POC in Power BI and in Tableau getting the More

£24 GBP / hour
(6 Reviews)
3.3
(2 Reviews)
2.1
tora987

hello. I hope to get your offer chance for your great project as a senior expert here. I am sure I can help your business perfectly in your requirement. I would love to discuss more about your project detail. Thank you More

£20 GBP / hour
(1 Review)
2.2
(1 Review)
1.4
BMMM

Hello. I read your description carefully to the end. I can help your business perfectly as your requriement. I would love to discuss more about your project. Hope a good response soon. Thank you!

£23 GBP / hour
(1 Review)
1.1
veskojl

Hi, I'm a BI/DWH/ETL expert with 12+ years of experience in that field. I'm proficient in wide variety of data tools: 1.ETL-SSIS, Pentaho Kettle, Talend, Oracle Data Integrator (ODI), Informatica. 2.Databases-MySQL More

£40 GBP / hour
(1 Review)
0.4