Now we are going to
use Power BI to make a Board Game dashboard. My goal is to make a magical list
that will update based on some slicers so we can eliminate options that do not
fit the people interested in playing.
So first let's get
the data in Power BI using XrmToolBox's Power Query (M) Builder. The step by
step instructions are available here: https://crmchartguy.com/power-query-builder/
You will also need
the Power BI Desktop
app. Once you follow the steps from the video above, all of your data will be
in Power BI and you can start building visualizations. Within a few minutes of
getting the data there I could create a table and create the slicers to
dynamically filter that table!
These are simple
tasks but I am going to document them for other's just starting out like me.
To create a table,
click the table button then select all the fields you want to display in the
table. When the table is selected you can drag and drop the columns in the
values list on the right hand side to re-order.
To create a slicer,
de-select the table and then click the slicer (table with filter) button then
select the field you want to filter on.
Once these are
created you can just click and drag to move and resize for the look you want.
So in just a few
minutes I created the Power BI dashboard below. Moving the slicers will
automatically update the results in my table so I can see the games that will
fit my requirements based on time and number of people.
 |
| My First Ever Power BI Report |
You can tell it is
working because Scotland Yard was selected as a potential game. Since this is
one of the best games ever, it is a success!
Tomorrow we will create a PowerApp to see the Board Game data and enter ratings.
 |
| Still some beautification needed but progress is being made |
No comments:
Post a Comment