The hottest Data Analysis Substack posts right now

And their main takeaways
Top Technology Topics
benn.substack 635 implied HN points 23 Feb 24
  1. In business analysis, there are two main approaches: a structured method using known metrics and BI tools and a more creative, less structured method that involves asking unique questions and using tools like Excel, SQL, and Python.
  2. The prediction that natural language will replace SQL in data management interfaces is interesting, but the role of SQL might evolve rather than disappear completely, still being crucial for generating queries efficiently.
  3. Artificial intelligence can assist in tasks like drawing or writing formulas, but the precision and efficiency of code often make it a better choice for data analysis, despite the potential for AI advancements in building complex queries.
Ground Truths 3934 implied HN points 19 Feb 24
  1. Polygenic risk scores can provide valuable information on high genetic risk for diseases like heart disease and cancer, beyond traditional clinical risk factors.
  2. The use of polygenic risk scores is advancing thanks to efforts like the eMERGE consortium, incorporating multi-ancestry data and rigorous validation.
  3. Actionable polygenic risk scores have the potential to reduce health disparities and enhance preventive strategies in medical practice.
Graphs For Science 52 implied HN points 24 Feb 24
  1. k-Core Decomposition is a way to explore the structure of networks by identifying the largest subgraph where every node has a specified minimum degree.
  2. The k-Core Decomposition algorithm involves recursively removing nodes with degrees lower than a specified threshold to reveal the k-core and k-shell structure of a graph.
  3. The degree of a node in a k-core doesn't have an upper limit, providing unique insights into network connectivity beyond traditional degree-based analysis.
Richard Hanania's Newsletter 3511 implied HN points 12 Feb 24
  1. Social scientists often resort to statistical relationships when randomized experiments are not feasible, which can lead to flawed conclusions due to selection effects and confounding variables.
  2. Flawed data is often worse than having no data at all, as it can mislead individuals into making decisions based on inaccurate information.
  3. To form reasonable opinions on social, political, and economic issues, it is essential to prioritize well-grounded ideas backed by theoretical reasoning and empirical data over blindly following data from flawed social science research.
Odds and Ends of History 2077 implied HN points 12 Feb 24
  1. AI technology, like the one used in TfL's Tube Station experiment, is rapidly changing and being implemented in various sectors.
  2. AI cameras at stations can have a wide range of uses, from enhancing security to improving passenger welfare and gathering statistical data.
  3. While AI technology offers numerous benefits, there are also concerns about privacy, surveillance, and potential misuse of the technology.
Get a weekly roundup of the best Substack posts, by hacker news affinity:
The Gradient 20 implied HN points 24 Feb 24
  1. Machine learning models can sometimes seem good but fail when applied to real-world data due to complexities that cause overfitting without being obvious
  2. Issues with machine learning models are increasingly reported in scientific and popular media, impacting tasks like pandemic response or water quality assessments
  3. Preventing mistakes in machine learning involves using tools like the REFORMS checklist for ML-based science to ensure reproducibility and accuracy
The Honest Broker Newsletter 714 implied HN points 12 Feb 24
  1. Europe experiences significant economic losses due to weather and climate disasters, averaging about €15 billion annually.
  2. Storms and floods are the main causes of losses in Europe, with heatwaves also impacting the region.
  3. Data collection on disaster impacts in Europe is lacking, making it challenging to assess long-term trends in weather and climate-related losses.
MatchQuarters 452 implied HN points 05 Feb 24
  1. Defensive coordinators should approach game planning holistically instead of solely relying on numbers.
  2. Offenses aim to create space, while defenses work to constrain it.
  3. Simplify the process of breaking down opponents by focusing on key formations, movements, and plays to develop a comprehensive game plan.
Brad DeLong's Grasping Reality 215 implied HN points 10 Feb 24
  1. Don't prioritize 'vibes' over actual data - the economy is actually excellent compared to past years.
  2. Partisanship influences perceptions of the economy - Democrats more optimistic than Republicans.
  3. Journalists sometimes emphasize negative news, even when data shows a positive economic situation.
sebjenseb 196 implied HN points 10 Feb 24
  1. Assortative mating occurs between races, with individuals who date outside their race being more similar to each other in terms of intelligence, height, and risk-taking behaviors.
  2. Current literature suggests that interracial relationships may have a higher likelihood of ending or experiencing domestic violence issues, and mixed-race children might be more prone to mental/behavioral problems, possibly due to self-selection rather than social factors.
  3. Attractiveness was a weak predictor of interracial dating across all races, indicating that mate value or race exchanges based on mate value were not significant factors in interracial dating.
Grace on Football 687 implied HN points 23 Jan 24
  1. Mohamed Salah's exceptional performance and consistency make him irreplaceable on the field.
  2. Using data and statistical analysis can help identify potential players to fill Salah's role.
  3. To replace Salah, focus on finding players who can contribute in areas like goal-scoring, creativity, and left-footedness to maintain team balance.
