Interview prep: 1,000+ topics

1,000+ topics are planned, and we are starting with these 100 tools and topics. Every topic is planned as one short chapter in the same format: Part 1 has the most important interview questions with clear answers, and Part 2, at the very end, has short tricks and formulas to remember. Each topic book is planned at 30 to 40 pages.

Business Intelligence and Analytics

  1. Power BI
  2. DAX
  3. Power Query
  4. Tableau
  5. AWS QuickSight
  6. Looker
  7. Excel for Analysts
  8. Advanced Excel Formulas
  9. Data Visualization
  10. Statistics for Analysts

Programming

  1. Python
  2. Pandas
  3. NumPy
  4. PySpark
  5. Java
  6. JavaScript
  7. TypeScript
  8. C#
  9. Scala
  10. Shell Scripting

Databases and Data Modelling

  1. SQL
  2. Advanced SQL and Window Functions
  3. PostgreSQL
  4. MySQL
  5. Oracle SQL and PL/SQL
  6. SQL Server and T-SQL
  7. MongoDB
  8. Redis
  9. Snowflake
  10. Data Modelling

AWS

  1. AWS Glue
  2. Amazon S3
  3. AWS Lambda
  4. Amazon Redshift
  5. Amazon Athena
  6. Amazon EMR
  7. AWS Step Functions
  8. Amazon Kinesis
  9. AWS IAM
  10. Amazon EC2 and VPC

Azure

  1. Azure Data Factory
  2. Azure Synapse Analytics
  3. Azure Databricks
  4. Azure Data Lake Storage
  5. Azure Functions
  6. Azure SQL Database
  7. Azure Event Hubs
  8. Azure DevOps
  9. Microsoft Entra ID
  10. Azure Monitor

Data Engineering

  1. Apache Spark
  2. Apache Kafka
  3. Apache Airflow
  4. Hadoop and Hive
  5. dbt
  6. ETL and ELT Concepts
  7. Data Warehousing
  8. Data Lakes and Lakehouse
  9. Delta Lake
  10. Data Quality and Governance

DevOps and Cloud Tools

  1. Git and GitHub
  2. Docker
  3. Kubernetes
  4. Jenkins
  5. CI/CD Pipelines
  6. Terraform
  7. Ansible
  8. Linux Commands
  9. Monitoring and Logging
  10. Cloud Cost Basics

Testing and QA

  1. Manual Testing
  2. Selenium
  3. API Testing and Postman
  4. Test Automation Frameworks
  5. Cypress and Playwright
  6. JMeter and Performance Testing
  7. SQL for Testers
  8. Agile Testing
  9. BDD and Cucumber
  10. Test Case Design

AI and Machine Learning

  1. Machine Learning Basics
  2. Scikit-learn
  3. Deep Learning
  4. Natural Language Processing
  5. Generative AI and LLMs
  6. Prompt Engineering
  7. MLOps
  8. Feature Engineering
  9. Model Evaluation Metrics
  10. Time Series Forecasting

Core Fundamentals

  1. Data Structures
  2. Algorithms
  3. System Design
  4. REST APIs
  5. Microservices
  6. OOP and Design Patterns
  7. Agile and Scrum
  8. Networking Basics
  9. Operating Systems
  10. Cybersecurity Basics

Chapter format

  1. What the tool is and where it is used
  2. Important interview questions: basic, intermediate, advanced
  3. Common mistakes and how to avoid them
  4. Short tricks and formulas to revise before the interview

Chapters are published as they are completed. Start with the Power BI chapter, our model for all the others.