Advanced

Questions

Excel:

Can you describe some advanced techniques for data cleaning and data preparation in Excel, including tools like Power Query and Power Pivot?
How do you use Excel to build and optimize complex financial models, including techniques for forecasting, scenario analysis, and risk modeling?

SQL:

Can you describe some advanced SQL techniques for optimizing query performance, including indexing, query planning, and partitioning?
How would you design and implement a data warehouse that can handle petabytes of data and support complex analytical queries?

Python:

How do you design and implement an end-to-end machine learning pipeline, including data collection, cleaning, feature engineering, modeling, evaluation, and deployment?
How do you use Python to build and deploy machine learning models in production environments, including techniques for model monitoring, versioning, and deployment?

Hands-on project - (Select One)

Customer Segmentation for E-commerce: Develop a customer segmentation model to identify groups of customers with similar purchasing behaviors and preferences using data from online transactions. The model should help the business personalize its marketing campaigns and product recommendations and optimize its pricing and inventory strategies.
Fraud Detection for Financial Services: Develop a fraud detection model to identify potentially fraudulent transactions in real time, using data from credit card transactions or bank transfers. The model should be able to distinguish between legitimate and fraudulent transactions and provide alerts or blocks for suspicious transactions to prevent financial losses.
Object Detection for Autonomous Driving: Develop an object detection model to recognize and classify objects in real-time video data using deep learning architectures like Convolutional Neural Networks (CNNs). The model should be able to help autonomous vehicles navigate complex environments, and avoid obstacles and hazards.

Create a new branch or fork this repo, your answers to the theory questions should be in a readme or txt file.
The solutions to the hands-on can be created in the repository too.
Create a pull request when you are ready to submit.