Best bi tool on Reddit

"I'd recommend Power BI, knowing finance and power users there's a natural learning curve for the team to adapt."

"I would recommend Power BI. You are already invested in Excel and if you have an Office 365 license, you probably already have Power BI Pro license."

"It's the fastest and most cost effective way in my view."

"There is nothing better than Power BI for non-technical users."

"Power BI would be the best budget friendly option while also being easy to use."

"Basic power bi functionality included with most licenses"

"Power BI should be perfect for this and is much cheaper than Qlik."

"PBI paginated reports are incredibly useful for data visualization."

"Power BI is excellent for aggregated presentation."

"It's free, you only pay for online/sharing capabilities which you won't need at all if you're just pdf-ing. Works great for everything I've ever needed to create."

"You can connect with Tableau and other data sources."

"Tableau can handle all the requirements you listed out."

"One of the most popular BI tools available in the market"

"Tableau has a much better UI/UX platform."

"Work top down."

"It's doable in tableau."

"I would lean on Tableau for sure."

"Go with Tableau. You get what you pay for."

"Two places I have worked used Tableau for that"

"Dynamic drill-downs and data discovery."

"PowerBI can also be integrated with this solution."

"Budget friendly and will accomplish just about everything on your checklist"

"Work top down."

"Works great for everything I've ever needed to create."

"Power BI can handle large data sets"

"Power BI has the most features in the free tier IMHO."

"Allows for self-service analytics without complex setup."

"If your data is going to be sat on SharePoint and you are using csv's use PowerBi."

"Power BI offers a good balance of features."

"Cheaper alternatives, gaining market share"

"This solution leverages Google BigQuery as a warehouse, simplifying the intricacies of the NetSuite data model."

"BigQuery can connect to sheets and represent them as tables, enabling incredible data handling capabilities."

"Looker is great for smaller companies in the Google environment."

"Data Studio is free and effective for serving users."

"A great combination for data analysis."

"Perfect for scenario"

"Data Studio is a great free option for data visualization."

"It's free, has a MySQL connector and should allow you to play around the data using different visualisation styles"

"Looker studio is free and has a reasonable upgrade path and integrates with google sheets."

"Looker Studio is free and integrates well with Google Sheets, making it user-friendly for data visualization."

"Comes with a bunch of report templates in Looker Studio to be used as examples to build your own."

"Looker works well with Sheets and is very easy to setup."

"Looker has content, field, and row level security that you can define down to the user level."

"Looker leverages a semantic layer to write performant sql (requires no or limited SQL knowledge for end users) to write SQL to the database and return and visualize those results. Point and click interface to create scenarios, 100% web based, governance and security built into the semantic layer, 100% API coverage. Also has aggregate awareness, allowing Looker to get results in the most cost effective and most performant manner possible. Because it’s not giving or aggregating data for performance or security Looker allows y"

"Looker leverages a semantic layer to write performant SQL, allowing users with limited SQL knowledge to visualize results easily."

"Addresses a lot of the data access, transformation, and collaboration requirements"

"Big fan of Looker"

"Looker is excellent for data modeling and tooling."

"Looker provides good user control but can be expensive."

"Looker is another alternative for BI tools."

"Take a look at metabase"

"Open source, query DB directly, great dashboard functionality with dynamic filters, auto email sending with reports"

"Metabase is a powerful tool for data visualization and analysis."

"It’s free for either deployment to your own infrastructure or if going via Cloud solution you could use your budget purchase a decent dedicated PaaS service"

"Metabase offers robust features and flexibility."

"Metabase is great for ease of use and simplicity."

"Cost effective solution for data visualization."

"Go open source: metabase, redash or superset."

"Metabase is an open source tool that allows for visual discovery of data."

"Metabase is moving to fix coding issues for dashboard creation, but it lacks functionality and aesthetics."

"We are also using Superset for building online game analytics dashboards, looks great so far."

"Works perfectly in a cluster like Kubernetes, but can play around with it locally. One of my favorite things about it is that you can parameterize queries and link them to a filter box, giving your end user ability to change the parameters and refresh the query. That means unlike tableau/powerbi, the queries don’t pull in the entire table in at once. Saves in overall query speed and amount of data being transferred. You can also easily make flat tables and export the results as a csv, which is the number one thing clients always ask for."

"Apache Superset is a powerful open-source BI platform with a SQL editor and no-code visualization builder."

"Definitely capable of serving kpis and charts similiar to qlik and the like"

"Apache Superset is open source and has good user and permissions management systems."

