Skip to content

YassinAnalytics/YassinAnalytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

62 Commits
ย 
ย 

Repository files navigation

Hi, I'm Yassin ๐Ÿ‘‹

Project Manager | Product & Data Enablement (PSM I, PSPO I)

๐Ÿ“ Paris | Turning complex projects into measurable outcomes through agile delivery, automation & analytics

๐Ÿ“ Publications

Featured Projects :

๐Ÿ“Š Automated Product Health Monitoring

  • Anomaly Detection โ†’ AI Root Cause โ†’ Daily Reports
  • Daily monitoring of revenue & usage metrics
  • Detect anomalies using statistical baselines (not fixed thresholds)
  • Log incidents with severity and full context
  • Send alerts only when action is required (Slack & Email)
  • Generate AI-based root cause analysis & recommendations
  • Produce a daily Product Health Report for leadership
  • Optional Notion documentation for incidents & history

Status: Completed n8n Postgres Analytics OpenAI Slack Gmail Notion Jira

GitHub

๐Ÿง  Multi-Channel Feedback โ†’ Product Backlog

Telegram + Forms + Email โ†’ AI โ†’ Jira โ†’ Notion

  • Collect user feedback from:
  • Telegram bot
  • Google Forms / Sheets
  • Gmail
  • Normalize all inputs into a unified structure
  • AI-powered analysis:
  • Category (bug, feature, questionโ€ฆ)
  • Sentiment & pain level
  • Business impact & effort
  • Summary & acceptance criteria
  • Compute a RICE-style priority score with tier weighting
  • Automatically:
  • Create a Jira issue
  • Generate a Notion documentation page
  • Log analytics to Google Sheets
  • Produce a monthly Product Intelligence Report with insights & trends

Status: Completed n8n Telegram GoogleForms GoogleSheets Gmail OpenAI Jira Notion

GitHub

๐Ÿงช Data Quality Monitoring

  • Notion Rules โ†’ SQL Checks โ†’ AI Diagnostics โ†’ Alerts
  • Centralize data quality rules in Notion (table, field, condition, severity)
  • Automatically convert rules into live SQL checks
  • Detect anomalies across your data warehouse
  • Aggregate results into a global data health score
  • Generate AI-powered root cause analysis & fix recommendations

Create:

  • Notion run records
  • Optional Jira incidents
  • Slack / Email alerts
  • Silent execution when data is healthy (zero noise)

Status: Completed n8n Notion SQL Postgres OpenAI Slack Gmail Jira

GitHub

๐Ÿ” B2B SaaS Renewal Risk Management

  • CRM + Usage + Support โ†’ Churn Scoring โ†’ Playbooks
  • Daily detection of subscriptions expiring in Jโ€“30
  • Enrich accounts with:
  • CRM data (HubSpot / Salesforce / Pipedrive)
  • Product usage analytics
  • Support tickets (Zendesk)
  • Compute an internal churn risk score
  • Route each account to an automated playbook: ๐Ÿ”ด High risk โ†’ Jira + Trello + Slack + Email escalation ๐ŸŸ  Medium risk โ†’ Proactive CSM follow-up ๐ŸŸข Low risk โ†’ Light renewal reminder
  • Log all decisions into a database for dashboards & analysis
  • Send a daily renewal risk summary email

Status: Completed n8n Postgres HubSpot Salesforce Pipedrive Zendesk Slack Gmail Trello Jira

GitHub

๐Ÿšจ Urgent Task Escalation (Google Sheets โ†’ Gmail โ†’ Telegram โ†’ Jira)

  • Detect Urgent tasks automatically from Google Sheets
  • Send an immediate personalized email alert
  • Mark the task as Notified to prevent duplicate alerts
  • Wait and re-check the task status after a delay
  • If still unresolved โ†’ send a Telegram escalation
  • Automatically create a High Priority Jira ticket and send a Telegram message with the ticket details

Status: Completed n8n Gmail GoogleSheets Jira Telegram

GitHub

๐Ÿ“ฌ Send One-Time Email Alerts from Google Sheets (Anti-Spam)

  • Trigger an email when a taskโ€™s Priority = Urgent in Google Sheets
  • Prevent duplicates by writing โ€œNotifiedโ€ back to the sheet
  • Personalize the alert with Task, Owner, Deadline, Status, Next Step
  • Plug-and-play with Google Sheets + Gmail credentials

Status: Completed n8n Gmail GoogleSheets

Template Available

GitHub

