Submission Checklist

Folder: doneee

Main Report Files

• olist_human_in_loop_report.Rmd - RMarkdown source report with code, checks, joins, plots, insights, limitations, and AI audit note.
• olist_human_in_loop_report.html - HTML report generated from the same analysis logic.
• build_html_report.R - R script used to generate the HTML report, plot images, and CSV tables.

Required Elements

• RMarkdown/HTML report: included.
• Basic data import and checks: included in the report and exported to tables.
• At least 3 joined tables: included.
  • orders_joined
  • items_joined
  • items_orders_reviews_joined
  • state_month_delivery
• At least 3 ggplot2 charts: included. The folder contains 6 chart images.
• 3 cautious business insights: included in the report.
• 2 limitations: included in the report.
• 1 AI audit note: included in the report.

Generated Plot Files

• plots/01_monthly_orders.png
• plots/02_review_distribution.png
• plots/03_low_review_categories.png
• plots/04_late_delivery_by_state.png
• plots/05_revenue_by_category.png
• plots/06_late_delivery_over_time.png

Generated Check and Join Tables

• tables/row_counts.csv
• tables/column_names.csv
• tables/missing_summary.csv
• tables/key_checks.csv
• tables/unmatched_join_keys.csv
• tables/date_checks.csv
• tables/join_row_check.csv
• tables/orders_joined_sample.csv
• tables/items_joined_sample.csv
• tables/items_orders_reviews_joined_sample.csv
• tables/state_month_delivery.csv

Note

The local R setup did not have Pandoc available, so the .Rmd file is provided as the RMarkdown source and the HTML report was generated directly with build_html_report.R.