In Day 2 of Dashboard Week, we were given the challenge to Design some powerful and convincing dashboards illustrating the impact of plastic on our oceans using Power BI. We were given around 10 different CSV files and were open to using additional data. We were also given the challenge to Merge Joins, DAX Formulas, M Queries, Custom Visual, Interaction.

In the beginning, using Power BI to analyse data was a bit challenging but later I started enjoying the features of Power BI. It has some excellent features like-

Content Packs:  

Power BI uses Content Packs, which has dashboard reports, data model and embedded queries.

Natural Language Q&A:  

This is one of the most powerful tools in Power BI. Natural Language Q&A allows users to write questions and provides the content and answer, which can be manipulated to match your visual need.

Print Dashboard:

Power BI provides a unique feature for printing dashboards, which can be handy in board meetings and discussions.

Custom Visualization:

It’s a library of custom visualization. If the business needs are different, then so should the visuals.

Get Data (Data Source):

With Power BI, businesses can get data from virtually anywhere. Power BI Desktop includes a huge array of on-premise and cloud data sources, structured and unstructured, with more added each month.

DAX Data Analysis Function:

Has more than 200 functions and counting. The rich DAX formula language includes libraries of incredible capabilities to perform computational gymnastics on your data and create powerful analytical data models.


I used some DAX calculations to divide my countries into groups. After spending a few hours exploring different graphs and joins, I was able to make some interesting dashboards in power BI. I really enjoyed exploring the features of Power BI.


The Data School
Author: The Data School