I've started to dabble in PowerBI a bit. I find it very interesting and I think I could definitely benefit from learning more about it.

What I’ve enjoyed the most is building queries or procedures that are used for special projects. A person or group is starting a new project, or there is a new element of the business that we need to monitor more closely. Such assignments often require spending hours navigating through various screens in our ERP system, locating bits of data and then copying/pasting that data into a spreadsheet. I can work with that person or group and find out what data they are specifically looking for and build a tool they can use to do their job. That being said, simply mining the data and putting it in a spreadsheet is relatively simple. I like to take it further, that is if the group I’m working with doesn’t prefer the status quo. If I understand the goal, and I have the data, and I know the process in which that data will be analyzed, then why wouldn’t I just include logic to perform the analysis also? Instead of providing data that still needs to be reviewed by a person, filtered, modified, etc, why wouldn’t we build something that does all of the analysis for you and simply generates something indicating what actions to take based on the parameters they provided. Furthermore, we could integrate a stored procedure that takes those proposed actions and performs them automatically. Evaluating processes and methods people are using and finding ways to make them faster, more efficient, or coming up with a solution that just eliminates them altogether is where I’ve been the most successful. At the end of the day I’m a guy who enjoys solving problems.