Tableau

Tableau

Utilities / Analytics / Business Intelligence
Needs advice
on
PowerBIPowerBIQlikQlik
and
TableauTableau

Hello everyone,

My team and I are currently in the process of selecting a Business Intelligence (BI) tool for our actively developing company, which has over 500 employees. We are considering open-source options.

We are keen to connect with a Head of Analytics or BI Analytics professional who has extensive experience working with any of these systems and is willing to share their insights. Ideally, we would like to speak with someone from companies that have transitioned from proprietary BI tools (such as PowerBI, Qlik, or Tableau) to open-source BI tools, or vice versa.

If you have any contacts or recommendations for individuals we could reach out to regarding this matter, we would greatly appreciate it. Additionally, if you are personally willing to share your experiences, please feel free to reach out to me directly. Thank you!

READ MORE
7 upvotes·97K views
Replies (2)
Owner at Alorya art ·

Hi,

I am the owner of my actual company, we are dealing in architectural design and software development. As the owner as I have many years of experience in coding cost control management and business management, I can understand quite well your request.

There are some things which will not help you in your business and other that will help you.

On my opinion Tableau, PowerBI or Qilk will not make huge difference to you. They are all good, and very powerful, you can find good comparison sites for choosing any of them. just search google with "Tableau vs PowerBi" and it will give you sites of people having written very good analysis and comparison for each of them. i highky recommend you do this way

But, if you wish to see deeper in your business, I can recommend you other things, that many software sellers won`t tell you.

In my life, I generally coded the softwares (since 2002) that would do the same thing as them. The first time I did it, was, when I was employee in a construction company. It was for its oil and gas project. My softwares were free for ever.

The things about these softwares are not in the software. I can tell it, because after coding the softwares I was assigned for managing them. The problem was never on the software side. But always personnel behavious was the problem.

I learned to resolve personel problem by learning/ having a course of ISO 9000.

Of course I am a motivational talker, and this helped me. people were enthusiastic to apply ISO 9000 and use the software because I gave the motivational talk.

So to be successful with the software you need human behavioral things next to it.

No matter what you choose, if you see these problems happening (personnel resistance, or refusing, or slowing or blaming the software for the mistakes etc) just remember my advice, it will be a great help to you.

Also if you do not wish to loose money, try first the opensource alternatives to these software. I have many writings about software business and technical stuff about business. I shared my experiences:

I shared with you, one of my blog about your question. Hope it helps:

READ MORE
Industry Trade Construction Business and Project Management: Business Management opensource free sofwares (trade-industry-management.blogspot.com)
1 upvote·3K views
Developer at Janbask Training·
Recommends
on
PowerBI

Power BI is an amazing tool. I have been using it since very long

READ MORE
Microsoft Power BI Tutorial: Tools, Installation, Architecture (janbasktraining.com)
1 upvote·1 comment·331 views
Bhumika K
Bhumika K
·
August 25th 2025 at 7:47PM

I’ve worked with a few of the big proprietary tools (Power BI, Tableau, and Looker) as well as some open-source stacks like Metabase and Superset. Each has its strengths, but in my experience the trade-offs usually come down to cost, setup complexity, and how easily non-technical teams can actually use them.

Recently, we started using Analytify at my company, and it’s been surprisingly effective for our needs. Compared to some of the heavier platforms, the learning curve has been much lighter—our finance and ops teams can spin up dashboards without leaning on engineering. From a budget perspective, it’s been more manageable than the licensing costs we used to deal with, and it still integrates smoothly with the usual data sources.

It doesn’t try to replicate every feature of the bigger enterprise platforms, but for a fast-growing org (we’re ~400 people now), the balance of usability, flexibility, and cost has been a big win. If you’re exploring beyond the traditional players, I’d suggest at least giving it a look alongside the open-source options you mentioned.

·
Reply

Looking for the best analytics software for a medium-large-sized firm. We currently use a Microsoft SQL Server database that is analyzed in Tableau desktop/published to Tableau online for users to access dashboards. Is it worth the cost savings/time to switch over to using SSRS or Power BI? Does anyone have experience migrating from Tableau to SSRS /or Power BI? Our other option is to consider using Tableau on-premises instead of online. Using custom SQL with over 3 million rows really decreases performances and results in processing times that greatly exceed our typical experience. Thanks.

READ MORE
7 upvotes·1.1M views
Replies (2)

BI tools are only as good as the data they're connected to. If you're already experiencing performance issues, you might want to consider a cloud database like Snowflake.

In my experience, there isn't a whole lot of a difference in PBI vs Tableau, for the vast majority of analysis. Personally, I favor Tableau because you can make really fancy/pretty things, but most business don't require that level. Most of the time I've seen people choose PBI due to cost or their team is already familiar with the platform.

I also recommend checking out Sigma Computing (sigmacomputing.com), they are a BI tool built like a spreadsheet so it's easy for people to learn and understand, and they're specifically built to optimize Snowflake connections.

READ MORE
6 upvotes·582 views

You need to start using Datawarehouse (DWH) solution and then feed data to tableau. For that you need to setup data pipelines and then transform data in the DWH, move all the custom queries into the DWH. This process is called ELT. You need AWS Redshift or Google Bigquery, a serverless scalable solution, this is the bottle-neck on your current SQL, not meant for processing millions of rows of data. A team of Data engineers can help you to setup these solutions.

READ MORE
6 upvotes·1 comment·4.2K views
Paul McDonald
Paul McDonald
·
March 28th 2022 at 3:42PM

Agree with Parth this sounds like an architecture issue not a tool problem.

Tableau is a great Analytics tool but if you keep utilising large extracts with lots of filters there will be performance hits.

Try switching from a mass extract filter exclude model to direct connect, include model. For performance I can highly recommend Snowflake as the DWH platform which has been a game changer for us. Good luck.

·
Reply

We need to perform ETL from several databases into a data warehouse or data lake. We want to

  • keep raw and transformed data available to users to draft their own queries efficiently
  • give users the ability to give custom permissions and SSO
  • move between open-source on-premises development and cloud-based production environments

We want to use inexpensive Amazon EC2 instances only on medium-sized data set 16GB to 32GB feeding into Tableau Server or PowerBI for reporting and data analysis purposes.

READ MORE
5 upvotes·316.8K views
Replies (3)
Recommends
on
Airflow
AWS Lambda

You could also use AWS Lambda and use Cloudwatch event schedule if you know when the function should be triggered. The benefit is that you could use any language and use the respective database client.

But if you orchestrate ETLs then it makes sense to use Apache Airflow. This requires Python knowledge.

READ MORE
4 upvotes·246.3K views
Recommends
on
Airflow

Though we have always built something custom, Apache airflow (https://airflow.apache.org/) stood out as a key contender/alternative when it comes to open sources. On the commercial offering, Amazon Redshift combined with Amazon Kinesis (for complex manipulations) is great for BI, though Redshift as such is expensive.

READ MORE
3 upvotes·253.8K views
View all (3)

We decided to use Tableau as it will allow us to quickly create rich representations of our data. It can also integrate well into our app using the JS api. Additionally, our team's experience with this platform should assist with getting our prototype up and running speedily.

READ MORE
2 upvotes·39.5K views