(Part 2) Best products from r/PowerBI
We found 3 comments on r/PowerBI discussing the most recommended products. We ran sentiment analysis on each of these comments to determine how redditors feel about different products. We found 22 products and ranked them based on the amount of positive reactions they received. Here are the products ranked 21-40. You can also go back to the previous section.
Which one of these are you talking about?
https://www.amazon.com/Information-Dashboard-Design-Effective-Communication/dp/0596100167
https://www.amazon.com/Information-Dashboard-Design-At-Glance/dp/1938377001
Wow...
https://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447
Your fundamental problem is that you need to start with what you are trying to do, then work to get the data in the right shape to meet this need.
GOALS:
Show the availability of resources with a given skillset over time. You want to allow for resources to learn new skills.
DIMENSION TABLES
Now that we know what your goal is, let's look at the actors that you have defined to determine what dimensions you need.
"Show the availability of resources with a given skillset over time" The nouns in your goal will give you the dimensions that you need.
Employee- DIM_EMPLOYEE (don't call people resources... they just don't like it :) )
Skillset- DIM_SKILLSET
Time- DIM_DATE (if you are calculating availability down to the hour, then you will also need a DIM_TIME table)
FACT TABLES
"Show the availability of resources with a given skillset over time. You want to allow for resources to learn new skills." The verbs will give you what needs to go into your fact tables.
These fact tables will be a little tricky depending on how complex you want to make them.
Availability- you are looking to capture the availability of a resource and compare it to the demand for a given skill.
​
​
but... unfortunately, I have to go. I will try to add some more to this later. Hopefully, this is enough to help you a little.