We just raised a $30M Series A: Read our story
2018-05-21T07:41:00Z

What is your primary use case for Microsoft BI?

29

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

ITCS user
Guest
7272 Answers

author avatar
Top 20Real User

I would describe myself as more of a casual user, only because I have so many other things that I have to get done. I wish I could be more of a user, but it's hard. Right now, I have two different main use cases. I use it for teaching. At another institution, I use it for demonstrating how easy it is to build dashboards. It was really to show to all my users the benefit of business analytics. I use it to demonstrate how easy it is to generate your own analytics versus having a department run reports for you then putting it in Excel and making graphs.

2021-09-24T23:07:00Z
author avatar
Top 20Real User

I'm a project manager and we are customers of Microsoft.

2021-09-02T20:30:56Z
author avatar
Top 5Reseller

I've been a consultant, so I've built some reports for some clients. I use and prefer its desktop version.

2021-08-19T20:40:21Z
author avatar
Top 5Real User

I am using this solution to monitor the dashboards that someone else has created.

2021-07-21T14:20:44Z
author avatar
Top 5LeaderboardReal User

We use this solution for our departmental reports, which are accessible from Microsoft Project Server and SharePoint.

2021-06-29T15:28:41Z
author avatar
Vendor

We are using it for financial data, and comparison charts. 

2021-06-21T11:09:25Z
author avatar
Top 10Real User

We have some monitoring data from turbines, and we want to plot the data to monitor the health state of turbines in different time stamps. I tried to download some data from the Postgres database and then do some plotting with that. I also tried to link different plots with each other to filter them and things like that.

2021-06-09T21:21:29Z
author avatar
Top 20Real User

Microsoft BI can be used for business data visualization.

2021-06-05T17:34:11Z
author avatar
Top 5LeaderboardReal User

We use it for reporting. We are using its latest version.

2021-05-19T22:14:12Z
author avatar
Top 10Real User

One of our primary use cases is to build an MSBA-based business intelligence solution for collection agents, so that they can receive daily information relating to bills in the form of ledgers. I've built several packages to import the data from where it has been dumped. I then created the data mask for data analysis to showcase all the outputs and conclusions. As a result, there is a clear breakdown of total collections, the different parameters, customer-based information, and other essential information. We are partners of Microsoft BI and I'm a solutions architect.

2021-05-12T12:29:06Z
author avatar
Top 10MSP

We primarily use the solution across many company verticals and within every area of the company - including finance, accounting, operations, logistics, HR, et cetera.

2021-04-21T20:19:55Z
author avatar
Top 5Real User

We are using it for analyzing transactions. In the products that we develop and supply to our customers, there are some applications that are connected to payments. We analyze the trend of transactions or payments that are done in our system by our clients. We want to understand how our clients are using our solution and if there are some conditions that are making them use our product more than others. We also analyze who is paying and how much, and how and at what time are they using our system.

2021-03-26T17:03:07Z
author avatar
Top 20Real User

It is for dashboards and reports.

2021-03-26T13:39:50Z
author avatar
Top 20Real User

We are using it for reporting ERP data, IT service data, financial data, and so on.

2021-03-25T18:07:44Z
author avatar
Top 10Real User

We mostly use this solution for dashboards and reporting. There are roughly 2000 people in our office. At the least, 100 people use Power BI. We have around 10 super users who use it a lot. A lot of people just use it to look at dashboards. A lot of managers look at Power BI for their dashboards.

2021-03-11T08:57:48Z
author avatar
Top 20Real User

I have used the solution for analytics which is displayed on the dashboard for my client.

2021-03-03T16:15:36Z
author avatar
Top 20Real User

We primarily use the product for running the reports and all data extraction in our organization.

2021-03-02T22:16:49Z
author avatar
Top 20Consultant

Our primary use case of this solution is as a reporting tool. We implement it for our clients. I'm a consultant in business intelligence and we are customers of Microsoft BI.

2021-02-27T08:22:58Z
author avatar
Top 5LeaderboardReal User

Enterprise reporting and digitization of dashboards using Microsoft Power BI, SSRS and Azure Reporting DB by integrating several applications to establish single version of truth.

2021-02-25T14:57:28Z
author avatar
Top 20Real User

I am a consultant for a big company. We deal with energy companies, petroleum, sales companies and we deal with everything from financials to operations. We deal with market strategy and we provide consultancy services - I'm a part owner of the company.

2021-02-23T21:06:10Z
author avatar
Top 20Real User

We primarily use the solution to run our industry reports. We get the data from data warehouse we are creating. I use it to export the data. We have been using Microsoft BI for one of the customers. That was completely in the customer environment. That's all. We did not have that solution for us in-house. However, we are working towards introducing it for our own purposes in the near future.

2021-02-16T19:37:03Z
author avatar
Top 5LeaderboardReal User

