Miguel Escobar

Author Archives

  • Comparing Similar Products (Movies) with Power BI

    Back Story: Back in the day, I used to work for this company with a truly all-star / amazing team. We were all part of this company called 20Th Century Fox, and we were in charge of the Theatrical distribution of films in Central America.

    Business Intelligence wasn’t a standard in the industry – at least not how we know BI nowadays, and I was the main person leading the charge of using BI tools to analyze the sales aspect of the business – specifically the Box Office. And that’s how I found PowerPivot (without the spaces back then) and the DAX language. I went deep into it and even took the online Power Pivot Workshop that Marco & Alberto used to deliver back in December of 2011 .

    I was able to implement a WHOLE bunch of reports, analysis and dashboards thanks to Power Pivot, but one thing that I couldn’t implement back then (because I started the journey with my own company), was a Comparison of “Similar” movies for the release planning of an upcoming movie.

    See…before a film gets to a certain theater / cinema / studio / location, it has to go through a certain planning phase. It starts with an estimate on how much that movie might be able to make, but….how can we tell?

    Well, you had a few options, but in the end it was all a manual approach where you’d need to think about what movies might be similar to this one (from every single perspective that you can imagine). Then you’d go through the system and search for every single similar movie one by one so you can grab what was the total gross revenue for each.

    What if…you had a table for all the similar movies (usually called Comps) and you could simply select the Movie that you’re interested in and it’ll display all of the Comps?

    Of course, this doesn’t only apply to movies, but to any product / service that you’d like to compare against similar products.

    This is where this blog post comes in!

  • Extracting Header and Footer Values from Documents, Files using Power BI + Using PDF Connector

    image

    Have you ever had a similar situation where a REALLY important value of the file is in either a header or a footer section? Let me give you a clear example with the following file:

    SNAGHTML18603940

    In the image above you’ll see that we have 2 values in the header section right under the logo of my company. Now, this is a PDF file, so we’ll connect to that PDF file, get the data underneath those header values (which is basically a table) and then create a new column specifically for the value of the Sales Group. You can imagine that I have a bunch of PDF files in a folder and each of those PDF files is for a specific Sales Group, so I need to have that value as a new column.

  • Custom Connectors & we’re the Power BI leading pioneers in Panama

    A couple of things have happened within the last few days. In short:

    • We have a new promo video
    • We published 3 Data Stories to the Power BI data stories gallery
    • Our Partner Showcase solution has been approved and published on the official Power BI website

    That’s A LOT of info to digest, but let’s get right into it.

  • Modern Excel & Power BI September FREE Course & we’re now a Microsoft Gold Partner

    imageWhatsApp Image 2018-09-28 at 18.21.36

    We have some exciting news to share with you guys!

    You’re probably wondering why we haven’t posted in a quite a long time and the reason behind that is that we’re focusing our time and effort to completely take over our local market: Panama.

    I’ve been wanting to do this for a very long time, and finally Powered Solutions is ready to take the big step and deliver training and services to all the businesses in Panama.

    We started operating from Panama in 2013, but our focus until a couple of months ago was the international market with customers all over the world.

    We have a very aggressive plan to reach the top of the Partner ecosystem here in Panama. A clear roadmap of where we want to be, how we’re going to do it and what we plan to do – so if you’re near in Panama, you’ll be hearing more from us pretty soon.

  • 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

    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