Blog

Categories: AnnouncementsPower PivotPower QueryPower BI

New and First Forum for Power BI, Power Pivot and Power Query in Spanish

Communities worldwide have emerged and flourished over the years but, can you believe that the Spanish speaking community has never had a forum solely focused on these topics? (ever!) Power Query, Power Pivot, DAX, and Power BI are now mature tools that have been around for quite some years now.Power Pivot has been around since […]

Announcements Power BI
Read full article >

Merge Operations in Power BI / Power Query – Part 6: Full Outer Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). This is the last post in the series! I highly encourage you to read Part 5 of this series before reading this one, but nevertheless, you can jump right in if you know the basics of Merge […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 5: Inner Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Similar to the previous posts in this series, I highly encourage you to read the first 4 Parts ( 1 | 2| 3 | 4 ) that I’ve published so far around Merge / Joins inside of […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 4: Right Anti Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Similar to the previous posts in this series, I highly encourage you to read the first 3 Parts ( 1 | 2 | 3 ) that I’ve published so far around Merge / Joins inside of Power […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 3: Left Anti Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read Part 1 and Part 2 of this series, I highly recommend that you read those prior to this post. In those previous posts, we went over the Left Outer Join and Right Outer […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 2: Right Outer Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read Part 1 of this series, I highly recommend that you read that prior to this post. In that previous post, we went over the Left Outer Join and some basics on how Joins […]

Power BI Power Query
Read full article >

Merge Operations in Power BI / Power Query – Part 1: Left Outer Join

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you’ve used Power Query or Power BI before, you’ve probably seen the “Merge” button which displays a window like the following: and this let’s you join 2 tables (or queries), and one of the questions that […]

Power BI Power Query
Read full article >

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 […]

Power BI Power Pivot Power Query
Read full article >

Clever Filters in Power BI / Power Query with Merge Operations

Have you ever wanted to do a specific type of filter that might be too specific to do with just the regular filter drop down or even the advanced filter operations in Excel? Let me give you an example of one of those scenarios. Imagine that you have a table like the following: [table style=”solid”] […]

Power BI Power Query
Read full article >

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

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: In the image above you’ll see that we have 2 values in the header section right under the logo of […]

Power BI Power Query
Read full article >

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 […]

Announcements Power BI
Read full article >

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

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, […]

Announcements Power BI
Read full article >