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:
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.