Blog

  • Advanced Power Query and other questions from ‘M is for Data Monkey’ readers

    image

    The #1 Power Query book in sales and ratings. THANK YOU everyone Sonrisa

    A little over a year ago, Ken Puls and I published a book called ‘M is for Data Monkey’ which came out from a cycle of iterations over our Live Online Workshop. The book, in essence, is a summarized version of our Workshop with some Key concepts and examples that we used back then in our Power Query Training Workshop. Of course, Power Query has changed and our online workshop has changed as well. We keep our workshop fresh and up to date with the latest and the greatest, but the book is still relevant and will keep being relevant for many years to come even if some of the new UI or feature changes are not reflected in the book.

    It’s crazy how well our book as been received across the globe with over 4.5 stars average on most of the reviews that we receive. Here’s a few of the reviews that some of the readers have left on the Amazon US site:

    image

    image

    image

  • New Functionality in Power BI Desktop–January 2017

    image

    Almost every month the Power BI team delivers a new version of the Power BI Desktop with some new connector, new ways to visualize data and some other ways to work even easier with your data model or your ‘Get Data’ experience.

    The one that I loved this time and that might not be completely visible for most people is the new extract values from a nested list. The whole reason why this might not be visible to most users is that you almost never see a List when working with just the UI of Power Query. So, how do we even get to use this new feature?

    Let’s try with a simple example:

    image

    A table with stats on some marathon races with fields like, Marathon ID, the Name of the participant and the place or rank that the participant got on each marathon

    We would like to work our way from the table on the left to the one on the right.

  • Announcements: Power BI Red Carpet Program + New Power Query book is out!

    image

    Power BI now in Panama!

    Powered Solutions is now part of the Power BI Red Carpet Program

    The Power BI Red Carpet Program is an invitation-only Microsoft Program for a few selected partners worldwide and Powered Solutions has now been nominated, selected and activated as the very first and only Microsoft partner to join this program in Panama. The program helps partners by providing the tools, training, content, and support in order to deliver a successful Power BI based solution and bring data to life.

    This program will enable us to continue delivering the Top Quality service that we provide around Microsoft Business Analytics Technology and to be even add more value to the value-proposition that our solutions can have for our customers.

    If you’re looking for a Microsoft Partner that will help you bring your data to life in Power BI, then contact us at info@poweredsolutions.co for a meeting

    The Book is ready!

    Long overdue! but the book is now available

    The book is finally ready and you can get your copy here. This book follows the same learning path that Ken and I (Miguel) created for the Power Query Workshop, so you can expect some basic to advanced Power Query – there’s something for everyone!

    S2A English Final

    Don’t forget to download the supporting files for FREE! Click here to download all of them

    In case you want to take your Power Query experience to the next level, then I’d recommend you sign up for our last Power Query workshop of the year on the 24th of November. Click here for details

  • M is for Data Monkey: put your name in the Book!

    image

    (You can have your name in one of the pages of our Book!)

    Ken Puls and I are writing a book on Power Query and the M language called ‘M is for Data Monkey and the last piece of the puzzle is to get YOU to be part of this book.

    What we need from you

    We’ll need you to submit the following information via email to info@powerquery.training

    • A copy of your receipt for the pre-order of the book – if you haven’t pre-order it then you can do so here
    • The name that you want to be displayed on the book – for example, it can be Miguel ‘Mike’ Escobar, or something among those lines like Miguel Escobar (PTY507)

    We only have space for a limited amount of names (around 80), so please submit your information as soon as possible!

    The deadline to submit this information is August 14th, 2015 at 23h59m US Eastern time.