Consulting

Results 1 to 6 of 6

Thread: PowerPivot Tutorials available?

  1. #1
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,702
    Location

    PowerPivot Tutorials available?

    The company is planning to expand the use PowerPivots, data cubes, and the like.

    Are there any simple tutorials available on the web about how to actually make and use them, with maybe some examples?

    The Googling I've done seems to be mostly PowerPivot features and/or PR/Sales talk

    Thanks

    Paul

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,702
    Location
    I tracked down a Que and a Microsoft Press book to order from the local bookstore, but I'd still be interesting in something else if anyone can point me.

    Paul

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,438
    Location
    Paul,

    Although I get a tad exasperated with his frivolous style all of the time, I would suggest that the best book is Rob Collie's book

    I have the eBook, and whilst I might claim I didn't really learn anything from it, I have been using PowerPivot for 2 years, have read the Russo/Ferrari book, and present a course on PowerPivot, I would still concede that it is probably the best starter.

    He doesn't cover data modelling to any extent, and I argue that this is a crucial aspect, especially when trying to use PowerPivot to link Excel sheets, I have had some real fun and games with tables that are many-to-many relationships.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,438
    Location
    There are also tons of blogs and articles, but they can get a bit heavy at times.

    You should look at the MS videos, they are PR and lamentably fail to show the real power and the real difficulties, but they get you going quickly.

  5. #5
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    One real difficulty I encountered was getting the Data Mining Add-On to work. I have SQL Server Express 2008 R2 and downloaded the Data Mining App, installed it and it would show in Excel (tried in both 2010 and 2013) - but the app will not connect to my SQL Server instance, and soon Excel wants to disable the add-on.

    I also have Visual Studio 2008, and it recognizes data mining but cannot create a useful sample to play with.

    Finally, just to be safe I downloaded and re-installed the Adventureworks files (specific to Data Mining), can see them in Management Studio, but cannot do anything with them.... bummer.

    [end or rant]

  6. #6
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,702
    Location
    XLD and stanl -- thanks for the insights and recommendations

    Paul

Posting Permissions

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