1. El problema: Error «Web no segura»

Llevaba meses sin entrar a mi propia página web (conquistandolugares.es). Para ser sincero, la última vez que accedí al servidor fue para lidiar con un problema raro de la licencia de Plesk (un temita con bastante miga que ya desarrollaré en otra entrada del blog).

El caso es que hoy me dio por entrar para echar un vistazo y, de repente, ¡pantallazo rojo al canto! El navegador me recibió con una alerta bastante fea diciendo que la web no era segura.

Ver eso en tu propia web te da un vuelco al corazón 😅. ¡Oye, un momento! ¡Que yo no le voy a robar datos ni tarjetas a nadie, que solo quiero compartir mis contenidos! Pero claro, ponte en el lugar de cualquier persona que visite la web: ve semejante cartelón de peligro y lo primero que piensa es que el sitio es sospechoso. Resultado: espantada generalizada de visitas.

Como el problema era que el certificado SSL había caducado, la solución rápida que todos conocemos era conectar por SSH desde PowerShell y renovarlo en un par de minutos. Pero el servidor decidió que hoy no era mi día de suerte y me soltó un portazo en la cara:

Connection closed by 212.227.229.115 port 22

¡Sin acceso por SSH! Mi única vía de rescate era entrar al panel de control de mi proveedor en Piensa Solutions y acceder a la consola web remota KVM/VNC de mi VPS.

Y ahí fue donde la cosa se complicó de verdad:

• Sin portapapeles: En la consola web de Piensa Solutions no se podía copiar ni pegar de forma normal. Tuve que teclear las órdenes directamente a mano en pantalla.
• El teclado poseído: La consola web forzó la distribución de teclado en inglés (US). Querías escribir una simple comilla ("), una barra (/) o un punto y coma (;) y en pantalla salían caracteres completamente distintos.

Dado lo que me ha costado mi buen tiempo resolver este rompecabezas, he grabado un vídeo explicando todo el proceso en detalle y he documentado la solución en este post paso a paso:

---

2. ¿Cómo soluciono esto?

Herramientas utilizadas

• Consola Web KVM/VNC: Panel de gestión de VPS en Piensa Solutions.
• PowerShell (Windows) / Terminal (macOS/Linux): Para la conexión SSH definitiva una vez desbloqueado el acceso.

Paso a paso para solucionar el bloqueo

Para evitar pelearnos con editores interactivos como nano o vim en una consola web lenta y con el teclado desconfigurado, inyectaremos las reglas de acceso directamente al archivo /etc/ssh/sshd_config. Lo haremos comando a comando, de uno en uno y sin comillas dobles para asegurarnos de que el servidor procesa la orden limpia sin errores de sintaxis.

Paso 1: Permitir el acceso del usuario root

Escribimos la primera línea en la consola web y pulsamos Enter:

echo PermitRootLogin yes >> /etc/ssh/sshd_config

Paso 2: Habilitar la autenticación por contraseña

Escribimos la segunda línea en la consola web y pulsamos Enter:

echo PasswordAuthentication yes >> /etc/ssh/sshd_config

Paso 3: Reiniciar el servicio SSH

Reiniciamos el demonio de SSH para aplicar los cambios en el sistema:

systemctl restart sshd

Paso 4: Conexión remota por SSH desde tu propia terminal

En cuanto la terminal web devuelva la línea de comandos limpia ([root@server-wp-conquistando-lugares ~]#), podemos abandonar la consola del navegador. Abre la PowerShell de tu ordenador y conéctate directamente introduciendo tus datos:

ssh root@212.227.229.115

*(Nota: En tu caso, deberás sustituir 212.227.229.115 por la dirección IP pública o el dominio de tu propio servidor VPS, e introducir la contraseña de root cuando te la solicite).*

---

3. Ya está funcionando

Resultado obtenido

Conseguimos saltarnos las restricciones de la consola web y recuperar el control total del servidor mediante SSH nativo desde nuestra propia terminal de PowerShell.

Comprobaciones finales

1. Prompt del servidor activo: Confirmamos que PowerShell muestra el mensaje de bienvenida oficial y el indicador de comandos remotos ([root@server-wp-conquistando-lugares ~]#).
2. Portapapeles operativo: Comprobamos que el clic derecho en PowerShell permite copiar y pegar comandos largos al instante.
3. Mapeo correcto del teclado: Comillas, barras inclinadas y guiones vuelven a escribirse perfectamente desde nuestra terminal habitual.

📊 Ficha técnica del proceso:
⏱️ Tiempo empleado: ~45 minutos (luchando con la consola web y la distribución de teclado).
🤯 Nivel de dificultad: Medio / Frustrante (debido a las limitaciones del visor web KVM).

Welcome back to my learning diary! As I work toward my Google Data Analytics Professional Certificate and prepare for my Cambridge B2 exam, I am documenting every step. Today, I am diving into the «Data Ecosystem»—the invisible world where data lives, breathes, and helps us make smarter choices. 📊

📑 Index

1. The Ancient Origins of Data Analysis
2. What is a Data Ecosystem?
3. Making Better, Data-Driven Decisions
4. Data vs. Gut Instinct: The Detective’s Dilemma
5. Key Takeaways & Knowledge Check

🏛️ 1. The Ancient Origins of Data Analysis

Did you know that data analysis isn’t a modern invention? It is rooted in statistics, which goes back as far as Ancient Egypt.

• The Pyramids: Egyptians used papyri to record calculations and theories, creating the earliest versions of spreadsheets.
• Evolution: While the tools have changed, the core idea—collecting information to drive success—remains the same.

🌐 2. What is a Data Ecosystem?

A data ecosystem is a collection of interacting elements that produce, manage, store, and share data. Think of it like a biological ecosystem, but for information!

The three main pillars are:

• Hardware & Software: The physical and digital tools we use.
• People: The analysts (like us!) who harness the power of the data.
• The Cloud: A virtual location that allows us to access data over the internet instead of local hard drives.

💡 3. Making Better, Data-Driven Decisions

Data-driven decision-making means using facts to guide business strategy. Instead of guessing, organizations use data to solve problems like low employee retention or improving brand recognition.

Pro Tip: Always involve Subject Matter Experts (SMEs). These are people familiar with the business problem who can help identify inconsistencies and validate your findings.

🕵️ 4. Data vs. Gut Instinct: The Detective’s Dilemma

Data analysts are like detectives; both follow clues and collect evidence to find the truth.

• Gut Instinct: This is an intuitive «feeling» based on past experience.
• The Risk: Relying only on a hunch can lead to biased or costly mistakes.
• The Solution: Find the «perfect blend» of data and business knowledge. Use more data for high-resource projects, and lean more on experience for «rush» projects

📝 5. Key Takeaways & Knowledge Check

To wrap up Part 3, remember that the Google Data Analysis Process follows six clear steps: Ask, Prepare, Process, Analyze, Share, and Act. Whether you are analyzing taxi ride demand or helping a retail store predict purchases, these fundamentals will keep you on track!

1️⃣Introduction

In this series of posts, I will document my journey through the Google Data Analytics Professional Certificate on Coursera. I was fortunate to receive a scholarship from Google, and I decided to take the course in English to improve both my data analytics skills and my English writing while preparing for the Cambridge B2 exam. My goal is to create a learning diary where I summarize the most important concepts from each lesson, reflect on what I learn, and gradually build a personal knowledge base about data analysis, analytical thinking, and real-world applications of data

2️⃣Introduction to Data Analytics

The first video introduces the importance of data in today’s world. Many industries such as e-commerce, healthcare, finance, marketing, and technology rely heavily on data to improve their processes, identify opportunities, develop new products, and make better decisions. Data can be understood as a collection of facts, including numbers, images, words, measurements, observations, or videos. Data analysis is the process of collecting, transforming, and organizing this information in order to draw conclusions and support informed decision-making.

The lesson also emphasizes that data is everywhere. Every time we search online, stream music, use GPS, read product reviews, shop online, or post something on social media, we are both using and creating data. The amount of data generated globally is enormous. For example, Google processes more than 40,000 searches per second, which represents billions of searches every day. Because of this massive amount of information, organizations increasingly depend on data analysts to interpret data and help guide strategic decisions.

The course also introduces the main stages of the data analysis process: 1) Ask 2) Prepare 3) Process 4) Analyze 5) Share 6) Act

