As interest in building a modern data stack has increased, so have the options of business intelligence tools available to support it. Sometimes just selecting your analytics tool can feel as daunting as the actual implementation itself.What is a business intelligence tool?A business intelligence (BI) tool—also known as an analytics tool—is data visualization software used for the purposes of reporting or analysis. Dashboards and reports commonly used for day-to-day analysis of key metrics and indicators are examples of a business intelligence tool.Before selecting a BI tool that is right for your environment you need to understand how it works (or doesn’t work), what is required to implement it, and how it will help your company meet business objectives. In this blog, we will discuss different use cases, the pros and cons of some of the more popular BI tools, and best practices to get started with your modern analytics implementation.BI Tools in The Context of Organizational Use CasesTo help narrow your focus, think about who within the business will be using the BI tool and the ways in which they will use it. Here are some common use cases to consider:Enterprise Reporting: Enterprise reporting is commonly defined as analytics that spans across several business units within your organization (i.e., sales, marketing, and finance) for the purposes of internal reporting. Typically, this entails a wider deployment across multiple business users, data sources, and the expectation that users will be using your data analytics tool for their day-to-day analysis. If your organizational analytics and requirements are centered around traditional enterprise reporting, then starting with the Gartner Magic Quadrant Leaders is a safe bet. Qlik, Tableau, and Power BI have market longevity in their respective platforms, robust cloud capabilities, active user communities, and R&D investment that allows for continual feature releases. These can be considered the tried-and-true options with the industry experience and depth to back up most customer use cases.Hybrid Vendor Approach: Often organizations will choose to build their solutions entirely on one vendor platform (i.e., all Microsoft stack). However, hybrid or modern data stacks (i.e., FiveTran/dbt/ Snowflake) have increasingly grown in popularity. Hybrid approaches to building a modern data stack lend themselves to business intelligence software that is built to take advantage of your data warehouse layer and not necessarily constrained to a specific vendor platform. We commonly see tools like Looker and Sisense fit this niche incredibly well. Both tools are positioned to fit well within a modern data platform, and are great for self-service analytics, guided analytics, and embedded analytics.Embedded Analytics: Embedded analytics places analytics at the point of need—inside of a workflow or application—and makes it possible for your users to take immediate action without needing to leave the application. If your focus is on embedded or infused analytics, a visionary like Sisense or a niche player like AWS QuickSight are great fits. These two tools are major players in the embedded analytics space but can also work well in a traditional enterprise reporting setting. These two vendors place a heavy emphasis on their embedded capabilities, and its core to their respective software platforms.Analytics Novice: For organizations just starting their business analytics journey and not wanting to make a significant investment upfront, low-cost alternatives exist that make the barrier to entry relatively low. Two great options that fit this use case are Power BI Pro licensing and AWS QuickSight. Power BI Pro licensing provides a low cost, per user entry point for clients looking to pilot Power BI. AWS QuickSight has several different licensing tiers that allows clients the flexibility to choose which option works for them.Top BI Tools Pros and Cons: There is No One-Size Fits All Organizational use cases help to narrow your focus in tool selection. But ultimately knowing where each analytics tool fits in your respective data framework is of equal importance. Consider this your “cheat sheet” so to speak on tool selection. Power BIPros: Power BI has established a major foothold in the BI and analytics space in six short years. Its native integration within the Office 365 stack, flexibility in terms of back-end deployment options, and relatively cheap entry point with Power BI Pro licensing makes it omnipresent in almost every tool evaluation I’ve been a part of the last several years. Power BI can be deployed in a variety of methods in terms of back-end data integration (Import, DirectQuery, LiveConnection, or Dataflows) and that flexibility alone opens multiple avenues in architecting your solution.Cons: Because it’s a Microsoft product, Power BI is oriented toward customers with an investment in the Microsoft stack. While hybrid approaches (Snowflake hosted on Azure to Power BI) are feasible, the potential downside to Power BI is attempting to fit it into a cloud architecture (AWS or GCP) in which native integration is limited.QlikPros: In terms of a time-to-value proposition in building an application from the ground up to production—Qlik is a definite market leader. Its associative data model still remains to me one of the most powerful features in an analytics tool period, and it’s making significant investment in its SaaS platform as well as advanced analytics functions in its search-based capabilities.Cons: Qlik is one of the few remaining “independents” that does not have a back-end cloud platform (i.e., AWS/QuickSight, Azure/Power BI, GCP/Looker) and it’s to be seen how that will affect direction long term in an industry that is rapidly driving toward convergence.LookerPros: Looker is currently defined as a Challenger in the magic quadrant, but I fully expect it to be a Leader in 2022. Looker defines itself not as a traditional BI tool but rather a modern data platform. Looker is great for self-service, guided, and embedded analytics. One of its key differentiators is its semantic layer (known as LookML), which is essentially a way of writing and generating SQL. What this opens up is true data governance and version control with reusable models. If you make a change once, it flows and propagates to everything. Coming from a developer background myself, this is a huge win in terms of the level of collaboration it opens up between your dev team.Cons: Looker fits well in situations where some sort of data warehouse/database layer exists but does not lend itself well to one-off use cases (such as building reports entirely off excel-based sources or a hybrid excel/source database data model). For some organizations in the early stages of analytics maturity, this may not be a clean fit.AWS QuickSightPros: QuickSight is currently defined as a niche player but expect this to change in the not-so-distant future. QuickSight plays well in terms of its extremely affordable price point for customers starting their analytics journey, and in a short amount of time has established itself a major foothold in the embedded analytics space.Cons: The product has room to improve from an overall visualization and capabilities perspective, but I would expect it to grow and better compete in the enterprise reporting space in 2022. For now, its capabilities are best suited to embedded analytics and solution-based applications.SisensePros: Sisense is also one of the few remaining independents in the analytics industry with a relatively strong user base. Sisense can be deployed via its ElastiCubes engine, which is its high-performance semantic layer that allows for blending of multiple data sources, or live queries that run directly against your data sources. Sisense is also built to handle most embedded analytics use cases and is truly one tool that can operate in both an enterprise and embedded analytics capacity with ease.Cons: Being an independent, Sisense will face the same challenges of not having a back-end cloud platform as part of its solution stack. While Sisense has a robust international presence, it does not have as wide of a user base and name brand recognition in North America as some of the other major analytics vendors.TableauPros: Tableau can be considered the industry leader in terms of visualizations and front-end aesthetics. Tableau has a robust user base, ecosystem, and long tenured standing within the analytics industry. Tableau Prep has helped to bridge the gap in the tool’s ETL and data prep capabilities that was previously filled using Alteryx as an intermediary.Cons: Tableau still has weaknesses in its overall ability for embedded analytics and needs a strong DWH component or intermediary layer to scale effectively.Best Practices for Selecting the Right BI Tool for Your EnvironmentOnce you’ve evaluated your business use cases and had the opportunity to review the pros and cons of the different business intelligence tools, here are some best practices to follow before making your final section.1.) Evaluate of your data stack:An analytics tool should not be considered a standalone tool but rather a part of your overall data stack/data architecture. Locking yourself into an analytics tool that isn’t a clean fit within your data architecture sets up development hurdles before the process even begins. So, if you’re building your modern data stack on a cloud platform like Azure, AWS, GCP, or Snowflake, then you should consider how each analytics tool (Power BI, Qlik, Looker, Tableau) fits into these respective architectures. Data complexity and frequency of data refreshes are two excellent starting points to evaluate this question.Data complexity will transformation logic occur within the analytics tool itself, or will an intermediary layer be needed for the heavy lifting? This will help you determine what’s needed in the back end versus front end and how your analytics tool will fit.Data refresh frequency will data need to be scheduled weekly, daily, or real time/streaming? Again, this will help you determine your approach on the back end and what analytics tool fits the frequency use case.2.) Run a proof of concept/tool evaluation: An analytics tool is an investment and it’s important to know how that investment will work for you. We encourage clients to go through an evaluation phase that either entails building a proof-of-concept application or conducting a tool evaluation to understand the level of effort in implementation and associated cost. Doing the homework up front allows you to understand how your future state analytics tool will function, scale, and what the cost may be.3.) Review the tool’s platform growth: When picking an analytics tool, the idea of future state roadmap or anticipated growth in that platform should be a key consideration. A tool with a limited product roadmap should be considered a red flag. I’ve had a client elect to choose a tool on the clear downswing because they were given a sweetheart deal on licensing. To no surprise, a year later they had to go through the process of ripping out that tool as it did not meet their future state growth goals.Selecting a business intelligence tool does not need to be a daunting task. Just be sure to go into the selection process knowing your use case, and how the tool will be used to meet your analytics needs.