Microsoft BI Valuable Features

Justin larson li?1426024414
Justin Larson
Principal Business Intelligence Analyst at a transportation company with 1,001-5,000 employees
SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components, leaving out SQL Server (and Azure versions of it, including the Azure warehouse and big data technologies). SSRS's display functionality is resoundingly flexible, and by comparison to other vendors, relatively easy to learn. SSAS Tabular performs very well with modest effort in design, and the ability to perform complex business modeling through DAX calculations stands out in a crowd. View full review »
08bfa2ab 50ed 4165 98b4 28b1d82af1f7 avatar
Rafael Martins Cardoso
Business Intelligence Analyst & Developer at a engineering company with 1,001-5,000 employees
Since its integration into SQL Server 2005, Microsoft has made a number of improvements and added many new features. It had a big overhaul in 2008 and acquired a bunch of new features with 2008 R2: KPIs, maps, sparklines, new functions, published Report Parts, and more. Let me highlight some of the advanced features that keep people on the platform: * Drill-through reports. These are ones where links in the data presented take a report viewer to related reports. Information Builders is another BI platform where this is available, but not as customizable as in SSRS. * Highly customizable charts. The data-driven custom colors. The fact that almost every attribute of a component of a chart can be tweaked. Try doing some of those customizations on your flashy new cloud BI platform. Reports within reports. Sub-reports within tables of data and sophisticated charts within tables within sub-reports within reports. Go as deep as you want. See as much detail as you want. * User-accessible parameters. Reports can offer report users parameters like no other platform. This makes linking to and from reports easy and allows you to integrate SSRS reports into other business applications. Try sending parameters to an Excel spreadsheet, a Power View report, or a cloud-based dashboard – impossible. * Extensible. Programmers can extend the tool’s functionality. Custom data sources can be coded. Custom delivery extensions can be built. External DLLs can be referenced from within reports. Many companies do take advantage of these features. View full review »
A4e6f7ca a713 4e24 bfd0 98a9b66716b0 avatar
Roman Nedzelsky, MVP
Senior Consultant | Architect at DHL
Firstly there was the wow effect, as when I saw the number of connectors which were made for this product/service. It is quite fantastic to have the ability to connect separate services like CRM, NAV, Facebook, Exchange etc. and make data integration and transformation based on these data connections in a few clicks. Also, the ability to download new visuals is quite nice. The effect of new graphics for higher management is magical and this is the good way not only for a pre-sale/sale or up-sale, but also for good impressions. Another great feature is, for example, the collecting of data in concrete folder on disk. If there is, for example, 100 csv files from other information systems, these should be automatically merged, analyzed and transformed into great graphical report. View full review »
D62fcc57 14c7 4516 8ba6 d4337b4cb83a avatar
Partner at a consultancy with 11-50 employees
The self-service part. View full review »
Alper sinav li?1430578613
Alper Sınav
Head of Information Systems Department at a government
* It provides easy integration with Office tools. * It is easy to understand BI architecture. View full review »
Anonymous avatar x60
Gilberto Gutierrez
Presales Architect at a tech vendor with 51-200 employees
With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license. View full review »
Anonymous avatar x60
Munashe Muwonde
Chief Tecnical Officer at a tech services company with 51-200 employees
Microsoft BI Stack's best features are as follows: SSRS – Self-service reporting and powerful subscription service PowerBI – Self-service BI MDS – Master data management SSAS – OLAP Cube View full review »
Add nigel
Nigel Magson
Founder at a tech consulting company with 51-200 employees
Microsoft SQL Server Report Publisher Microsoft SQL Server Report Builder Microsoft SQL Server Reporting Services (Web Portal) SQL Server 2016 delivers built-in mobile BI capabilities. The above tools give professionals the ability to deliver business insights quickly and easily as well as enabling a quick way of presenting the data/charts/reports over a web portal. The portal is compatible for cross platform, from desktops to major mobile devices. Overall a great way of delivering your insights to your data. View full review »
583ca12e 47ff 419d bb21 c3461e82c201 avatar
Rex Campbell
Web Developer at a energy/utilities company with 1,001-5,000 employees
The ease of implementation and reliability of SQL Server Reporting Services far exceeded the solution originally implemented with Crystal Report. The Crystal Report Servers (3 of them) were crashing on a weekly basis at one of the companies where I worked. View full review »
B8186609 4fa0 4a21 bfde 0894fd8fd83e avatar
Farhan Ahmed MCTS/MCITP/MCC SQL Server
Senior Software Engineer - Business Intelligence at a tech consulting company with 51-200 employees
The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features. View full review »
Khumbulani chikura li?1429858974
Khumbulani Chikura
Business Intelligence Architect at a tech services company
Power Query, Power Pivot, Power View & SQL Server Data Tools comprising of. View full review »
Anonymous avatar x60
Managing Director at a tech services company with 1-10 employees
Standardized solution that comes with data warehouse and BI cubes straight out of the box for deployment for both Dynamics NAV and AX products. Enhanced wizard allowing for customization of BI Solution without having to go through SQL scripts to generate additional measures and dimensions. View full review »
Dung dinh tien li?1414330229
Dung Dinh Tien
Database Expert at a outsourcing company
It provides a full platform for our BI solution (database, ETL, reporting, analysis, and so on). View full review »
Taner kocakafa li?1421997594
Taner Kocakafa
Customer Data Analytics Specialist at Allianz Turkey
Power Query and Power Pivot are the most valuable features. You can easily manage your data on Excel. İf you have a professional version, you can do it. However, if you don't use Power Query and Power Pivot, then your raw number is limited. The Unpivot specialty is useful because you can't do it in the front-side of Excel. View full review »
D18c2646 75d4 4671 ad43 aa9d14449524 avatar?1444213539
George Chinowaita
Business Intelligence Consultant at a tech services company with 51-200 employees
It is good for highly formatted reports. View full review »
Gregory dinh li?1427980858
Gregory Dinh
Consultant MOA BI at a manufacturing company with 1,001-5,000 employees
MS SQL & SQL Server Analysis Services. View full review »
6c651f50 a2bb 4d01 923f cd35600cad86 avatar?1441375288
Akshata Tare
Data Analyst at a tech services company with 51-200 employees
Pivoting is the most valuable feature. View full review »

Sign Up with Email