Find Jobs
Hire Freelancers

Data ETL - Tableau Optimisation

$15-25 AUD / hour

Stengt
Lagt ut over 6 år siden

$15-25 AUD / hour

We are a smallish bookkeeping /BI company that provides BI services to a number of small businesses in Australia. At the moment we export their information out of Xero, MYOB (accounting packages) into Excel and Access and from there we import it into Tableau for visualisation. We use an ODBC for Xero and other software for MYOB export. This system is slow and cumbersome and I believe there are faster and more effective ways of extracting and storing the data so tableau has easy access to the data. The data is only exported once a month and then visualised but I would like to create the infrastructure so that we could offer a live service. My current needs is for you to provide me with a solution on how this can best be achieved. Once we have determined the best structure I would like to implement it with your assistance and maintain it on a monthly basis. To summarise: 1. Propose the architecture / structure required to extract data from XERO/MYOB, store the data so that Tableau can have fast access to the data. 2. Implement above 3. Optimise existing Tableau dashboards 4. Maintain the system
Prosjekt-ID: 15172924

Om prosjektet

7 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
7 freelancers are bidding on average $24 AUD/time for this job
Brukeravatar
Hi, I'm a DWH/ETL/BI expert from Bulgaria (EU) with 8+ 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 PowerCenter. 2. Databases - MySQL, MSSQL, PostgreSQL, Oracle, Teradata and a few others. 3. BI - Pentaho BI, SSAS, SSRS, PowerBI, Cognos Also, my daily job routine requires very good scripting skills: Bash, Powershell, Python, as well as deep knowledge of SQL and database performance tuning and optimization. Best Regards
$25 AUD om 40 dager
4,4 (1 omtale)
3,8
3,8
Brukeravatar
Hello Sir- May I know if you are interested I PowerBI? I have extensively worked on it and can provide solutions using that. Tableau works fine too. Thanks Aanvik
$27 AUD om 20 dager
5,0 (1 omtale)
2,3
2,3
Brukeravatar
Hi. i don't know what is the backend database of these two apps. It would be perfect if it was a MSSLQL Server. In that case i would created a report database from which the Tableau would red the reports. If this is not a MSSQL Server and if the report data are less than 10GB i would setup a MSSQL Server express edition in which i would loaded the Report Data and then i would connected the Tableau with the DB. But if the report data are more than 10GB i will write a app in VB.Net and exported the report data in CSV Files and connect the Tableau with them. One question , how does your client access the Tableau Reports ?
$30 AUD om 10 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I have 4 years of experience in creating dashboards and visualisation in Tableau. I can help you on the tableau part of your project.
$15 AUD om 40 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

AUSTRALIAs flagg
Salamander Bay, Australia
0,0
0
Betalingsmetode bekreftet
Medlem siden jul. 9, 2017

Klientbekreftelse

Andre jobber fra denne klienten

Design a Logo
$150 AUD
Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.