- June 28, 2023
- Marnix Jansen
- Power BI
Sounds a bit strange, I understand, but let me explain:
Before you're going to open up your laptop and turn it on, you wanna make sure you've first determined what you're going to do.
Go low-tech! Technology only gets in the way of your common sense and creativity during this phase. Just a whiteboard and some markers or a few sheets of paper and a pencil. Don't forget an eraser as you're going to let your mind go over all sorts of different ideas.
Then go by these steps:
Determine the report user.
Determine the information requirements of the report user
Draft the report. This doesn't have to be cut in stone but will serve as a direction.
Draft the data model starting by the fact table(s) and then the dimensions.
Now, you are clear on what you're going to be using Power BI for and you can open up Power BI and start building!
Doing this first is going to significantly increase the odds of important decisions actually getting based upon your report.