Data Analyst | MBA (Data Analytics) & B.S. Computer Science
Turning data into business insights using SQL, Excel, and dashboards
- Built an end-to-end analytics system using multi-source retail data
- Developed a forecasting model to predict future sales trends
- Created dashboards and insights to support business decision-making
π https://github.com/BogdanMygovych/Sales-Analytics-Forecasting-Model
- Analyzed 150K+ transactions to identify revenue trends and customer behavior
- Built dashboards to track KPIs such as revenue, orders, and average order value
- Identified peak sales hours and top-performing products
π https://github.com/BogdanMygovych/Coffee-Shop-Analytics-Dashboard
- Performed customer segmentation and revenue analysis using SQL and Excel
- Identified top 20% of customers driving majority of revenue
- Built dashboards using Power BI to track business performance
π https://github.com/BogdanMygovych/E-Commerce-Sales-Analysis
- Data Cleaning & Transformation
- Exploratory Data Analysis (EDA)
- KPI Development & Tracking
- Business Insights & Reporting
- GROUP BY, JOINs, Aggregations
- Trend and performance analysis
- PivotTables, VLOOKUP
- KPI reporting
- Power BI & Tableau dashboards
- Data storytelling
- Pandas, data cleaning, analysis
- Git, GitHub, MySQL, Jupyter
π§ mygovychb@gmail.com
π https://www.linkedin.com/in/bogdanmygovych/