Power BI is a free (or very low cost) and effective solution to business intelligence. What is business intelligience? Business intelligence (BI) is the process of collecting, transforming, analyzing and presenting data to support and drive business deisions. Data presentation and analysis is frequently listed among the top or most in-demand skills on sites like LinkedIn and Forbes. Data analysts, marketing coordinators and business managers (among many others) frequently need to make sense of all this data and then effectively present it to their team. Power BI is a end-user tool that provides this. A user can import or connect data from multiple sources to make stunning interactive visuals and dashboards with ease. Power BI lets you:
Download Power BI desktop from powerbi.microsoft.com and Microsoft on premises data gateway to allow you to automatically refresh and schedule your reports. To check if your operating system is 64 bit or 32 bit go to Start and type in "about your Pc". You can also download the app to view data on-the-go.
There is hundreds of data sources you can connect to. These include:
There are many different visuals in Power BI. These include line graphs, maps, tables, funnels and much more. The Visuals Library is an active and growing developer community where there are even more visualizations to choose from.
You can easily create custom filters to segment your data with the click of a mouse. This is done with your basic slicer but there are neat ways to filter your data as well. Date slicers have a built-in calendar you can use to easily narrow down specific date ranges. You can create your own filters using custom calculated columns. In addition, there are page and report level filters you can apply on the Power BI report canvas.
Drill down mode work great when you have natural hierarchies. For instance, in your sales data you could have many categories with each category made up of sub categories. Further within a subcategory you have many products. For example a category could be electronics: Sub categories of electronics are tv, computer, radio, etc. Within the tv sub category there are many different products, brands and sizes of tvs. Another example of a natural hierarchy is in a date table where you have years, months and days.
Once you are happy with your reports and visuals on Power BI desktop you can publish it to Power BI Service (online). The benefits of publishing reports are:
In Power BI Desktop select "Publish" at the bottom
Scheduling reports means being able to refresh your data automatically. In the free version you can do this once a day. With Power BI Pro you can refresh your dataset up to 8 times per day. However, you can set up and refresh multiple data sets at the same time.
In Power BI service, select the datasets you wish to refresh:
Initially when you publish a report to Power BI service, only you will have access to it. However, you have the option to share reports/dashboards with others and can even publish to the web where anyone can see.
After selcting the share icon, simply enter in the emails with whom you'd like to share. They will be sent an email and will be able to view but not edit the report.
You can publish your report to the web as an iframe. This will allow anyone to view and interact, but not edit, the report.