Mickyas Shawel | Assignment Portfolio

Repository of assignments and projects completed for graduate coursework.

IBM 6540 Assignments

• M02 – Introduction to Data Science in R Reflection
  Reflection on reproducible data science, Quarto, and the Tidyverse ecosystem.


• W02 – Fundamentals of Machine Learning Reflection
  Reflection on tidymodels, machine learning concepts, model evaluation, and MLOps.


• W03-1 – Regression Fundamentals and Chapter 5 Reflection
  Reflection on linear regression, R-squared, multiple regression, regression assumptions, and hands-on exercises using the mtcars and customer_data datasets.


• W04-1 – Reflection on Logistic Regression and Ch8: Preprocessing with Recipes
  Reflection on logistic regression, odds, preprocessing recipes, and classification modeling.


• M05 – Reflection on Odds, Log(Odds), Odds Ratio, and Log(OR)
  Reflection based on the Step 1 class recording covering logarithms, probability, odds, log odds, odds ratios, logistic regression foundations, and exam-ready R code patterns.


• M05 – Visualizing Data with Tables
  Reflection on effective table design using the gt and gtExtras packages, including descriptive statistics, inline distribution graphics, professional table styling, and applications for marketing analytics reports.


• M06-1 – Improving LADD Coffee's Digital Strategy
  RevealJS proposal presentation examining how LADD Coffee, a newly opened specialty coffee shop in West Covina, can strengthen its digital strategy through local search, social media, product-led content, first-party measurement, and customer journey analytics. The presentation includes reproducible R visualizations, a proposed channel-priority framework, customer journey analysis, measurement planning, data requirements, analytics methods, and a 90-day digital strategy.


• M08 – Reflection on Regression-Focused Methods and Classification Models
  Machine learning reflection using the Retail Sales with Seasonal Trends and Marketing dataset, including a customer-oriented analytics objective, supervised regression, data splitting, preprocessing recipes, 10-fold cross-validation, linear regression, Ridge regression, Lasso regression, model comparison, test-set evaluation, and feature-importance analysis.


• M09 – Reflection on Trees with Group Project Data
  Application of decision trees and ensemble machine-learning methods to the Retail Sales with Seasonal Trends and Marketing dataset. The analysis reframes the group project's sales-revenue objective as a supervised regression problem and includes an 80/20 train-test split, preprocessing recipe, regression tree, Random Forest, XGBoost, 10-fold cross-validation, model comparison, feature importance, cost-complexity pruning, optimal tree selection, leaf-node analysis, and a business-focused explanation of overfitting and model generalization.

IBM 6300 Assignments

• W03 – Shopify Orientation and Admin Exploration
  Exploration of Shopify store administration, platform features, and reflections on applying Shopify to the CPP Farm Store consulting project.


• W04 – Shopify Store Concept and Initial Setup
  Store concept report for a CPP Farm Store-inspired Shopify prototype, including target customer analysis, product category planning, initial Shopify setup evidence, and connection to the CPP Farm Store consulting project.


• OACP-W04 – Career Research Essay: Careers in Omnichannel Retailing
  Career research essay examining current opportunities in omnichannel retailing, e-commerce, retail marketing, and analytics through real job postings from Anastasia Beverly Hills, Mattel, and Morphe. The report compares employer expectations, technical and soft skills, e-commerce and analytics tools, and connects those requirements to IBM 6300 coursework, the MSDM program, the CPP Farm Store consulting project, and personal career preparation.


• W05 – Shopify Store Product Catalog Development
  Product catalog development report for the CPP Farm Store Shopify prototype, including 8–12 products, product descriptions, pricing, images, inventory details, category organization, assortment strategy, and product presentation recommendations.


• W06 – Shopify Store Collections and Navigation
  Collections and navigation audit for the CPP Farm Store Shopify prototype: ten collections reviewed, two mislabeled main-menu links corrected via the Shopify Admin API, a missing Specialty Foods link added, merchandising logic, customer experience explanation, and CPP Farm Store application reflection.


• OACP-W06 – Shopify to Google Merchant Center Connection Lab
  Documented connection attempt between the CPP Farm Store Shopify prototype and Google Merchant Center via the Google & YouTube sales channel: real screenshots of the existing account connection, the live setup checklist, and the exact platform barrier—a locked storefront-password toggle tied to the store's development-plan tier—that stopped the flow before product-level review, plus a CPP Farm Store application reflection.


• W07 – Shopify Store Storefront Design and Customer Experience
  Storefront design and customer experience improvements to the CPP Farm Store Shopify prototype, including homepage, product page, and collection page evidence, live inventory and product-data fixes made via the Shopify Admin API, customer journey reflection, and CPP Farm Store application reflection.


• Google Shopping Ads Certification Part 1 – Foundations & Requirements
  Individual certification work covering three Google Skillshop modules on Shopping Ads fundamentals, plus a CPP Farm Store application reflection connecting Shopping Ads requirements to the GP3 product feed and Assignment 5 storefront fixes.


• Google Shopping Ads Certification Part 2 – Retail Strategy, Campaign Types & Performance Max
  Individual certification work covering three Google Skillshop modules — Launch Your Retail Strategy, Identify the Right Shopping Campaign Type, and Unlock the Power of Performance Max — plus a 400–600 word CPP Farm Store application reflection addressing campaign objectives, product prioritization, campaign type selection, customer touchpoints, KPIs, and connection to the group project Campaign Plan, Creative Brief, and Dashboard deliverables.


• W10 – Store Testing and Analytics Review
  Customer journey test of the CPP Farm Store Shopify prototype from homepage through checkout preview, identification of three store strengths and three areas for improvement, Shopify analytics review using ShopifyQL session data from the last 30 days, and a pre-final-submission improvement plan.


• Google Shopping Ads Certification Part 3 – Certification Exam
  Proof of completion of the Google Shopping Ads Certification assessment through Google Skillshop, plus a 400–600 word final application summary covering the three most useful concepts learned, CPP Farm Store omnichannel opportunities, personal contributions to the group project, professional confidence in retail media strategy, and a resume-ready certification description.

GitHub Repository: IBM-6540-IBM-6300