"Apache Superset is amazing for this, but it needs some devops knowledge."

"Offers more features compared to Metabase while being open source (and it can be hosted wherever you want)"

"Still supporting qlikview"

"Amazing"

"We use Qlik to deliver analytics to our partners externally and for the public via a portal. They can apply filters and analyse as they wish."

"Thank me later ;)"

"The Qlik QAP is really good, but expensive."

"Qlik, Tableau etc are much better BI tools."

"Qlik is definitely still supporting QlikView, and you can create static, pdf reports in QlikSense off the shelf."

"Learn Python data science libraries and Dash."

"Learning Python is a great investment for data analysis."

"Python data science libraries are free and customizable, though they have a steeper learning curve."

"Seaborn is great for creating visuals."

"Plotly is very flexible for creating whatever visuals you can imagine."

"Matplotlib is very flexible for creating visuals."

"Sisense has an embedded feature that's definitely worth checking out."

"Great, simple, intuitive"

"Openness and ability to embed and play nicely with other software"

"Sisense is focused on external/embedded BI."

"Sisense embedded analytics or domo might be what you are looking for."

"Sisense, nice product, but their pricing is a nightmare."

"Look into Apache Superset."

"Just use Apache Superset/Preset"

"Open source BI tool, cheapest, used at Airbnb"

"Apache Superset"

"Apache Superset's cloud offering is paid."

"Domo is perfect for PMs to create their own dashboards and for developers to create custom charts."

"Easy to use tools for data ingestion and transformation for the casual user and Python/R integration along with other data science feature for more advanced uses cases"

"It does everything you ask"

"If you got money Domo, Sisense."

"My company uses ThoughtSpot and it’s made our clients lives a hell of a lot easier."

"Sounding like a great option for you"

"Works well in this scenario"

"Bold BI can be used to create SaaS analytics dashboards, and their support team is helpful in creating dashboards for your data."

"Bold BI offers a user-based filter feature that customizes dashboard data for logged-in users."

"User based filter"

"Inzata analytics offers drag and drop ETL, AI data modeling, and quick dashboard/report building, making it user-friendly."

"Self-service data modeling with AI, drag and drop dashboard and report creation, drill anywhere for exploration and queries, secure external sharing of dashboards"

"[Inzata.com](https://Inzata.com) Deployable on-prem and server agnostic."

"R with Shiny library is excellent for data visualization."

"R is also a powerful tool for data analysis."

"R is great for processing if you have programming experience."

"Also, AWS, recommend the gateway runs on EC2 in the same VPC"

"AWS offers business intelligence under QuickSight."

"You can also consider Sigma for something that is cloud native."

"Zing Data is particularly user-friendly and automates many processes."

"User-friendly for quick analysis without prior modeling."

"Zing Data is a good option with a free tier."

"Fairly robust and would meet your needs"

"NetSuite can be connected to Tableau using ODBC, enhancing data analysis capabilities."

"Netsuite's EPM tool PBCS is robust and meets user needs."

"Plotly Dash! It's free if you can host your own fargate app on AWS"

"Plotly Dash"

"Helical Insight supports simple dot notation for extracting nested structure data."

"Helical Insight offers a self-service drag-and-drop interface similar to Tableau, with extensive embedding options and support for various authentication methods."

"Work top down."

"Dynamic drill-downs and data discovery."

"Focuses on the AWS eco-system"

"Check out Qrvey for its innovative features."

"Business Intelligence (BI) reimagined for startups and SMBs"

"Discover rich insights, beautiful visualizations, and ready-to-use dashboards straight out of the box with Polymer's AI."

"Interesting that this question has been so popular in this forum. I think I gave this recommendation twice just last week. Popular use case."

"Embedded apps via KNIME Server"

"FineReport has a built-in connector that supports multiple data sources, including MySql, and offers stunning data visualization types."

"Built-in connector supports multiple data sources, including MySql"

"Luzmo offers a flexible solution with good APIs and is ideal for embedded analytics."

"Embedded analytics is their sweet spot"

"Qlik Sense or Qlik Cloud could also be an option."

"You can use Qlik Sense. It's great and will handle this easily."

"QuickSight is an excellent tool for data visualization and analysis."

"Quicksight will handle most situations."

"On-premise version, can be deployed on Linux, and it can be white-labelled for reasonable price (one installation < $250/month)"

"SeekTable excels in embedded reports, making it a strong choice for specific needs."

