Kumar Gaurav Excel, Power BI, SQL, Advance Excel, Python
No reviews yet

Are you ready to take your data analysis and visualization skills to the next level? Look no further! Our training programs cover a wide range of essential tools and languages including Excel, Power BI, SQL, Python, and VBA.

Whether you're a beginner or looking to refine your expertise, our courses offer:

Excel: Master spreadsheet manipulation, data analysis, and automation techniques to streamline your workflow and unlock valuable insights.

Power BI: Learn to create dynamic dashboards and reports, transforming raw data into compelling visualizations for informed decision-making.

SQL: Dive into the world of databases with SQL, mastering queries, joins, and data manipulation to efficiently manage and analyze large datasets.

Python: Explore the versatility of Python for data analysis, visualization, and automation, empowering you to tackle complex tasks with ease.

VBA: Unlock the full potential of Excel with VBA programming, automating repetitive tasks and enhancing functionality to boost productivity.

Our experienced instructors provide hands-on training, practical exercises, and real-world examples to ensure you gain the skills and confidence needed to excel in today's data-driven world.

Subjects

  • Python Beginner-Expert

  • VBA & Macro Beginner-Expert

  • Power BI Desktop Beginner-Expert

  • SQL Queries Beginner-Expert

  • Excel (Advanced) Beginner-Expert

