Pivot Table Jobs in India

1. Sales & Performance MIS Prepare daily, weekly, and monthly MIS reports for skincare sales, revenue, returns, and cancellations Track key e-commerce KPIs: GMV, Net Sales, AOV, Conversion Rate, ROAS, CAC Monitor performance by SKU, category (cleansers, serums, moisturizers, sunscreens), and channel 2. Marketplace & D2C Reporting Track performance across platforms such as Amazon, Flipkart, Myntra, Nykaa, and Shopify Monitor order flow, fulfillment status, RTO, refunds, and delivery TAT Reconcile sales data with marketplace and payment reports 3. Inventory, Batch & Expiry MIS (Skincare-Specific) Maintain SKU-wise inventory reports including batch numbers and expiry dates Track near-expiry stock and support liquidation / discount planning Monitor stock ageing, replenishment needs, and out-of-stock risks Coordinate with warehouse and supply chain teams for stock accuracy 4. Pricing, Promotions & Campaign Analysis Track discounts, offers, and campaign performance (sale days, influencer campaigns, launches) Analyze price changes, margin impact, and contribution by SKU Support marketing teams with campaign performance data5. Returns & Quality MIS Analyze return reasons (damaged, leakage, allergic reaction, incorrect item) Track customer complaints and feedback trends Share insights with QA and product teams to reduce return rates 6. Data Accuracy & Process Improvement Ensure accuracy and consistency across all MIS reports Automate reports using Excel, Google Sheets, or BI tools Maintain documentation and SOPs for reporting processes Required Skills & Qualifications Bachelors degree in Commerce, Business, IT, or related field 13 years of MIS / data reporting experience (beauty, skincare, FMCG preferred) Advanced Excel / Google Sheets (Pivot Tables, XLOOKUP, formulas, dashboards) Strong understanding of e-commerce operations and inventory management High attention to detail due to batch & expiry-sensitive products

Having good knowledge Google sheet & Advance excelDaily Wise MIS Report.Ageing Report Weekly Wise.Monthly Wise MIS Report.Batching MIS Daily Basis.

- Design, develop, and maintain comprehensive Management Information System (MIS) reports and dashboards to provide actionable insights to management and other departments.- Collect, clean, and analyze data from various sources to identify trends, patterns, and insights that support strategic decision-making. - Streamline and automate data collection and reporting processes to enhance efficiency and reduce manual errors. - Work closely with various departments to understand their data needs and provide tailored MIS solutions that support business objectives.- Monitor and maintain the performance of MIS systems, ensuring data accuracy and resolving any issues promptly. - Provide training and support to end-users on MIS systems and data management tools, ensuring effective utilization across the organization. - Generate ad-hoc reports as requested by management to support specific business initiatives or address immediate data needs.- Ensure the integrity and security of data within MIS systems, adhering to company policies and industry standards.

Dear Candidates,Greetings from Odisha Job Consultancy!!We are seeking a dynamic and experienced MIS Executive to join our team. As an MIS Executive, you will be responsible for managing and maintaining data systems, analysing data, and generating reports. This is a full-time position based in Bhubaneswar, Odisha. Qualifications and Skills>Qualification- Any Graduate>Fresher's can apply>Strong knowledge of MIS concepts and tools>Proficiency in Microsoft Excel, including VLOOKUP, HLOOKUPs, and Pivot Tables>Experience in MIS reporting and data analysis>Excellent attention to detail and accuracy>Strong organizational and time management skills>Ability to work independently and in a team>Good communication and interpersonal skills>Knowledge of data validation techniquesRoles and Responsibilities>Co-ordinating with the sales team for their sales performance tracking head office Instruction follow-up.>Tracking the sales team performance on day to day basis.>Reporting the sales team performance on daily basis.>Preparing MIS report sharing the final analysis report to management for further strategy development.>Preparing sales incentive plan marketing schemes and making sure proper implementation.>Co-ordinating between sales, marketing, product development service department for smooth operations and sales process.>Preparing MIS report sales ANALYSIS Report.>Working as medium between Management and Sales team.Contact HR PriyaInterview Venue- Odisha Job Consultancy, 1st Floor, MRF Tyre Building, Baramunda Bus Stand, Bhubaneswar

