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 an awful report which is ugly, slow to respond, poorly designed and provides a terrible user experience. 👎🏻 But, the analyst made sure the report users were involved from the get-go, organized thorough [...]
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're going to develop a new report in powerbi, turn your computer off!
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 [...]
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 [...]
