MIS Reports - Dashboards,Visualizations,Forms,Data-Cleaning,Format,Automate,Graphs,Data Analysis

Posted At: Sep 24, 2021, from India

Service Banner
  • Cost$71.86
  • Delivery Time1 days
  • Delivery DateMay 03, 2024
  • Feedbacks0
MIS Data Analyst
FromIndiaMember SinceSep 23, 2021
Contact Seller

About This Service

Worked as MIS Data Analyst with almost 18 years of Industrial process experience, Projects & Reports Handled -

Sales: Sales Annual Business Plan, Sales Product Forecast Plan, Sales Branch Budget Plan, Sales Incentive / Compensation, Discount Analysis, Order Inflow Daily , Sales Employee Acquisition, Sales Employee Retention, Setting Sales Targets, Area Potential, Area Coverage Map, Product Pricing (Price Realization), Trend - Product,State,Segment, Pipeline Enquiry Report, Top & Bottom Performers, New Customer Growth/Decline, Existing Customer Growth/Decline

Marketing: Monthly Budget vs Actuals, Dealer Campaign, Quality Enquiry (Hot/Warm/Cold), Source of Enquiry , Enquiry vs Order Conversion.

Service: Spares & Service, Dealer Service Performance, Spares Stock & Forecast Analysis,Customer Satisfaction Index.

Production & Logistics- On Time Machine Delivery, Process Time Analysis, Batch Plan, Inventory.

Finance Reports- Receivables - Outstanding, Reconciliation-Customer Ledgers, Sales Vs Collection, Account Reconciliation, Profitability, Quotation Comparison.

Human Resources- Manpower Requisition, Manpower Retention , Head Count Waterfall, Appraisal Workings , KPI Dashboards

Computer Competencies -

Advanced Excel:

Vlookup Data, Picture lookup, Hlookup, Hyperlinks, Visualizations-Pivot Table, Pivot Chart, Dynamic & Logical Graphs, Form Control, Data Validation, Indirect Substitute Formulas, Name Manager, Advanced Charting, Advanced Filter, Grouping, Split Functions, Text Functions, Nested IF, And Concatenate Functions. Conditional Formatting, Protecting Sheets

Excel Macro VBA: Excel Recorded Macros to run Auto Tasks , Auto Reporting, Auto Data Cleaning, Auto Mailers and Auto Updates in Power Point Slide.

Word & PPT: Mail Merge, Alignment for Documentation. Interactive PPT

Power BI: Data modelling & Data cleaning with Query, using DAX calculation, calculated columns, Measures, Reporting in Tabular, Matrix & Chart forms, Multiple Dashboard & Visualizations

Google Certification Data Analytics: Key Aspects, Data Phases, Data-Driven Decision-Making, Data Exploration

What seller need from the Buyer to get started?

Objective for the Report

Who is the Stack holder - Analyses the Data/ Reports - Top/Middle Level/Entrepreneur

Idea how to work with Process / Formula / Logic

Clear requirement of Type of Work / Report Format / Graphs / Visualization / Dashboards

Frequency of Report Generation / Usage

Send bench mark report / dashboards

Proposal for Time to Complete the Project

Attachments

In this service seller added more items as an attachment. To view these items join us

Freelance Service FAQs

So here are four main steps to follow when searching for freelancers:
1) Inspect. Before you consider searching for the right freelancer, have a clear vision of what the project is about.
2) Shortlist. Once you've examined each freelancer that is bidding, you can now think about making a short list.
3) Interview.
4) Hire.

Within the service page, you will see a 'Contact Seller' button at right side. We recommend contacting your seller before placing your order, especially if you have specific requirements.

Freelance service is any fixed contract service. Designing, tax filing, software development with no full time commitment comes under freelance service.

Services similar to Reports

Find the best reports freelance services you need to help you successfully meet your Content Writing project planning goals and deadline

Browse reports services in Content Writing

If you're not seeing exactly what you are looking for, browse more reports freelance services with similar skills. You can talk about the price and timeline to create a personalized reports project with reports experts here.

Microsoft Excel services in reports

Professional data entry and organization

  • From$6.21
  • Delivery7 days
Data Entry service offered by Abdallah A. from Lebanon

I will complete any type of data entry work

  • From$13.89
  • Delivery1 days
Data Entry service offered by Sana Riaz from Pakistan

Accounting service

  • From$132.03
  • Delivery7 days
Accounting service offered by Rahul R. from India

I will do Data Entry , Copy paste and web research for you

  • From$8.73
  • Delivery1 days
Data Entry service offered by The P. from United Arab Emirates

Macros services in reports

Develop VBA Excel / Word / Outlook Macros

  • From$17.37
  • Delivery2 days
Desktop Applications service offered by Vincent B. from Philippines

Excel VBA Macros and Templates Development.

  • From$14.37
  • Delivery7 days
Data Processing service offered by Tathagat from India

Am an excel and macro expert as well working profession..

  • From$541.86
  • Delivery14 days
Excel service offered by Srini V. from India

Ms Excel Financial File creation

  • From$45.22
  • Delivery7 days
Excel service offered by Vincent B. from Kenya

Microsoft Power BI services in reports

I can create any kind of dashboard using Power Bi

  • From$34.73
  • Delivery14 days
Data Extraction ETL service offered by Bakhtawar A. from Pakistan

Business Analyst

  • From$59.89
  • Delivery21 days
Data Visualization service offered by Santhosh Kumar S. from India

Excel Data Entry and Processing

  • From$223.98
  • Delivery7 days
Data Entry service offered by Denver C. from United States

Excel Data Services

  • From$6.95
  • Delivery1 days
Reports service offered by Rajashekar S. from India

reports experts you may hire for your reports project