These steps form the framework that will guide the entire certificate program.

---

3️⃣ Googlers introduced in the video

Several Google professionals appear in the video to explain different aspects of data analytics and share their experience working in the industry:

• Tony — Program Manager at Google and Data Analyst
  Introduces the course and explains the importance of data analytics.
• Angie — Program Manager of Engineering at Google
  Explains the importance of data cleaning and how understanding data deeply can feel like solving a mystery.
• Alex — Research Scientist at Google
  Studies the impact of artificial intelligence on society and users.
• Lila Jones — Member of the Google Cloud team
  Leads teams that help customers move their systems and data to cloud technologies.
• Evan — Learning Portfolio Manager at Google
  Designs educational programs and training related to big data technologies.

Later in the course, other instructors will guide each stage of the analytics process.

---

4️⃣ Personal reflections

Something that surprised me

The number of industries where data analysts can contribute. Data analytics is useful in many fields such as healthcare, finance, marketing, technology, and e-commerce.

Something I already knew

The idea that data is everywhere. The analytical process also reminds me of the DAFO (SWOT) analysis framework, where structured steps help analyze a situation and make better decisions.

Something new I learned

I learned how many different teams work at Google and how data plays a role in many areas such as engineering, research, cloud computing, and education.

5️⃣ Why I’m Taking This Course

I decided to take the Google Data Analytics Professional Certificate after receiving a scholarship from Google. Data is becoming increasingly important in almost every industry, and I wanted to better understand how organizations use data to make decisions and solve real-world problems.

Another reason I chose this course is that I want to improve my professional skills while also practicing my English. Since I am preparing for the Cambridge B2 exam, I decided to complete the entire course in English and document my learning process through this blog.

By writing about each lesson, I hope to reinforce what I learn, improve my technical vocabulary, and build a personal record of my progress in data analytics. Over time, this learning diary will also become a small portfolio that shows how my understanding of data analysis develops step by step.

Title (H1)
Starting the Google Data Analytics Certificate

Heading (H2)
Introduction

Heading (H2)
What is Data Analytics?

Heading (H2)
The Data Analysis Process

Heading (H2)
My Personal Notes

Heading (H2)
What I Learned in This Lesson