img

Power BI/Tableau vs Superset/Metabase

Hi, I am currently evaluating which BI tool will be implemented across the company. In my earlier companies I have used Superset where I wrote SQL queries for each dashboard or insight requirement and created a visualisation directly from them. I realised that in Power BI I can't write SQL queries directly, I can only connect directly to the database tables and do the transformation inside Power BI. A workaround would be to write sql queries separately and create a view in my db and then connect power BI to the view to create a dashboard. I want to ask for your opinions on this. 1. Should I move to a tool where I can write queries and make visualisations. 2. Use views with power BI. 3. Simply abandon SQL queries and just do transformations entirely in power BI.

img

satyaNadella

Stealth

9 months ago

To answer all your questions, there’s one question that needs to be answered. How large is the data? If it’s too big/the queries take a lot of time to run directly in PBI, it’s better to connect PBI with views in which transformations have been made. If the transformations are small, then do it directly in PBI.
img

HangryJay

Stealth

2 months ago

Depends on the data size + cost. On cost side: Tableau is the most expensive tool among these with complex licensing per user pricing. PowerBI is comparatively cheaper. Superset is completely FOSS and Metabase's free version is good enough I guess. On data side: If the data is small, you can go with PowerBI/Tableau, in case of medium sized data, it would be better to use SQL queries directly and then integrating it with Metabase/Superset. However in case data is too big and SQL takes too much time to execute try creating aggregate tables using DBT and use those to power your dashboards.
Sign in to a Grapevine account for the full experience.

Discover More

Curated from across

img

Data Scientists on

by Xplorrrr072022

Polo Ralph Lauren

Advice needed for PowerBI and DAX

Hello community, Hope you are having a wonderful time. I started learning PowerBI and DAX as i feel this is probably the one i haven't tried. I already have a pretty good knowledge of Excel, Python - Pandas,numpy,etc., My current work revolves around data analysis and insight generation from one or the other way from a ton of data thrown at our team. I haven't tried Tableau yet (don't know how much it's used across industry, any idea about it, please share, much appreciated) but yes, I worked in Google data studio before (made projects during University). What are the pitfalls i need to avoid learning these tools. How widely are these used in companies, and any general thoughts about PowerBI or other platforms you use for Analysis visualisation and dashboard building which are popular or used in organisations! Regards!!

img

Indian IT on

by Arunya

Accenture

Power bi or snowflake

I have SQL experience and I am trying to switch. In terms of switching, which one will be a good option.. and any course suggestion to get hands on.. please help

img

Product Managers on

by MMM

TCS

Share your views

Is there any scope In powerbi development

img

Business Roles on

by Bizrick3

Stealth

Non-tech roles

I am currently in a sales generalist role making around 3 LPA in a startup. I am already 25 and I would like to switch into account management or a media buying role. What skills or tools should I consider learning? Currently learning excel & will be starting power BI. My goal is to reach at least 10 LPA this year through any certification or a skill. I know I have higher expectations but I am ready to learn anything that it takes.

img

Product Managers on

by Wannabe_PM

Stealth

How do you measure data and make decisions based on that?

As the title says I want to learn how and which tools do product people in startups use to query data, make dashboards, do A/B testing and all that. I'm working at a startup where none of this is practiced, so I want to know how other folks do it as most startups in the growth stage and above do this and expect the candidate to be aware of the tools, setup etc.

img

Data Scientists on

by LikelyHazel4

Student

Planning to learn PowerBi. But I do not know SQL . Can I earn well as a freelancer even if I do not know SQL ? Is it necessary to learn SQL or I better learn Python and PowerBi?

img

Referrals on

by PleasedGauge

Student

Any Career guidance or referral ✨?

Dear community, I hope this message finds you well. My name is Yash, and I recently graduated from NIT Raipur with a strong passion for Analytics. During my academic journey, I dedicated myself to acquiring skills in Power BI, SQL, Python(ML), and Excel, recognizing their pivotal role in modern analytics. Furthermore, I have had the opportunity to collaborate with various companies, where I applied my expertise in SQL to develop complex queries and conducted Data analysis projects, including sports Analytics. Additionally, I have completed four Power BI projects across different domains, showcasing my ability to translate raw data into actionable insights. I'm Not getting any positive response. Can anyone share their thoughts on my resume, what else I can do to make it better. Even apply for an internship but not getting any positive response.

img
img

Indian Startups on

by PleasedGauge

Student

Give Referral or career guidance ✨

Dear community, I hope this message finds you well. My name is Yash, and I recently graduated from NIT Raipur with a strong passion for Analytics. During my academic journey, I dedicated myself to acquiring skills in Power BI, SQL, Python(ML), and Excel, recognizing their pivotal role in modern analytics. Furthermore, I have had the opportunity to collaborate with various companies, where I applied my expertise in SQL to develop complex queries and conducted Data analysis projects, including sports Analytics. Additionally, I have completed four Power BI projects across different domains, showcasing my ability to translate raw data into actionable insights. I'm Not getting any positive response. Can anyone share their thoughts on my resume, what else I can do to make it better. Even apply for an internship but not getting any positive response.

img