AdDataExpress vs. Microsoft BI (MSBI) vs. Yellowfin

When using tools like AdDataExpress, demographics are key when trying to identify new relationships. Being able to segment out the population by many demographic fields is absolutely necessary to try and optimize what we are spending. Trying to use this as a pure CRM is probably not the greatest idea, but using it in parallel with one would be good.

Incentivized

Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.

Incentivized

We can recommend this software without hesitation, as it has the ability to generate reports and data analysis, as well as process the data automatically, which saves time. It is ideal for small and medium-sized companies that wish to improve their services in the business world

Incentivized

• Provides email addresses - essential when doing cold email outreach.
• Provides agencies for each brand/company.
• Provides media spend for parent company and brand.

Incentivized

• Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
• Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
• Transfer of data from one application to another via Excel and comparison of data attributes between applications
• Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Incentivized

• Yellowfin’s Storyboard, Timeline and Collaborative tools make it easy to share data and insights across an organisation.
• Strong Operational and Executive Dashboards that reflect the business KPIs and can send out prompts to people within the business based on rules.
• Yellowfin makes it incredibly easy to create dynamic reports and dashboards which incorporate maps through locational intelligence functionality.
• Yellowfin is a single license and all access is via a web browser making it perfect for both on-premise and cloud deployment. Mobile apps are also available.
• User roles and source filtering allows Admin/IT to offer different functions/views by user group/role.
• Mobile BI applications to support any device ..
• API connectors ( YF 7.2 on the way in Mar16 ) for a range of third-party Web-based applications, data sources, Enterprises CRM/ERP apps & open data platform apps, including Salesforce, Google Analytics, Twitter, Youtube , Zoho CRM, XE.com & more coming to make endusers to integrate their applications for better benefits
• Yellowfin Integration with Predictive analytical and Big Data processing tools like R, UDF, Spark to build rich applications for end users

• Filtering is not optimal
• Integration with other products is not intuitive or even there
• Keeping data up to date automatically

Incentivized

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• The ability to predefine a colour for a specific graph as a selection option dynamically.
• The ability to customise the label of a chart, especially with respect to performance related reporting graphs we need an increase in dynamic charting options to meet our more specialised requirements.

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.

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.

Incentivized

As mentioned previously, if a newer company is looking for a strong, polished BI tool, Yellowfin would be a great software vendor to consider. Unfortunately, the high cost might be a barrier to these newer companies who dont have any legacy software/agreements such as an EA agreement with Microsoft.

Incentivized

The product has been reliable.

99.9% availability

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.

MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.

Incentivized

They have good support in what they provide. But what they provide is not what is promised. I would stay with them if I can. Be very careful before signing up with them. They are not what they seem in the sales pitches. Be very careful and make sure you test and test before you sign up.

This training was more directed toward what the product was capable of rather than actual programming.

Yellowfin provides 3 levels of training to support consumers, business analytics, developers and Administrations :

1. Yellowfin BI Training - Level 1 (Exploration)
2. Yellowfin BI Training - Level 2 (Advanced)
3. Yellowfin BI Training - Level 3(Expert)

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.

Web-based training for large audiences for Level 1 and Level 2 I would suggest

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.

Design the data model and views for each dashboard is very important and it is the success factor Configuration of cluster for large implementation

Winmo allows more dynamic and functional searches, and puts agency and brand contacts in one place. It also allows exports based on spend and in general, is much more dynamic of a software.

Incentivized

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.

Incentivized

Yellow Fin platform is browser agnostic and is accessible from desktops as well as mobile devices. It is very simple and fast, it is integrated with Big Data, clients do not require a great training. It just works. But it’s easier to have things on the cloud, especially if you need to use different computers. Yellow Fin lacks the cloud feature.

Incentivized

- Tested 500 con-current users in Linux platform with 4 cores systems - Tested with cloud based VM - Tested with 1000 reads per minutes

• Expanded lead horizons
• Agencies provided for each company
• Efficiency of potential partners

Incentivized

• 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.

Incentivized

• made our org more data centric
• Decisions are made based on data vs opinion
• has created a single source of truth for the bulk of the organization

Incentivized