Ditutup

Data ETL Project for use in Datorama

Casita is a US-based technology consulting and web engineering company.

Our Client manages the ad-buying strategy for a large client using performance and spending data. Particularly:

* they compare weekly ad performance to the same week's performance the previous year

* they track channels that have aired an advertisement compared to performance

* they track actual advertisement spending versus planned spending

They receive this data from a variety of ad-serving platforms and it is currently processed through a variety of methods. ETL processes (primarily run through SSIS packages and stored procedures) generate tables which are viewable in Tableau.

Our client wants to take the same data and have it fed into a different application, Datorama ([login to view URL]), a cloud-based visualization platform. In Datorama, they want to create dashboards for the three data analyses listed above.

Datarama's pricing structure charges for numbers of rows of data and our client would like to limit costs. Also, our client has the strategic goal of not being tied to Datorama long-term. Therefore, the data warehousing and manipulation of data should be done outside of Datorama, using servers owned and maintained by our client.

We'll conduct the project one report at a time. For example, we'll start with the week-to-week comparison report. From accessing the various data streams, manipulating the data locally, serving it into Datorama, and building the dashboard in Datorama for that first report, we'll learn lessons that would ideally expedite and simplify the creation of the subsequent reports.

The successful Engineer will work with a team including a Project Manager, Systems Analyst, and Quality Assurance tester.

Kemahiran: Azure, Data Extraction, Penggudangan Data, SQL, SSIS (SQL Server Integration Services)

Lihat lagi: datorama salesforce, datorama certification, datorama tutorial, datorama query api, datorama demo, datorama wiki, datorama api documentation, datorama functions

Tentang Majikan:
( 0 ulasan ) Springboro, United States

ID Projek: #19574631

28 pekerja bebas membida secara purata $8149 untuk pekerjaan ini

ramzitra

Hi, I am interested in your project. The project is not clear for me, I need more details and specifications. Please send me a message so that we can discuss all the details. Thanks, Ramzi

$9000 USD dalam 60 hari
(181 Ulasan)
7.4
eclipsetechno

Hi, It seems it has to be created using .NET and SQL server to make compatible. Seeing the way you create development seems similar like us and we also work for a project with a team consisting of IT Analyst, project m Lagi

$18000 USD dalam 140 hari
(1 Ulasan)
4.5
ashupathania

We are a team of three persons and have expertise in sql,ssis,ssrs,tableau and Dataroma

$7000 USD dalam 60 hari
(23 Ulasan)
4.8
bmartynvw

Hi, My name is Benjamin. I'm an expert solution architect with over 14 years of experience. I have designed and built solutions that extract data from data warehouses, transform the data to summary data, and load i Lagi

$9000 USD dalam 30 hari
(8 Ulasan)
4.0
sreenivas2903

Hi. Iam expertise in sql server and reporting and extraction . I got ur point and i have a plan too .because in my organisation also we are mocking all data in warehouse and send just the repoting info to front end too Lagi

$7777 USD dalam 10 hari
(15 Ulasan)
4.3
julianbagilet

Hi there, We’re experts developers, having 10+ years experience developed 800+ websites/systems. Not only that, we’re also UI designers (FULL STACK). We have checked yours requirements and we’re available to work FAS Lagi

$8117 USD dalam 7 hari
(2 Ulasan)
3.6
tausy

Hi, I'm a data engineer with over 5 years of industry experience developing data-centric applications using a number of tools and technologies including ML, Big Data/Hadoop, BI, ETL, DWH, SQL, and PL/SQL. I am curre Lagi

$9000 USD dalam 30 hari
(3 Ulasan)
3.8
rubineverest

Hello, I’m Katserikov D, full Stack PHP Developer with a total experience of 12+ years . My extensive history on freelancer and reviews speak for the professionalism, high quality of work and reliability that I o Lagi

$8000 USD dalam 30 hari
(1 Ulasan)
3.1
solarsoftwares

Greetings! Glad to see your proposal for BI project as we have a strong experience on Creating dashboard on Various tools based on the Client metrics Our Experts have worked on Various tools, Data Visualization & Re Lagi

$10000 USD dalam 45 hari
(3 Ulasan)
3.9
abfreelancec

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.5 years experience in MS SQL Server and 6.8 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when Lagi

$8500 USD dalam 30 hari
(2 Ulasan)
2.3
arjun366333

Ready to start the work to work for you in Data ETL ,please check my recent similar work ,we can discuss more chat,thanks regards kanta singh.

$6111 USD dalam 30 hari
(1 Ulasan)
1.8
Scorpion09

Hi, Microsoft certified Datawarehouse Engineer will be glad to help you out here. I personally have ~5 years of experience in dealing with SSIS and data visulization using various tools including tableau. I have gone Lagi

$5555 USD dalam 21 hari
(2 Ulasan)
1.5
TakaAlex

Hi, there! Very interested on your project. Having rich experience on Big Data management, I can do the project with high quality on your requirements. When you give me the good opportunity to complete your project, Lagi

$8333 USD dalam 30 hari
(2 Ulasan)
1.6
avinpanwar300

Hello , Greetings !!! I just read your Project Description and i m willing to go ahead and start Development on this Project MSBI Project . I have done this kind of project recently i can give you this Project Lagi

$5555 USD dalam 30 hari
(2 Ulasan)
1.1
alexmares82

I have extensive experience working with big data and BI tools. Last project in this area implied integrating different data sources in [login to view URL], a very similar tool like Datorama. One other project implied cre Lagi

$9500 USD dalam 14 hari
(0 Ulasan)
0.0
emreela

I am a computer engineer and I have been working in the IT sector for over 8 years. I started in the field of software development. But then I specialized in database and business intelligence. I worked in different s Lagi

$7500 USD dalam 45 hari
(0 Ulasan)
0.0
rishabhmishra93

Hi, I am an ETL developer with wide experience in data extract and load. I have wide experience in handling very large varieties of source files which included web services, databases, excels and csv as well. we hav Lagi

$7777 USD dalam 7 hari
(0 Ulasan)
0.0
arkacol

Dear sir /madam With a Bachelor’s Degree and Master’s Degree in computer science, numerous years of hands-on experience creating and implementing software applications, and the ability to troubleshoot and solve problem Lagi

$8000 USD dalam 7 hari
(0 Ulasan)
0.0
sotnikovuri

@@@ No problem Please visit [login to view URL] in my profile As you can see my skill in this site I have deep experience of web development and high quality pixel-perfect design in more 7 years I read your descrip Lagi

$5555 USD dalam 30 hari
(0 Ulasan)
0.0
ideepeners

Hello Sir greetings from iDeepeners !!! We are in the top 1% freelancers on Freelancer platform.(Preferred Freelancer) We are an Indian, Next Generation Data Analytics and Dashboard Solutions providing team : iDeepen Lagi

$7500 USD dalam 30 hari
(1 Ulasan)
0.0