Recently I was leading some Power BI sandbox co-development with a client whose business is based on buying and selling commodities with US and Canadian customers. As we explored ways to solve business problems with Power BI, we encountered a situation where their Canadian customers’ financial transactions are in Canadian dollars (CAD), but the client’s reporting was all in US dollars. The client wanted a dynamic currency conversion calculator built into their reporting to show all financials in US dollars. There wasn’t a dynamic currency table in the client’s SQL server. This was a request that I had not fielded before, but I was confident that Power BI could handle it. Below I outline how we solved this particular challenge in a few simple steps noted below. Learn more about how we can partner with you to elevate your Business Analytics. Or head on over to our Power BI resources library for more information.
Millions of users have adopted Microsoft's widespread business analytics platform and are seeing their businesses transformed. Over the past three years, we’ve learned a few tips on how to optimize your teams Power BI training and deployment. Below are 10 Tips for Power BI Training, that will immediately empower your users.
This week I had a chance to work with a client who wanted to start their journey into Business Continuity Planning using the Azure Site Recovery tool. This was their first-time recovery planning, so they wanted to start with a few non-production machines. They could watch for any performance impacts to the machine and end with a failover test. During the experience, I ran into some issues that I thought would be helpful for others.