Find Jobs
Hire Freelancers

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

₹1500-12500 INR

Fermé
Publié il y a plus de 3 ans

₹1500-12500 INR

Payé lors de la livraison
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.
N° de projet : 27922437

Concernant le projet

24 propositions
Projet à distance
Actif à il y a 3 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
24 freelances proposent en moyenne ₹8 815 INR pour ce travail
Avatar de l'utilisateur
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 always add data later on to the file, and the report will update accordingly, Let us discuss more John
₹10 000 INR en 10 jours
5,0 (73 commentaires)
5,6
5,6
Avatar de l'utilisateur
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 response. Thanks
₹10 000 INR en 5 jours
4,9 (55 commentaires)
5,9
5,9
Avatar de l'utilisateur
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 on personal finance applications. Looking forward to hearing from you. Thank you BAVarun PS: Please have a look at the reviews given to me on this platform. PPS: The price indicated in the bid is generic in nature. It may change basis on the work required
₹7 000 INR en 7 jours
4,5 (28 commentaires)
4,9
4,9
Avatar de l'utilisateur
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 handling large data sets to gain insights using Python and R. i have also worked on PowerBI, Tableau , R and Python to develop web based dashboards that would provide insight to policy makers. Considering my qualification and experience i would be pleased to do this task for you. Look forward to hearing from you soon.
₹10 000 INR en 7 jours
5,0 (10 commentaires)
4,4
4,4
Avatar de l'utilisateur
Hi there, I am fresher on freelancer and looking for my first job. I am a highly motivated, result-oriented individual, willing to go an extra mile to reach goals and learn along the way. Typing Accuracy 90%. I'm confident that if given this opportunity, I will thrive and deliver quality work within stipulated deadlines. I look forward to contributing my skills and experiences if given the opportunity.
₹7 000 INR en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am a certified Six Sigma Blackbelt with an overall experience of 12+ Years in Quality Management, MIS, Reporting, Training and Delivery! Please consider me for this role!
₹11 000 INR en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi, I have been doing this kind of work on a daily basis in my full time job. Can certainly help you out.
₹9 000 INR en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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
₹12 000 INR en 10 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am best parson for your work And I hope you give me your work and I am your work is risponsiblete with under time complete submit & you com to me again in again call me 9534352653
₹6 000 INR en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am a professional and have managed excel files in the past. I have over 10 years of experience in accounts receivables (AR) management (assistant manager) and hands on experience in reporting. Combining data to get desired output is important so I would be able to take and understand your requirements. My approach will be to create a report with Pivot/bars and macros to prepare the dashboard. With a short analysis, Anil Kabra from Bangalore region is giving the highest volume of 300K and sales of Rs1.8 crores. With litle insight of the business I would be able to provide you with trend, forcast and action plans basis the data and information. Regards, Ashok
₹7 222 INR en 4 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I have exp of around 3 years on various front end tool. That does not including coding and data analysis exp. I think tool and language can be discussed later but in my opinion we can use Python for cleaning and any visualization tool for dashboard( can be done in excel alone but depends on data size).
₹11 111 INR en 15 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 parameterised reports for you where you can go and play with the data by your choice. I am open to Power BI, Tableau, SSRS, Advanced Excel reporting tools where you can easily materialised your requirements. Please let me know if we can disucss more about this opportunity. Thanks, Pratik
₹12 000 INR en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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
₹5 556 INR en 7 jours
0,0 (1 commentaire)
0,0
0,0
Avatar de l'utilisateur
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
₹1 500 INR en 7 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 preparing Reports and Dashboards is an Iterative process hence I have given 15 days. Tools which I would like to use in preparing such report will be Power BI as it cheaper then Tableau and can accommodate all your needs.
₹9 000 INR en 15 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 decisions, I shall be happy to help. I can do the data connectivity & integration from a variety of data sources. I will help you create a single customized dashboard/report with all your data sources that can generate business insights and help you decide your next set of action steps to rapidly analyze and improve your business. Added Advantage: Being a Chartered Accountant, I understand the Financial impact of transactions Major clients I'm handling currently is HT Media & Toyota, Ford with huge data & variety sources. Im also a consultant to BCG, Infosys, Deloitte & KPMG I’d love to hear more about what would make this project a success for you, and explore if we’d be a good fit to work together. Regards Ekta
₹12 222 INR en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 deliver both local or online access. I will deliver working online tool to process your data and be able to store previous data and insert new by drag and drop. This projected will be made in a way where future developments, such as machine learning/IA, will be easy and basically plug and play. Best regards
₹12 500 INR en 15 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 you can think from which sprite i will do that project. Kindly send me a sample file and further instruction. Thanks
₹11 111 INR en 5 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 updated with charts, graphs and other information
₹3 333 INR en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Dear Sir, I came across a your requirements that I believe fits me perfectly. I am interested to work for you. After reading the description and requirements and matching it with my own experiences, I know that I would be a valuable asset to your project. I have a good knowledge of Python, Excel, SQL, Data Analysis, Data Extraction, ETL, Data Visualization, Dashboard using Python, Scraping, Statistics, Machine Learning etc. I am fit for this project because I have completed such projects using Data Analysis, Data Visualization, Dashboard and Report Making and Machine Learning.
₹1 500 INR en 5 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de INDIA
Kolkata, India
0,0
0
Membre depuis oct. 27, 2020

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.