Skip to content
Power of Business Intelligence

Power of Business Intelligence

Blog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.

  • Books to Read
  • COVID-19 report
Power of Business Intelligence

Power of Business Intelligence

Blog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.

  • Books to Read
  • COVID-19 report
Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari, Marco Russo
Books

Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari, Marco Russo

Andrzej Leszkiewicz February 4, 2021

While you can import one table from an Excel file into Power BI and start adding fields into a visual, in most cases your data … Read More

Alberto FerrariMarco Russo 1 Comment on Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari, Marco Russo
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI by Gil Raviv
Books

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI by Gil Raviv

Andrzej Leszkiewicz February 4, 2021

I usually don’t read books with step by step instruction like “click File, then click Open”. I start working with a new tool right away … Read More

Gil Raviv 1 Comment on Collect, Combine, and Transform Data Using Power Query in Excel and Power BI by Gil Raviv
A power BI report that displays its own metadata, including refresh history
PowerShell Tricks and Workarounds

A power BI report that displays its own metadata, including refresh history

Andrzej Leszkiewicz February 1, 2021

A crazy Power BI idea is in my head. It rather doesn’t make much practical sense, but such crazy ideas sometimes lead to useful solutions for the … Read More

1 Comment on A power BI report that displays its own metadata, including refresh history
PowerShell script to publish Power BI reports into multiple tenants
PowerShell

PowerShell script to publish Power BI reports into multiple tenants

Andrzej Leszkiewicz January 27, 2021

I’m working with multiple Power BI tenants, workspaces and reports. It’s a pain to log out (I’m always logged in with an account for previous report), copy … Read More

3 Comments on PowerShell script to publish Power BI reports into multiple tenants
Line and stacked column chart with outliers
Storytelling with data Tricks and Workarounds

Line and stacked column chart with outliers

Andrzej Leszkiewicz November 12, 2020

In this post I’ll show how to handle a time series of data with outliers (extremely high values). For example, number of new COVID-19 deaths … Read More

COVID-19 Comment on Line and stacked column chart with outliers
Stacked column chart conditional formatting (COVID-19 report)
Tricks and Workarounds

Stacked column chart conditional formatting (COVID-19 report)

Andrzej Leszkiewicz August 16, 2020

I have updated my COVID-19 report today. New chart design: Old chart design: Old version of the chart worked, but it wasn’t perfect because of … Read More

Comment on Stacked column chart conditional formatting (COVID-19 report)
Who is a data storyteller? A composer or a musician?
Storytelling with data

Who is a data storyteller? A composer or a musician?

Andrzej Leszkiewicz August 8, 2020

I’ve been mentioned and a link to my blog has been shared by SWD (thank you!). The post itself and a few comments under the … Read More

Comment on Who is a data storyteller? A composer or a musician?
Storytelling with data in Power BI: part 3
Uncategorized

Storytelling with data in Power BI: part 3

Andrzej Leszkiewicz July 30, 2020

Storytelling with data in Power BIStorytelling with data in Power BI: part 2 So far I have created 11 pages report (+ title page) with … Read More

1 Comment on Storytelling with data in Power BI: part 3
Storytelling with data in Power BI: part 2
Storytelling with data

Storytelling with data in Power BI: part 2

Andrzej Leszkiewicz July 23, 2020

Since my first post about storytelling in Power BI I’ve created first 8 pages of the report : In some cases you may want to … Read More

2 Comments on Storytelling with data in Power BI: part 2
Storytelling with data in Power BI: part 1
Storytelling with data

Storytelling with data in Power BI: part 1

Andrzej Leszkiewicz July 13, 2020

Introduction, a visual with fully disabled interactivity for cover page. I’m starting a series of posts based on “Storytelling with data. Let’s Practice.” book by … Read More

2 Comments on Storytelling with data in Power BI: part 1

Posts navigation

Previous 1 2 3 Next

Follow me:

Recent Posts

  • It’s a client requirement. The customer is always right.
  • Power BI: HTML formatted titles
  • Elon Musk’s 12 Principles. Rocket building or data visualization?
  • 3D and animation in Power BI?
  • PowerShell script to download Power BI report from Power BI Service

Categories

  • Books
  • Data Preparation
  • Excel
  • Freelance Consulting
  • Power BI Jobs
  • PowerShell
  • Sharing and Embedding
  • Storytelling with data
  • Tricks and Workarounds
  • Uncategorized

Tags

3D Alberto Ferrari animation COVID-19 data management DAX Gil Raviv Marco Russo navigation Publish to web security SQL URL parameters VBA

Archives

  • March 2021
  • February 2021
  • January 2021
  • November 2020
  • August 2020
  • July 2020
  • June 2020
  • Books to Read
  • COVID-19 report
Proudly powered by WordPress | Theme: BusinessDeal | By ThemeSpiral.com.