Blog

Categories: AnnouncementsPower PivotPower QueryPower BI

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 >

The Powerpivot Way – CALENDAR TABLE (Monthly and Weekly Totals)

New Video Up! have you ever wanted to group your aggregations by Month or Week? Check out this video where I use a calendar table to help me make things easier.

Power Pivot
Read full article >

Someone answered the million-dollar question! (What is Powerpivot?)

YES! IT’S CORRECT! Someone answered the million-dollar question and I feel like Steve Harvey or some other host about to give the million-dollar check to the winner. My friends at Portalfronthosting created this AMAZING video with subtitles in english and spanish! Sí, en español Check it out and don’t forget to share it! The revolution […]

Power Pivot
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 >

What is Powerpivot? (The Million-dollar question)

(The Riddler) While the prize on whoever answers this question varies, it could potentially be worth more to any business in terms of ROI. In short, Powerpivot is the new tool that allows/enables the business users to take a much more important role in the creation of insights that are relevant to the decision making […]

Power Pivot
Read full article >