Data Warehousing Jobs and Contests

.
Sign up and start earning
Sign up to start earning. Are you A Data Warehouse Expert ? You could be earning money working on these jobs!

Browse Jobs on Freelancer

Project/Contest Description Bids/Entries Skills Started Ends Price (USD)
Get Data Entry Done - 25/07/2017 22:46 EDT Wentworth Institute of Technology- Graduate Certificate Program Project - Statistical Application of Data: USA Sep 2014 – April 2015 Started with Massachusetts School Students Test Score Dataset containing 200+ observation and 16 predictor variables. End goal of the project is to help students get better score by analysing factors like teacher’s performance, parent’s occupation, student to teacher ratio and more. To achieve that I cleaned the data and selected 5 predictor variables and generated correlation matrix for data. Further created scatterplot, Histogram, Regression, Models, and 3D Scatterplots using MS Excel and R Studio. Project - Hospital Data Management: Created business rules, data models, ERDs, EERD using gliffy (online tool) for Mountain View Community Hospital. Designed database and normalization of data using SQL. Banasthali University – [url removed, login to view] Project - Rajasthan Heritage Trip: India Sept 2011 – Dec 2011 Designed a website using [url removed, login to view], C# and SQL database offering online travel plans and tour services to customers who wish to go for a trip across Rajasthan offers two kinds of services: (a) Regular Tour and (b) Customized Tour. Regular Tour provides standardized tour packages with day and city-wise schedule displayed as output depending upon the type of trip and range of budget as selected by the customer. Customized Tour offers flexibility to customers by allowing them to select number of days, budget and cities; the tour is planned based on customer’s inputs with daily schedule displayed as output. WORK EXPERIENCE e-Inqwest PLC Intern (Software Engineer) India June 2012 – April 2013 Gesture Based Clinic Appointment System: Developed an interface for patients to take appointment number in a new way (using hand gestures). Used Microsoft Visual Studio 2010 Express for writing, testing and debugging code. Application for Windows 8 Operating System – “Todlearn”: Learning application for kids providing information about animals, birds, fruits etc. basically transforming the text learning to more interactive and responsive. Used Visual Studio, HTML5 and CSS for building the application. Android Application Development: Design and developed a mobile application called ‘Funny Jungle’ using MIT AppInventor for Android platform. End to end testing and debugging of application on physical mobile devices and emulator. Researching and editing media (audio and pictures) meeting industry standards (.png, .wav) and device specification. Researched different patterns and combination of voice and images to provide enhanced user experience and learning. KarROX Limited Intern (Software Engineer) India June 2010 – Dec 2010 eCommerce Webstore Development: Designed a fully-featured and functional webstore for online shopping. Key design features include management of customer accounts, store inventory, shopping cart, customer registration, login information and order status. Designed in [url removed, login to view] using C# and SQL database. 12 SQL, Database Administration, Database Programming, Data Warehousing Jul 25, 2017 Today6d 16h $570
Get Data Entry Done Wentworth Institute of Technology- Graduate Certificate Program Project - Statistical Application of Data: USA Sep 2014 – April 2015 Started with Massachusetts School Students Test Score Dataset containing 200+ observation and 16 predictor variables. End goal of the project is to help students get better score by analysing factors like teacher’s performance, parent’s occupation, student to teacher ratio and more. To achieve that I cleaned the data and selected 5 predictor variables and generated correlation matrix for data. Further created scatterplot, Histogram, Regression, Models, and 3D Scatterplots using MS Excel and R Studio. Project - Hospital Data Management: Created business rules, data models, ERDs, EERD using gliffy (online tool) for Mountain View Community Hospital. Designed database and normalization of data using SQL. Banasthali University – [url removed, login to view] Project - Rajasthan Heritage Trip: India Sept 2011 – Dec 2011 Designed a website using [url removed, login to view], C# and SQL database offering online travel plans and tour services to customers who wish to go for a trip across Rajasthan offers two kinds of services: (a) Regular Tour and (b) Customized Tour. Regular Tour provides standardized tour packages with day and city-wise schedule displayed as output depending upon the type of trip and range of budget as selected by the customer. Customized Tour offers flexibility to customers by allowing them to select number of days, budget and cities; the tour is planned based on customer’s inputs with daily schedule displayed as output. WORK EXPERIENCE e-Inqwest PLC Intern (Software Engineer) India June 2012 – April 2013 Gesture Based Clinic Appointment System: Developed an interface for patients to take appointment number in a new way (using hand gestures). Used Microsoft Visual Studio 2010 Express for writing, testing and debugging code. Application for Windows 8 Operating System – “Todlearn”: Learning application for kids providing information about animals, birds, fruits etc. basically transforming the text learning to more interactive and responsive. Used Visual Studio, HTML5 and CSS for building the application. Android Application Development: Design and developed a mobile application called ‘Funny Jungle’ using MIT AppInventor for Android platform. End to end testing and debugging of application on physical mobile devices and emulator. Researching and editing media (audio and pictures) meeting industry standards (.png, .wav) and device specification. Researched different patterns and combination of voice and images to provide enhanced user experience and learning. KarROX Limited Intern (Software Engineer) India June 2010 – Dec 2010 eCommerce Webstore Development: Designed a fully-featured and functional webstore for online shopping. Key design features include management of customer accounts, store inventory, shopping cart, customer registration, login information and order status. Designed in [url removed, login to view] using C# and SQL database 24 Data Entry, SQL, Database Administration, Database Programming, Data Warehousing Jul 25, 2017 Today6d 15h $369
Help me write something (paraphrasing) -- 2 Writing a literature review article Data warehouse literature review I have articles about data warehouse in health care systems I pick the main points that I would like to highlight in the literature review In other words, quotes The requirement of this task is to paraphrase with no plagiarism and write them in a form of literature review Use the same references that I pick the quotes from and you can add more articles if you need but ask me before It has to be included with proper introduction and conclusion 31 Research Writing, Health, Database Programming, Database Development, Data Warehousing Jul 23, 2017 Jul 23, 20174d 2h $120
Write some Software Hello, We are looking for experts who can build business intelligence on top of data and provide real time web-based dashboards to end user for slicing and dicing of data. Regards 9 Report Writing, Data Warehousing, Business Intelligence Jul 22, 2017 Jul 22, 20172d 23h $320
Snowplow analytics software installation Looking for someone with experience installing Snowplow analytics software. You will install Snowplow Software in an AWS enviroment and you'll: 1. Setup a Snowplow Collector 2. Setup a Snowplow Tracker and/or Setup a Third-Party Webhook 3. Setup Enrich 4. Setup alternative data stores (e.g. Redshift, PostgreSQL) 5. Set up Data modeling in Redshift or database selected and set up on point 4 6. Set up environment in order we can Analyze our data! We have some things installed and set up (Vagrant, Virtual environment, Snowplow, Snowplow collector and Snowplow trackers) you can start from this point in this case you'll start in point 3 or maybe it's needed to be installed from the beginning. 7 Amazon Web Services, Data Warehousing Jul 19, 2017 Jul 19, 20174h 14m $521
Zoho, Syncfusion or Spago BI: Open Source Business Intelligence Reporting Portal For Restaurants Hello - I am looking at utilizing Zoho, Syncfusion or Spago BI: Open Source Business Intelligence Reporting Portal For Restaurants or some other open source BI tool to create a reporting/analytics/dashboard engine for my restaurants. Main features: - 10 - 15 dashboards: sales, ops, financials, top/bottom 5, - Multiple reports: capturing data from multiple sites - mobile/tablet accessible: HTML 5 - alerts - data in the cloud My anticipation is approximately 20-30 hours of work to get this going. Can provide more details and requirements in future. We are also looking for someone to update/add reports as needed - 11 Cloud Computing, Data Warehousing, Business Intelligence Jul 17, 2017 Jul 17, 2017Ended $31
to convert database into excel -- 2 Use the data tranformation studio to convert the database into an excel 43 XML, Excel, Software Architecture, Database Development, Data Warehousing Jul 15, 2017 Jul 15, 2017Ended $54
Data Entry We need a data entry person that will be getting the data from a website that we will assign and entering in to a wordpress sites, we will explain the process (very simple to do) 6 Virtual Assistant, HTML, Copy Typing, Data Warehousing Jul 15, 2017 Jul 15, 2017Ended $3266
to convert database into excel Use the data tranformation studio to convert the database into an excel 37 XML, Excel, Software Architecture, Database Development, Data Warehousing Jul 14, 2017 Jul 14, 2017Ended $44
Write some Software convert the database into excel -- 4 I need some help in my project freelancer must familer with B2B Data tranformation studio 11 XML, Excel, Software Architecture, Database Development, Data Warehousing Jul 14, 2017 Jul 14, 2017Ended $49
Data Entry We need a data entry person that will be getting the data from a website that we will assign and entering in to a wordpress sites, we will explain the process (very simple to do) 5 Virtual Assistant, Copy Typing, Data Warehousing Jul 14, 2017 Jul 14, 2017Ended $3493
Write some Software convert the database into excel -- 3 I need some help in my project freelancer must familer with Data tranformation studio 8 XML, Excel, Software Architecture, Database Development, Data Warehousing Jul 14, 2017 Jul 14, 2017Ended $66
SOA built Build an SOA template 6 Oracle, Microsoft SQL Server, Data Warehousing, ITIL Jul 12, 2017 Jul 12, 2017Ended $393
E-commerce Automation. -- 3 Hello, Let me introduce my problem towards you people. We are running our e-commerce business on different channels as well as we are about to start our own e-commerce business. We are right now doing business in books category. Process we need to automate is Product pricing calculation and stock feed generation for different platforms and , Procurement, Dispatch. Whole process need to be automated so that the manpower cost can be reduced 6 Data Processing, Pentaho, SAS, Big Data, Data Warehousing Jul 11, 2017 Jul 11, 2017Ended $438
list of hotels and cities of the world i need a list of all hotels with cities and countries of the world, it shouldn't be 100% updated so few errors are accepted, it should show the hotel stars rating and the country all in excel table 65 Data Processing, Database Administration, Big Data, Database Development, Data Warehousing Jul 11, 2017 Jul 11, 2017Ended $124
power BI developer Power BI Dashboards Development 19 SAP, Software Development, Microsoft SQL Server, Data Warehousing Jul 10, 2017 Jul 10, 2017Ended $395
Data wrangling project Requirment : Choose any area of the world from [url removed, login to view], and download a XML OSM dataset. The dataset should be at least 50MB in size (uncompressed). We recommend using one of following methods of downloading a dataset: Download a preselected metro area from Map Zen. Use the Overpass API to download a custom square area. Explanation of the syntax can found in the wiki. In general you will want to use the following query:(node(minimum_latitude, minimum_longitude, maximum_latitude, maximum_longitude);<;);out meta; e.g. (node([url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]);<;);out meta; the meta option is included so the elements contain timestamp and user information. You can use the Open Street Map Export Tool to find the coordinates of your bounding box. Note: You will not be able to use the Export Tool to actually download the data, the area required for this project is too large. Step Four - Process your Dataset It is recommended that you start with the problem sets in your chosen course and modify them to suit your chosen data set. As you unravel the data, take note of problems encountered along the way as well as issues with the dataset. You are going to need these when you write your project report. SQL Thoroughly audit and clean your dataset, converting it from XML to CSV format. Then import the cleaned .csv files into a SQL database using this schema or a custom schema of your choice. MongoDB Thoroughly audit and clean your dataset, converting it from XML to JSON format. Then import the cleaned .json file into a MongoDB database. Hints and Tips Feel free to adapt the code from the Case Study lesson to help you approach the auditing of your data. It will help your organization by creating a new script for each aspect of your dataset that you audit. Each field that you audit should also include a function that will help you update your dataset. You may want to start out by looking at a smaller sample of your region first when auditing it to make it easier to iterate on your investigation. See code in the notes below for how to do this. You can use a small (1-10MB) sample to make sure that your code works, and then an intermediate sample to check for the most common problems to clean. Remember to perform data cleaning when you convert the XML into CSV or JSON format. You won't change the original data file, only the data that you plan on inserting into your database. This is where your earlier organization will pay off, since you can just import the update functions from your auditing scripts into the cleaning and conversion script. Step Five - Explore your Database After building your local database you’ll explore your data by running queries. Make sure to document these queries and their results in the submission document described below. See the Project Rubric for more information about query expectations. Step Six - Document your Work Create a document (pdf, html) that directly addresses the following sections from the Project Rubric. Problems encountered in your map Overview of the Data Other ideas about the datasets Try to include snippets of code and problematic tags (see MongoDB Sample Project or SQL Sample Project) and visualizations in your report if they are applicable. Use the following code to take a systematic sample of elements from your original OSM region. Try changing the value of k so that your resulting SAMPLE_FILE ends up at different sizes. When starting out, try using a larger k, then move on to an intermediate k before processing your whole dataset. 5 SQL, Big Data, Data Warehousing Jul 5, 2017 Jul 5, 2017Ended $21
Inventory & Orders Spreedsheet I need a master in VBA and Macros to create a simple spreed sheet to calculate the orders, update warehouse and another spreed sheet for calculating cost and warehouse. 26 Excel, Data Warehousing Jul 4, 2017 Jul 4, 2017Ended $5
Microsoft Power BI Reporting Development - 04/07/2017 14:14 EDT I need someone with strong Microsoft Power BI skills and experience to provide assistance, basically just provide Q/A support. 20 Microsoft, Data Mining, Database Administration, Data Warehousing Jul 4, 2017 Jul 4, 2017Ended $112
Project for bhaveshghodasara Hi bhaveshghodasara, I noticed your profile and would like to offer you my project. We can discuss any details over chat. 6 Excel, SQL, Web Scraping, Data Mining, , Data Warehousing Jul 4, 2017 Jul 4, 2017Ended $104
Microsoft Azure Data APIs I am currently building a series of analytics functions within my company's website that allows us to track key data from systems at across our business. This requires me to integrate data from Typeform , and RMSCloud via API into a Microsoft Azure SQL database. The API documentation for each solution can be found at the links below: [url removed, login to view] [url removed, login to view] I require the configuration of the Azure environment and the establishing of the data APIs. This project will continue to expand and will likely require ongoing support so please provide me with a price for this job and for an hourly rate so we can engage going forward. Also, this project is reasonably time sensitive so please let me know any further detail that is required for accurate pricing and time estimates. 11 Data Processing, Database Programming, Data Warehousing Jun 22, 2017 Jun 22, 2017Ended -
Write some Software -- Urgent task We are looking for Data Architect freelancers Skills: Apache Spark with JAVA (Maven): The complete Jump ETL project is being developed using Java running in Apache Spark Data Warehouse Modeling (Star schema, snowflake schema, etc.) Near Realtime Data Processing (Kappa, Lamda architecture). ETL Tasks Orchestration, Scheduling, architecture, etc. Scope: Develop and enhance the ETL for Jump DaaS infrastructure Develop connectors to different third parties (through web services mainly) to extract information and store it in our RAW data store Data warehouse modeling and design to accommodate the Jump KPIs data model Process and transform RAW data into the data warehouse Process and aggregate data warehouse information into Jumps BI/AI platform database 19 Java, Big Data, Data Warehousing, Spark Jun 19, 2017 Jun 19, 2017Ended -
Talend Developer I need a Talend developer experienced expert for my multiple projects. If you have knowledge please bid. Details will be shared in message with the freelancers. 38 SQL, Software Architecture, Database Administration, RESTful, Data Warehousing Apr 14, 2017 Apr 14, 2017Ended -
Showing 1 to 23 of 23 entries
« 1 »