Can you make a video where you show how to connect to a database, using MySQL workbench and MySQL-Python-connecter. And show us how to retrieve data and analyse it or how to insert data
Embedded sql in power BI for dynamic date range filters and more! Whenever I do this I write my sql as a CTE then use chat gpt to convert it to a sub query, per requirement of power bi
Short term it just works and non data nerds don't need to know how.
This is exactly I’m dong now, but I also a domain ‘expert’ or someone who understand the business.
Love your videos
Please do make a video on complete machine learning roadmap Its much needed ❤
Now you can do this easily in Chatgpt + Plugins
Can you make a tutorial video on how to go about it?
If you connect your excel to my production database, i will seek termination of whoever granted you credentials. Regards, DBA.
Not a data nerd but pretty sure you should putting something between a production database and anything like PowerBi (IE: Redshift)
people, do your best to not have your dashboards running on raw sql. it is not advisable to have biz logic sitting in BI tools
make a tutorail
I know this videos a few months old.. but any suggestions for building a reporting tool with input functionality? From my search I’ve found that SQL Alchemy or Flask are my best bets.. but figured it’s worth asking. Basically want to have live data like with Tableau but be able to make updates and the data can be refreshed continuously
Is this connection between DB and excel termed "powerquery"? I want to learn this badly, do you have videos on this?
Data data data
I can't believe you pronounce SQL SQL
Python can do that right? Not in BI, but in a jupyter notebook, export that to a PDF? Does that work?
😂😂😂 Hopefully the Final Time…never! It will be at the least 3 different requests 😂
wow, it's not eskyu-el
@jordanmartinetti8224