1. Data Collection and Management- Design and implement surveys, questionnaires, and tools for rural data collection.- Ensure data accuracy, completeness, and timeliness in collaboration with field teams.- Develop and maintain a centralized database for rural development metrics, including socioeconomic, agricultural data.2. Data Analysis and Insights- Analyze data to identify trends, patterns, and key areas for intervention in rural communities.- Evaluate program outcomes and effectiveness using statistical methods and predictive modeling.- Prepare analytical reports to guide decision-making and policy formulation.3. Monitoring and Evaluation (M&E)- Develop indicators and frameworks to monitor and evaluate rural development programs.- Support real-time tracking of project progress and outcomes.- Generate performance dashboards for stakeholders, ensuring transparency and accountability.4. Technology and Tool Utilization- Leverage GIS tools to map rural infrastructure and resources.- Use software like Excel, Power BI, or other advanced data visualization.- Implement machine learning models for predictive analysis where applicable.5. Desired Skills and Competencies:- Technical Skills: Proficiency in statistical software, data visualization tools, and GIS mapping.- Analytical Thinking: Ability to derive actionable insights from complex datasets.- Communication: Clear presentation of findings to technical and non-technical audiences.- Problem-Solving: Crafting innovative data solutions for rural challenges.- Cultural Sensitivity: Understanding rural dynamics and working collaboratively with diverse communities.

Dear Candidates,Greetings from Odisha Job Consultancy!!We are seeking a dynamic and experienced MIS Executive experienced in IT or Solar Sector to join our team. As an MIS Executive, you will be responsible for managing and maintaining data systems, analyzing data, and generating reports. This is a full-time position based in Bhubaneswar, Odisha. The ideal candidate will have 1 to 3 years of experience in a similar role.Qualifications and Skills>Qualification- Any Graduate>1 to 3 years of experience in MIS or related field in IT or Solar sector.>Strong knowledge of MIS concepts and tools>Proficiency in Microsoft Excel, including VLOOKUP, HLOOKUPs, and Pivot Tables>Experience in MIS reporting and data analysis>Excellent attention to detail and accuracy>Strong organizational and time management skills>Ability to work independently and in a team>Good communication and interpersonal skills>Knowledge of data validation techniquesRoles and Responsibilities>Co-ordinating with the sales team for their sales performance tracking head office Instruction followup.>Tracking the sales team performance on day to day basis.>Reporting the sales team performance on daily basis.>Preparing MIS report sharing the final analysis report to management for further strategy development.>Preparing sales incentive plan marketing schemes and making sure proper implementation.>Co-ordinating between sales, marketing, product development service department for smooth operations and sales process.>Preparing MIS report sales ANALYSIS Report.>Working as medium between Management and Sales team.Contact HR SonalikaInterview Venue- Odisha Job Consultancy, 1st Floor, MRF Tyre Building, Baramunda Bus Stand, Bhubaneswar

Dear Candidates,Greetings from Odisha Job Consultancy!!Position- MIS Executive- Google Sheet Expert in Logistic CompanyWe need an Data Studio and Google Sheet expert who will create reports and dashboards for the company reporting dashboard for various metrics, in, by date, week, and month by each employee, departments, and projects. expert in logical functionGoogle Sheets Customization skills - Google Sheet Scripting with Apps ScriptsGood Communication SkillsExcellent VBA Scripting Developer Skills will be an added advantageStrong Analytical Skills and MS Office , Excel SkillsShould be able to handle & achieve the departmental requirementsUnderstanding of operational process, logical thinking, reporting and analysisShould be open to change, Multi-tasking skills along with Accurate and Timely reportingWork on date and generate various types dashboards, reports/ad-hoc reportsGood understanding of computer systems, mobile devices and other tech productsContact- SonalikaInterview Venue-1st Floor, AK Tyre Building, Bus Stand, Baramunda, Bhubaneswar

Dear Candidates,Greetings from Odisha Job Consultancy!!Job title: Advance Excel Executive/ Data Entry OperatorJob description:Good in Advance Excel, V hook up, Hlook up, Pivat TableMaintaining MIS of Data Collation ,Compilation Analysis Data and provide data for salesforecast.Interview Round - 1 round i.e. F2F roundRequired Candidate profileMinimum Qualification should be 10+2Excellent knowledge of correct spelling, grammar and punctuationFamiliarity with MS office and Google sheets.Typing speed and accuracyComputer SavvyBasic knowledge of Computer and excelContact- SonalikaInterview Venue- 1st Floor, MRF Tyre Building, Baramunda Bus Stand, Bhubaneswar