I post about Power BI dataflows a lot, but that’s mainly because I love them. My background in data preparation and ETL, combined with dataflows’ general awesomeness makes them a natural fit for my blog. This means that people often think of me as “the dataflows guy” even though dataflows are actually a small part of my role on the Power BI CAT team. Most of what I do at work is help large enterprise customers successfully adopt Power BI, and to help make Power BI a better tool for their scenarios.
As part of my ongoing conversations with senior stakeholders from these large global companies, I’ve noticed an interesting trend emerging: customers describing self-service BI as a two-edged sword. This trend is interesting for two main reasons:
- It’s a work conversation involving swords
- Someone other than me is bringing swords into the work conversation
As someone who has extensive experience with both self-service BI and with two-edged swords, I found myself thinking about these comments more and more – and the more I reflected, the more I believed this simile holds up, but not necessarily in the way you might suspect.
This week in London I delivered a new presentation for the London Power BI User Group – Lessons from the Enterprise: Managed Self-Service BI at Global Scale. In this hour-long presentation I explored the relationship between self-service BI and two-edged swords, and encouraged my audience to consider the following points:
- The two sharp edges of a sword each serve distinct and complementary purposes.
- A competent swordsperson knows how and when to use each, and how to use them effectively in combination.
- Having two sharp edges is only dangerous to the wielder if they are ignorant of their tool.
- A BI tool like Power BI, which can be used for both “pro” IT-driven BI and self-service business-driven BI has the same characteristics, and to use it successfully at scale an organization needs to understand its capabilities and know how to use both “edges” effectively in combination.
As you can imagine, there’s more to it than this, so you should probably watch the session recording.
If you’re interested in the slides, please download them here: London PUG – 2019-06-03 – Lessons from the Enterprise.
If you interested in the videos shown during the presentation, they’re included in the PowerPoint slides, and you can view them on YouTube here:
- Central IT-delivered business intelligence
- Self-service business-delivered business intelligence
- Managed self-service business intelligence delivered in close partnership with IT
For those who are coming to the Microsoft Business Applications Summit next week, please consider joining the CAT team’s “Enterprise business intelligence with Power BI” full-day pre-conference session on Sunday. Much of the day will be deep technical content, but we’ll be wrapping up with a revised and refined version of this content, with a focus on building a center of excellence and a culture of data in your organization.
Update 2019-06-10: The slides from the MBAS pre-conference session can be found here: PRE08 – Enterprise business intelligence with Power BI – Building a CoE.
There is also a video of the final demo where Adam Saxton joined me to illustrate how business and IT can work together to effectively respond to unexpected challenges. If you ever wondered what trust looks like in a professional environment, you definitely want to watch this video.
 This may be even more exciting for me than Power BI dataflows are, but it’s not as obvious how to share this in blog-sized pieces.
 Without this second point, it probably wouldn’t be noteworthy. I have a tendency to bring up swords more often in work conversations than you might expect.
 And if you’ve been paying attention for very long, you’ll probably expect this to come up pretty often.
 Pun intended. Obviously.
 For a given value of “professional.”