Professional Context
Between meeting today's deadline for the evening news broadcast and digging deeper into the trends hidden within the latest crime statistics, the daily priorities of a News Analyst are constantly at odds, making it essential to optimize data analysis workflows and model precision.
💡 Expert Advice & Considerations
Don't waste time trying to use Gemini for creative writing; focus on using it to analyze and visualize data, and then use those insights to inform your reporting.
Advanced Prompt Library
4 Expert PromptsCrime Rate Analysis and Visualization
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.
ETL Pipeline for Social Media Data
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.
Regression Model for Predicting News Article Engagement
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.
Statistical Summary of Survey Responses
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.