Find Jobs
Hire Freelancers

Data Warehousing and Analytics reports Sample Project

€30-250 EUR

Ολοκληρώθηκε
Αναρτήθηκε περίπου 5 χρόνια πριν

€30-250 EUR

Πληρωμή κατά την παράδοση
The requirement is to do the following based on the given data set. - Draft out a short report after reviewing the data set the purpose/objectives/tools required for modeling and reporting. - take the data set and build a data model in Microsoft solution (preferably SSIS) but any other method also will do. (Star Schemas) - Design the star schema based on the data set we would use. Analytics: ======== - Once the data model is built then connect the DB with any front end reporting tool which is also compatible with Python or R. - Do some sort of analytics to show different trends in the insights of the data set. - Use the front end tool either Tableau or Power BI to get different insights into the data set **Purpose of this project is to gain some learning out of it to see how data modeling happens and how you can preform some sort of analytics using python and R and then how can you use reporting tools to view nice graphs and key findings. **
Ταυτότητα εργασίας: 19341104

Σχετικά με την εργασία

22 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hi there, Thanks for your requirement. what I understood that you are looking for end to end analytics solution with data warehouse. I may help you this. I need to know your data sources. Data integration: Using SSIS , pull all kind of data from sources, then apply all sort of logic and transformation to populate data warehouse ( star schema model) Data Model: If data volume is high and complex, then SSAS/tabular model will be used otherwise model can be designed in power bi itself. Report and visualization: Power Bi will be used to produce visual and report. it also Support R and Python. please contact me for more discussion. regards, purna.
€130 EUR σε 15 ημέρες
5,0 (1 αξιολόγηση)
2,2
2,2
22 freelancers δίνουν μια μέση προσφορά €162 EUR για αυτή τη δουλειά
Avatar Χρήστη
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€200 EUR σε 3 ημέρες
4,9 (119 αξιολογήσεις)
7,0
7,0
Avatar Χρήστη
Hello, I am a data scientist and R/Python programmer. I read your project description and I can do it for you. I will be looking for your reply for further discussion. Thank you.
€250 EUR σε 3 ημέρες
5,0 (19 αξιολογήσεις)
5,0
5,0
Avatar Χρήστη
A Data Scientist with experience in Python, R programming, R Shiny, R studio and anything related to data science and python Master in Engineering, Electrical and Electronic Engineer, who is dynamic, reliable, resourceful, committed and organized with enthusiastic approach to succeed with a pleasant attitude. Possessing excellent analytical skill and good research background. I have successfully completed IELTS with an overall band of 7 and have a good proficiency in English 10 Years Experience in Data Science Data Visualization Power BI Tableau Business development Anything on R programming COMPLETED PROJECTS • FM radio. • VHDL Design of an Up/Down Counter. • Design of Up/Down Counter using PIC. • Duck Shooter Program using C. • Pointer movement controller on 2-dimentional axis using C. • LCD display Manipulation projects including: o Text Display o Volt-Meter • Analog to Digital Conversion (8-bit). • Sound to Light Color Organ Design and Development. • Minesweeper Player Creation using PIC. • Simulation of an End to End Communication System with MATLAB. • (BENG Individual Project) (MENG Part A). • (MENG Individual Project) (MENG Part B). • (MENG Group Project).
€30 EUR σε 3 ημέρες
4,9 (17 αξιολογήσεις)
4,7
4,7
Avatar Χρήστη
Highly effective Data Engineer with over 25 years of experience, Andrew Kim is specialising in data integration, data conversion, data engineering, ETL, big data architect, data analytics, data visualization, data science, analytics platforms, and cloud architecture. He has an array of skills in building data platforms, analytic consulting, trend monitoring, data modelling, data governance and machine learning. SPECIALTIES TECHNICAL SKILLS • Big Data (Hortonworks and Cloudera) – Spark(PySpark, Scala), Kafka, Hive,Impala, NiFi, HDFS, Sqoop, Ranger, Yarn, Solr, SAM, Schema Registry, SuperSet • Language: Python, Scala, R, JavaScript • Data Visualization – Tableau, PowerBI, OBIEE, DOMO • Plunk & ELK Stack – ElasticSearch, Logstash, Filebeat, Kibana • AWS – S3, RefShift, DynamoDB, Athena, Kinesis, EMR, Aurora, Glue • Azure – Data Warehouse, Polybase, SQL Server, HDInsight, SSIS, SSAS • ETL – Informatica Power Centre, Informatica Big Data Management (BDM), SSIS • Data Science & Engineering – R / RStudio / SparkR Packages: dplyr, ggplot2, stringr, plyr, carrat, SparkR, NLP, tibble, TensorFlow, curl, Python / PySpark, MLLib • Libraries: MLLib, NumPy, SciPy, Pandas, Matplotlib, Seaborn, SciKit-Learn • DBMS / OLAP – Oracle, SQL Server, TeraData, MySQL, Postgres, Essbase, SSAS • Data Modelling – Kimball, Vault • Machine Learning / Statistical Modelling - Linear Regression, ?Logistic Regression, Classification and Regression Trees, Naive Bayes, ?K-Nearest Neighbors
€277 EUR σε 3 ημέρες
5,0 (2 αξιολογήσεις)
4,0
4,0
Avatar Χρήστη
Hi, I am a professional Business Intelligence Consultant with over 6 years of experience. I have worked on so many Business Intelligence projects, where i was responsible for ETL, Data visualization using Informatica, SSIS, Python and Power BI. I was working on this freelancing platform a while ago, but then becuase of workload, unfortunately I had to stop using this platform, but I am back now and I will charge you less for it as I need a start again. I have read your request and I am ready to work for you, Please lets have a chat and then I can show you some sample proejcts, which I have developed. I am waiting for your response. Thank you Farrukh
€30 EUR σε 3 ημέρες
5,0 (2 αξιολογήσεις)
3,4
3,4
Avatar Χρήστη
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
€222 EUR σε 5 ημέρες
4,9 (4 αξιολογήσεις)
2,7
2,7
Avatar Χρήστη
Dear Sir, I can create Star schema with dataset and get insights with Power BI. I have immediate availability. Let us discuss the details so l can work on it.
€200 EUR σε 7 ημέρες
5,0 (1 αξιολόγηση)
2,0
2,0
Avatar Χρήστη
I have been working on Data for the past 8 years, i believe that story boarding is the most important part of any Data Analytics Project, I would use SQL Server as the database, SSIS as the ETL tool and Tableau for reporting, we can also do some Outlier analysis or K means clustering and showcase the same in a nice graph. Before working on the dashboard i would love to create a wire frame for your review and we can work together to edit it as per your convenience.
€200 EUR σε 7 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
i have a good knowledge of python and data warehousing , Analytic and i have also involve in similar type of project in my organisation
€30 EUR σε 7 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
More then 15 years of experience in DBMS.
€155 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I am working on Data Warehousing & ML/AI domain.I have recently completed my project where i pulled data from 32 different ERPs & consolidated it in one Data Warehouse. Applied logic on data & on top of it, i used Tableau for data Visualization.
€200 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hi, We have gone through your requirements and we have done similar kind of projects in the past. We have a team of experienced professionals working in the following areas like Business Intelligence, Data Science, Python, R , SQL, SSIS, SSAS, AI, Tableau, Power BI Machine Learning etc. Kindly share the data set and other required details related to the project. So that we be able to deliver the project in given timeline.
€222 EUR σε 7 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I have extensive experience in preparing data data from disparate system using ETL tools and applying data quality techniques before building a complex data analysis solutions, have built various dashboards with diagnostic and descriptive analytics using Tableau that has helped business to take necessary actions / decision around the business process
€111 EUR σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
€155 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I'm currently working for an e-commerce fashion retailer to do the same. Please reply me in order to start the work.
€155 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Certified MSBI -Data Warehousing expert, working in this tool from last 9 years. Have already worked on the script as source excel files to various destinations. Relevant Skills and Experience MSBI, SSIS , ETL, DW, .NET
€250 EUR σε 10 ημέρες
0,0 (1 αξιολόγηση)
0,0
0,0
Avatar Χρήστη
hi, I am a data science undergraduate and I am currently working as a data analyst. As per your requirement, I would like to tell you that I have experiences in data warehousing and data analyst works. I am passionate about doing data analytics works. I am willing to do your project and give the best output for your requirements. best regards
€55 EUR σε 4 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
We bring 20 years of data warehousing experience and have a very strong understanding of BI and Analytics. We are very confident that we will able to help you on this.
€111 EUR σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της IRELAND
Rathmines Dublin 6, Ireland
5,0
17
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Σεπ 27, 2015

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.