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. **
项目 ID: 19341104

关于此项目

22提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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威客以平均价€162 EUR来参与此工作竞价
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
More then 15 years of experience in DBMS.
€155 EUR 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
用户头像
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
付款方式已验证
会员自9月 27, 2015起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。