- June 28, 2023
- 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:
1️⃣
Determine the report user.
2️⃣
Determine the information requirements of the report user
3️⃣
Draft the report. This doesn't have to be cut in stone but will serve as a direction.
4️⃣
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.
