Weekly Roundup for June 29, 2020

MK_logo_horizontal_rgb.png

I love the new page navigation capability in Power Bi. It is so much simpler than the button navigation. I have replaced them with this capability in all my reports!

 

About 2 months ago, Microsoft bought Softomotive, which will give them significant capabilities in Robotic Process Automation (RPA). This will be a natural complement to a tool like Power Automate, and it is now available in your UI flows.

 

You always have to keep an eye out for high-cardinality columns in your data model. Datetime columns are frequent culprits at this and will make your data models large and non-performant.

 

If you are going to build a (true) data warehouse, Agile is a great tool to keep the project on track and to reach value sooner. This is a really great article covering what to think about when starting a new Agile data warehousing effort.

 

I am constantly preaching to my clients the benefits of a self-service BI strategy. 1. Enabling the business to move at their own speed; 2. Getting the business more involved in their own data; and 3. Getting to insights faster than your competitors.

 

I couldn't agree more! When designing and building a BI data model, you really must make the names of the tables, columns, and calculated measures "client facing" (i.e., client friendly) from the beginning. This is crucial; otherwise, you will end up with a BI solution that no one wants to use.