Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 24

Thread: Article: M is for (Data) Monkey

  1. #11
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by carlosam14 View Post
    I read all the book, very nice read and I really enjoy all figures, congrats to Miguel and you for making this book. I do it the work and make, start from 0 each example then compare with your complete's file, all Ok. at this point My request (for continue learn) to you is: Can share with me, some more examples, to continue learn.

    Thanks
    Not readily built, no. But if you really want to learn, try answering questions in our forum. You see all kinds of interesting challenges there, and it will really expand your knowledge.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #12
    Acolyte Iloveexcel&excelloveme's Avatar
    Join Date
    Jun 2017
    Posts
    25
    Articles
    0
    Excel Version
    2016
    Hi Ken,

    Love your book (got it 2 weeks ago from BookDepository.com)

    Anyway, I'm having some issue with Chapter 10, pg 91 "Connecting to the Data Model".

    Somehow when i click on "Query-Sales", i can't seem to click on 'edit'. Below is the screenshoot, not too sure if you're able to help me out

    Click image for larger version. 

Name:	2017-06-26_19h01_20.png 
Views:	25 
Size:	20.4 KB 
ID:	7013

    Appreciate your help

  3. #13
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hey there,

    What version of Excel are you using? 2010 or something later?
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #14
    Acolyte Iloveexcel&excelloveme's Avatar
    Join Date
    Jun 2017
    Posts
    25
    Articles
    0
    Excel Version
    2016
    Hey, is 2016

  5. #15
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Ah, okay. That section is specifically targeted at Excel 2010, and not 2016. So you won't see this setup at all in Excel 2016.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #16
    Acolyte Iloveexcel&excelloveme's Avatar
    Join Date
    Jun 2017
    Posts
    25
    Articles
    0
    Excel Version
    2016
    Opps, my bad. May I assume that Page 90 is to Load directly into Power Pivot for Excel 2016?

  7. #17
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Yes, that's correct. Pages 89-90 are for Excel 2013 and higher (including Excel 2016)
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  8. #18
    Acolyte Iloveexcel&excelloveme's Avatar
    Join Date
    Jun 2017
    Posts
    25
    Articles
    0
    Excel Version
    2016
    ooh .... Silly me ... Thanks Ken

  9. #19
    Hi, Ken.
    The book is really great and helpful. Are there any plans for 2nd edition given that PQ has improved significantly?

  10. #20
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,317
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Hi razmochaev,

    I'm glad you're finding the book useful. There are plans for a second edition, although I can't comment yet on how soon that will happen. (But it will happen.)
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Page 2 of 3 FirstFirst 1 2 3 LastLast

Posting Permissions

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