We primarily sell Power BI licenses. Mostly, we focus on the retail industry. Usually, we are using the Power BI reports for dashboards. We are also providing our customers with some data warehouse reporting. Basically, we do long-term categorization of stock and inventory numbers and sales figures so that they can compare the sales and stocks to the inventory numbers. We tend to deal with physical inventory reports. We tend not to deal with the solution for financial operations.

2021-02-12T11:50:52Z
author avatar
Top 20Real User

We primarily use the solution for building dashboards, one-off analytics, and things of that nature that combine data.

2021-02-08T17:07:47Z
author avatar
Top 10Real User

We use it mainly for Qlik Sense. We're using business interests analytics. Everyone from marketing to sales uses it. Microsoft BI is usually used for oversight.

2021-02-04T16:14:43Z
author avatar
Top 5Real User

I use Microsoft BI for my own projects that are related to integrating with Excel datasets. I use the visualization and graphing functions, and I have tried using the Python integration.

2021-02-03T10:48:30Z
author avatar
Top 5Consultant

I lead the data visualization competency. As a competency leader, my responsibility is to make people grow in this technology. It could be Power BI, Tableau, or QlikView. We are service-oriented, and depending upon the demand, we have to have experienced people and a resource pool ready in these areas. Depending upon the requirement, I decide how many people need to be trained or hired.

2021-02-03T09:10:29Z
author avatar
Top 5Real User

We have integrated this solution into the software that we created for a client specifically for reports and data consumption. It is a hybrid infrastructure project with hybrid integration. It has a lot of reports executed or created from the cloud.

2021-01-31T07:02:24Z
author avatar
Top 10Real User

This solution is primarily used for business analytics. We generate reports so that the business analytics team can use them for their analysis.

2021-01-30T05:46:10Z
author avatar
Top 20Real User

We primarily use the solution for integrating into our ERP so people can have a dashboard analysis of whatever is important to analyze or compare, whether it be top-selling products or sales performance, or quota analysis.

2021-01-29T05:58:34Z
author avatar
Top 10Real User

I use Microsoft Power BI for analytics. It is an online service for business intelligence. I use it to analyze every piece of data that I have. My key performance indicators are on Power BI. My sales indicators, such as number of clients, number of sales and region, type of client, type of solution, due to date comparison, and due to year comparison, are really based on the sales of the company. I am using Power BI Pro.

2021-01-22T23:46:37Z
author avatar
Top 10Real User

We are an analytics company, and we consult for different companies. Currently, we were doing automation of financial reporting, income statements, balance sheets, cash flow, and different kinds of analysis on revenue and products. We extract data from ERP solutions, accounting data, and then we transform that into financial reports.

2021-01-21T19:20:09Z
author avatar
Top 20MSP

All our operational dashboards are on Microsoft BI. Visualization is primarily what we use Microsoft Power BI for today. We're in a position to explore all the underlying data. For example, your SLAs, how they're trending month on month, or how your backlog of tickets is going. We look at all the respondent resolution SLAs or different priorities every month. If there's a dip somewhere, we're able to double click and then go to the actual client or the ticket, which has caused a problem. You can go back and see if you need to do anything to recover from that situation. For example, if your SLA brings 25% and if you're dipping to 94%, go back and see why you're dipping. If there are, let's say, too many incidences from a specific technology or a specific client, go back and see what you need to do to fix those things. We're now looking to get to the next level with exploratory analytics. We want to go into what we call explanatory analytics, which analyzes the underlying data. Instead of waiting for something to fail, you come out and say, "Hey, these are some areas that are not working well, and you probably need to look at it." We're trying to use Microsoft BI and for what we call actionable insights. This tool should be able to build up and show you what the underlying data is telling you. For example, our affiliates may be trending at 95%, but since we run a shared service, there could be some clients where it's 100% and some clients where it's probably 85%. Those claims could lead to a client-side problem or a client satisfaction issue. Explanatory analytics can give you such exceptions automatically. Then you can go back and work on those clients to ensure that you pull your SLA back up from 85% to 95% and ensure that customer satisfaction doesn't dip.

2021-01-12T15:44:28Z
author avatar
Top 5LeaderboardReal User

We use Power BI to manage all business indicators. Our customers' files, operations, number of transactions, satisfaction levels, history. We have a very powerful dashboard we use in Power BI and all our customers use it. I use it to drill down data from customers, to make decisions regarding business and other things. We are Microsoft partners and I'm a board member of our company.

2021-01-10T08:16:16Z
author avatar
Top 10Real User

We use Microsoft BI on our portfolio management platform. We use live dashboards, in the public cloud.

2021-01-05T09:08:00Z
author avatar
Top 5MSP

We have a few projects. We're using the solution primarily to develop a modern sitemap.

