Personally, I like to make sure the SQL works the way I want first and use SQL Developer for that. After that, I shall then put in the query in Power BI.
You are viewing a single comment's thread from:
Personally, I like to make sure the SQL works the way I want first and use SQL Developer for that. After that, I shall then put in the query in Power BI.
SQL developer is a foreign language and totally new tool when you don't know sql and just come from an excel background. But when I get to developing more complex queries this will be an option
yes, it is quite fun when you get the hang of it and give your better control.
there's another 2 tool I heard of which I have not tried is Lincpad and Valentina Studio.
only because I'm quite comfortable with SQL developer.
although I did go to the Valentina Studio to read bit about and was bit impress.
maybe something for you to consider https://www.valentina-db.com/en/valentina-studio-overview :-)
I use Valentina Studio for my steemsql SQL queries. It works pretty well once you get the hang of it. And it's free.
Yay... free is good. So, is SQL developer but I see the Valentino Studio has a more funky look than the boring SQL developer. :)