You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ETL / ELT Framework powered by DuckDB, designed to seamlessly integrate and process data from diverse sources. It leverages Markdown as a configuration medium, where YAML blocks define metadata for each data source, and embedded SQL blocks specify the extraction, transformation, and loading logic.
AI Report Factory automates data storytelling, transforming raw business data into analytical, narrative-driven reports. It ingests structured datasets, computes KPIs, generates visualizations, and produces Markdown & HTML reports with actionable insights for startups, analysts, and enterprises.
Photo Report Automation for BI Dashboards - Script to extract, classify, and convert photos from weekly construction reports into structured datasets with Base64 encoding for Power BI visualizations.
This project automates the generation of reports by integrating data cleaning, SQL query execution, and email dispatch functionalities using Python. Designed for efficiency and scalability, it allows for seamless automation of routine reporting tasks. with Technologies Used Python SQL Anaconda Task Scheduler (Windows)
Automation of monthly warehouse reporting: comparison of accounting balances with actual warehouse balances to identify discrepancies in product items.
Hands-on learning materials from the 3-course Google Business Intelligence Certificate program, covering BI foundations, data models and pipelines, Tableau visualization, and decision-making
The report that we currently export does not calculate figures correctly. The company that we have the program through currently offers no solution to the issue. I created a way to crawl the Excel report and extract the information that was necessary for accurate reporting.
Python automation project that loads marketing CSV exports, cleans and standardizes the data, aggregates total KPIs, and generates both: a simple human-readable TXT report and a structured, client-ready PDF performance report
Google Apps Script automation that identifies students who skipped flex classes by consolidating COGNOS attendance data with FlexiSched absence reports.
Efficiently process and automate complex reports using Python. This project streamlines data integration, cleaning, and report generation, reducing processing time by 97%.