2020-12-23T21:41:56Z
author avatar
Top 5LeaderboardReal User

I have taught and mastered many desktop tools, including Power BI, for the purpose of prototyping designs for business intelligence and data warehousing. Currently, I am teaching data analytics at graduate level and Power BI is on my schedule. We teach tools like Power BI by going through common scenarios in a business intelligence environment, which most often deal with the factual numerics that get designed into a sales force reporting dashboard or similar solution, showing details like order placement, orders shipped and paid for, etc. The templates for these typically use a style of diagramming called star schema, which is a common dimension modeling technique. I can't say whether it's the most frequent real-world use case that a real customer would focus on, but for the level of our tutorials, a sales scenario might involve a description of customers, products, locations, maybe geography, and the timing of sales for trends analysis. Other than Power BI, I also teach AWS and Azure, where I help guide students to plan and come up with architecture for deploying to the cloud. It's not actually very hands-on, as it's more to help with architecture diagramming for the intentions that students have when using them. And at our institution, all of our courses last only four weeks, so it's very fast tracked, which sometimes means that we don't really go too in-depth. AWS has a lot of samples and diagrams, including many graphics that are fairly artistically detailed. The level at which I've helped students reference those kinds of diagrams is mainly for their team projects, to illustrate their intention, for example, to deploy a database into AWS. If it's an SQL Server database, we usually choose Azure. But it's not to actually do it. It's rather to have the intention to, for illustration purposes.

2020-12-13T06:21:00Z
author avatar
Top 5LeaderboardMSP

We are a service provider and Microsoft BI is one of the tools that we implement for our clients. We do not use it ourselves. My primary use case is integration, but it is also used for reporting and data analysis services.

2020-12-09T14:37:26Z
author avatar
Top 20Real User

In general, we use it to have access to the data that we have processed from the HCM system and also to deploy it to the teams. Because it has low-level security features, I can guarantee that only selected people have access to the information seamlessly. We don't take a lot of steps to create, for example, different profiles and ensure the data security that I need. It is on the cloud because we have pro accounts. Usually, we have the desktop version for designing and using ourselves here, but when we deploy this, it is usually on the Microsoft cloud; it is not on-premises. We are using the most updated version because they release monthly updates.

2020-12-08T00:15:42Z
author avatar
Top 20Real User

I take care of business transformations in the company, which includes solution transformation, and so on. We have a range of products that are legacy products. They are fairly old. We are substituting them with new age products, and one of them is Power BI. We are using its latest version currently.

2020-11-27T11:58:15Z
author avatar
Top 5Real User

Microsoft BI can be useful for several scenarios, depending on your end audience, or what they're looking for. Depending on your creativity, imagination, and what the tool allows you to build, you can create a lot of cool things with it. You can build a lot of very elaborate and dynamic reports for example. The most important thing to consider is to understand what your audience is looking for. The development side of the tool is not the problem.

2020-11-23T18:06:00Z
author avatar
Top 5LeaderboardReal User

Usually, when dealing with business intelligence projects with big data, all customers have Office 365 but within these licenses, Microsoft BI is often included.

2020-11-22T15:44:00Z
author avatar
Top 10Real User

We use Microsoft BI for the visualization of data. We also hope to use it for machine learning as it's very powerful, but at the moment, we are trying to get authorized for reporting and analysis.

2020-11-13T15:11:22Z
author avatar
Top 10Consultant

We primarily use Power BI for data science solutions.

2020-11-09T16:54:26Z
author avatar
Top 10Real User

We use this solution to analyze financial statements from our partners. We build dashboards to see information on a product that is offered by one of our local telcos.

2020-10-29T15:10:53Z
author avatar
Top 5LeaderboardReal User

I am currently a management consultant and, before my current employment, I was a management consultant as well. I also had a stint with an online retailer in India. My usage with Power BI has been in the area of practical day-to-day operations, web host operations, and equipment status monitoring.

2020-10-29T10:20:47Z
author avatar
Top 20Real User

It is mostly used for monthly cost reports for our department. We are also using it as a dashboard for giving some overview for management purposes. We are using the latest version.

2020-10-26T09:30:22Z
author avatar
Top 10Consultant

Integrate information handled in silos, BI is a perfect tool for visualice different MS Excel sheets into a focus context for risk dashboards and operational information.

2020-08-24T19:46:16Z
author avatar
User

MS BI is our primary BI tool for entire company. We have a whole MS BI ecosystem: SSIS->Database/DW->SSAS->SSRS/Power BI. it is great and very cost effective.

2020-08-21T20:07:09Z
author avatar
Top 20Real User

We have SharePoint in our company and then we just wanted to visualize that list and it connects to the Check Point list.

2020-07-26T08:19:00Z
author avatar
Top 20Real User

