Power BI Challenge 9 - Currency Conversion and More from Brad

[EnterpriseDNA]

Here’s Brad’s entry for Power BI Challenge 9. @bradsmith, feel free to add other details of your work.

Here’s how Brad described it:

Alright everyone, here’s my submission for data challenge 9!

I should start off by saying that unfortunately I didn’t include any machine learning in this report as I did last time, I’ll explain why at the end. Also, I didn’t really have time for this challenge as I only started this over the weekend haha.

Anyways, I did still take a different approach to this challenge as many others. Almost the entire report is dynamic. The main goal was to try to give the user the ability to determine what they wanted to see. A user can chose to see the any of the measures and how they are doing compared to the historicals in terms of MTD Current Month vs. Previous Month, MTD Current Month vs. Previous Year, or YTD Current Year vs. Previous Year. The currency selector is located just below the filters on each page with the current exchange rates used for that period listed at the bottom right of the page.

The most dynamic pages in the report though are definitely the last two (Top Performers & Adhoc Analysis). This one not only has all the features of the previous pages, but the user can see which dimension they want to see the data in and by which measure.

Machine Learning - As for machine learning, as my last challenge showed and were probably hoping to see some more of this time, I really like integrating machine learning into my reports, but this report was truly more focused on on the reporting side by providing a report for Enterprise DNA Recycle LTD (EDR) that allows everyone to be able to compare the same data universally across the company while being flexible enough to report any of the currencies. As a result, I didn’t really see anywhere from my perspective that machine learning would have been a value add for this report. Although I debated including a page that would go into forecasting exchange rate prices so that they could look at leveraging currency futures and save money or even make money based on that… If anybody would like me to create that page or walk through how to do that I’d be more than willing.

And that’s my report! I really tried for flexibility this time rather than my usual approach, but I think it turned out alright.

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.

[EnterpriseDNA]

This post is part of the Enterprise DNA platform improvements, through the Data Challenge our members and non-members can now share how they built their dashboard and what their inspiration is in building it. We hope all members can utilize it efficiently.

[sam.mckay]

Nice one bread. Always excited to see your reports now when you submit them, because who knows what type of advanced analytical workers embedded into them. I really like how you have used the analyst hub logo as well. Some good promotion there

overall I can see how informative your reporters, are like a lot of the unique visualizations you’ve used. Looks like you’ve dived into a few custom visualizations in this one. For some reason some of the colors don’t really line up to me so maybe have a look at that for next time. If you just simplify the color palette that little bit more I think you’ll find that it will just make the looks and feel of your report that much more compelling.

Maybe there’s some ideas arounds analysis and visualization that we could go into on a call. And record it for the channel. To me it looks like you’ve really used especially around the kepis some innovative visuals that I’m sure others would want to learn a little bit more about. So let’s do it!

Sam