The IBM Apptio platform is a technology business management solution that enables organizations to make better decisions about technology investments. It connects technology spend to business value so organizations can adapt to changing market conditions.
N/A
Microsoft BI (MSBI)
Score 8.6 out of 10
N/A
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.
Microsoft BI is a great tool when it comes to various integration with line of business applications and its own ecosystem which contains office applications widely used all over the world. Hence, it is well suited for organizations that are complex and have global foot-print. …
We use IBM Apptio exclusively for application TCO reporting. It compiles data from different sources then export to Excel to customize report for the user. Our intention is to start a TCO dashboard within IBM Apptio, so Excel is no longer required and leadership can drill down. We are also trying to fully automate our cloud billing.
Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
Does very well at handling complex allocations and automation. Also great at bringing in data automatically, manipulating that data, and allowing you to feed that data into a complex model. So all the behind-the-scenes stuff works really well. It's also pretty good at visualization. It has some similar capabilities like a Power BI and Tableau, but generally provides most of the visualization technology that somebody would need with the tool.
For Validation purpose, if possible, enable the JavaScript code so we can the hide the Tab based on current period and more validation we can perform on client side.
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.
We absolutely love it at the State of Kansas. It is very user-friendly, which helps us explain the information to those who are not as into the budgets. We consult out with Marysville, and they are super helpful in helping us with the behind the scenes stuff, like creating new tabs and uploading the reports for us to filter through. It is very simple to use and that helps us be able to teach others in our department how to use it properly.
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
We use this currently where I work and we have the consultant Maryville helping us with our Apptio reports and data. I originally used Apptio a few years back and since then I have switched employment, and I was able to talk to the leadership team about what we did at my previous job, and now we are building the reports here at my new place of employment
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
I have not been directly involved with the post sales support team. However, that team has provided training materials and recommended practices that have been very helpful in coming up to speed on how to more fully use the product. My understanding from both vendor management and our upline stakeholders is that our relationship with Apptio is strong.
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Was awesome to have been taught by legendary Debbie Hagan for Cost Transparency in person. Her knowledge is extensive and she is an excellent trainer. Her years of experience really shined.
The all talented training organization crosses all the T's and dots all the I's. I am constantly learning and often refer to training documentation for post training real life issues.
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Well, so far. Apptio Consulting covered specific model architecting areas particularly. Most of the heavy lifting is being done in-house with support from Apptio as it relates to tool impacts and needs. Some administrative tasks were redundant
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
So we've used Proven Optics, which is an add-on to ServiceNow. Well at least use it with certain customers and Nicus. Nicus is probably the biggest competitor of Apptio. The trouble with Nicus is their SQL-based ingestion process. It's a little bit more difficult. So the reason why you'd go with Apptio is that it's very easy and very intuitive to bring in new data sources and being able to model a lot of the data once it's already in the system doesn't require a lot of coding experience.
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
It's delivered on a lot of those, especially the relationship between IT and financing that relationship's been a bit of a rollercoaster on that journey. We've come out the other end of it, and we're all friends now, which is a good thing. So they've accepted the Apptio output and are much more involved in providing the data and helping to use the tool, which is excellent. I think one of the downsides that are probably not talked about enough is the fact that, um, once you have trained and delivered a TMB skillset within your organization, they become very good at that. So if you've got any high-performing members in that team, they become extremely valuable elsewhere. And we've unfortunately suffered the case whereby one of our highest performers was immediately then poached and went off elsewhere for a much better opportunity. So we applaud that for them, but it's really hard to train other people. It's really hard to take them up to speed, and you have to sort of go through those picks and troughs every time. So that's just life, you know.
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.