100 ChatGPT Prompts to Master SQL and Tableau

If you're aiming to develop your skills in SQL or Tableau, you're in good company. These tools are essential for data analysts, and proficiency in them can significantly enhance your career prospects. But knowing where to start is often the challenge.

This guide includes 100 hands-on prompts to help you strengthen your skills in SQL and Tableau. Whether you're enrolled in a data analytics course or learning independently, these prompts are designed to give you practical experience.

50 SQL Prompts for Learning and Practice

SQL Fundamentals

• What is SQL and what are its common uses?

• List the main types of SQL statements (DML, DDL, DCL).

• Write an example of a basic SELECT query.

• How do you filter results using WHERE?

• What’s the difference between WHERE and HAVING?

Aggregations and Grouping

• How do you count records using COUNT()?

• Show how to use SUM(), AVG(), MIN(), and MAX().

• Explain GROUP BY with a real-world example.

• Combine GROUP BY with HAVING to filter groups.

Joins and Table Relationships

• What is an INNER JOIN and how does it differ from a LEFT JOIN?

• Explain RIGHT JOIN and FULL OUTER JOIN with examples.

• How do you join more than two tables?

• Provide an example of a self-join.

Filtering and Searching

• Use LIKE, %, and _ for pattern matching.

• Compare IN, BETWEEN, and NOT IN.

• How do you handle NULL values in conditions?

Data Manipulation

• How do you insert a new row into a table?

• Syntax for updating data in SQL.

• How do you delete specific rows?

• Difference between DELETE, TRUNCATE, and DROP.

Intermediate Concepts

• What is a subquery? Show a nested example.

• Use CASE WHEN for conditional logic.

• Create and use a Common Table Expression (CTE).

• Introduction to window functions.

• Compare RANK(), DENSE_RANK(), and ROW_NUMBER().

Applied SQL Analysis

• Query to find the top 3 selling products by region.

• Calculate the average order value per customer.

• Identify customers with more than five orders.

• Find orders placed in the last 30 days.

• Get the second-highest salary from an employee table.

Performance and Optimization

• How do indexes improve performance?

• Difference between clustered and non-clustered indexes.

• Best practices for writing efficient SQL queries.

• Tips for improving SQL readability.

Database Design and Modeling

• What is normalization and why does it matter?

• Describe 1NF, 2NF, and 3NF.

• What are primary and foreign keys?

• What are constraints and how are they used?

Data Cleaning with SQL

• Find and remove duplicate rows.

• Replace NULL values with default values.

• Standardize text formatting (uppercase, lowercase).

• Extract year, month, and day from a date column.

Advanced Scenarios

• How to pivot data in SQL.

• How to unpivot data for analysis.

• Use UNION and UNION ALL in queries.

• Calculate running totals using SQL.

• Compare data between two tables.

• Create and use stored procedures.

• Simulate a small sales database and query it.

• Suggest a small portfolio project using SQL.

50 Tableau Prompts for Learning and Practice

Getting Started with Tableau

• What is Tableau and why is it commonly used?

• How to import Excel or CSV files into Tableau.

• Difference between Tableau Desktop and Tableau Public.

• Define dimensions vs. measures.

• Overview of Tableau’s workspace and its sections.

Building Basic Visuals

• Create a bar chart using Tableau.

• Build a line chart to show trends over time.

• Create a pie chart for category breakdown.

• What is a scatter plot and when to use it?

• How to add labels, colors, and sizing to enhance visuals.

Designing Dashboards

• Combine multiple sheets into one dashboard.

• Add interactivity using filters and actions.

• Create filters that apply across all charts.

• Add dynamic titles to dashboards.

• Design mobile-friendly dashboards.

Working with Maps

• Create a map visualization in Tableau.

• Visualize sales by region with filled maps.

• Enable tooltips for map data.

Data Cleaning in Tableau

• Introduction to Tableau Prep.

• Clean and combine datasets.

• Rename, split, and group fields in Tableau.

Using Calculated Fields and Logic

• What are calculated fields and how are they used?

• Create a calculated field for profit margin.

• Use IF, CASE, and ZIN functions.

• Calculate year-over-year or month-over-month growth.

Advanced Analytics in Tableau

• Introduction to Level of Detail (LOD) expressions.

• Explain FIXED, INCLUDE, and EXCLUDE.

• Calculate running totals.

• Create moving average charts.

• Highlight top N customers by sales.

Choosing and Creating Chart Types

• When to use histograms vs. boxplots.

• Create a waterfall chart.

• Build a bullet chart.

• Use dual-axis charts effectively.

Data Relationships and Blending

• Difference between joins and blending in Tableau.

• Use Tableau relationships instead of traditional joins.

• Simulate a use case with customer and sales data.

Improving Interactivity and UX

• Add filter and highlight actions to dashboards.

• Use URL actions for external linking.

• Create parameters to control visuals dynamically.

Tips and Best Practices

• Create bins or grouped dimensions.

• Use sets to compare categories.

• Design an interactive heat map.

• Choose the right chart for the data.

• Schedule automatic Tableau dashboard refreshes.

Real-World Use Cases

• Build a sales dashboard with KPIs and trends.

• Track website traffic in Tableau.

• Create a dashboard for HR data.

• Visualize churn and retention trends.

• Suggest a Tableau project for a portfolio.

Conclusion

Whether you're enrolled in a data analytics course or self-learning, these SQL and Tableau prompts provide structure and clarity to your learning path. Each one is a stepping stone toward building a stronger foundation in data analytics. Use them to practice, explore real-world scenarios, and build projects for your portfolio.

By engaging with practical exercises, you're not just memorizing syntax—you’re learning to think like a data analyst.