Best bi tool on Reddit

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

"Cheaper alternatives, gaining market share"

"But, if you have O365 licences, Power BI would be an option. Keep in mind you will probably need to set up Gateways."

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

"Good option, but I wouldn’t recommend it unless experiencing lots of hyper growth as I firmly believe a Looker scales the best"

"Looker doesn't run locally and needs a stack to run effectively."

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

"Two places I have worked used Tableau for that"

"Perfect for scenario"

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

"Handles most use cases"

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

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

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

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

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

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

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

"Sounding like a great option for you"

"Works well in this scenario"

"Great, simple, intuitive"

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

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

"Still supporting qlikview"

"Amazing"

"Basic power bi functionality included with most licenses"

"Learn PowerBi."

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

"Full SDK"

"Learn Looker."

"Learn Tableau."

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

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

"Better pricing"

"Embedded apps via KNIME Server"

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

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

"User based filter"

"Work top down."

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

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

"Embedded analytics is their sweet spot"

"Focuses on the AWS eco-system"

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

"Fairly robust and would meet your needs"

"Learn Python data science libraries and Dash."

"Mode is improving quick."

"It will handle most situations."

"Cheaper than the PBI/Tableau crowd"