Our primary use case is to learn what Power BI can do. We also use it to create dashboards and to see what is available for people to use. We see how it integrates with Excel. You can easily get the data into a visualization but also still have access to the underlying data. We use it see how we can move away from an Excel spreadsheet but still give the users the correct answers to the questions that they have. I want to move away looking and fixing issues on particular lines and be able to easily answer the questions with visualizations so users can answer the questions a lot quicker and adapt to changes easier.

2020-05-26T08:17:00Z
author avatar
Top 10Real User

Daily updated production indicators dashboard: We get production data (Number of pieces, downtime, and downtime reasons) from the shopfloor and input them on an Excel sheet.

2020-04-09T23:19:00Z
author avatar
Top 10Real User

Our primary use for this solution is geospatial analysis.

2020-02-19T10:25:00Z
author avatar
Top 10Real User

Our primary use is real-time & batch analytics on Postgres databases in combination with MS Excel.

2020-01-09T23:04:00Z
author avatar
Top 5LeaderboardReal User

Since we are a consulting company, our cases vary from customer to customer and from department to department, but mainly we have found two "standard" cases: Business users connecting to a DWH, or trying to consolidate several Excel workbooks to create business dashboards. In the DWH cases, it is simpler since most of the data transformations and modeling are done by IT, but in the 'spreadsheet world', it becomes more complicated. Users try to move from a huge table filled with numbers and "color-coded" cells to data visualizations, sometimes not even knowing how to write a simple Excel expression.

2019-12-28T16:15:00Z
author avatar
Top 5Real User

Power BI is a great tool for analytics. It is useful if you have a requirement to create a dashboard with self-service capability, along with KPIs, and you want to drill down to the data details.

2019-12-05T15:54:00Z
author avatar
Top 5Real User

I have developed and deployed more than twenty separate customer solutions. I am a Business Intelligence Deployment Specialist. The most significant implementation was to reduce the Financial consolidation time for one hundred and twenty companies into one shareholder report, from thirty days to four minutes.

2019-10-21T11:12:00Z
author avatar
Consultant

The primary use case was mainly to create dashboards and present them for reporting purposes. We use Microsoft Power BI to create dashboards, provide insights, and use its various analytical and insight functions to send to either the departmental manager or the general manager of marketing and sales or retail ops.

2019-05-22T07:18:00Z
author avatar
Top 10Consultant

We use this for data analysis and the creation of indicators. It is one of the most powerful tools for BI in my experience. It works very fast, is intuitive, and useful. You just drag and drop, as soon as you download it.

2019-05-06T15:17:00Z
author avatar
Real User

* Running a team to build end-to-end BI solutions for large enterprises. * Data typically stores in SQL Server. Some ad-hoc data pulled from SharePoint lists or Excel files. * Use of SSAS Tabular in some models. * Currently, no deployment of premium. A large deployment of PBI Pro. * We also use Tableau Desktop and on-prem server, but Power BI was a go-to product.

2019-04-04T22:56:00Z
author avatar
Real User

* Management BI/dashboard reporting * Quick sharing of data from source to business users which is very useful.

2019-01-25T06:25:00Z
author avatar
Real User

I primarily use this for creating dashboards and reports for the oil and gas industry.

2019-01-20T07:09:00Z
author avatar
Consultant

My primary use case is for the performance, compared to MS Dynamics NAV, and flexibility in data and dashboard building.

2019-01-09T11:10:00Z
author avatar
Real User

It is a good platform for data analysis, organization, and all of the other interim performances that are necessary.

2018-11-22T10:29:00Z
author avatar
MSP

The primary use case for this solution is mirroring it to the dock so we can match up different parts of Office like Excel, Word, etc. and then we can clear it.

2018-10-24T14:07:00Z
author avatar
Real User

My primary use case is for view of the dashboard.

2018-09-25T09:23:00Z
author avatar
Real User

We use Microsoft BI for all of our data analysis processes.

2018-09-25T09:23:00Z
author avatar
Real User

Our primary use case is for data prediction. We use our predictive model index, and then express the data to Power BI.

2018-08-01T07:08:00Z
author avatar
Real User

Using it, I receive financial information from the financial department.

2018-07-25T07:31:00Z
author avatar
Real User

It is a good solution. We use it for analyzing and visualizing data relating to warehouses and connections from other ERP systems, etc.

2018-07-18T07:08:00Z
author avatar
Real User

Its primary use case is for CIPs from the purchasing department. It performs perfectly. It is very quick and easy to use.

2018-07-04T06:10:00Z
author avatar
Real User

It's primarily for reporting, and the performance has been very good.

2018-06-03T09:17:00Z
author avatar
Real User

Visualization and minor analytics. It has performed quite well thus far.

2018-05-21T07:41:00Z
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
541,108 professionals have used our research since 2012.