Miguel Escobar

Author Archives

  • Microsoft Certifications Goals– Can a Excel/Power BI guy Achieve this???

    For the past few months I’ve been getting more and more serious about my business and the certifications that I hold.

    So far I’ve been able to accomplish the ones below as an individual:

    MCSA: BI Reporting - Certified 2017Microsoft Certified Trainer 2018-2019

    and just a few weeks ago I was able to have my company (Powered Solutions) attain the Silver Data Analytics Competency:

    logo (1)

    With that in mind, I’ve been thinking about the next steps that I need to take in order to have my company be a Gold Partner and in order to make that happen I need to have enough customer references (those are ready to go!) and I also need to have enough professionals in my organization that have the correct certifications – starting with myself.

    My next goal: Become a Microsoft Certified Solutions Expert: Data Management and Analytics

  • UPDATE: 2nd edition of ‘M is for Data Monkey’

    DataMonkeyCover

    As you may already know, Ken Puls and myself wrote a book called ‘M is for Data Monkey’ almost 3 years ago and we’ve been working thoroughly on the 2nd edition of that to keep the content up to date and relevant.

    We’ve got some news to share with you guys about the development of this book and when it’ll arrive to your favorite book store. Before we get into the this, we would like to cover some aspects as to why it has taken us so far to release this book.

  • Notes about the Microsoft Business Applications Summit 2018

    Image result for microsoft business applications summit 2018

    Last week was a busy week! Had the pleasure of flying over from Panama to the US for the first time and meeting tons of cool people for the very first time. One of them being my partner Ken Puls whom I’ve worked with for the past few years and yes – that was the first time that we actually met in person, how crazy is that?

    Furthermore, that was ALSO the first time that I met Rob Collie who I’ve also worked with for quite a few years!!

    In the event that you want to watch the session “From 0 to [M]ax: M language deep dive’’ that I did at the Summit, you can click on the button below to watch the VOD:

    Watch the VOD of my Session

    I’d like to take this opportunity to thank everyone who attended the event and who reads this blog or watches any of my videos. It is thanks to you that I’m able to do things like these and I hope that you guys enjoyed the event as much as I did.

  • Improved Web Scraping Experience in Power BI

    A lot of things have happened in the last couple of days. I’m for the first time in my life in Seattle spending some quality time with people that I’ve never met in my life other than through the power of the internet. It’s a nice feeling to finally put a face to a name that you always see on your inbox.

    I’ll be speaking later today, but I had to get this post out to the world as soon as possible.

    I’ve covered the new Web Scraping experience before in here, and talking with the product team today at the Business Applications Summit they (Ehren specifically) told me that they just updated and improved the experience, so he showed me a demo and I took home my homework so I could implement what he showed me on my own dataset

    What’s new

  • RETRY recursive function in Power BI & Power Query

    Recursive functions are a topic that I rarely come across.

    To give you some perspective, the instances that I’ve needed recursive functions can be counted with just 1 hand.

    This is one of those situations where a recursive function is probably the best way to go.

    Big thanks to NicoPer who posted this question on the Official Microsoft Power Query forum.

  • Navigation Window / Folder in Power Query and Power BI

    Motivated by one of the latest videos from the MSFT guys behind Guy in a cube:

    where they talk about one of the hidden secrets behind Power Query / Power BI, I wanted to talk about another one of those hidden gems inside Power Query / Power BI that is not completely visible or intuitive for most folks when they start using the tool.

  • Results: The Best ETL tool for the Business Analyst–Tableau Prep vs Power BI vs Trifacta Wrangler (Google Prep)

    The results are in! Let’s find out which tool is better for the average Business Analyst based on the 3 scenarios that I showcased a few weeks ago here.

    I was able to get in touch with the Product Team from Microsoft’s Power Query and also the one from Trifacta’s Wrangler. I tried getting in touch with the Tableau folks, but they  never replied to my emails. Luckily, someone within Tableau’s Sales team did see my videos on YouTube and was able to give me a more refined view of what Tableau is capable of. Big thanks to everyone who helped me along the way through forum responses and multiple emails!

    We’re going to break this down by each scenario and then we’ll tally up the results to figure out who’s the winner.

  • New Web Scraping experience in Power BI / Power Query (Using CSS Selectors)

    The latest version of Power BI Desktop came out with a new Web Connector specifically designed for Web Scraping Scenarios. in this blog post I’ll try to go deep into how this new experience works and how you can take advantage of it.

    Before we move forward, you’re gonna need the latest version of Power BI Desktop (May 2018 for me) and also enable the Preview feature in the Options window:

    image

    My Scenario: Get Data From Amazon

    I want to find out how many books are out there that have anything to do with Power Query. I want the reviews that go with them, the name of the authors, when they were released and, of course, the names of these books.

    The best place to find this information is probably Amazon. So I went on Amazon and did a quick search using the keywords “power query”.

    image