Experience

  • Retail Analyst (Jul, 2023–Present) at Trends of India
    Trends of India-Retail Analyst July 2023 to Till Date
    ➢ Build dashboards, internal / external reports and present key datasets to enable all team members to efficiently and effectively mon-
    itor performance and priorities their efforts.
    ➢ Translate data into meaningful and measurable metrics for leadership and various teams.
    ➢ Perform ad-hoc analysis and special projects as needed.
    ➢ Able to respond to all data inquiries and questions as they pertain to business outcomes by navigating through multiple data sys-
    tems and multiple operational teams.
    ➢ Generate various monthly and quarterly, analyses and reporting
    ➢ Statistical concepts and trending analysis.
    ➢ Collect, clean, and organize data from various sources for analysis. Collaborate with internal teams to understand data requirements
    and ensure data accuracy.
    ➢ Design and develop interactive and insightful Power BI dashboards and reports.
    ➢ Conduct exploratory data analysis to identify trends, patterns, and insights. Collaborate with team members to extract actionable
    insights from data sets.
  • Sr. MIS Executive - WFM (May, 2022–May, 2023) at Teleperformance
    Teleperformance-Sr. MIS Executive (WFM) May 2022 to May 2023
    ➢ Skilled in Advanced Excel, SQL and Power Bl (Power Bl Desktop.
    ➢ Experience in connecting with multiple data sources like SQL Server,Excel from Power Bl to build complex Datasets.
    ➢ Extensively worked on performing the ETL Activities in Power Query.
    ➢ Good Experience in filtering the Unwanted Data in Power Query
    ➢ Created Dashboards style of reports using Power Bi Desktop Visualizations like Bar Chart, Line Chart,Area Chart and Slicer etc.
    ➢ Extensively used transformat ions like Merge Queries,Append Queries, Pivoting the Column,Un Pivoting Columns,Adding Cus-
    tom Columns,Splitting the Columns,Merging the Columns etc.
    ➢ Extensive Experience in doing Data Modelling in Power Pivot Model.
    ➢ Extensively worked on Enhancing the Data Modelby Creating New Columns,New Measure and New Tables using DAX Expres-
    sions.
    ➢ Extensively used different Categories of DAX.
    ➢ Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report.
    ➢ Good Experience in Creating Hierarchies and Drilldown Reports.
    ➢ Good Experience in sorting the Data in Visualizations,Grouping and Binning the Data in Power Bl.
    ➢ Experience in publishing the Reports to Power Bl Service and setting up the necessary connections. 0 Extensive
    Experience in Creating the Dashboards using Multiple Reports.
    ➢ Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset. 0 Imple-
    mented ROW LEVEL SECURITY (RLS) as part of security in Power Bl.
    ➢ Experience in sharing the Reports and Dashboards with End Users.
    ➢ Maintain and Analyses workforce performance, lead analysis and staffing change data for continuous quality and productivity
    improvement.
    ➢ Assist with development of performance indicators and reporting mechanism to measure operating standards and facilitate effective
    decision support.
    ➢ Create and communicates schedules and provides regular reports to Management on workload and workforce.
    ➢ Work closely with operations team to analyze and help them to improve their performance.
    ➢ Generate ideas for process and services improvement planning.
    ➢ Use trends and reports to forecast requirements.
    ➢ Engagement with Business Unit and workforce Management team leader in relation to process performance by publishing
    Client/TL APR, Client/TL Shrinkage, Shift adherence, FTE (People Mapping) etc.
    ➢ Facilitate monthly planning meetings with Management and Client. Share and adjust accurate short- and long-term workload and
    headcount forecasts.
    ➢ Identify the root causes problems and develop measurable solutions of process to eliminate re occurrence.
    ➢ Provide forecasting on daily, weekly, monthly and yearly basis capacity planning.
  • Analyst (Nov, 2021–Present) at Trends of India
    ● Tracking Salesman & Store Performance monthly, Quarterly, Yearly on basis of different Parameters(ABV,ABS,FF,Conversion etc.)
    ● Segregation of Sales Net Amount between Company & Franchise Business Partner as per Agreement between company & Franchise Business Partner.
    ● Cordinating with HR. Team to get Clear Salary of Store Manager, Karigar Staff,Salesman & Office Staff.
    ● Calculating Tax difference between Wholesale Tax Amount & Retails Tax Amount of Same items of Same Tracking ID.
    ● Generate Report for most demanding Saleable Items, Design, Color, Size of Cloths.
    ●  Developed Model & Track the different Lots of Clothes MTR. of different Fabrics issue to Factory Karigar & After Sewing also track how much Items quantity received into Warehouse. To know gap between actual & Expected.
    ●  Identify the Rate mismatch of same design in different Bill No. & Report to Vendor to get clarification or Correction.

    ● Track Payment to Party & Purpose of expenses in New Store launch using bank statement & UPI Summary.
    ● Create PPT (PowerPoint Presentation) & Dashboard to Show Company Overview to Franchise Business Partner & interact with Company Employee Meetings.
    ● Tracking Stock availability as per Items,Design,Color & Size on different Store & info. Management & Warehouse Team to Maintain Stock on the Stores.
    ● After Store Audit Track Pilfirage of Stock / Shortage of Stock on basis of different Parameter & get notified to Management & HR. Team to take further Action.
  • Analytics Trainer (Apr, 2020–Nov, 2021) at Kumar Gaurav
    Advance Excel: Countif,Sumif,Advance Filter,Sorting, Pivot Table,Sumproduct,Vlookup,Xlookup,Index,Match,Power Query,Conditional
    Formating,Data Validation,Address,Indirect,Text Function,Networkdays.INTL,Power Query,Relationship,Offset

    Power BI: Calculated Columns, Measures, Modelling & DAX(Creating New Column,New Measure and New Table),Power Bi Dasktop
    Visualization, Relationships, Power Query/M(Merge Queries,Append Queries,Pivoting Columns,Unpivoting Columns,Addimg Custom
    Column,Splitting the Columns.Merging Columns etc.),Bookmarks,Power Pivot Model,Filter(Visual Level,Page Level,All Page and Drill
    Through), ierarchies and Drilldown,Power Bi Service,RLS.
    SQL: DDL,DML,DQL,DCL,Procedure,Function,Views,Loop,Aggregate Function,Logical Operator,Constraint,JOIN,Having
    VBA: Workbook,Worksheet Function,Sorting,Filter,Loop,FSO,Thisworkbook,Activeworkbook,Object
    Python: Tuple,Sets,Lits,Dictionary,User defined Functions,NumPy Array, Python Pandas, Matplotlib,lamda Function,Seaborn
  • Associate Analyst (Mar, 2019–Mar, 2020) at Conduent Business Services Pvt Ltd
    CONDUENT-Associate Analyst March 2018 to March 2019
    ➢ Develop Business architecture using as scope, processes, alternative, risks and executing client’s business requirement through work
    flow and quality analysis
    ➢Engages with project stakeholders to influence direction of project to meet project expectation
    ➢Dealing with large datasets and working on database to analysis & building model
    ➢Implement theoretical principals & hypothetical testing on parameters to analyze data and produce result
    ➢Outlier treatment, Model validation, Model implementation
  • Executive -Supply Chain management (Jan, 2018–Jan, 2019) at OYO Rooms
    OYO ROOMS -Executive -Supply chain in Vendor Management Jan 2017 to Jan 2018
    ➢ Developed Google Spreadsheet model to handle Pan India supply chain
    ➢ Planning supply chain schedules in advance in preparation for future requirements
    ➢ Performed Trend Analysis of Data and Automation of reports, prepared variance reports such as Forecast vs. Actual dispatch.
    ➢D2H: delivery to hotel – defined hotel inventory levels, re-orders levels and automated ordering process, escalation handling,
    publishing periodic dashboards.
  • Executive - Actuarial (Jun, 2016–Jan, 2017) at Max life insurance
    Max Life Insurance-Randstad (Actuarial Group underwriting team) -Actuarial Executive June 2016 to Jan 2017
    ➢ Risk classification and categorize the participants of data
    ➢ Review, analyze and negotiate proposed pricing with the sales force based on the competitive platform
    ➢ Strategic Pricing & making quotes of Insurance Plans for New Business Schemes in Group Underwriting Team.
    ➢ Presented every price with detailed assumptions to cross functional teams for review and approval

Education

  • M.SC(Statistics) (Jan, 2013–Jul, 2015) from Banaras Hindu University, Varanasi–scored 8.53

Fee details

    ₹400–700/hour (US$4.68–8.19/hour)

    Fee will varies according to different tools . Fee for Excel, power bi, SQL, python will be different

Reviews

No reviews yet. Be the first one to review this tutor.