Dashboard creation has been gaining importance in business direction and strategic decision-making since data collection is easier to retrieve. Microsoft Power Platform’s Power BI is one of the biggest apps related to business intelligence. It allows you to connect to multiple sources, create attractive and interactive dashboards, and share them across multiple users. The best part is that all your data will be connected in real time without requiring strange and difficult connections.
Before getting into the dashboards building, there are a few things that you must learn to ensure user engagement and information retention:
Before creating Power BI dashboards, you must download the Power BI Desktop app, which you will find on the Microsoft page. After downloading it, you can start building without any problem.
There are multiple data sources that you can connect, which will lead to creating a report. You must know that the visualization comes from reports in the dashboards, and each report is based on a dataset. Think of a dashboard as a way to underlying reports and datasets.
Connecting dashboards to data sources is as simple as opening the app and selecting the “Get data” button. Then, you should look up the data you want to connect to:
Excel remains one of the most used spreadsheet apps, and as a part of Office 365, connecting it to other Microsoft Apps is essential. Luckily, Power BI has multiple ways to bring data from Excel, and the first one is by searching the connector exactly as explained in the first point.
However, when you first open the Power BI app, you’ll find a button that allows you to select reports created in Excel, and there’s even a button called “Excel Spreadsheet” next to the “Get Data” button. All these options are practically the same.
SharePoint lists are an excellent option to store data and share it with multiple users, and Power BI can be connected to it through different options. You must select the “Get Data” option and then search “SharePoint” in the pop-up window.
You may find three different options:
After selecting one of those options, you’ll need to put the URL of the SharePoint that you want to connect to:
SQL Server is one of the most useful connectors inside of Power BI, mostly because you can connect to different apps through it, even if they have not a specific connector inside of Power BI. Using it is as simple as selecting the “SQL Server” button next to the Excel button. After clicking on it, it’ll open a pop-up window:
It is important to have the Server and the Database to which you will connect to. For example, if you want to connect to a Dynamics CRM App, you will have to input something like this: myorgname.crm.dynamics.com,5558. The ports 5558 and 1433 are always open as endpoints to Power BI.
You can also select the Data Connectivity mode, which can be:
Don’t forget to use SQL Statements to simplify the quantity of data that you’ll import.
Customizing dashboards in Power BI is very simple. You’ll need to have any type of visual inside the page (charts or reports) and select which one you want to edit. After selecting it, you’ll be able to set which filters you want to be applied to that visual, which columns it will include, and which order they will have.
Also, you can edit the visual format by clicking on the upside button, which will allow you to edit the columns’ colors, values, sizes, and totals. You can even customize cell colors by condition!
Power BI has an interactive platform from the first time you start using it, with numerous new capabilities for Power Platform. For example, if you click a row inside a report, it will automatically filter all the visuals inside the page depending on the row you selected.
However, there are more creative ways to make interactive dashboards, such as including buttons, sliders, or filters; it is up to your imagination. Power BI also allows you to import customized visuals that can be used to create more interactive dashboards.
Following the last section, some ideas that you might have while creating dashboards are:
As said before, Power BI has great capabilities; the only limit is your creativity. Brand new visuals even allow you to create an aquarium that displays data through fish!
It is important to know that Power BI is part of the Power Platform. The Power Platform is a complete suite of apps based on the same database: the Dataverse. The best part is that you can use them all above as they’re in the same ecosystem. For example, you can automatize a flow that sends an email when a field inside Power BI gets to a specific value, bring all your data from Dynamics 365 apps (such as Supply Chain Management, Marketing, Human Resources, and more), or embed dashboards inside Power Pages. Building automatizations and connections across the Power Platform allows you to create powerful dashboards that can be useful while seeking important data.
To sum up, Power BI is an easy app to learn, use and apply. One of the industry leaders, with a solid performance and wide coverage of connections to search for data, working across multiple apps and making decisions a lot easier. Don’t hesitate to use these apps and render the processes inside your business.