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
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