Blog

Categories: AnnouncementsPower PivotPower QueryPower BI

ABC Analysis with Power Query

After an amazing first Power Query workshop in English, we are providing our attendees with even more CRAZY cool content that they’ll be able to put into practice (and understand) right away! You might have already seen an ABC Classification Pattern with Power Pivot here, but this time you’re going to see this pattern being […]

Power Query
Read full article >

Power Query for Excel – Replace values using values from another column

Another video trick for Power Query. A glimpse of how advanced you can go with Power Query using custom M code. Be sure to check out more tips and tricks like this one on the oficial Power Query Training page

Power Query
Read full article >

Getting Started & Understanding Power Query and the M Language

Let’s put Power Query and the M Language under the scope Power Query is a breakthrough tool for self-service Business Intelligence and it’s the new best tool released by Microsoft within the span of 5 years. I’ve already posted about what Power Query is and what it represent to us but, How can I get […]

Power Query
Read full article >

What is Power Query?

It’s a bit crazy that at this point I haven’t posted anything clearly defining what Power Query is and where it fits in the whole self-service BI experience with Power BI. So it’s time to actually sum up some points and post them here so we can clear that doubt about what really is Power […]

Power Query
Read full article >

Understanding Tables, Relationships and Data Modeling in Powerpivot

Figure 1: Shows a fact table with 2 dimension tables for Customers and SalesPerson My response to the image above 2 years ago as an excel user: “What the heck is a FACT and DIM table?” One of the common questions that anyone using Powerpivot has is… How should I model my Data in Powerpivot? […]

Power Pivot
Read full article >

Cool trick: Always show Yesterday’s, Today’s or Tomorrow’s

                                             Executive: Are these values correct?                                             Excel-guy: yes, but you need to check the dates                                                              slicers to see what dates the report is using                                           Executive: Ugh… I just want to click on the report and                                                                    see the latest values If you ever had this situation before let me tell you that you’re […]

Power Pivot
Read full article >