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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。