2️⃣6️⃣ What are the most commonly used BI tools?
Popular Business Intelligence tools include Tableau, Power BI, QlikView, Looker, and Google Data Studio. They help visualize data, build dashboards, and generate insights.
2️⃣7️⃣ How do you use Excel for data analysis?
Excel offers functions like VLOOKUP, INDEX-MATCH, Pivot Tables, Conditional Formatting, and Data Validation. It's great for quick analysis, cleaning, and reporting.
2️⃣8️⃣ What is the role of Python in data analytics?
Python is used for data manipulation (Pandas), numerical analysis (NumPy), visualization (Matplotlib, Seaborn), and machine learning (Scikit-learn). It's versatile and widely adopted.
2️⃣9️⃣ How do you connect Python to a database?
Use libraries like sqlite3, SQLAlchemy, or psycopg2 for PostgreSQL. Example:
import sqlite3
conn = sqlite3.connect('data.db')
cursor = conn.cursor()
3️⃣0️⃣ What is the difference between.loc and.iloc in Pandas?
⦁ .loc[] is label-based indexing (e.g., df.loc by row label)
⦁ .iloc[] is position-based indexing (e.g., df.iloc by row number)
💬 Tap ❤️ for Part 5