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

Evner: API, Databaseudvikling, Power BI, Database Administration, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Hemel Hempstead, United Kingdom

Projekt ID: #27466979

34 freelancere byder i gennemsnit £27/timen for dette job


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 Flere

£35 GBP / time
(24 bedømmelser)
(69 bedømmelser)

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 Flere

£27 GBP / time
(141 bedømmelser)
(7 bedømmelser)
(21 bedømmelser)

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

£27 GBP / time
(14 bedømmelser)
(15 bedømmelser)

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 Flere

£27 GBP / time
(17 bedømmelser)

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

£27 GBP / time
(12 bedømmelser)

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 Flere

£27 GBP / time
(5 bedømmelser)

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 Flere

£21 GBP / time
(1 bedømmelse)

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 Flere

£18 GBP / time
(6 bedømmelser)

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 Flere

£28 GBP / time
(11 bedømmelser)

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 Flere

£24 GBP / time
(6 bedømmelser)
(6 bedømmelser)
(2 bedømmelser)

Hello, I am experienced in analyzing and visualizing Data using microsoft Powrer BI ( Dax , M. Power pivot, Power query). I can design the report layout, extract date using query, design date structure model with di Flere

£30 GBP / time
(1 bedømmelse)
(1 bedømmelse)

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 Flere

£40 GBP / time
(1 bedømmelse)

HI This is Sathya. Power Bi expert along with MSBI As well . Please reach out to me +91-9920278028 for further discussion

£27 GBP / time
(0 bedømmelser)