Power BI
Marnix Jansen
Combine multiple Excel sheets
How do you combine multiple Excel sheets in #powerbi, even when the structure is different? Learn all about it in this short video!
Soft skills are more important than hard skills
When it comes to #powerbi, soft skills are more important than hard skills! Let me give you an example: A data analyst built a terrible report that is ugly, slow to respond, poorly designed, and provides a terrible user experience. 👎🏻 But, the analyst made sure that the report users were involved from the beginning, organized thorough user kick-off [...]
Marnix Jansen
Merging tables in Power BI
These are the 4 variants of table joins in Power BI, given in M (Query Editor) and their equivalents in DAX. I initially created this one-pager as a reference for myself, but would like to share it with all my Power BI friends out there.
Marnix Jansen
When you start developing a new report in Power BI, turn off your computer!
It sounds a bit strange, I understand, but let me explain: Before you open up your laptop and turn it on, you want to 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 use a [...]
Marnix Jansen
The art of designing a Power BI model
Before you start building a new Power BI model, it is crucial to establish the context first. I have facilitated many Lean VSM (Value Stream Mapping) initiatives to make a process (more) lean. I have learned the SIPOC (Supplier - Input - Process - Output - Client) approach as [...]
