Portrait of Ayush Patel

Data Analyst

SQL • Python • Power BI • Tableau • Excel

  • Data quality & automation
  • KPI dashboards
  • Data Analysis and Storytelling
View Projects
0
Years in Tech

Projects

Capstone dashboard screenshot

Data Analysis & Visualization (Capstone)

Analyzed LinkedIn postings with Tableau, Excel, SPSS; clustering + predictive models for trends & skills.

Outcome: recommendations for curriculum & hiring focus.

View Project
HEAD competition poster

Extreme Weather Risk & Facilities

Forecasted FCI degradation; proposed mitigation for floods, early warnings, resilient materials.

Outcome: prioritized maintenance & budgets.

View Project
Weather Dashboard — animated hero with charts

Weather Trends Dashboard (Streamlit)

Live conditions and historical trends with interactive charts, city search, KPIs, and one-click CSV/HTML exports. Data via Open-Meteo APIs.

Tech: Python • Streamlit • Altair • Pandas • REST APIs

Live App GitHub
Login alert UI

Login Alert System (Python)

Captures login details, webcam snapshot, emails alerts for suspicious activity.

Impact: faster response to unauthorized access.

View Project
Task API UI

Task Management API + UI

Flask + SQLite REST API with scheduling, reminders, user management and simple front end.

View Code

Education

B.Sc. in Computer Application & Information Technology

Sardar Patel University — CGPA 9.65

Cyber Security Analytics (Honours)

Mohawk College — Hamilton, ON

Analytics for Business Decision Making

Mohawk College — Hamilton, ON

Skills

A snapshot of the technologies, tools, and methods I work with.

Python SQL Power BI Tableau Excel Pandas NumPy Matplotlib Git & GitHub REST APIs Data Visualization Dashboarding

Photography

Aurora Photography

Captured moments of the northern lights — click any photo to view fullscreen.

Certifications

View Credly
IBM Predictive Analytics Modeler IBM Business Intelligence Analyst Azure AI Fundamentals MS Security, Compliance & Identity IBM Enterprise Design Thinking

LinkedIn Learning

Excel Advanced Formatting Techniques certificate Excel Creating a Dashboard with Power Query (Microsoft 365) certificate Excel Data Visualization Designing Custom Visualizations certificate Excel Data Visualization Mastering 20 Charts and Graphs certificate Excel Essential Training Microsoft 365 2018 certificate Power BI Data Modeling with DAX certificate Power BI Essential Training 2020 certificate Tableau Essential Training 2022 certificate Tableau for Data Scientists certificate