XLSX Data Wrangling

Create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with formulas, formatting, and financial modeling conventions.

Design database schemas, plan data migrations, optimize queries, and model data relationships using expert analysis and automated tools.

Search Azure AI Search indexes using the Python SDK for full-text, vector, hybrid, and semantic search with AI enrichment.

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

Perform CRUD operations, run queries, and manage containers on Azure Cosmos DB NoSQL API using the Python SDK.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.