Best Gemini prompts for News Analysts, Reporters, and Journalists

Using SQL, write a query to extract the last 6 months of crime data from the Snowflake database, including date, location, and type of crime. Then, use Tableau to create an interactive map that displays crime hotspots and trends over time. Finally, write a Python script to calculate the correlation between crime rates and demographic factors such as income level and education, and include the results in the Tableau visualization. Ensure the query is optimized for performance and the visualization is clear and easy to understand.

Design an ETL pipeline using Python to extract social media posts related to a specific news topic from Twitter and Facebook, transform the data into a structured format, and load it into a Snowflake database for analysis. The pipeline should handle errors and exceptions, and include data cleaning and filtering steps to remove irrelevant or duplicate posts. Write a SQL query to validate the data loaded into the database and ensure it meets the required quality standards.

Build a regression model using R to predict the engagement (likes, shares, comments) of news articles based on factors such as headline, content, and publication time. Use a dataset of historical article engagement data to train and test the model, and evaluate its performance using metrics such as mean absolute error and R-squared. Write a report summarizing the findings, including the most important factors influencing engagement and recommendations for improving article engagement based on the model's predictions.

Analyze a dataset of survey responses from a recent news poll using Python, including calculating summary statistics such as mean, median, and standard deviation for each question, and performing hypothesis tests to determine if there are significant differences in responses between different demographic groups. Visualize the results using Tableau, including bar charts and scatter plots to illustrate the relationships between variables. Write a brief report summarizing the key findings and implications for the news story, and include recommendations for follow-up questions or additional analysis.