Upstatement’s Post

Don't threaten a reporter. You'll just make 'em ornery. Example: When researching a fairly innocuous (I thought) story about a well-known organization, an interviewee asked to "edit" my story before it was published. No. I explained that wasn't an option. I'll share facts for checking, but the only person who gets to edit my story would be … my editor. Interviewee then "shared" a story about a previous magazine article about the organization, where someone was misquoted, and while he "didn't know the details," Legal got involved, and the magazine had to destroy all the copies, or pay money, or something. Now I had to ask: If they resort to threats, what do these folks have to hide? I dug deeper. The resulting story was a bit more negative than what I'd originally envisioned. My original version would've been fair and accurate, as was the final result. There are many different ways to tell a story. The more negative version wasn't out of vengefulness. The threat pinged my reporter spidey sense, and that's where it took me. But just know that, if you try to tell a reporter what to do, or worse, threaten, it is likely to backfire.

Let's assume that your cat isn't the most politically engaged, but one day you ask him "Hey, do you think more cats should be armed with high-powered assault lasers?" Some cats might have strong opinions on this. But, as expected, your cat hadn't really considered the issue and is pretty ambivalent. Or, hypothetically, let's say that right before you raise this question, your cat had been reading the Paw Street Journal. They'd just seen a chart showing recent polling results. Apparently a 75% of cats support "cat-mounted assault lasers." In this scenario, you might notice that your otherwise unopinionated cat has become suspiciously pro-laser. Why? Similar to people, most cats aren't experts in public policy. They don't have the background (or interest) to really unpack the implications of big issues and come to perfectly-reasoned opinions. Instead, their political attitudes are heavily influenced by the attitudes of other cats. Like people, cats' opinions are socially driven. As Cindy Y. Xiong Ph.D. and I show in our paper, these social conformity effects can actually spread through charts and graphs that visualize public opinion survey results. This is my personal mega-post on our findings, wherein I reduce modern political polarization into shameless analogies about opinionated cats & dogs, and attempt to unpack more context and implications for dataviz design and political data journalism. https://lnkd.in/eK2bNmhG

Snapchat pays Data Scientists $250k Can you solve a real Snap SQL Interview question? Assume you're given tables with information on Snapchat users, including their ages and time spent sending and opening snaps. Write a query to obtain a breakdown of the time spent sending vs. opening snaps as a percentage of total time spent on these activities grouped by age group. Round the percentage to 2 decimal places in the output. Link to the full problem, multiple hints, and a place for you to test out your SQL query: https://lnkd.in/efRg9EYe

Snapchat pays Data Scientists $250k Can you solve a real Snap SQL Interview question? Assume you're given tables with information on Snapchat users, including their ages and time spent sending and opening snaps. Write a query to obtain a breakdown of the time spent sending vs. opening snaps as a percentage of total time spent on these activities grouped by age group. Round the percentage to 2 decimal places in the output. Link to the full problem, multiple hints, and a place for you to test out your SQL query: https://lnkd.in/euSxcftF

Snapchat pays Data Scientists $250k Can you solve a real Snap SQL Interview question? Assume you're given tables with information on Snapchat users, including their ages and time spent sending and opening snaps. Write a query to obtain a breakdown of the time spent sending vs. opening snaps as a percentage of total time spent on these activities grouped by age group. Round the percentage to 2 decimal places in the output. Link to the full problem, multiple hints, and a place for you to test out your SQL query: https://lnkd.in/efRg9EYe

I find this very moving. Send Caleb your best tips! But I’ll take your leftovers

📊 HUMAN RIGHTS DATA | Data is key to protecting human rights. By unlocking the power of #DataViz, we can track violations, drive accountability, and help people flourish. Check out the Rights Tracker's easy to understand human rights scores here⤵️ https://ow.ly/5Qbg50PQJtt

Start doing more unguided projects ✅ But why? 🤔 The main benefit of doing unguided projects is that they help clarify the concepts you have learned. Additionally, this builds self-confidence, which in turn can help you land a job. If this sounds convincing, then give our latest resume project challenge a try The challenge is to analyze historical election data and provide insights from the 2014 and 2019 elections to a private media company named AtliQ Media. Highlights: 1️⃣ This is free, no cost barrier 🆓. 2️⃣ This will help you to practice both technical and soft skills 🛠️💬. 3️⃣ The Dataset & problem statement that mimics real-world scenarios 🌏. 4️⃣ We'll feature the top presentations on our social media channels 📲. 5️⃣ Top 3 winners will be featured on our website 🏆. 👉 Participation Link: https://lnkd.in/ekx-KkgK #codebasics #resumeprojectchallenge #data #dataanalyst

📣Cool narratives job alert: The Global Narrative Hive is looking for a Network Lead! The Hive a new-ish network, build on the connecting of networks of many groups, seeking to further connect and grow the global ecosystem of activists and campaigners, communications workers, researchers, artists, journalists and many others using narratives to advance their visions of a more just world. Where does the hive come from? Born out of an eighteen-month co-design process involving more than 400 individuals from around the world, we work to bridge disconnects in the narratives field – facilitating shared learning between actors with different skills and knowledge and creating space for new actors to build connections and experiment with narrative strategies. 🙌The role: The Network Lead is a new leadership role intended to consolidate and grow the reach of the Global Narrative Hive, working with a small, international staff team. There's been a Q A ongoing via padlet: https://lnkd.in/etx74yae Check out the hive on their medium space: https://lnkd.in/exeM5g2F

💡 MainStreet Macro: New era in hiring 🔦 New research reveals the extent to which remote work has affected hiring trends. In this episode of MainStreet Macro, ADP Chief Economist Nela Richardson shares new data on the shifting geography of hiring. https://lnkd.in/dZs64mQb