Andrew C. Madson

Greater Phoenix Area Contact Info
83K followers 500+ connections

Join to view profile

About

Andrew Madson is a Data Analytics, Data Science, and AI Evangelist at Dremio, where he…

Articles by Andrew C.

See all articles

Contributions

Activity

Join now to see all activity

Experience & Education

  • Dremio

View Andrew C.’s full experience

See their title, tenure and more.

or

By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.

Licenses & Certifications

Volunteer Experience

Publications

  • Data Mining FDA Docket 2019-N-1482: Content, Sentiment, and Metadata

    American Medical Writers Association

    The legal status of cannabis continues to evolve, raising challenges for medical writers who work in population health and drug safety. To guide messaging, research has investigated how the public perceives cannabis, often relying on surveys or “big data” analyses of social media. However, these methods can be costly. As a supplement, we explored comments posted to a United States Food and Drug Administration docket on cannabis science and risk, which may offer an accessible, purposive…

    The legal status of cannabis continues to evolve, raising challenges for medical writers who work in population health and drug safety. To guide messaging, research has investigated how the public perceives cannabis, often relying on surveys or “big data” analyses of social media. However, these methods can be costly. As a supplement, we explored comments posted to a United States Food and Drug Administration docket on cannabis science and risk, which may offer an accessible, purposive, cost-effective source of data. We applied a multipronged methodology that involved content analysis, sentiment analysis, and metadata analysis. The findings suggest that broad messaging on cannabis may have limited effectiveness. Instead, medical writers should design messages that emphasize the risks of particular products as well as express empathy for consumers suffering from specific conditions. Moreover, among other things, the findings suggest that medical writers should use the terms “cannabis” and “marijuana” intentionally, considering the implications of each. In the future, research should develop methods to further segment drug consumers demographically and psychographically, building on the methodology that we present here. This research may inform not just messaging but regulatory writing practices and state drug policies.

    Other authors
    See publication
  • WHICH CHART WHEN? The Data Analyst's Guide to Choosing the Right Charts

    GUMROAD

    Are you tired of spending hours crafting the perfect data visualization only to have your audience squinting, scratching their heads, or simply losing interest? As a data analyst, you know how crucial it is to present your findings in an easy-to-understand and engaging manner. After all, the insights you uncover are only as powerful as your ability to communicate them effectively.



    Fret not, fellow data enthusiasts! I've got you covered. This guide is your ultimate resource for…

    Are you tired of spending hours crafting the perfect data visualization only to have your audience squinting, scratching their heads, or simply losing interest? As a data analyst, you know how crucial it is to present your findings in an easy-to-understand and engaging manner. After all, the insights you uncover are only as powerful as your ability to communicate them effectively.



    Fret not, fellow data enthusiasts! I've got you covered. This guide is your ultimate resource for choosing the right charts to bring your data to life. No more confusion or glazed-over eyes—just clear, compelling visualizations that will have your audience eagerly following along and enjoying the journey through your data.



    By reading this guide, you'll discover the following:



    How to identify the perfect chart type for your specific data and goals
    15 popular chart types, explained in detail, with tips on when and how to use each one
    How to avoid common pitfalls that can make your visualizations less effective


    Keep your valuable insights from getting lost in translation. Dive into this guide and unlock the full potential of your data by mastering the art of choosing the right charts. Your audience will thank you, and your career as a data analyst will soar to new heights!

    See publication
  • The Lady in White (Illustrator)

    Mother's House Publishing

    After a night of fate and fury, young Jai Apprendu becomes the last of his village -- a village he could never call home. Guided by a golden charm and the oracular lady, he searches for justice, soon undertaking an epic journey of prophecy, secrecy, and conspiracy.

    Other authors
    • Michael Madson
    See publication

Projects

  • Natural Language Processing for sematic risk detection

    -

    Created a robust natural language analysis system (utilizing Google's BERT) that analyzed all global email, text, and chat traffic withing JP Morgan and identified risks in 43 specific categories.

    Systems included python, Jenkins, Classifier, git, Java, Javascript, KAFKA, Kubernetes

    See project
  • Outlier Risk Scoring

    -

  • Fairness - Enterprise Analytical Model

    -

    Created an analytical model that analyzed the FAIRNESS of faculty members' grading practices. The model was adopted by the enterprise and analyzes hundreds of thousands of evaluations every month and is utilized as a core KPI for executive decisions and process improvement.

    Systems included python, R, Tableau, Power BI

    See project
  • Accumulated Withdrawal Compliance System

    -

    I worked with legal, it, software development, and analytics teams to create a compliance system that monitors withdrawals from long-term fee-based investment management accounts.

  • Acquisition Consultant - Insurance Referral Enterprise Assimilation

    -

  • Aquisition Consultant - Investment Management Enterprise Assimilation

    -

  • Consultant - Financial Planning Software Algorithm Assumptions

    -

  • Project Manager - Performance Management Metrics

    -

  • Relationship Manager National Role Standardization

    -

  • Robo-Advisor Business Model Expansion

    -

  • Salesforce CRM Migration

    -

Honors & Awards

  • 2011 Top National Producer - Acquisitions

    -

  • Excellence In Action (multiple)

    -

  • Inaugural Member - Alumni Advisory Board

    -

  • Rock Solid - National Business Process Improvement

    -

  • Voice of the Customer

    -

Languages

  • Spanish

    Full professional proficiency

Recommendations received

More activity by Andrew C.

View Andrew C.’s full profile

  • See who you know in common
  • Get introduced
  • Contact Andrew C. directly
Join to view full profile

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More