Microsoft BI Valuable Features

Justin Larson
Principal Business Intelligence Analyst at a logistics 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 »
Rafael Martins Cardoso
Business Intelligence Analyst & Developer at a tech services 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 »
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 »
Accountant at a government
The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization. View full review »
Juanjo Gomez
IT Director at a manufacturing company with 5,001-10,000 employees
* Easy to use. * End-users can make changes to the graphics. * The tool runs very fast. View full review »
Olumide Ibilaiye
Business Intelligence Developer at a financial services firm with 1,001-5,000 employees
It's actually the self-service of Power BI, because we're on a lean structure here, the technical side. So we wanted them to push some of those things back to end-users. View full review »
Principal at a tech services company with 1-10 employees
The ability for business users with a mission to solve their own problems, without an IT person. View full review »
Partner at a consultancy with 11-50 employees
The self-service part. View full review »
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 »
Gilberto Gutierrez
Presales Architect at a tech services company 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 »
Dipak Bhudia
Founder with 1-10 employees
It works mostly with Excel, and it's a very good price. View full review »
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 »
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 »
Arturo Laos
CEO at a tech services company
It is easy to work with. The tool is very complete. View full review »
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 »
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
Database Expert & BI Developer 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
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 »
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
Consultant MOA BI at a manufacturing company with 1,001-5,000 employees
MS SQL & SQL Server Analysis Services. View full review »
Director, Education Management Information Systems with 51-200 employees
* Dashboard functionality * Ease of integration with various data sources View full review »
Christopher Herbert
Professor of Private International Law with 1,001-5,000 employees
* Low cost - it's a free application * Ease of use - excellent user interface View full review »
Akshata Tare
Data Analyst at a tech services company with 51-200 employees
Pivoting is the most valuable feature. View full review »
Geoff Speedy
IT Director with 10,001+ employees
* Integration of DB and reporting * Standardised SQL language * Plenty of support * Cloud options * Continual improvement year-over-year View full review »
Principal at a tech services company with 1-10 employees
Most importantly, the dashboards. Recently, we are exploring vendor provided analysis/visuals and the use of R. View full review »
Peter Valbonesi
Project Manager with 51-200 employees
* Ease of use * Dashboard * Easy access to databases and spreadsheets * Multi-table access View full review »
Senior Manager with 10,001+ employees
* Predictable cloud environment * High performance * Ease of development and maintenance View full review »

Sign Up with Email