Translate Stories into Insights Fast with Microsoft Power BI
Data is a summary of thousands of stories. Right now, amidst the coronavirus crisis, crafting the right story will reveal invaluable insights that will set you up for a better outcome. Microsoft Power BI is one way to achieve short-term goals or stopgap measures.
Data has existed since the beginning of time, but nowadays technology has given us the power to analyze it. Let’s walk through just how to take a situation, such as the Coronavirus (COVID-19) pandemic, and craft it in a way that will allow us to analyze all the data that is coming in.
This high-level introduction to getting started with Microsoft Power BI is based off a simple dashboard Smartbridge deployed to track the COVID-19. In fact, the data showcased in this report is near real-time, while other popular dashboards show data up to a day old.
As we’ve shared in a previous article, it’s critical to invest your efforts wisely in BI projects that will effectively manage and monitor productivity, employee performance, organizational efficiency, and business productivity. In many cases, this can even be achieved with out-of-the-box solutions.
1. Build Your Case
You should always start by coming up with as many questions as possible. Brainstorming and sketching can help you build your case.
Try to find all the dimensions involved in the analysis, a dimension is a way to break the data and might also be known as categories. Countries are an example of a dimension we used in our COVID-19 example.
List out all the measures/metrics to be reported, a measure is a value that can be summarized (sum, avg, etc). For our case, we used Cases, Deaths, and Recoveries as our measures.
2. Source Your Data
Now that you have your case, find a reliable source of data that include those dimensions and metrics. With Power BI Desktop, you can connect to data from many different sources such as:
Databases (Snowflake, SQL Server, Oracle, MySQL, DB2, etc)
Files (Excel, CSV, XML, Jason, etc)
Azure (Database, Data Warehouse, Cosmos, etc)
Power BI (Datasets, DataFlow, etc)
Online Services (Sharepoint, Salesforce, Google Analytics, etc)
3. Clean, Transform, and Reshape Your Data
By using tools like PowerQuery and DAX, you can manipulate your source and get the expected outcome of data that you will then be able to use when it comes to modeling and visualizing.
4. Build Your Model
Data can come from multiple sources/tables. By building your model you will teach Power BI how to understand the relationship between them.
5. Build Your Measures and Visualizations
Now that you have your data available, you need to start by creating measures. For our case, we used Total Cases, New Cases, Total Deaths, New Deaths, Total Recoveries and Active Cases for our measures. Once you have your dimensions and measures you can start building out the visualizations that will allow you to understand the data much more easily.
6. Publish to the Service
For this step you will be uploading the development from your desktop to the web service. You will need to choose a workspace in which your report and dataset will reside.
7. Create a Gateway and Schedule Refresh
Keeping data fresh is always a priority, creating a gateway gives Power BI the ability to query on-premise databases, files, and other sources. Once the gateway is built, schedules can be created.
8. Share with Others
Now that your development is on the service, you can share your insights. Power BI has many ways to share. Some of them are:
Sharing throuh Power BI
Sharing through Teams
Embedding into a website
Embedding into SharePoint
Export to PowerPoint
Analyze with Excel
Smartbridge is a Microsoft Power BI Partner
With Power BI, you’ll be able to create powerful models and visuals with data that you’ve collected for any situation. This will allow your organization to better analyze a situation and take the proper steps to mitigate risks, resolve issues, and make informed decisions to best fit the needs of the company.
There’s more to explore at Smartbridge.com!
Sign up to be notified when we publish articles, news, videos and more!