Agile Analytics is a specialist consulting firm with teams across Australia, New Zealand and the US, and a Microsoft Gold Partner in Data Analytics, Application Integration and Cloud Platform.
They consult, design, and deliver tailored data analytics and technology solutions to mid-to-large size organisations across the world – helping organisations build a data-driven culture, to gain and sustain competitive advantage. The Power BI ecosystem is expanding quickly, and this partnership ensures that clients have access to the right tools to solve their challenges.
“The world of business intelligence is complex, and you need the right team of people just as much as the right software to deliver exceptional work”, said Soheil Bakhshi. “We’re really excited to be partnering with the team at Agile Analytics in Australia and look forward to working closely together over the coming months.”
Whether you’re operating in an enterprise environment or introducing self-service across the organisation, as the number of reports that you’re using or managing grows, things can get out of control quickly.
Document – Instantly see how your reports are structured and identify risks before they become a problem with complete documentation at the click of a button.
Review – See where the data in your reports is coming from without having to go into Power BI or check multiple screens to ensure accuracy of reporting.
Improve – Quickly check whether you’ve been following best practices and magically fix issues right in the app.
“Our focus has always been on positive business outcomes and empowering data driven organisations. We are proud to partner with Data Vizioner and expand our offering to our clients” said Iman Eftekhari of Agile Analytics.
Power BI is taking off, and it’s fast becoming the most popular business intelligence platform on the market. It’s easy to engage with and get professional results quickly, making it the perfect tool for organisations looking to beef up their BI prowess and make data driven decisions through-out the organisation.
Like anything, technology alone doesn’t solve problems – people do, and the road to success is paved by a wide range of users throughout your organisation.
In this post we’re going to look at three best practices for implementation and give you the tips you need to make sure you avoid common pitfalls so you are on the fast track to success with Power BI on your organisation.
1. Setup multiple environments
When working on a Power BI implementation project, it’s wise to have multiple environments to manage the lifecycle of your BI assets. Below we’ve listed several environments that should be considered depending on the complexity of the project and your organisation’s needs.
Development (aka Dev)
Being able to keep on top of the many reports you’re testing, and having the ability to track changes that occur, is essential as you get setup. Without a specific Dev environment, your production environment will quickly become overwhelmed with assets, making it hard to maintain and manage.
When working in the dev environment, make sure that you have data sources specifically for development. We’ve seen production data used in dev on many occasions which can lead to serious privacy and data sovereignty issues. Your dev data sources shouldn’t contain sensitive data.
These development environments can be on your local network, in cloud storage (like OneDrive for Business or GitHub), or a Workspace in Power BI Service.
Tip: The data sources of all published reports to Power BI Service must be sufficient for development use only and should avoid including confidential data.
User Acceptance Testing (aka UAT)
The people who will be using the reports daily are the ones who should be testing them – they know the business best, and will be able to identify opportunities and gaps that the development team may not be able to identify themselves. By making sure the user is brought into the process early on, it maximizes the value added to the business.
User acceptance testing is the last phase of testing. The UAT environment should only be created once the solution has been fully tested in Dev and approved by senior Power BI developers.
As its name reflects, UAT helps with the overall acceptance rate of the solution and drills into the users’ mindsets. Available only to a select group of users, they will have access to published datasets, reports, and dashboards in the UAT environment for testing purposes only.
Tip:All data sources in Power BI must be switched from Dev to UAT before being published to this environment.
Production (aka Prod)
Prod is the most important environment in every organisation as it’s where the whole project comes together. The solution has been through intensive tests during development, audited by experts, peer reviewed internally several times and accepted by the end users in UAT. The iterative process to get to production means we can provide a better solution that has more trust amongst users.
This environment includes real world data and it’s very important that each Power BI report has been fully tested before being published to the “Production” environment. We’re now using live, real-world data so all data sources in the model must be switched from UAT to Prod.
It’s important to remember that despite best efforts, things can go wrong when deploying to Prod. Many organisations will have an exact replica of Prod acting as Pre-Prod environment for deployment and testing purposes. This tends to only be cost effective in larger businesses where there are lots of projects in play. For smaller organisations, the alternative is to bring the UAT environment as close as possible to Prod (while taking into account privacy and security requirements).
Tip: Specific Workspaces should be defined for each business unit (if applicable).
2. Certify your data sources
Reports are only as good as the data that populates them, so we need to take steps to maximise the accuracy of our data. Data sources should be reviewed and certified by data professionals in your organisation and only certified data sources should be used in Power BI to ensure you can trust what you’re seeing.
After the internal review is done, you may come up with various confidence levels for your different data sources. Try to categorise your data sources with some self-explanatory names, for example, Gold, Silver, Bronze. From there you can make the decision to keep or ban certain data sources from being used in your Power BI implementation, in all Power BI projects across your organisation. For example, an organisation may ban all Bronze data sources and only use Gold and Silver in Power BI implementation.
Tip: As self-service BI becomes more common, ensuring the right processes are in place to make sure the data being used can be trustedbecomes increasingly important.
A list of certified data sources should be provided to all parties involved in a Power BI project and like everything, make sure this is documented – which is the perfect segway to our final best practice:
3. Document your setup
As we have seen – a lot of work goes into implementing Power BI so that it follows best practices and delivers value to your business. But as people change within the organisation and knowledge gets lost, you need to ensure you have the right systems in place to maintain continuity – otherwise you may end up having to go through this process again.
Documentation, like certification of data sources, is another governance process that you need to make sure you’ve considered early in the implementation process. Have a plan around how you will approach it and who will be responsible for maintaining it so you can be confident that there is a central place to turn to with information on how the implementation has been completed.
Competing short term priorities often mean that documentation is push aside as it is perceived as time consuming with a longer-term payoff. However, without it, reports can be difficult to work with, hard to handover and challenging to review – costing you significantly more down the track.
Modern documentation tools make the documentation process easy, saving you days, maybe even weeks, so it’s worth investigating smarter ways to pull it together.
Tip: Ensure that you have a way to rapidly document your reports and keep thisup-to-date as your reports change.
We hope these three best practices and tips will help you on your Power BI implementation journey. If you haven’t already, check out our recent governance webinar on Self-Service BI and its Perils which outlines a range of other best practices to consider.
As COVID-19 continues to spread globally, we recognise the extreme pressures health systems are under to flatten the curve and treat those that have contracted this novel coronavirus. Like many of you, we are now working from home. But for so many, that isn’t an option – in particular those providing health services and other essential services that keep our cities and countries running.
Unlike the 1918 Spanish Flu, our ability to respond and contain modern pandemics is driven by data and we want to play our small part in helping where we can. For this reason, we will be providing Power BI Documenter free of charge to all government entities and health bodies that are currently tackling COVID-19 until the end of September.
If you are involved with the provision of these essential services, please talk to us about how Power BI Documenter can help free up your time to focus on the most important things that will help your country in this time of need.
This is available at our complete discretion and is intended for new customers. We will use the New Zealand essential services guidelines as a reference point for the eligibility, although we will consider applications globally.
For businesses currently facing significant financial burdens due to COVID-19 or limitations in new spending we would like help where we can as well so please reach out to discuss and we’ll work with you to find a solution.
Let’s get through this together – our door is always open