Tools Setup Checklist:
✅ Install Microsoft Excel (or Google Sheets)
✅ Install a SQL database (e.g., PostgreSQL, SQLite)
✅ Install Python (Anaconda or Miniconda)
✅ Install Power BI Desktop (free version)
✅ Install necessary Python libraries:
   - pandas, numpy, matplotlib, seaborn, jupyter
✅ Set up a GitHub account for portfolio projects
✅ Install a code editor (VS Code or Jupyter Lab)

-- Sample SQL Query for Data Analysis
SELECT 
    region,
    COUNT(*) as total_sales,
    AVG(amount) as avg_amount
FROM sales_data
WHERE sale_date >= '2023-01-01'
GROUP BY region
ORDER BY avg_amount DESC;

# Python Data Cleaning with Pandas
import pandas as pd

# Load data
df = pd.read_csv('sales_data.csv')

# Handle missing values
df.dropna(subset=['amount'], inplace=True)

# Remove duplicates
df.drop_duplicates(inplace=True)

# Handle outliers (IQR method)
Q1 = df['amount'].quantile(0.25)
Q3 = df['amount'].quantile(0.75)
IQR = Q3 - Q1
df = df[(df['amount'] >= Q1 - 1.5*IQR) & (df['amount'] <= Q3 + 1.5*IQR)]

// Power BI DAX Formula for Total Sales
Total Sales = 
SUMX(
    Sales,
    Sales[Quantity] * Sales[Unit Price]
)

// Year-over-Year Growth
YoY Growth = 
VAR CurrentYear = CALCULATE(SUM(Sales[Amount]), YEAR(Sales[Date]) = YEAR(TODAY()))
VAR PreviousYear = CALCULATE(SUM(Sales[Amount]), YEAR(Sales[Date]) = YEAR(TODAY()) - 1)
RETURN
DIVIDE(CurrentYear - PreviousYear, PreviousYear)

Portfolio Project Ideas:
1. Sales Dashboard — Analyze sales data and create an interactive dashboard in Power BI.
2. Customer Segmentation — Use Python to segment customers based on purchasing behavior.
3. Marketing Analytics — Analyze campaign data and provide insights to improve ROI.
4. HR Analytics — Analyze employee data to identify trends in attrition and performance.
5. Financial Analysis — Analyze stock or financial data to identify trends and patterns.

Interview Preparation Tips:
1. Practice SQL queries — joins, aggregations, window functions
2. Practice Python — data manipulation with Pandas, visualization with Matplotlib
3. Practice case studies — walk through a data problem from start to finish
4. Practice behavioral questions — STAR method for answering questions
5. Practice presenting insights — communicate your findings clearly

Recommended Books for Data Analytics:
1. "Storytelling with Data" by Cole Nussbaumer Knaflic
2. "Data Science for Business" by Foster Provost
3. "Python for Data Analysis" by Wes McKinney
4. "SQL for Data Analytics" by Upom Malik
5. "The Data Warehouse Toolkit" by Ralph Kimball

Best Online Courses for Data Analytics:
1. Google Data Analytics Professional Certificate (Coursera)
2. IBM Data Analyst Professional Certificate (Coursera)
3. Data Analytics with Python (Uncodemy)
4. SQL for Data Science (Coursera)
5. Power BI for Data Visualization (Microsoft Learn)

Data Analytics Communities:
1. Reddit — r/dataanalysis, r/datascience
2. LinkedIn — Data Analytics groups
3. Kaggle — Data competitions and community
4. DataCamp — Community forums
5. Uncodemy — Alumni network and community