Blog

17 Oct

Transitioning to Data Science Career with Udemy

Uncategorized 6642 Views

Data Science is one of the leading tech career fields globally and several people are transitioning to data science

10 Aug

How to use Power BI without Work or School Email

MICROSOFT POWER BI 96802 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 2063 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 3940 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 2402 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 16265 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 2884 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 3908 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 12206 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 2946 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 3212 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 21513 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 2257 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 4265 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 6301 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 7352 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 5409 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 1242 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 2276 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 1573 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 606 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 939 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 2105 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 989 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 15249 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 1511 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 723 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 2091 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 15879 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 3929 Views

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