Microsoft BI Room for Improvement

Dung dinh tien li?1414330229
Database Expert at a outsourcing company
* Monitoring features: I need Microsoft to provide a set of tools to help me monitor Microsoft's products. For example, when I need to investigate the performance issues of SSIS packages, I do not have a tool, instead I have to write scripts to query data for analyzing performance. * SSIS Connectors: Microsoft needs to provide more drivers to connect other data sources in a native way, which they are doing very well in Power BI, and that we can connect and process data from JSON, SOAP, SAP, Salesforce, and so on. view full review »
D62fcc57 14c7 4516 8ba6 d4337b4cb83a avatar
Partner at a consultancy with 11-50 employees
The navigation. The way you navigate the product, compared to other products in this industry, that could be improved a bit. It's user friendly, but you would like to have it even more user friendly. When you do selections in one tab in Report, and then you move to the next tab, then you have to do your selections again. So one tab as a global, central selection possibility would help. If you compare to QlikView, there's still a lot of functionality that QlikView has that Power BI doesn't. For most companies, Power BI is good enough, especially if you consider the price tag it's an easy choice. But it still has some catching up to do to match the functionality in QlikView. view full review »
Justin larson li?1426024414
Principal Business Intelligence Analyst at a transportation company with 1,001-5,000 employees
No product is perfect, and the Microsoft stack is no exception. The first things that come to mind are Microsoft's recent shift in strategy to focus on cloud first. While this makes sense for them, it leaves the on-premise products lagging in support and new features, while the vast majority of users (mid to large corporations) are still using on-premise solutions and/or are cloud-averse. For example, the announcement that the pricing model for Power BI would change, simultaneously rolling out both Power BI Premium and Power BI Report Server created a great deal of confusion for people who were very enthusiastic about the product. The failures to address concerns with the speed and nature of the changes were felt by users across the spectrum, and it was a situation created by their cloud-first strategy. Similarly, if you look at the tried and true on-premise options for data processing, interfacing with emerging technologies, especially big data technologies, lags behind. This is considerably less true for Azure users, but that is specifically a cloud offering, which again, many corporate entities are not yet ready to embrace. It's easy to think of BI as only the visualization aspect of data, and that point of contact between users and data is absolutely where the rubber meets the road in BI. In reality, there are a whole stack of tools and concepts behind the visualization that enable that interaction - from security, data governance, integration, performance, network and infrastructure, and automation... there are many facets to BI as a system. The visualization aspect, while being the most visible to business users, also happens the be the weakest point in the entire Microsoft BI stack. The PowerBI visualization experience is underwhelming in almost every way compared to many alternatives. Another difficulty is navigating the many products within the suite. There are many components, and each component has many versions. Dealing with feature and compatibility issues with so many versions of so many products can be very frustrating at times. Microsoft does not do itself any favors on this front with the way they name their products. "PowerBI", for example, could be in reference to the desktop design tool, a cloud-based service for publishing and administering data models (which comes with three distinctively different pricing models, the features of which are different and not interchangable), or an on-premise server solution replacing SSRS. You'll make yourself dizzy looking at the Azure services offered. The good news is the sky's the limit, the bad news is you'll have to navigate some pretty cloudy areas to make heads or tales of what to actually use. view full review »
Anonymous avatar x60
Managing Director at a tech services company with 1-10 employees
To add-in the functionality of AI into the reporting, so this can improve further on the product as it is currently. The BI reporting still relies on historical transactions. view full review »
Khumbulani chikura li?1429858974
Business Intelligence Architect at a tech services company
SSMS & SSRS. view full review »
Anonymous avatar x60
Chief Tecnical Officer at a tech services company with 51-200 employees
The following areas could be improved: Publishing and sharing data using PowerBI. People without private emails cannot publish and, frankly, this doesn't allow for easy training. It's not always easy to speak directly with a MS Power BI expert. You have to sign up to the Power BI service using an email address to share and view Power BI reports and dashboards, but Microsoft doesn't yet support personal (.cox, .gmail, et.) or government (.gov, .mil, etc.) email addresses. view full review »
Anonymous avatar x60
Presales Architect at a tech vendor with 51-200 employees
The Windows OS dependency needs to improve. There are some bugs with the new features that have released. It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency. view full review »
6c651f50 a2bb 4d01 923f cd35600cad86 avatar?1441375288
Data Analyst at a tech services company with 51-200 employees
Its ease of use feature is not very intuitive and needs to improve. view full review »
Taner kocakafa li?1421997594
Customer Data Analytics Specialist at Allianz Turkey
Performance can be better; of course, it depends on your hardware but it can also be improved. Once I tried to upload 5 million rows on Power Query from a CSV file but I got an error about my personal computer, i.e., my RAM was not enough for uploading. Also, sometimes this process takes a long time. view full review »
Alper sinav li?1430578613
Head of Information Systems Department at a government
Our expectation is putting BI to work in real-time data collection systems in the maritime environment. The Automatic Identification System is a great source of data regarding the ships from around the world. From kinematic to static including some commercial data, it streams to the maritime monitoring stations. So, collecting and processing of this data and also, creating useful information are the key factors for our government entity. However, this data is real-time data which means that the process should be done in seconds for thousands of ships. We are forcing the boundaries of the Microsoft BI product right now and wish to see some stream data processing methodologies in the future. view full review »
Gregory dinh li?1427980858
Consultant MOA BI at a manufacturing company with 1,001-5,000 employees
SQL Server Reporting Services (SSRS) is not user friendly, requires development. Power BI will surely provide a huge boost to MS BI in terms of self-service BI. Then again, SSRS developers are plenty, thus not so expensive. view full review »
B8186609 4fa0 4a21 bfde 0894fd8fd83e avatar
Senior Software Engineer - Business Intelligence at a tech consulting company with 51-200 employees
There needs to be support for more data sources in DirectQuery. DirectQuery is a method of connecting your data directly, i.e. any changes in data source will reflect in report immediately. (This is very great feature if you are doing live analysis of your data). As of now there are limited number of Data Sources such as SQL, SQL Azure, which are supported by Power BI with DirectQuery. Although Microsoft keeps working on adding different data sources in DirectQuery (currently only six data sources in this method and three more in Preview), that's why I feel that still DirectQuery (method of connecting your data) has more room for improvement because there are many other data sources that are commonly used by different organization like (MySQL, Access, etc.) view full review »
D18c2646 75d4 4671 ad43 aa9d14449524 avatar?1444213539
BI Developer at a tech services company with 51-200 employees
There is need to improve the graphical and dashboard reports; they must have tabs. This gap is usually compensated by QlikView. view full review »
08bfa2ab 50ed 4165 98b4 28b1d82af1f7 avatar
Business Intelligence Analyst & Developer at a engineering company with 1,001-5,000 employees
The few things I mention below constitute very strong reasons why Microsoft has essentially abandoned the platform and why I agree with them. * Lack of mobile support. Reports look terrible on mobile screens. They don’t have the ability to redraw themselves as with responsive UIs. Security remains a hassle on mobile because SSRS relies heavily on Active Directory. * Speed of development is too slow. To be fair, each SSRS report has the potential to be its own business application, aware of who is viewing the report and customizing the output accordingly. Those that take advantage of the advanced features are in for a surprise – developers will spend countless hours squinting at the screen getting every pixel to fall exactly where they want it. Setting up data sources is still a thing for advanced SQL developers. It’s not like other modern BI platforms where stores of data sets are easily converted to dashboards. * Antiquated IDE for code developers extending it. I really wish that the custom code windows provided richer programming assistance (like auto-complete, object-oriented constructs, Intellisense…) and support for other programming languages. view full review »
583ca12e 47ff 419d bb21 c3461e82c201 avatar
Web Developer at a energy/utilities company with 1,001-5,000 employees
The build in Report Builder for end users needs improvement. But for someone that has some training on SSRS, its very straightforward. view full review »
Add nigel
Founder at a tech consulting company with 51-200 employees
License fee structure. Mobile reporting Services is only available for the "Enterprise" addition of SQL Server 2016. This comes with a hefty price tag. Would be better if you could pick and choose the features you require and then the price tag is set accordingly. Rather than paying for the full Enterprise addition and getting a lot of features we do not need/use. view full review »
A4e6f7ca a713 4e24 bfd0 98a9b66716b0 avatar
Senior Consultant | Architect at DHL
Well definitely the connectors, which is always a huge space for improvement in configurations, especially the amount of connectors etc. Also, the graphic designs of the reports needs work as they are still really strictly defined, and with the amount of output, there isn’t space for such a design realization. view full review »

Sign Up with Email