Microsoft BI Primary Use Case

Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
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. View full review »
Northern Europe IT Business Intelligence Manager at Adecco
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. View full review »
Sai Krishna J
Manager, BI & Analytics at a consultancy with 11-50 employees
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. View full review »
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,249 professionals have used our research since 2012.
Gary Gonsalves
Consultant at a consultancy with 11-50 employees
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. View full review »
Compensation Coordinator at a computer software company with 1,001-5,000 employees
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. View full review »
Oscar Estorach
Chief Data-strategist and Director at
Usually, when dealing with business intelligence projects with big data, all customers have Office 365 but within these licenses, Microsoft BI is often included. View full review »
Consultant at a computer software company with 10,001+ employees
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. View full review »
Jose Barbosa
Board Member at GTI Digital
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. View full review »
Samuel Kamau
Co-Founder at Beta Edge Technology Limited
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. View full review »
BI Consultant at eInfochips
We primarily use Power BI for data science solutions. View full review »
Business Intelligence Developer at Kathmandu
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. View full review »
Executive Vice President at a security firm with 201-500 employees
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. View full review »
Praveen Chaudhary
Senior Consultant at a computer software company with 10,001+ employees
We have a few projects. We're using the solution primarily to develop a modern sitemap. View full review »
Jorge Barroso
Consultor at Scitum
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. View full review »
Head of Digitalization at a mining and metals company with 5,001-10,000 employees
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. View full review »
Alberto Guisande
Director at Decision Science
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. View full review »
Rohit B
Lead Statistical Analyst | Innovation Champion at a pharma/biotech company with 10,001+ employees
We have SharePoint in our company and then we just wanted to visualize that list and it connects to the Check Point list. View full review »
Marian Petkov
Team Leader at Eurobank EFG Bulgaria AD
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. View full review »
Innovation & Project Portfolio Management Practice Director at FACTUM
We use Microsoft BI on our portfolio management platform. We use live dashboards, in the public cloud. View full review »
Data Analyst at a tech services company with 201-500 employees
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. View full review »
Mark Cunningham
Regional PDS - Director of Business Intelligence at JLL
* 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. View full review »
BI Analyst at eVision Industry Software
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. View full review »
Data Scientist at Packen SAS
Our primary use is real-time & batch analytics on Postgres databases in combination with MS Excel. View full review »
Microsoft Dynamics Specialist at Strategix Business Solutions
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. View full review »
Diógenes Eloi
Consultor at PwC Brasil
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. View full review »
Balaji Ram
IT & Projects Development at Mohamed Hilal Group
* Management BI/dashboard reporting * Quick sharing of data from source to business users which is very useful. View full review »
Vice President - HSE Engineering at Reliance Industries Ltd
Our primary use for this solution is geospatial analysis. View full review »
Bart Witteveen
ERP Consultant MS Dynamics Nav at Witteveen Logistics & IT
My primary use case is for the performance, compared to MS Dynamics NAV, and flexibility in data and dashboard building. View full review »
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
456,249 professionals have used our research since 2012.