Blog

10 Aug

How to use Power BI without Work or School Email

MICROSOFT POWER BI 3 Comments 2864 Views

If you have ever tried to sign in to Power BI with your regular email address and Power BI

4 Jul

Key DAX Concepts you should know (part 2)

MICROSOFT POWER BI No Comment 143 Views

Though, DAX can be a very wide subject with so many details, behavioral patterns and performance considerations to learn.

9 Jun

Key DAX Concepts you should know (part1)

MICROSOFT POWER BI No Comment 218 Views

Intro DAX is a Data Analysis EXpression language used in Power BI. I attended a Power BI conference sometimes

6 Mar

Power BI Developer-the Secret Tech Role you have

MICROSOFT POWER BI No Comment 137 Views

Background There is a Secret Role in tech (especially in the west) that people are not discussing enough about.

26 Dec

How to deal with null in Power Query

POWER QUERY 1 Comment 1104 Views

One of the common Data Preparation questions Power BI and Excel Users ask is how to deal with null

23 Dec

Table Heat Maps as alternative to Line Charts?

Data Visualization No Comment 143 Views

Introduction Is there a possibility that Table Heatmaps can be used as alternative to Line Charts? At least in

16 Dec

Is AVERAGE the right DAX function for Average?

DAX No Comment 266 Views

Introduction The most used functions in DAX have to be SUM(), COUNT() (and it’s colleagues) and AVERAGE(). There is

16 Nov

Understanding Power BI Page Settings (Part 2)

Data Visualization No Comment 796 Views

Power BI Report Page As a Power BI Report Developer, having a good understanding of Power BI Page settings

2 Nov

Power BI Bookmarks Essentials (Part 1)

Data Visualization No Comment 120 Views

Apart from DAX, the other tricky thing to work with in Power BI is Bookmarks. And why not? Bookmarks

10 Oct

3 Datasets For Your Portfolio

Practice Data No Comment 311 Views

Introduction If you want to build a Data Analysis, Data Visualization or Reporting Portfolio, then you can find data

4 Oct

Hide Total For Selected Column In Power BI Table

Data Visualization, MICROSOFT POWER BI No Comment 1508 Views

Apart from the fact that I am baffled by how my Power BI reports use Tables, Power BI tables

1 Oct

The Best 2 PL300 Resources

DA100, MICROSOFT POWER BI, PL300 No Comment 153 Views

Of the many Microsoft Certification Exams, the Power BI Certification Exam, PL300 is one of the most popular. The

28 Jun

Understanding Power BI Page Settings (Part 1)

MICROSOFT POWER BI No Comment 337 Views

Have you ever felt like the Power BI Page or Canvas is too small to fit all of the

20 Sep

DAX Formula To Rank Based On Multiple Values

DAX, MICROSOFT POWER BI No Comment 527 Views

Performing ranking in DAX is simple enough when you are considering just single numerical values. I mean, for example,

26 Aug

Understanding Power BI Engine – Power Query

MICROSOFT POWER BI, POWER QUERY No Comment 250 Views

Power BI is more then what most think it is. Power BI is a collection of engines that all

15 Jul

How to use Native SQL Queries on Excel Data with

MICROSOFT EXCEL, MICROSOFT POWER BI, POWER QUERY No Comment 371 Views

Using native SQL Queries against data sources can come with certain advantages. Chief among those advantages is the ability

26 Feb

So You Want to Take The Microsoft DA-100 Exam…

MICROSOFT POWER BI No Comment 94 Views

First of all, congrats to me on my certification eh? Thank you, thank you. So in this article, I

31 Jan

5 Must-Have Custom Visuals

MICROSOFT POWER BI No Comment 199 Views

There are 2 groups of charts in Power BI; Standard charts Custom The standard charts are the ones available

17 Jan

Power BI Desktop 2020 Update Summary

MICROSOFT POWER BI No Comment 54 Views

Happy New Year! As you probably already know, Power BI releases updates for the tool every month. Although 2020

2 Jan

FinQuest Finance Provides Interest Free Loans For

MICROSOFT POWER BI No Comment 54 Views

Happy New Year! It’s that time of the year for fresh announcements and we have an exciting one. Foresight

24 Dec

Column Chart Or Bar Chart? Which To Use?

MICROSOFT POWER BI No Comment 56 Views

Hello there. Today’s topic is about some of my favorite charts to use, they also happen to be the

6 Dec

Three (3) Chart Types You Should Avoid

Data Visualization No Comment 127 Views

There are endless options of chart types to pick from when visualizing; ranging from Bars to Lines, to Waterfalls,

5 Dec

Gentle Introduction To Variables In DAX

DAX, MICROSOFT POWER BI No Comment 82 Views

Beasty DAX DAX formulas can quickly become very complicated and difficult to read especially when you start to combine

29 Nov

When to Combine ALL and FILTER – Functions

DAX, MICROSOFT POWER BI No Comment 1001 Views

In my previous post, I wrote about ALL and FILTER functions in DAX. And I mentioned that ALL is

28 Nov

When And How To Make Use Of Funnel Charts In Power

Data Visualization, MICROSOFT POWER BI No Comment 124 Views

So first of all, everything (data, maybe?) that’s poured at the top of this funnel doesn’t flow through the

20 Nov

Sort Your Measures In One Table In Two Minutes!

MICROSOFT POWER BI No Comment 68 Views

Hello there, how do you do? Today’s going to be a short one. What I have for you today

19 Nov

Functions In Focus: ALL and FILTER (Part 1)

DAX, MICROSOFT POWER BI No Comment 148 Views

In my previous post, I introduced 3 Table Functions You Must Master. FILTER, ALL and VALUES. The reason you

14 Nov

How To Effectively Use Bookmarks in Power BI

Data Visualization, MICROSOFT POWER BI No Comment 203 Views

“Bookmarks”? Yes, bookmarks. You know those thin strips in between books with the main purpose of referring to a

7 Nov

3 DAX Table Functions You Must Master

DAX, MICROSOFT POWER BI No Comment 285 Views

Writing DAX in Power BI is always against tables isn’t it? Our data are stored in tables, so analyzing

29 Oct

Be Smart With Smart Narratives

Data Visualization, MICROSOFT POWER BI No Comment 141 Views

Have you ever spent so much time working on a Power BI visualization that when you are finally done,