Power Query Isn’t Required: New Excel Functions Handle Straightforward Sources Cleanly

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
GitHub

SQL-Mongo Converter - A Lightweight SQL to MongoDB (and Vice Versa) Query Converter

SQL-Mongo Converter is a lightweight Python library for converting SQL queries into MongoDB query dictionaries and converting MongoDB query dictionaries into SQL statements. It is designed for ...
IEEE

Advancements in SQL Query Optimization: A Review of Join Order and Index Selection

Abstract: Efficient SQL Query Optimization (QO) is a fundamental aspect of database management systems, aimed at enhancing query performance and reducing resource consumption typically involves ...
GitHub

GitHub - Mauolea349/olist-ecommerce-analysis

A comprehensive end-to-end data analytics project analyzing 110,000+ orders from Brazilian e-commerce platform Olist (2016-2018). This portfolio piece demonstrates advanced SQL, Python ETL, and Power ...