The spreadsheet has been around since the 1990’s and has pretty much revolutionized the business world’s capabilities to work with and analyze data. However in recent years new technologies such as Microsoft’s Power BI have fundamentally changed how we work with, understand and interpret our data. The mighty spreadsheet is an incredible tool. It easily digests data – spitting out new calculations with ease. However creating the calculations and tables takes time. The business user diligently enters rows and columns of data and creating new formulas – all taking a lot of time. If you want to see the data from a new perspective; you have to create a new table and populate – all taking valuable time.
Power BI is Microsoft’s latest Business Intelligence technology. Power BI makes it easy to create new reports, visualizations and dashboards. Instead of having to create tables of data or huge number of formulas like you do in spreadsheets; Power BI uses a drag and drop interface to easily construct tables and graphs in seconds. Power BI also includes new filtering and highlighting technologies that creates interactions and relationships easily – allowing the user to get new insight and intelligence.
So if you have exhausted the capabilities of the spreadsheet and you want to bring a new dimension to your reports and dashboards try out Power BI today www.powerbi.com. If you are interested in improving your Power BI and Excel skills visit us atwww.powerbicollege.com.
In this brief blog we are going to look at the steps to create a percentage Pie graph in Power BI. We are going to work with a Human Resource data source that includes the training costs of a company. We are going to create a small interactive dashboard that displays the number of employees trained, and the total training cost. In addition we are going to display the number of employees trained by gender. We are also going to display the training cost by department as a column graph.
The first step is to load the training data into Power BI and to create the interactive dashboard. We have used Card visualizations to display the number of employees trained and total training cost. As previously mentioned the training cost by department is shown as a column graph and the pie graph displays the number of employees trained by gender.
The dashboard displays the number of employees trained by gender. The graph would be much more useful if it displayed the percentages on the pie graph. Power BI has introduced a great new feature called the Quick Calc. The Quick Calc calculates the percentage of the grand total and can be displayed on the pie graph. To calculate the percentage, select the value and select Quick Calc. The Show Value As is changed to percentage of grand total. The pie chart formatting option is also changed. In the formatting option select the details label. Change the label style to both. This will display the percentage on the graph.
The interactive dashboard can be filtered to display only one gender. Click on the Female gender.
Another option is to click on one of the departments and this will display the percentage of number of employees trained for that department in the pie chart.
Power BI is Microsoft’s latest Business Intelligence technology and tool for business users who want to understand their data. Power BI has been developed for the hundreds of millions Excel and other spreadsheet users who want an easier, quicker and far more productive method of analyzing data and creating interactive dashboards. So what is Power BI and why is it so important? Power BI takes your data – it can be any type of data – business, marketing, sales, human resource etc. and turns it into easy to use powerful interactive dashboards and reports in minutes. Power BI is easy to use; just use drag and drag interactions to build your cards, tables and visualizations with a few clicks of the button.
Power BI also provides new methods of filtering, highlighting and visualizing your data. These new technologies make it easy to understand new patterns and relationships within your data leading to new intelligence and insights.Power BI is based in the cloud therefore making it easy to distribute and share dashboards and reports. Microsoft have invested heavily in making Power BI work with the Internet and it does not matter whether you are using laptops, desktops, tablets or smartphones. It also does not matter whether you are on Windows, Android or Apple – Power BI will work with them all.
In short Power BI is probably the most important new technology since the development of the spreadsheet.
If you are interested in trying out Power BI – Go to www.powerbi.com and sign up for a free account. If you would like to improve your Power BI or Excel skills – visit us at Power BI College www.powerbicollege.com