TrustRadius
Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.MicrosoftExcellent BI Stack for an all-in-one solution architecture, however may need specialized platforms for non-traditional datasets2019-09-05T14:36:36.030ZWe implement Microsoft BI solutions to clients across North America. Clients are constantly coming to us having issues gathering their data from disparate sources in order to make meaningful decisions with their information. Depending on the client and their licensing agreements, we will then evaluate options, and the Microsoft BI stack tends to be a leader of the pack to solve many client data issues.,Great traditional ETL data gathering tools.
Large technical user community.
Excellent data visualization tools.,The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.,8,Denodo, SAP BW/4HANA and Tableau Desktop,8,7,Denodo, SAP Crystal, HighchartsVerified UserMicrosoft BI is great if you're looking for a BI product that feels like the other Microsoft products you use2019-01-10T01:20:13.027ZMicrosoft BI is used across many departments within the organization. Due to the availability of other software tools, Microsoft BI is only used in certain parts of the business. Microsoft Power BI is used for automated data reporting and interactive visualizations. The software is also used for some analytics processes.,As with most every other Microsoft product, Microsoft BI makes setting up and analyzing data about as easy as it gets.
Creating graphics is very easy.
Connecting to multiple data sources works just fine.
Simple reporting and integration with other Microsoft products is great.,Microsoft BI is not top of the for advanced analysis and modeling.
Reshaping and restructuring data is doable, but not super simple.
Customizing visualizations is sometimes difficult to impossible.,8,Tableau Online, Tableau Public, Alteryx Analytics, TIBCO Spotfire, MicroStrategy Analytics, Microstrategy Usher, SAS Business Intelligence, SAS Advanced Analytics and SAS Data Integration Studio,9,8,Tableau Online, Tableau Public, SAS Business Intelligence, SAS Advanced Analytics, Alteryx Analytics, Microsoft SQL Server, MySQLThomas YoungMicrosoft BI - Putting the power into your reporting2019-01-23T18:50:51.581ZWe use Microsoft BI primarily just within our lab group and department due to its very specific and powerful data visualization capabilities. While it is applicable to almost any work involving data analytics, it might seem like overkill for some people. We have found that it does an excellent job in preparing and displaying the more complex data that we deal with.,Data display in graphs and tables
Compatibility with other Microsoft products
User-friendly and informative reporting,Data compatibility with non-Microsoft products
Data sourcing functionality is poor
Offline server functionality impedes out of country work,7,Torqus Systems POS, UltiPro, Sisense, Domo, Zoho Analytics, Dundas BI, Looker, Qualtrics, Infragistics ReportPlus, QlikView, Tableau Desktop, SAP BusinessObjects Business Intelligence (BI) Platform and IBM Cognos,5,9,Torqus Systems POS, UltiPro, Sisense, Domo, Zoho Analytics, Dundas BI, Looker, Qualtrics, Infragistics ReportPlus, IBM Cognos, SAP BusinessObjects Business Intelligence (BI) Platform, Tableau Desktop, QlikViewShelby BowdenOutstanding Report Creator2019-01-17T18:52:15.283ZSeveral people that I know use Microsoft PowerBI. It is mainly used for reporting for several teams, then I am able to access those reports for my own use. When I use it I import Excel sheets in, and use PowerBI to make them more visually appealing and easier to filter. It works like a charm. I have not seen any issues other than the occasional drag with data sets.,Makes reports more visually appealing
Very good variety of formats for charting information
Good cloud connectivity (most of the time),Need to be proficient with Excel before diving into PowerBI
Only available with a monthly subscription
Steep learning curve for many users (including me),10,Whatagraph,10,10,Microsoft 365 Business, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Cisco Aironet Access Points, Cisco Data Center Network Manager, Oracle VM VirtualBox, Oracle Java SE, DameWare Remote Support, Microsoft System Center Configuration Manager, Citrix NetScalerMichael TimmsMicrosoft BI - A diamond in the rough2019-01-16T15:27:20.293ZData modeling, visualization, and analytics.
Microsoft BI is currently only used for dashboarding (descriptive analytics), where data relationship is simple, while most of the predictive analytics are done in other tools.,Easy integration with other Microsoft products.
Great integration with R/Python.,Map visualization limit on data count
Inability to model data relationship with multiple non unique keys,7,TIBCO Spotfire,9,9,TIBCO SpotfireIvan LeungBusiness Intelligence like you never seen before2019-01-10T03:29:31.254ZMicrosoft BI is being used by specific departments, providing analysis of different types of data, how resources are being used and even showing how well Support Departments are doing, responding to tickets that are eventually fed to Microsoft BI. There are many problems being addressed, including allowing several types of connections to our data.,Allow many types of connections to our data
Makes impressive graphics from the data collected
Provides interactive resources and dashboards,Should have support for other operating systems
Prices could be a bit better for organizations with more users,10,Zoho Reports,6,10,Microsoft 365 Business, Windows Server, Microsoft Exchange, SolarWinds Netflow Traffic Analyzer, Google Ads (formerly AdWords)Jean FrancoPower BI just works!2018-12-06T17:46:28.032ZWe currently have limited use of Power BI within our IT and accounting departments for relaying reporting information. We use Power BI to create an efficient interface for our executive team to gain access to vital sales information from our restaurants in a concise, detailed manner as opposed to our traditional Excel spreadsheets. IT uses Power BI to track purchasing as well as within our help desk department.,Great for translating numbers in graphics that are easy to understand and manipulate for anyone with no technical expertise,Additional training and tutorials that exist with Power BI as users are working with it would be beneficial.,9,9,8,Microsoft Office 365, Microsoft Dynamics GP, Windows ServerJason ShawMIcorosft BI - Gather, share and take action on your data2018-10-19T16:45:01.800ZMicrosoft BI is a great tool to allow for the visualization and communication of data to my whole team. Microsoft BI is being used in conjunction with many operational KPI's to better drive action and responses to improve or address issues that arise. The main problem solved by BI is the ability to gather and bring together information from multiple sources and unify this data.,Bringing data together from multiple sources
Allows for graphical representation of data to improve communication up and down the management chain.
Tracking of data for use in the future,Could be more user friendly
Improve the learning curve for new users
Allow for better integration with mobile app.,4,SAP Access Control,8,6,Microsoft 365 BusinessBrian CaulfieldMultiple tools in single package.2019-01-12T19:04:31.747ZIn my organization, we are using MSBI to create, maintain and deploy reposts. We use all three component of MSBI like SSIS, SSRS, SSAS. We use ETL packages to maintain Dataware hosts using SSIS. We create reports using SSRS and analyze the data using the SSAS tool,Create packages to move data and perform different data related tasks using SSIS
Create reports to summarize the data in an understandable form using SSRS
Analyze the data provided by teams and create data cubes and reports to understand the data properly using SSAS.,It should be an open source tool for a vast variety of implementation.
You need to buy a licensed server to maintain MSBI
Need a proper course or content to learn concepts, which sometimes creates difficulty.,8,Pentaho, WebSphere DataPower Gateway and Informatica Enterprise Data Integration,8,8,Microsoft Office 2016, Pentaho, Skype for Business (formerly Lync)Lakhan SuriGood for visualisations and reporting!2019-03-19T16:12:34.263ZMicrosoft BI is used by a few data teams in my organisation in conjunction with other business intelligence tools. One of the primary reasons for using Microsoft BI is its simplicity, user friendliness, and good palate of visualisation options. Unlike most other standard BI tools in the market, Microsoft BI does provide a good array of graphical representations - thereby making it a good choice for reporting purposes.,Good range of visualisation features.
Very easy to setup and get onboard.
Handles data integration from multiple sources decently well.,Not advisable to use Microsoft BI as a standalone primary tool for data management.
The process of moulding or repurposing data is not easy.
Integrating Microsoft BI with non-Microsoft tools is a huge pain.,7,Oracle Business Intelligence Cloud Service, Tableau Public and Looker,6,8,Looker, Tableau Server, Power BI For Office 365Verified UserGreat BI tool2019-02-05T14:16:56.387ZWe have been using a number of Microsoft products in our company and decided to go with the Microsoft BI platform due to its easy integration with Microsoft Office suite. We wanted to incorporate a business intelligence tool into our enterprise to get a full 360 view of our mission-critical data. Microsoft BI helped fill that role.,Report generation from our back end data warehouse has become way more streamlined using this tool.
By using the Power Pivot and Power View it has enabled us to access and mash up data from a variety of sources. Plus it can easily be shared with other users through simple Office applications.,The implementation time for Microsoft BI can be fairly lengthy. It's definitely longer than some of the other products we evaluated.
The upfront investment in terms of capital and time is fairly large with this tool. It requires a compliant Microsoft SQL server in the back end to leverage most of its functionality.,8,Oracle BI Foundation Suite,8,8,Adobe Advertising Cloud, Amazon DynamoDB, Amazon CloudFront, Amazon Elastic Compute Cloud (EC2), Amazon CognitoVerified UserFor the IT professional on the go2019-01-24T00:00:24.724ZWe use it in various pockets across our organization. We use trend analytics, reports, and interactive dashboards all the time, but the real workhorse is the Marketing cost data aggregation toolkit. We also connect PowerBI with SQL integrated OLAP databases, enabling us to leverage data housed within SAP with extracted data to create visual dashboards to track various KPI metrics on a daily basis.,Microsoft BI allows us to combine data from multiple sources, build data models, create visualizations, and share the results.
Cloud Interactive charts in a cloud that can be easily shared
Connectors to popular data sources, allowing us to integrate with almost any system,More authentication methods to allow power users to connect directly to Web APIs.
It can be quite difficult to setup without guided assistance from experienced users
Limits on dataset size.,8,Google Analytics and IBM Cognos,8,8Verified UserMicrosoft BI is the program you've been waiting for!2019-01-23T18:20:41.499ZMy company deals with a lot of data, and it is extremely important that we have an efficient, easy to use program with visually appealing outputs. Microsoft BI can do it all. We collect a lot of data in the field and have to look at trends in that data through time. After our own analysis, that all has to be presented to our clients who generally need self-explanatory figures. Microsoft BI has been a great program for us.,It is a very user-friendly interface! Doesn't take long to learn and be able to make some great graphs.
The accessibility and sharing capabilities are beyond wonderful-- it has made it easy to share between employees before sending out final reports and it is easy to share with clients who need something to look at before the full report is finished.
There are a lot of options for data display and they can be as complex or simple as you want and still look amazing.
They have a great online resource for help and tutorials. If you don't catch on quickly on your own, it is quite easy to do some reading online and teach yourself.,The Microsoft BI app can be finicky at times and it would be great for that to be more streamlined. We sometimes require data to be shown during fieldwork, and a functional app makes a big difference.
The program doesn't always remember my settings. This may just be a glitch with the program on my computer, but it would be a huge timesaver if I didn't have to reset my preferences every week.,10,Tableau Desktop, Keen IO, Domo, Qualtrics, Google Analytics and Google Analytics Premium,10,10,Qualtrics, WordPress, Blogger, Google Drive, Apple iCloud, Microsoft Access, Dropbox, Dropbox BusinessVerified UserMicrosoft Business Intelligence is a quick and cheap way to start practicing with data visualization.2018-12-07T16:36:06.265ZMicrosoft BI is currently being used across the organization by all departments who have staff interested in tapping the hidden value of their data. It allows users to create their own queries and visualize them without a large time investment to learn the software. Ad hoc reporting is easier to accomplish using MS BI than some of the other data mining software out there.,Easy to learn the software.
Allows complex queries to be created ad hoc and ran against databases quickly.
Gives the users the ability to empower their departments by setting up easy to implement visualizations.,Understanding the full scope of the software takes a lot of time.
It doesn't handle very large datasets well, importing can take a while.
I have not found a way to build scheduled reports.,9,Microsoft SQL Server and MS SharePoint,7,8,Microsoft SQL Server, MS SharePointVerified UserPower BI will put an S on your chest2018-06-19T18:25:50.134ZIt is currently being used at a program level by project controls to provide project performance data to the project team. Engagement with Power BI allows the different stakeholders for the project to engage with performance data providing them the opportunity to be more responsive to issues and opportunities. It keeps everyone that is a part of the project on course and helps drive collaboration with the team members.,The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI.
I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training.
I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to.
Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so.
Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI.
Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free.
Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.,The desktop version is free, monthly updates, free training resources...what's not to love. I'm sure that someone with a higher degree of technical learning will be able to better articulate some negatives for Power BI, I'm just not that guy. I have nothing but appreciation for Power BI.,10,10,10Jason LeidigA Very Powerful and Innovative BI and Virtualization Tool: MS BI2018-09-07T21:25:35.634ZPower BI is a dashboard, data query and, data modeling tool. You can report your data as quickly and easily as with other competitors. With machine learning ability you can easily query, model and report your data. With the AI supported insight ability, you can drill down to the problems. If you want more analyzing tools, you can do it with the R scripts in Power BI.,User experience (UX) is the top priority for Microsoft in Power BI. It has incredible abilities to query data from the source, such as machine learning. Query, design, and reporting is in one tool. There is no need for additional tools.
It can get data from all resources, even in the reporting frame structure. There is no need for a table structure anymore. If you have unstructured data in any resource, machine learning can recognize/learn how to capture it and get data as you wish. If a data requires editing with some Excel operator (mid, left, find, etc), you no longer need to write any command. Power BI is doing it for you with machine learning technology. You just give some example about what you need in data and it recognizes/ learns how to get it and then populate it.
Power BI has a lot of dashboard charts, very different range, very different purpose and you can find what you need. Charts look so pretty and configuration is so easy too. If you want to create a report (using a chart), you can type what you need while you are talking to a friend. Power BI creates it simultaneously as you are writing.,Actually, there is one thing I can say. If you are working with huge data, depending on your computer configuration and only with the desktop (free) version, it is a little bit slow.,10,QlikView, SAP BusinessObjects Business Intelligence (BI) Platform and Tableau Desktop,10,10,Micro Focus PPM (formerly HP PPM), Xmind, SAP Analytics CloudCelil ÇİYNEKLİIdeal for Data Analytics and Visualization, but not for noobs2018-07-14T20:06:09.061ZWe use Microsoft Power BI for one of our client's project data management. He has a database of mobile app users who sign up for the premium account and Power BI is used to analyze the data and build a graphical representation of the given data, which is very convenient when you need to create a presentation or something (or simply want to see your data presented visually.),Data analytics features - you can filter the data according to a billion (it feels like) ways and make sure your data is just what you need.
Graphs, charts, and everything else visual - not only you can analyze your data according to filters and everything, you can also make it look good and understandable without having to look through a ton of numbers.
It can handle quite large amounts of data input, so this makes it a good addition for the projects that require big data.
Works well with other Microsoft products (including .NET projects).,It's not very user-friendly (at least, not if you use it every single day and can tell where a feature is located when you wake up in the middle of the night). It takes some time to get the hang of it.
Sometimes it feels like there is just a bit TOO MANY features. I mean, they are all awesome, but it's easy to get lost.,8,9,7Zee GimonGreat Graphics presentations2018-05-03T21:40:10.719ZThe software is being used as a way to develop different outputs graphics for different analysis and solves problems that I and my collaborators take from field surveys for planning new strategies in order to preserve nature and biodiversity in our territory. The people that use this software are me with the data being stored in Excel sheets.,The customized colors and presentation
Introduces Excel data for graphics
Innovate the way we used the data and new elements for analysis,Printable graphics is a must
The whole concept of the presentation for a company is missing
Is not easy make changes to the graphics,7,Tableau Desktop,8,8,QlikViewYemsi PinoMicrosoft BI - Good choice for departmental deployments and limited budget2018-04-09T21:05:12.404ZMicrosoft BI is being used as part of a departmental implementation, especially for self-service capabilities. We build our solutions using different Microsoft BI components or tools such as Reporting Services, Integration Services, and Power BI Report Server.,Self Service Capabilities
Easy to use
Integration with MS Office,Data Quality Capabilities
Performance issues in Power BI with some source systems
Data Governance features,8,Microsoft SQL Server,7,7,IBM Cognos, MicroStrategy AnalyticsGonzalo AngeleriMicrosoft BI - Advanced Surveys2017-10-16T15:38:36.912ZMicrosoft BI is being used in a department to manage Advanced Surveys. It served as a gateway to developing the reporting system for the administrators of the department doing the said surveys.,Easy to use.
Integration with other systems.
Quick development.,More advanced reporting options.
Reporting tools interface update.
Drag and drop functionalities improved.,9,Microsoft SQL Server,10,9,OutSystems, SQL Server Business Intelligence Manager, Microsoft SQL ServerReinaldo André MuralhaThink hard on your BI goals2016-09-26T14:51:45.123ZWe have been using a Microsoft BI stack (SSIS SSRS and SSAS) to support our SaaS solution for almost a decade. Over sixty client organisations are now using our SaaS solution to manage their operational risks and related activities. With Microsoft BI, clients can use Report Builder to access our data sources to design, develop, publish and distribute their own reports. On the other hand, we as a service provider can use Visual Studio Data Tool to create and maintain data sources/models. I mostly get called in to design and develop sophisticated dashboards and smart KPI reports (often programming-intensive in nature) for clients when the complexity goes beyond dragging and dropping plus simple VBA expressions. Overall, our clients are happy with the reporting flexibility delivered by Microsoft BI and we ourselves are very positive with the future of this product.,Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.,Report Builder 3.0 shipped with MSSQL 2012 is a nice free tool but our client users sometimes encounter problems such as the tool automatically shut down without saving the changes being made. We haven't implemented the new RB with MSSQL 2016 yet thus cannot comment on the latest version.,10,As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.,,Visual Studio.NETHaibo YangMicrosoft BI - a complete BI offer at last!2016-12-15T20:43:03.745ZWe build BI solutions on our source systems through Microsoft BI. We use most of SQL Server Enterprise tools, more specifically SSRS, SSIS, SSAS; our end-users mostly work with SS Management Studio, Reporting Services and Excel. Our BI department is for external clients only, we have no internal BI infrastructure.,Relative ease of use of SSAS cubes for end-users
Versatility of SSRS for creating reports and automating their executions
Integration with Office 365,SSRS Report Builder requires more IT skills than other reporting tools
No SSAS actions available in Report Builder
Integrated security tools are not readily available; Management Studio works well for SSAS, but no way to keep track of global security attributions unless you build a report on the DB,8,At the moment, the lack of use of Power BI has indered our market progression IMO
A large majority of customers keeps the solution once implemented, very few have switched platform
Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.,,Tableau Desktop, Alteryx AnalyticsCharles SaulnierIt's Excel for Big Data. So easy, so cheap, so fast, and powerful enough most everything.2016-04-12T19:02:25.152ZMicrosoft BI is, and seemingly shall be, the "BI Tool Of Tomorrow" forever. There are few people using it at my organization. In general, whenever I tell technically savvy people in the analytics/consulting space that there's a free visualization tool in Microsoft Excel that's 90-95% as good as Tableau, they are like "What?!" Then, they forget all about it in favor of expensive clunky tools and straight up coding.
Microsoft BI is a many-times-relabelled tool for visualization and lite analytics. It's like super duper Pivot Tables and Pivot Charts that let you work with big data. As an analytics tool per se, it's as good as Excel since it is Excel. I wouldn't do any analytics heavy lifting with it personally, but you can easily do algebra stuff and make derived variables. The real business benefit is visualization. It's just very easy and powerful.,EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases.
FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery.
FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.,More than two dimensions. Yes, I know that 2D is the core of Excel's DNA. However, we're starting to deal with higher-dimensional arrays here in analytics land so better visualization support would be cool.
UI weirdness. By default, you are flipping back between regular Excel tabs and super-top-secret BI tabs. You create charts in one place, but look at them in the other. That kind of stuff. I know there are a couple of other ways to interact with Microsoft BI, but please figure out the main way.
Better hookups to other analytics tools including Microsoft's. Microsoft BI has a good variety of data connections, and I don't expect it to bloom into a full-fledged analytics tool, but it may be a good idea to keep hammering at connectivity with "hardcore" analytics. In my case, Python stuff.,10,Tableau Desktop, Google Analytics, Google Charts, SAP Crystal Reports, SAS Visual Analytics, SAS Analytics, QlikView and D3.js,Tableau Desktop, Anaconda, Google Drive,8,7,20,,Familiarity. It's Excel. It's a spreadsheet. Come on.
Thinking in matrices (PivotTables) takes a little getting used to, but it's not hard. For people without a good high school math background, it may seem unintuitive.
Charts and PivotCharts are fairly easy, but Microsoft has a ways to go to make them less ugly.,Data source connections. It's sometimes difficult to replace and update connections.
Dropping certain types of fields into the Pivot Table (example: default aggregation type for values).
The weird interface. Microsoft tried to have it both ways by using the standard Excel interface for some tasks, and the "Power" interface for others. It's just awkward, cumbersome, and confusing.,7Alexander LubyanskyMicrosoft BI from a Consultant's Perspective2016-11-15T16:11:35.951ZMy company is a Microsoft partner, and we use the Microsoft BI stack throughout the organization. We mainly use it for development and implementation of ETL, database management, analytical processing, and reporting (SSMS, SSIS & SSRS). As consultants, we typically design these processes in our clients' environments (which range from SSMS versions 2008 - 2016), but also do some in-house work for internal product development.,Database management: Although learning all the features of Management Studio may initially seem daunting, they provide a intricate system to support the entire database environment.
Data flow and process management: SSMS and SSIS work together seamlessly to automate processes, allow users to create jobs to kick off their processes, and provide users a log of runtime variables, errors, and warnings.
Data modeling: SSAS provides a feature-rich environment to develop both multidimensional and tabular models.,There seems to be a slightly different language for every need: T-SQL, MDX, DAX, Excel formulas, Access DB SQL, C#, etc. While there are a wide variety of needs these meet, it would be helpful to have a more common base-language between languages with similar functionality (SSMS's T-SQL and Access' SQL, Excel formulas and DAX).
Reporting Services in Visual Studio tends to be a little buggy, especially when dealing with parameterized reports.
It would be helpful to have processing time displayed when processing tables from SSMS. I'm often forced to decide between the detailed error log that the processing dialog box displays (with no start/end times) or scripting out the job to XMLA for the gain of process start/end times but a loss of the detailed errors.,8,My organization uses Microsoft BI for nearly all of our development. We would not be able to integrate with our clients to deliver our solutions easily without it.,MySQL,Skype for Business, ZoomMegan JuellMicrosoft BI- Multiple sources, One solution2016-10-24T16:14:47.780ZMicrosoft BI is used in our organization for data analysis and reporting. I used it as a part of marketing live dashboard implementation. It is really a great tool for visualization and customization of views. It's useful in making decisions based on live data and we connect Google Analytics data.,I like how the dashboard is customizable to your own preference.
Its a Microsoft tool so it works perfectly with Excel.
It's an easy to learn and use tool with minimal training required.
The mobile app works perfectly with the dashboard view of your data.,More training resources for new users.
Better integration with SRSS.
I feel it still has a long way to go as far as Tableau is considered.,9,I would say making work easier for internal marketing reports is a great time saving activity in which Microsoft BI excels. Instead of downloading data manually from various sources, it integrates live data from applications.,BizNet Excel Suite, Tableau Desktop and Tableau Online,Microsoft Access, IBM SPSS, IBM Watson AnalyticsJasmeet S Babra
Unspecified
Microsoft BI
710 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
