+ Reply to Thread
Results 1 to 5 of 5

Analysis in Pivot and Charts for educational project

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Analysis in Pivot and Charts for educational project

    Hello!

    I have a sample raw data to perform analysis for educational and training purpose in terms of pivots, charts etc. I have attached the sample file. I need help from the Pros out here as to what kind of analysis can be done with this data.

    I thought about few things like:
    1. cost per salesman in this year compared to past year
    2. cost per sales manager in this year compared to past year
    3. departmentwise comparison along with fiscal year comparision.
    4. branchwise comparision along with fiscal year comparision
    5. some kind of a cost analysis considering branches and departments with a comparison of fiscal years
    6. productwise analysis with a comparison of fiscal years and compared to average of all products

    I am working on 1 and 2 but it is difficult for me to even think of a logic as to how to go about doing the remaining things. Also if there is anything else that can be analyzed or any consolidated pivots/charts that can be added. Would greatly appreciate if I can get some help here.

    Thank you

    PS: Sorry if this question does not belong to this forum. If yes, kindly advice some analytical/analysis forums.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-10-2015
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    26

    Re: Analysis in Pivot and Charts for educational project

    Here is a possible example of #3
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Analysis in Pivot and Charts for educational project

    It may come in handy
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Re: Analysis in Pivot and Charts for educational project

    Thank you. both looks good and i am also looking at the data from various angles.
    @stasinek. I am working on a report similar to what you have sent but unable to derive the same via pivot. I am going to try it myself and will come back to you if I have any difficulty

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Analysis in Pivot and Charts for educational project

    Pay attention to change the layout of the data in the source table

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Complex Data Analysis Project
    By CapstanJD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2014, 10:18 AM
  2. Time Sheet and Project hours analysis - urgent!!
    By Monika Puri in forum Excel General
    Replies: 7
    Last Post: 03-30-2014, 11:14 PM
  3. Replies: 1
    Last Post: 03-06-2014, 11:00 AM
  4. Data Analysis- advanced pivot functions for employee analysis
    By Dsankie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-10-2013, 12:30 AM
  5. GUI School & Work Project for Analysis
    By Mordred in forum The Water Cooler
    Replies: 16
    Last Post: 04-13-2011, 04:50 PM
  6. Educational List
    By Waterworka1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2009, 12:15 PM
  7. Replies: 1
    Last Post: 10-17-2008, 03:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1