All articles with 'Power BI' Tag

Introducing Power BI Play Date – Online class to master Power BI (oh yeah, Power Query & Power Pivot too)

Published on Dec 4, 2019 in Power BI
Introducing Power BI Play Date  – Online class to master Power BI (oh yeah, Power Query & Power Pivot too)

Hello friends,

It’s here. Power BI Play Date – our online training program is now ready for your consideration. Please take a few minutes to read this to know all about the program. If you are ready to join, click here.

Check out below slideshow to see some of the reports you can create in our course. It is #AWESOME.

Continue »

Introduction to Power BI – What is it, how to get it, how to create reports with Power BI and how to publish them?

Published on Nov 8, 2019 in Power BI
Introduction to Power BI – What is it, how to get it, how to create reports with Power BI and how to publish them?

Power BI is a data analytics & visualization software. It is one of the most popular and powerful way to work with complex business data. In this page, you will find a comprehensive guide to start your Power BI journey.

Continue »

Yummy WAFFLE chart in Power BI

Published on Sep 3, 2019 in Power BI, Power Query
Yummy WAFFLE chart in Power BI

Waffles are yummy, Power BI is awesome. The combination is going to send your taste-buds on a cruise. Learn how to make a yummy waffle chart in Power BI.

Continue »

How to conditionally format visuals in Power BI?

Published on Jul 30, 2019 in Power BI
How to conditionally format visuals in Power BI?

Do you know that you can apply conditional formatting rules to visuals in Power BI? In this post, let’s learn how to conditionally format visuals in Power BI. Something like this:

Continue »

Should finance people learn Power BI?

Published on Jun 14, 2019 in Financial Modeling, Power BI
Should finance people learn Power BI?

I recently went to Sydney to conduct some training programs on Advanced Excel and Power BI. While I was there, I met my good friend Danielle, who runs Plum Solutions, a financial modeling consultancy & training company. We got talking about various things and the topic eventually turned to “finance people and Power BI”. We […]

Continue »

How to fake “Key influencers chart” in Excel?

Published on May 1, 2019 in Charts and Graphs
How to fake “Key influencers  chart” in Excel?

Recently, Microsoft Power BI introduced a very useful visualization, called key influencers visualization. As the name suggests, this is a chart of key parameters that effect a measure or outcome.

For example, you have customer satisfaction rating as a measure. Now you want to know which aspects of your data impact the ratings most? You can create the key influencer visual and Power BI finds all the top ranking influencers (using rules and machine learning).

But can we make it in Excel?

Let’s see…

Continue »

There is an Easter Egg in this Power BI report

Published on Apr 18, 2019 in Excel Challenges, Power BI
There is an Easter Egg in this Power BI report

Its Easter time. At Chandoo.org, I have tradition of publishing Easter Egg hunts since 2009. This is the first time our Easter egg hunt is on Power BI. Changing times, eh?

Continue »

Power BI Webinar, Amsterdam & Australia tours [update time]

Published on Mar 15, 2019 in Master Class, Training Programs
Power BI Webinar, Amsterdam & Australia tours [update time]

Hiya folks… just a quick update on whats keeping me busy this year, with a bonus Excel tip at the end. Take a sip of your favorite brew and read on.

Continue »

Employee Turnover Dashboard – Power BI for HR

Published on Mar 8, 2019 in Power BI, Power Pivot, Power Query
Employee Turnover Dashboard – Power BI for HR

Work in HR and use Power BI? You are going to love this extensive, powerful and useful Employee Turnover Dashboard. In this detailed article, learn how to create your own attrition dashboard system with Power BI. Full example workbook, video and sample data included.

Continue »

My top 5 tips for designing beautiful Power BI reports

Published on Sep 10, 2018 in Power BI
My top 5 tips for designing beautiful Power BI reports

Power BI allows you to create rich, interactive and informative reports. But it is also a massive pain to create beautiful yet functional reports with Power BI. Over the last 12 months of heavy usage, I have picked up a few tricks to speed up my Power BI report design time. In this post, let me share my top Power BI design tips for creating pretty reports.

Continue »

What is Power BI, Power Query and Power Pivot?

Published on Aug 27, 2018 in Power BI, Power Pivot, Power Query
What is Power BI, Power Query and Power Pivot?

In this installment of Power Mondays, let’s go the very basics of it all.

What is Power BI?

Power BI is a software to create and publish interactive, web-enabled reports & visualizations for your audience. You can use Power BI on a PC or web to create things. Once you publish a report (or few visuals), your audience can consume them by using any device – PCs, Macs, Web browsers, Apps on cell phone / tablets etc. 

Continue »

Nest Egg Calculator using Power BI

Published on Aug 6, 2018 in Power BI, Power Pivot, Power Query
Nest Egg Calculator using Power BI

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In the first installment, let’s take a look at something we all can related to – Money. 

We all know that Power BI is good for creating awesome visual experiences. Today let me share another fun way to use Power BI – to build a calculator. Learn how to create nest egg calculator in this Power BI parameter example tutorial.

Continue »

How to undo in Power Query [Quick Tip]

Published on Jun 22, 2018 in Power Query
How to undo in Power Query [Quick Tip]

Ever wondered how to undo in Power Query. If you try to press CTRL+Z or look for undo icon in Power Query (either in Excel or Power BI), you will not find it. The reason is simple. There is no undo in Power Query. So how to undo ?

Continue »

Best Excel Books & Power BI Books – 2018

Published on Jun 11, 2018 in Learn Excel, Power BI, Power Pivot, Power Query
Best Excel Books & Power BI Books – 2018

So you have decided to up your game with Excel and / or Power BI this year and now ravenously looking for books to read. You have come to the right place. Here is my list of recommended best Excel books, and books on Power BI, visualization, dashboards, VBA, Macros and analytics.

Use below links to navigate the relevant section of this page:

Continue »

May the POWER BI with you [Star Wars Day Viz]

Published on May 4, 2018 in Power BI
May the POWER BI with you [Star Wars Day Viz]

It is star wars day. Let’s celebrate the ultimate nerd day of the known universe in a way that resonates with us. Let’s dress up as storm troopers and make exploding 3d pie charts.

Just kidding. Let’s just make a cool visualization in Power BI instead.

Continue »