7 responses

  1. Mr. E~
    August 24, 2016

    THANK YOU! 😀

    Reply

  2. Sarath
    August 25, 2016

    This was nice a very much helpful
    Awaiting this type of posts

    Reply

  3. m-b
    August 26, 2016

    “Pivot tables cant work when you have more than a million calls”

    I’m pretty shure they can as long as you hook up the pivot table directly to a database (so the data isn’t loaded into a worksheet).

    In 2013/16 you can also load data > 1m records directly into the data model without needing Power Pivot.

    Reply

  4. Tobias
    August 26, 2016

    This is good advice, but as much as I love Excel, I would drop the whole data set into Power BI and analyse it there if I had the option. 🙂

    Reply

  5. Ali
    August 31, 2016

    Does this course require advance statistic knowledge

    Reply

    • Hui…
      September 1, 2016

      @Ali

      No

      Reply

  6. Bruce
    January 19, 2017

    One thing to check also is in the raw CAD data there is typically a column with some vague name that indicates the order of the time stamps and that can be used to filter the initial query down better.

    Reply

Leave a Reply

 

 

 

Back to top
mobile desktop