Đã Đóng

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.

Kĩ năng: Xử lí dữ liệu, Excel VBA, Python, Data Analytics, Statistics

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Kolkata, India

ID dự án: #27922437

27 freelancer chào giá trung bình₹8891 cho công việc này


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 Thêm

₹10000 INR trong 5 ngày
(43 Nhận xét)

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 Thêm

₹10000 INR trong 14 ngày
(23 Nhận xét)

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 Thêm

₹10000 INR trong 10 ngày
(20 Nhận xét)

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 Thêm

₹10000 INR trong 7 ngày
(6 Nhận xét)

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 Thêm

₹7000 INR trong 7 ngày
(14 Nhận xét)

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 Thêm

₹9999 INR trong 7 ngày
(5 Nhận xét)

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 Thêm

₹12500 INR trong 7 ngày
(3 Nhận xét)

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 trong 5 ngày
(0 Nhận xét)

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 Thêm

₹3333 INR trong 3 ngày
(0 Nhận xét)

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 Thêm

₹11111 INR trong 5 ngày
(0 Nhận xét)

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 Thêm

₹12500 INR trong 15 ngày
(0 Nhận xét)

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 Thêm

₹12222 INR trong 3 ngày
(0 Nhận xét)

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 Thêm

₹12500 INR trong 8 ngày
(0 Nhận xét)

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 Thêm

₹9000 INR trong 15 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)

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 trong 7 ngày
(0 Nhận xét)

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 trong 10 ngày
(0 Nhận xét)

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]! Thêm

₹10000 INR trong 8 ngày
(0 Nhận xét)

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 Thêm

₹12000 INR trong 7 ngày
(0 Nhận xét)