Day 30 of My Data Analytics Journey !

Today marks the 30th day of my Data Analytics learning!
The following questions and tasks were given by my Training Director to strengthen my basics and improve my practical skills.

🔹 1. How did Python get its name?

Python was created by Guido van Rossum in the late 1980s.
The name didn’t come from the snake 🐍, but from the British comedy show Monty Python’s Flying Circus.
Guido wanted something short, unique, and fun for his programming language.

🔹 2. What is a Scripting Language?

• A scripting language is used to automate tasks
• Usually interpreted, not compiled
• Examples: Python, JavaScript, Bash 👉 Think of it as writing small programs to quickly solve problems

🔹 3. What is a Query Language?

• A query language is used to interact with databases
• Example: SQL (Structured Query Language) 👉 You use it to ask questions from your data, like: SELECT name, age FROM students WHERE age > 20

🔹 4. What is a Programming Language?

• A programming language is a formal language to build software
• Examples: Python, Java, C++ 👉 You use it to design algorithms, build applications, and solve complex problems

🔹 5. Difference Between Scripting, Query, and Programming

• Scripting Language → Used for automation (e.g., Python, JavaScript, Bash)
• Query Language → Used for extracting and manipulating data (e.g., SQL)
• Programming Language → Used for building full applications (e.g., Java, C++, Python)

🔹 6. Task – Repeat a Sentence 2000 Times in MS Word (Macro Method 1)

Sometimes Alt+F11 may not open VBA editor. Instead, use this method:

Step 1: Enable Developer Tab

1. Open MS Word
2. Go to File → Options → Customize Ribbon
3. On the right side, tick Developer → Click OK 👉 Now you’ll see the Developer tab

Step 2: Open Visual Basic Editor

1. Go to the Developer tab
2. Click Visual Basic

Step 3: Insert a Module

1. In the VBA editor, click Insert → Module
2. A blank window opens

Step 4: Paste This Code
Sub RepeatSentence()
 Dim i As Long
 For i = 1 To 2000
  Selection.TypeText "I am learning Data Analytics." & vbCrLf
 Next i
End Sub

Step 5: Run the Macro

1. Close the VBA editor
2. In Word → Developer → Macros
3. Select RepeatSentence → Click Run

✅ our sentence will be repeated 2000 times in the document automatically.

🔹 7. Task – Send Different Emails to 100 People (Thunderbird Mail Merge)

1. Create a CSV file with columns like Email, Name, and Message

• Example:

  • [e-mail] → Ramya → Hello Ramya, how are you?
  • [e-mail] → Visky → Hi Visky, keep learning!

1. In Thunderbird → Install Mail Merge Add-on

2. Write an email like this:

To: {{Email}}
Subject: Personal Mail
Hi {{Name}},

{{Message}}

1. Go to Tools → Mail Merge → Select CSV → Send Now ✅

🔹 8. Task – VLOOKUP & HLOOKUP in Excel

VLOOKUP (Vertical Lookup):
=VLOOKUP(101, A2:C10, 2, FALSE)
👉 Finds the value in the 2nd column for ID 101

HLOOKUP (Horizontal Lookup):
=HLOOKUP("Maths", A1:F3, 2, FALSE)
👉 Finds the value under the “Maths” heading .