Implications, by Scott Belsky 1356 implied HN points 04 Jan 24
  1. The future will be personalized to your preferences, with digital experiences tailored to you.
  2. Local OS-native AI models will improve everyday life and redefine consumer AI, focusing on personalization, trust, and privacy.
  3. Small brands will become more competitive with big brands, AI will influence purchase decisions, and education will undergo a significant transformation.
Stealing Signals 137 implied HN points 10 Feb 24
  1. Success in fantasy football is not solely reliant on the advice of experts but on the effort and engagement of the players themselves.
  2. Examining individual players within the context of their own careers is more valuable than making comparisons between players in different situations.
  3. Considering full-season data without understanding how it was accumulated and the conditions present can lead to flawed predictions for the upcoming season.
SemiAnalysis 7576 implied HN points 27 Sep 23
  1. Eroom's Law and Moore's Law are critical in Semiconductors and Drug Research, analyzing time, money, and output.
  2. Healthcare, a $4 trillion industry, lags behind in technological progress driven by Moore's Law.
  3. Illumina acquisition by Nvidia could bridge the gap in genomics, addressing bottlenecks and enabling full-stack healthcare solutions.
After Babel 1118 implied HN points 03 Jan 24
  1. Researchers should stop using the Global Burden of Disease study for analyzing mental health trends.
  2. The youth mental health crisis is not just limited to America, but is an international issue in many Western countries with high levels of smartphone adoption.
  3. The Global Burden of Disease study underestimates changes in mental health statistics since 2010, especially in depression, self-harm, and suicide rates.
Cremieux Recueil 235 implied HN points 02 Feb 24
  1. Before Loving v. Virginia in 1967, state laws banning interracial marriage were common in the U.S., stretching back to the 1600s.
  2. Since the legalization of interracial marriage, the rates have increased over time, showing a more mixed ethnoracial composition in America.
  3. Analysis of interracial marriage rates can provide insights into race relations, impact of societal movements like the 'Great Awokening,' and patterns of intermixing across different races and sexes.
SeattleDataGuy’s Newsletter 871 implied HN points 26 Dec 23
  1. Seattle Data Guy's work in 2023 involved filming videos, virtual conferences, and writing articles and newsletters.
  2. Client trends in 2023 showed shifts towards greenfield projects, solution design, marketing, and education.
  3. Popular articles in 2023 covered topics like data modeling, breaking out of tutorial hell, and essential templates for data analytics.
Onchain Wizard's Cauldron 137 implied HN points 02 Feb 24
  1. The chainEDGE 3.0 update brings significant improvements for users, including enhanced UI and filtering options.
  2. The new version features tools like auto-filtering of low liquidity tokens and detailed insights into smart money swaps.
  3. chainEDGE 3.0 offers optimized token and wallet pages, along with a Portfolio God dashboard for sorting and filtering smart money holdings.
Shades of Greaves 412 implied HN points 12 Jan 24
  1. The author tried investing $250 in ads for their self-published book but didn't see good returns, highlighting the challenges of advertising for self-published authors.
  2. Despite spending on ads, the author sold very few copies through Facebook and Amazon, underscoring the risk of not getting desired results from advertising efforts.
  3. Data from the failed ad campaigns is seen by the author as a way to learn and refine future advertising strategies, showing the importance of using past experiences to improve future marketing efforts.
RESCUE with Michael Capuzzo 9787 implied HN points 08 Jun 23
  1. John Berndsen's heart complications after receiving the Pfizer vaccine illustrate a potential link to myocarditis and the importance of questioning vaccine safety.
  2. Many adverse reactions to COVID-19 vaccines are not being reported in the media, and the numbers show a significant impact on health, including deaths.
  3. John Berndsen's experience highlights the importance of critically examining the safety and necessity of additional vaccine doses, especially for vulnerable individuals.
Scott's Substack 117 implied HN points 31 Jan 24
  1. No anticipation means the baseline period is equal to Y(0) not Y(1)
  2. Difference-in-differences coefficient equals ATT in the post period for the treatment group plus parallel trends bias minus ATT in the incorrectly specified baseline period
  3. Difference-in-differences always requires three assumptions to point identify the ATT: SUTVA, Parallel trends, and No Anticipation
Steve Kirsch's newsletter 10 implied HN points 19 Feb 24
  1. The New Zealand OIA request revealed that COVID vaccines were found to increase the risk of dying, instead of providing protection against COVID.
  2. The data released under OIA showed that vaccinated individuals experienced a significant increase in mortality during the COVID outbreak, contrary to what was expected.
  3. Mainstream epidemiologists have avoided analyzing the data that shows the vaccines increased the risk of dying from COVID, leading to a lack of public discussion and questioning.