Find Jobs
Hire Freelancers

Large Dataware Housing Project Datasets(Mock), FRS, and some use cases

$30-250 USD

Closed
Posted over 6 years ago

$30-250 USD

Paid on delivery
Looking for a large relational dataset which can be one of those open datasets but want them to be relational data model so the tables are connected either normalized or denormalized. We need some FRS, and use cases that can be derived out of these datasets, something like ETL, and BI reporting. Requirement: Industries preferred : (Aviation, Retail & Healthcare) [Exception: Northwind / Sakila / AdventureWorks ] 3 - Large Fact Tables (Tables should be partitioned by Date Fields) 5 to 10 - Dimension Tables FRS - End to End data flow with any transformation requirements and use cases (I know need those use cases for cleansing, and transforming those datasets, not looking for any codes. Overall, looking for a FRS / BRD document) Reporting - What are some useful insights that can be derived from the data. Like joins, aggregation, staging tables etc Data Authenticity - Can be completely mock data, but appreciate if it can be meaningful data such that any correlations makes sense. Size - 5-10 Gigs of Data when uncompressed. Overall, the requirement is to build sample practice projects to provide an understanding of how end to end ETL works. From ingesting data to Reporting.
Project ID: 15850120

About the project

5 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $336 USD for this job
User Avatar
We use our expertise in data warehousing and relational database management to deliver you project on time. Relevant Skills and Experience Data warehouse, ETL processes, Database management Data mart, OLAP, Conceptual modeling, Data Analytics, Data Cleansing, Data Extraction, Data Processing, Data Warehousing Proposed Milestones $250 USD - Deliver the project Additional Services Offered $200 USD - ETL processes, Database management Data mart, OLAP, Conceptual modeling,
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I need wpork
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello and G'Day I am Sudhir Kumar Chauhan and I'm post graduate in computer science & engineering with around 13 years of experience in Oracle & SQL server DWH with BFSI domain. Relevant Skills and Experience I hav very strong experience in data modeling for DWH using star and snow flake schema. I can send you across my update CV for my skill plz contact me at 91 9654117422
$277 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Dec 11, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.