Recently I conducted a session for BI team of a large customer.
This introduces the concept of end user BI to hard core developers.
Have a look. It will give you a different perspective.
2 hour video.
For BI developers
BI developers use sophisticated tools to get, cleanse, transform data and then use data warehousing technologies along with specially designed front-end applications.
While this is great, they usually don’t get any exposure of how Excel Power BI is transforming the end user level analytics.
Here is a detailed view of Power BI from the point of view of a developer. The language used is familiar to programmers and BI experts.
Why should you view it?
In spite of delivering sophisticated BI solutions to users, they still copy paste the data into Excel and struggle with it to get whatever they want.
As a developer, if you understand what users do, you can refine your solution architecture and create more relevant output which is easier to consume by end users.
End users go through endless struggle to get work done – but they never escalate their misery to developers. They genuinely think that this is the only way available and there is no option.
If you as a developer understand what they are doing, you can help them save time and focus on analytics rather than operational, mundane activities.
Most developers have a very superficial understanding of how Excel works. Recently, Power BI has added many tools which have redefined the whole gamut of what Excel and SharePoint can do together.
That is why you should view this.
This is a live session recorded as a screencast video. Therefore, the delivery is conversational, some discussion will be heard and the video / audio quality is not optimal.
Watch it in Full Screen mode at 720 p – highest possible resolution. The video consists of many demos. Therefore, viewing the details of UI are important for learning the nuances.
- Power BI is a great way to give structured data to users and create reports instantly
- Developers should deliver data through Power Query – Shared Queries so that users do not have to struggle with copy pasting and cleaning the output from BI tools
- Observe what users do to standard BI reports. This will help you understand how the process can be refined, simplified and made more effective.
- Power BI does include in-depth skills like M language and DAX functions – which fall into the realm of developers. End users are unlikely to understand and master these features. Developers can utilize these tools to deliver useful data in a usable format – with minimal coding.
Let me know your feedback. Enjoy.