๐Ÿ“Š Automated Sprint Reports from Jira to Gmail

  • Generate sprint reports automatically from Jira
  • Calculate KPIs (tickets, story points, blockers, completion rate)
  • Build HTML report with summary & detailed table
  • Send directly to stakeholders via Gmail on schedule

Status: Completed n8n Jira Gmail Template Available

GitHub

โšก Create Jira Tickets from Google Forms (via n8n)

  • Capture responses directly from Google Forms and route them into Jira
  • Transform and map form fields into Jira issue schema automatically
  • Instantly return Jira issue key & URL for tracking

Status: Completed n8n Jira GoogleSheets Gmail GoogleForms

GitHub

๐Ÿš€ Create Jira Tickets from Streamlit Forms

  • Create Jira issues instantly from a Streamlit app
  • Validate & transform form data into Jira API schema
  • Prevent duplicate submissions with built-in safeguards
  • Return instant JSON responses with Jira issue key & URL

Status: Completed n8n Streamlit Python Jira

GitHub

โš™๏ธ Automate Jira Ticket Creation from a Streamlit App (via n8n)

  • Create Jira issues from a Streamlit form via an n8n webhook
  • Validate and map fields (Project Key, Issue Type, Priority, Labels, Assignee, Epic Link)
  • Return the created issue key and URL for instant follow-up
  • Include a compact dashboard to review recently created issues
  • Offer optional AI-style summaries generated locally (no external AI required)

Status: Completed Streamlit Python Jira Template Available

GitHub

๐Ÿ“‹ Automated Meeting Minutes Distribution

  • Streamlined workflow for sharing meeting notes via Gmail:
  • Automatically sends meeting minutes from Google Sheets to stakeholders
  • Supports structured note-taking with predefined columns (Topic, Status, Owner, Next Step)
  • Eliminates manual distribution of meeting summaries

Status: Completed n8n GoogleSheets Gmail Template Available

GitHub

๐Ÿ“ง Instant Google Form to Gmail Notifications

  • Real-time notification system for Google Form submissions:
  • Sends immediate email alerts for new form submissions
  • Delivers notifications within ~1 minute of submission
  • Perfect for time-sensitive workflows and urgent requests

Status: Completed n8n GoogleSheets Gmail GoogleForms Template Available

GitHub

๐Ÿ“ง Daily Google Form Submissions to Gmail Recap

  • Automated workflow consolidating daily form submissions into organized email summaries:
  • Aggregates all daily Google Form submissions into single digest
  • Delivers structured recap at scheduled time (default 5 PM)
  • Integrates Google Sheets โ†’ Gmail via n8n automation

Status: Completed n8n GoogleSheets Gmail GoogleForms Template Available

GitHub

๐Ÿค– Telegram Daily Calendar Assistant

Automated workflow delivering daily agenda summaries via Telegram:

  • Automates calendar monitoring using n8n workflows
  • Delivers personalized morning briefings at 7 AM
  • Integrates Google Calendar โ†’ Telegram via API magic

Status: Completed n8n GoogleAPI Telegram Template Available

GitHub

๐ŸŽฎ Video Game Market Analysis (1980-2016). Leveraged SQL and Power BI to uncover key industry trends

  • Analyzed 16,598 game titles using SQL and Power BI to uncover:
  • Regional market trends (NA vs EU vs JP vs Other markets)
  • Platform dominance patterns

Status: Completed SQL PowerBI

GitHub

๐Ÿ“Š TikTok Engagement Analysis. What drives engagement on TikTok? A data dive into 19K videos

  • Processed 19K videos to determine engagement drivers
  • Discovered likes account for 82% of total engagement
  • Developed correlation models between views, shares, and comments

Status: Completed Python SQL PowerBI

GitHub

๐Ÿ“Š Retail Analytics Dashboard - Case Study : SaaS solution replacing complex Power BI for omnichannel retailers

  • 62% faster decisions with AI alerts
  • 100% adoption by non-technical teams
  • 22% reduction in out-of-stock situations

Status: Completed PowerBI Figma

GitHub

โšฝ๏ธ MPG Player Recommender โ€“ Fantasy football picks optimizer
Built with Python and Power BI to surface undervalued players on Mon Petit Gazon (Premier League):

โ€ข Fetched and cleaned 531 player records via MPG
โ€ข Engineered features: recent form (last 5 matches), cost-value ratio, position scarcity
โ€ข Deployed interactive dashboards: Power BI template

Status: Completed PowerBI Python

GitHub

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published