Best ChatGPT prompts for Computer Systems Analysts

Given a complex SQL query that joins five different tables and performs multiple subqueries, identify the most performance-critical components and provide a rewritten version of the query that minimizes latency and maximizes throughput, assuming a database schema that includes the following tables: customers, orders, products, inventory, and shipping, and the following indexes: customer_id, order_id, product_id, and shipping_date.

Using a dataset that includes customer demographic information, purchase history, and support ticket data, develop a predictive model that identifies the top factors contributing to customer churn, and provide a Python script that trains a regression model on this data and outputs a ranked list of the most influential features, along with their corresponding coefficients and p-values, assuming a target variable of 'churn_status' and a set of predictor variables that includes 'age', 'purchase_frequency', and 'support_tickets_opened'.

Describe the architecture of an ETL pipeline that integrates real-time data from multiple sources, including social media APIs, IoT sensors, and cloud-based applications, and provide a high-level design document that outlines the key components, data flows, and processing steps involved in extracting, transforming, and loading this data into a Snowflake data warehouse, assuming a target schema that includes the following tables: social_media_posts, sensor_readings, and application_logs.

Using Tableau, create a data visualization dashboard that provides stakeholders with real-time insights into key business metrics, including customer acquisition costs, sales revenue, and customer satisfaction ratings, and provide a step-by-step guide on how to connect to a Snowflake data warehouse, create the necessary data models and calculations, and design a set of interactive visualizations that allow users to explore and drill down into the data, assuming a dataset that includes the following columns: 'customer_id', 'acquisition_date', 'revenue', and 'satisfaction_rating'.