"Preset.io offers a cloud-hosted solution for Apache Superset, making it easier for organizations to adopt."

"There’s a hosted service for superset called preset."

"They can create their own query’s without writing SQL."

"Full SDK"

"Go open source: metabase, redash or superset."

"I really like superset. I installed all the dependencies through conda."

"Go open source: metabase, redash or superset."

"Much more of a click button install, and their docker stack is nice."

"Requires the ODBC connector which is $499/month list price. Lets your boss make whatever kind of custom spreadsheets he wants in a tool he is familiar with."

"Uses saved search exports so you don't need ODBC module."

"Learn Looker."

"Learn Tableau."

"Amazon QuickSight or google looker studio"

"Look into Grow.com! Sent you a dm"

"Sigma Computing aligns perfectly to your current stack. Snowflake's preferred BI tool, and a spreadsheet interface for the excel heavy folks."

"Hex is a great lightweight BI tool that essentially uses a Jupiter notebook framework with built-in visualizations."

"Direct database query access with SQL and virtualization for handling large datasets."

"An exceptional tool for AI intelligence that enhances productivity."

"Holistics.io offers a cloud-hosted, SQL-first BI platform with strong support for version control and a software dev workflow."

"Roosboard is a voice and search enabled business analytics platform that makes it easy to build interactive dashboards and reports."

"It takes all the data out of QuickBooks and puts it into a data warehouse. You can then access your data with Excel. It is a one-time price - not a subscription."

"BlinkMetrics systematically and automatically pulls your metrics from any tool and showcases it to you however you need."

"Holistics is a good fit for your requirements with self-service capabilities and governance."

"The Executable English platform offers a user-friendly interface that simplifies complex technology, making it accessible for various applications."

"Snowflake is an easy, affordable, and quick set-up for data warehousing."

"Amazon Redshift is a great alternative for data warehousing."

"Similar features as Looker but more agreeable pricing."

"Coefficient connects Snowflake, Tableau, HubSpot, and Google Analytics to Google Sheets."

"They're really partnership-focused and have drag-and-drop self-service reporting and dashboarding. People love them on G2 Crowd."

"SAS allows for advanced analytics right out of the box."

"BIRST is cloud based, easily configured with AWS and Redshift, and provides a robust set of enterprise BI capabilities."

"Salient is a great option for both dashboards and indepth analysis, I like their dashboards as a viewer and builder."

"Better pricing"

"SDK is vast and provides single version of truth with your metadata for business users"

"Their platform is built to deliver and automate management of analytics at massive scale. They also offer freemium tier for POCs."

"It talks to many 3rd party systems via APIs and its API connector is the best on the market"

"Costs nothing to take look and decide on your own"

"Best and affordable in the market"

"Should be perfect for this and is much cheaper than Qlik"

"Take a look at www.revealbi.io it is a native SDK which can live within your own environment."

"Also check out count.co if want more of a narrative format with good visuals."

"[Streamlit](https://streamlit.io)"

"Lesser known tool, but have you researched Dundas BI?"

"DashboardFox may be a good option compared to Crystal as it's self-hosted and one-time payment."

"Dash is a great tool for building interactive web applications with Python."

"Shiny is excellent for creating interactive web applications with R."

"NLyte effectively manages infrastructure and provides great reporting."

"Microstrategy has a product called desktop that is free and pretty simple."

"ProCore is excellent for managing construction projects."

"The basic hosted business account is free and offers reasonably priced options for growth."

"DReveal might be a great fit for C# ASP .Net."

"Quill combines the best of in-house and embedded BI."

"Rational BI offers browser-based notebook analytics, allowing for narrative flow in reports."

"Jupyter is a flexible tool for data analysis and visualization."

"It's a good alternative to subscription-based tools like Tableau and Power BI."

"Another solution would be datastudio in combination with bigquery."

"It makes getting insights out of your data as easy as Googling for it."

"Google Data Studio is simple to get started with."

"Easy reporting and an AWS partner."

"Processing is excellent for visualizations."

"Mode is improving quick."

"It will handle most situations."

"Cheaper than the PBI/Tableau crowd"

"Highcharts Dashboard has potential but still needs improvement."

"SAP Business Objects has a proven track record but is expensive and complicated."

"IBM Cognos is powerful but also expensive and cumbersome."

"Meta Base's cloud offering is paid."

"Great products, but their chance of being selected killed by a sales teams that couldn't or wouldn't answer basic questions."

"Great products, but their chance of being selected killed by a sales teams that couldn't or wouldn't answer basic questions."