Data Warehousing and Analytics reports Sample Project

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

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. **

Data Analytics Data Warehousing Database Development Python R Programming Language

Project ID: #19341104

About the project

22 proposals Remote project Active 4 years ago

Awarded to:

purnasasmal

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 SS More

€130 EUR in 15 days
(1 Review)
2.2

22 freelancers are bidding on average €162 for this job

schoudhary1553

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. More

€200 EUR in 3 days
(119 Reviews)
7.0
MasterKym

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 in 3 days
(19 Reviews)
5.0
engineeringexp

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, resou More

€30 EUR in 3 days
(17 Reviews)
4.7
asjkim

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 scie More

€277 EUR in 3 days
(2 Reviews)
4.0
farrukhcheema23

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, More

€30 EUR in 3 days
(2 Reviews)
3.4
jayantavkumar

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 Inform More

€222 EUR in 5 days
(4 Reviews)
2.7
AliSafder

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 in 7 days
(1 Review)
2.0
abhisheksindhwal

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 rep More

€200 EUR in 7 days
(0 Reviews)
0.0
vinamrax94

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 in 7 days
(0 Reviews)
0.0
aap31374

More then 15 years of experience in DBMS.

€155 EUR in 3 days
(0 Reviews)
0.0
kuldeepahuja

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 Tabl More

€200 EUR in 3 days
(0 Reviews)
0.0
pankajsakalle81

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, Py More

€222 EUR in 7 days
(0 Reviews)
0.0
barathisenthil

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 diagno More

€111 EUR in 2 days
(0 Reviews)
0.0
sunilmudunuri

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 desi More

€155 EUR in 3 days
(0 Reviews)
0.0
jayas9896

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 in 3 days
(0 Reviews)
0.0
dhawansaahiljobs

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, More

€250 EUR in 10 days
(1 Review)
0.0
Sathjay

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 passiona More

€55 EUR in 4 days
(0 Reviews)
0.0
Systemanddata

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 in 10 days
(0 Reviews)
0.0