Best bi tool on Reddit

"I use PBI desktop to track data for my business, as well as a very extensively built dashboard for my personal finances."

"Why not just use Power BI Desktop, it’s free to download."

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

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

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

"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 is designed to easily handle hundreds of millions of rows."

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

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

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

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

"Looker Studio is free, you can give it a shot"

"I can suggest Metabase. Easy deployment if you can follow a YouTube video and light weight if you have a on Prem server available."

"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"

"At Metabase we have embedding that covers pretty much all use cases and all budgets."

"Metabase offers robust features and flexibility."

"You can try metabase for dashboards. Easy and free"

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

"Did you take a look at Metabase’s embedding tools?"

"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"

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

"All of the tools you mention can do what you need."

"For Looker, you could play around with access filters & roles for dashboarding ACL."

"Looker is another alternative for BI tools."

"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)"

"* Superset is pretty solid, 100% open source and free, essy to configure ... kinda basic in terms of BI functionality, but can do the job a lot of the time"

"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 ;)"

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

"Qlik Sense and NPrinting"

"If import any tools like Tableau, Qlik or PowerBI can handle it fine."

"Which Qlik licensing did you look at?"

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

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

"Look into Apache Superset."

"Just use Apache Superset/Preset"

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

"Apache Superset"

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

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

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

"R + markdown reports. Higher technical overhead but once you get it set up it will be so much more impressive."

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

"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"

"Knime"

"Embedded apps via KNIME Server"

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

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

"Sigma Computing!"

"Look at https://www.sigmacomputing.com/"

"Shiny"

"R Shiny or Plotly dash"

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

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

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

"Quicksight will handle most situations."

"Quicksight is not on-prem but it's cheap af and becoming more and more capable by the day."

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

"If I had to have one tool from 2010 until now, it would be SSRS."

"SSRS"

"SQL Server Reporting Services (SSRS) or SAP Business Objects or Crystal Reports"

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

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

"Better pricing"

"Our software might line up with what you need."

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

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

"We provide external users reporting through embedded Microstrategy dossiers."

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

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

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

"I’ve worked with Holistics, and it’s been a good fit for embedding dashboards directly into apps."

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

"Streamlit is pretty great if you know some Python."

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

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

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

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

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

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

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

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

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

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

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

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

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