Encerrado

Data Analysis and Reporting- Create a dashboard to pick up data on a monthly basis and prepare consequent reporting

Parashnath Polypack Pvt Ltd, Kolkata is engaged in the manufacture of 210 litre plastic drums which are used for packaging of liquids and semi liquids. The industries concerned include food industry, paint industry, solvents, acids, road construction etc.

The raw material used is imported from the Middle East. Every month, we receive trade data (import data only) about the different raw material being imported by our competitors all over the country. The data includes a number of details such as Indian company, address, contact details, product info, foreign company, price, qty, customs duty, Indian port of call etc.

Please refer to the attached file to understand the kind of data which we will be playing with.

The work involved:

1. Clean the data received according to a set format. Every month the data comes in a particular format only.

2. Create a dashboard to pick up the clean data and to be able to perform analytics.

3. Display key KPIs which will be decided upon confirmation of work.

4. Create historical trends, moving averages, monthly charts etc.

5. To create a background to be able to use the data for further predictive analytics.

I need a one click dashboard which can pull data from an excel sheet, clean my data, perform analytics, and then display on the dashboard.

The medium/tool to be used is open for discussion. The various factors involved would be complexity of work, ease of modifications once the project is passed onto me, flexibility in using data, amount of data to be analysed etc.

The various options include Python, R, Qlikview, Tableau etc.

Habilidades: Processamento de dados, Excel VBA, Python, Data Analytics, Estatísticas

Veja mais: php create table csv data, create database normalize data, create graphs mysql data, freelancer analytics, work from home jobs data analytics, how to get freelance data analysis work, data freelancer, analytics side hustle, digital nomad data analyst, part time data analysis, data analysis work from home, reporting data analysis findings, project data analysis reporting, sales data analysis reporting, data analysis dashboard, reporting data analysis, data analysis reporting experience needs presentation skills, create php dashboard excel data, data analysis and reporting freelancer, data analysis reporting

Acerca do Empregador:
( 0 comentários ) Kolkata, India

ID do Projeto: #27922437

27 freelancers estão ofertando em média ₹8891 nesse trabalho

finecodervw

Hi, I am well versed with Excel formulas, macro, Dashboard and statistics and can help to clean the data and prepare the dashboards. it would help to discuss further on the requirement. Looking forward to your respon Mais

₹10000 INR in 5 dias
(43 Comentários)
5.6
WIFTCAP

Hi, nice to e-meet you. We have a team of experienced full stack developers with a focus on Python/Django. We have built a number of web and mobile based applications including (not limited to): 1. A sophisticated trad Mais

₹10000 INR in 14 dias
(23 Comentários)
5.0
JohnRikz

Dashboard expert I'm an experienced data analyst, will create for you a user friendly dynamic dashboard that will display trends and analytics. Will include filters, slicers and timelines . As a dynamic table, you can Mais

₹10000 INR in 10 dias
(20 Comentários)
4.2
haris021

I am an inter-disciplinary researcher with over 5 years of professional experience. I have been extensively working on Python and its application in water resources management for data analytics. I have experience of h Mais

₹10000 INR in 7 dias
(6 Comentários)
3.7
BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 60 projects on FL. Expertise - Macros Formulae VBA User forms Willing to share a sample of my work done o Mais

₹7000 INR in 7 dias
(14 Comentários)
3.9
anirudh14588

Hi, I am a Tableau/Power BI & Microsoft Certified Excel expert with >8 years of experience creating beautiful yet insightful dashboards. I am well verse in gathering the requirements, cleaning data and creating dashboa Mais

₹9999 INR in 7 dias
(5 Comentários)
2.7
dataguru2110

Hi I have 10 years of experience in Data Analysis, Data warehousing ,Business Intelligence and certified Power BI Expert. I have built so many Power BI reports and have experience in building report using different da Mais

₹12500 INR in 7 dias
(3 Comentários)
2.7
lala1706

Hi, I have extensive experience working with Python and machine learning. I can prepare data analysis dashboard for you in Tableau or Python within budget and timeline.

₹9000 INR in 5 dias
(0 Comentários)
0.0
harshmrinaldas

I will give u a dynamic excel tool which will be helpful in future as well, you need to add new data in sheet and everything will be updated, as soon as u update any new month data, drop-down list of month will also be Mais

₹3333 INR in 3 dias
(0 Comentários)
0.0
avinash1976vijay

Hello Sir, I am read about your project. I have 15+ year's of experience of that type of project. I am working as MIS head. If you will be select me for that project, it will be my first project on freelancer site, so Mais

₹11111 INR in 5 dias
(0 Comentários)
0.0
garciargs

Hi, I am responsible for BI (Qlik and PowerBi) and python data analysis development on a daily basis on my current job. I can make this project using open source technologies (no subscription cost) where you can deliv Mais

₹12500 INR in 15 dias
(0 Comentários)
0.0
ektasethi

Hi: I am a BI Expert. I enable any organisations' data breathe.....Tableau is my forte.... If you would like to visualize your data in Tableau, POwer BI, Qlik with handy filters which shall allow you to take quick Mais

₹12222 INR in 3 dias
(0 Comentários)
0.0
iellawendi

Hello, I am interested in the project. I initially think of Excel power tools to wrangle and analyze the data. I already acquired skills in Python, SQL, Power Bi, and Excel so I am open to discuss more the project and Mais

₹12500 INR in 8 dias
(0 Comentários)
0.0
muditgupta2080

Hello Sir/Ma'am, I can definitely help you with this projects. I have done similar analysis for an energy company sometime back. I have more than 6 years of experience in Data Visualization and Analysis. I understand Mais

₹9000 INR in 15 dias
(0 Comentários)
0.0
SHALINI199427

Hi, this is shalini from mangalore. I am MBA graduate I have knowledge in data analysis,believe me I can complete it within given time frame

₹1500 INR in 7 dias
(0 Comentários)
0.0
nitinfaye35

I have work on data analysis on monthly dataset for sales forecasting using different algorithms and also work on streamlit app for show output . This project I will be completed on time Regard Nitin Faye

₹5556 INR in 7 dias
(0 Comentários)
0.0
jaydeepd271

Hi, I have been doing this kind of work on a daily basis in my full time job. Can certainly help you out.

₹9000 INR in 7 dias
(0 Comentários)
0.0
shrawantadiraju

I have experience in working with Machine learning models and creating websites linking the models to the Flask dashboards. Have experience working in python, Heroku, Flask etc

₹12000 INR in 10 dias
(0 Comentários)
0.0
AniKhanna93

Ankit || 6 years || Certified Tableau and Power BI Reporting Expert || Expert in Business survey dashboards Take a look at my recent Tableau surveys: 1. COVID-19 SURVEY - [login to view URL]! Mais

₹10000 INR in 8 dias
(0 Comentários)
0.0
pratikchavan21

Hi there, I have around 6 years of Data processing and Visualization experience. I can make interactive visuals for your data within given time. I have used various tools to create dashboards and reports. I can create Mais

₹12000 INR in 7 dias
(0 Comentários)
0.0