A while ago, I came across a post where an experienced data analyst shared some of the ChatGPT prompts they use to speed up their workflow.
I saved a few, tried them while learning and they genuinely made things easier
So I decided to put together my favorites in one place.
Here are 30 ChatGPT prompts that can save analysts hours every week. ๐
Deloitte asked these Power BI interview questions.
Can you answer all of them without Google?
โข Difference between Import, DirectQuery, and Live Connection
โข Explain Star Schema vs Snowflake Schema
โข What is row context vs filter context in DAX?
โข When would you use CALCULATE()?
โข How do you optimize a slow Power BI report?
โข Difference between SUM and SUMX
โข What is context transition?
โข How does incremental refresh work?
โข How do you implement Row-Level Security (RLS)?
โข What are gateways, and why are they required?
If you can answer these confidently,
You're already ahead of most candidates.
๐ Save this for your next Power BI interview.
GOOGLE Free Courses With Certificates
โข Cybersecurity
https://t.co/BnW1z0ULzgโฆ
โข Business Intelligence
https://t.co/nLNUyCvZY1โฆ
โข Advanced Data Analytics
https://t.co/nLNUyCvZY1โฆ
โข Digital Marketing
https://t.co/ScQmf6mDEIโฆ
โข AI & Machine Learning
https://t.co/64ou8n2bisโฆ
โข Data Analytics
https://t.co/44SHsRArXxโฆ
โข Project Management
https://t.co/TrR95pDuKQโฆ
โข UX Design
https://t.co/BaW7gMiVZJโฆ
โข IT Automation
https://t.co/nLNUyCvZY1โฆ
โข IT Support
https://t.co/nLNUyCvZY1โฆ
Get certified and boost your career with Google courses.
If youโd love to see more content like this, donโt forget to follow @aiwithjonny for more content... ๐๐๐๐
Want to learn SQL without getting bored?
Try these 5 websites that teach SQL like a game:
โ SQL Murder Mystery โ Solve a crime using SQL queries ๐ต๏ธ
โ SQLBolt โ Interactive lessons with instant feedback
โ SQLZoo โ Practice SQL step by step with challenges
โ Select Star SQL โ Learn by completing fun missions
โ Lost at SQL โ Escape-room style SQL puzzles
Learning SQL becomes much easier when you solve problems instead of just watching tutorials.
Bookmark this for your Data Analytics journey.
SQL Joins made simple
Imagine 2 tables are 2 friend lists.
Table A = Employees
Table B = Departments
Both are connected using Department ID.
โ INNER JOIN
Shows only the people who have a matching department.
Think: "Common friends only."
โ LEFT JOIN
Shows everyone from the Employees table, even if they don't have a department.
Think: "All employees + matching departments if available."
โ RIGHT JOIN
Shows every department, even if no employee belongs to it.
Think: "All departments + matching employees if available."
โ FULL OUTER JOIN
Shows everything from both tables.
Matched records stay together, unmatched records are also shown.
Think: "No one gets left out."
If SQL Joins confused you before, remember this:
INNER = Common
LEFT = All Left
RIGHT = All Right
FULL = Everything
Save this for your next SQL interview.