DEV Community: Elvis Kwabena Asare Nkrumah

Three years after a branch to Data Analytics: How Extracurriculars Shaped My Career

Elvis Kwabena Asare Nkrumah — Thu, 03 Apr 2025 11:38:52 +0000

A few years ago, I was deeply immersed in data engineering, writing blogs, and taking courses around the field. But as my curiosity grew, I realized that I wanted to do more than just structure data—I wanted to analyze it, visualize insights, and tell compelling stories. This realization led me down the path of data analytics, and today, I proudly wear multiple hats: Data Analyst, and Tableau Academic Ambassador (Tier 3 of the Tableau Ambassador Program).

One of the biggest lessons I’ve learned? Extracurricular activities can be game-changers for students and early-career professionals.

How Extracurriculars Transformed My Journey

University education lays the foundation, but real-world exposure and hands-on experiences are what truly sets you apart. My transition from data engineering to analytics wasn’t just about learning new technical skills—it was fueled by the extracurricular activities I took on. Through my Tableau Student Ambassador role, I’ve gained invaluable experience in areas beyond just data visualization:

Event Marketing & Organization: Managing workshops and data visualization challenges using platforms like Eventbrite has given me hands-on experience in audience engagement, promotional strategies, and community building.
Content Creation & Thought Leadership: From blog posts on Dev.to to insights on LinkedIn, sharing my knowledge has helped me refine my communication skills and build credibility in the data space.
Public Speaking & Community Engagement: Hosting workshops, webinars, and data challenges has allowed me to connect with like-minded professionals and improve my ability to present technical concepts with clarity.
Networking & Career Growth: Being active in the Tableau community and other tech spaces has opened doors to mentorship, collaborations, and career opportunities I never anticipated.

The Rewards? They’re Limitless!

The impact of these experiences has been transformational. Not only have I gained practical skills, but I’ve also built a strong personal brand that continues to open doors. As a result:

I’ve had the chance to lead impactful initiatives.
I even launched my own YouTube channel to share insights on data analytics, visualization, and career growth.

And the journey continues! In celebration of Ghana’s Independence Month, I organized a Tableau Viz Challenge/Hackathon. This exciting event allowed participants to explore Ghana’s rich history through data storytelling. Participants created insightful dashboards, and competed for exciting prizes—including Tableau souvenirs and certificates.

My Advice to Students & Aspiring Data Professionals

If you’re a student looking to break into the data field or any tech-related industry, here’s what I’d recommend:

Get involved in ambassador programs (Tableau Student Ambassadors, Microsoft Learn Student Ambassadors, etc.).
Start writing and sharing your learning journey—whether on LinkedIn, Dev.to, Medium, or other platforms.
Participate in hackathons and challenges to apply your skills in real-world scenarios.
Launch a YouTube channel, blog, or podcast—sharing your insights can establish you as a thought leader.
Engage with professional communities to build relationships and discover new opportunities.

The key takeaway? What you do outside the classroom can shape your career just as much—if not more—than what you learn in lectures.

Let’s connect and grow together! 🚀
You can find me on LinkedIn (Elvis Kwabena Asare Nkrumah). Drop a comment—how have extracurriculars shaped your journey?

Making RDBMS Simple: What's Up with the First Normal Form?

Elvis Kwabena Asare Nkrumah — Mon, 04 Dec 2023 19:41:33 +0000

Introduction:

Hey there! Ready to explore the world of databases? We're starting with a cool topic: normalization. Today, we're talking about the First Normal Form (1NF). It might sound fancy, but don't worry, we'll break it down into easy bits. Let's dive in!

Scenario 1:

Imagine you're building a library database to keep track of books. At first, you might think, "Let's put everything about a book in one place—title, author, genre, and if it's available." Sounds good, right? But as your library grows, things get messy.

Enter the First Normal Form:

So, what's this 1NF thing? It's like the hero that saves your data from being a mess. It tackles two main problems: too much repeated info (we call it redundancy), and making sure each piece of info is simple and clear (that's atomicity).

Let's take note of the following key terms:

Redundancy: This is when you have the same info in different spots. 1NF helps us get rid of this mess and keeps things neat.
Atomicity: Fancy word, simple idea. It means each column (like title or author) should have just one type of info. And every piece of info should be simple, not a mix of things.

Putting it into Action:

Let's make our library database! We'll use two tables – one for authors and another for books.

-- Table: authors
CREATE TABLE authors (
    author_id INT PRIMARY KEY,
    author_name VARCHAR(255) NOT NULL
);

-- Table: books
CREATE TABLE books (
    book_id INT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    genre VARCHAR(50),
    availability BOOLEAN,
    author_id INT,
    FOREIGN KEY (author_id) REFERENCES authors(author_id)
);

This code creates two tables. One for authors, keeping things like their ID and name. The other is for books, linking back to the authors. Easy, right?

Scenario 2:
Consider the mock database below:

This table structure violates 1NF because the 'Skills' attribute is multivalued. This means that a single employee can have multiple skills.

Implementing 1NF:

To transform the mock database into 1NF, we need to address the multivalued attribute in the 'Skills' column. We can create a separate table named 'EmployeeSkills', with the following structure:

This new table establishes a many-to-many relationship between the 'Employees' and 'EmployeeSkills' tables, ensuring that each employee is associated with a unique set of skills.

Conclusion:

Great job! You've just conquered the basics of the First Normal Form. This simple rule helps us make databases that are organized, grow-friendly, and easy to understand. Stick around for more fun database stuff in our next chat!

How to Learn RDBMS Part 2 - Mastering SQL (Learning by doing)

Elvis Kwabena Asare Nkrumah — Tue, 07 Nov 2023 07:41:01 +0000

Introduction:
SQL (Structured Query Language) is a fundamental skill for anyone working with databases. Whether you're a data analyst, a software developer, or an aspiring data scientist, having a strong command of SQL is essential. While learning the basics of SQL is relatively straightforward, mastering it requires dedication, continuous learning, and, above all, practice. In this blog post, we'll delve into the importance of practice in mastering SQL and discuss a valuable resource for honing your skills.

The Power of Practice:
Imagine learning to play a musical instrument or perfecting a sport - practice is the key to achieving proficiency. The same principle applies to SQL. Mastering SQL means going beyond just understanding the syntax and database concepts; it means being able to write complex queries with confidence. The more you practice, the more comfortable you become with the language, and the better you get at solving real-world problems.

Practice with Realistic Data: SQL-Practice Website:
One excellent resource for honing your SQL skills is the SQL-Practice website (www.sql-practice.com). This website offers a wide variety of mock datasets and a series of SQL questions, ranging from easy to challenging. Here's why it's a valuable resource:

Realistic Datasets: SQL-Practice provides mock datasets that simulate real-world scenarios. This is crucial because it allows you to work with data that you might encounter in a professional setting, giving you a taste of what it's like to work on actual projects.
Progressive Difficulty: The questions on SQL-Practice are categorized by difficulty, which is incredibly helpful for learners. You can start with the basics and gradually move to more complex queries as you gain confidence. This gradual progression is essential for building a strong foundation.
Instant Feedback: One of the most significant advantages of using SQL-Practice is that you receive instant feedback on your queries. This feedback helps you understand where you went wrong and how to improve, a feature that accelerates the learning process.
Comprehensive Solutions: If you're stuck on a particular problem, the website provides detailed solutions. These solutions not only help you when you're stuck but also serve as valuable learning resources to understand different ways of solving problems.

HackerRank and Beyond:
In addition to using SQL Practice, platforms like HackerRank offer SQL challenges that can take your skills to the next level. HackerRank offers a wide range of SQL problems, from basic to advanced, and also allows you to compare your performance with other users. Practicing on HackerRank is particularly beneficial if you're preparing for technical interviews, as it exposes you to a diverse set of challenges and improves your problem-solving skills.

Conclusion
In the world of data, SQL is a foundational skill that empowers you to extract valuable insights from databases. However, mastering SQL is a journey, not a destination. The key to success lies in practice and continuous learning. Websites like SQL-Practice and platforms like HackerRank provide the perfect environment for honing your skills, allowing you to work with realistic data and tackle a wide variety of challenges. So, if you're looking to master SQL, remember: practice, practice, practice, and you'll find yourself becoming a SQL expert in no time.

How best to learn RDBMS Part 1

Elvis Kwabena Asare Nkrumah — Tue, 17 Oct 2023 02:25:13 +0000

A relational database management system (RDBMS) is a type of database that stores data in tables. Tables are made up of rows and columns, and each row represents a single record. Each column represents a different attribute of the record.

RDBMSs are the most popular type of database, and they are used by businesses of all sizes to store data such as customer information, product information, and financial data.

If you are interested in learning how to use RDBMSs, there are a few things you can do:

Take a course: There are many online and offline courses available that can teach you the basics of RDBMSs. Personally I would advise you to take popular courses include:

IBM's Introduction to Relational Databases:https://www.coursera.org/learn/introduction-to-relational-databases
Introduction to Databases by Stanford University on Coursera
SQL for Beginners by Udemy

Read books: There are also a number of books available on RDBMSs. Some popular books include:

SQL in a Nutshell by Kevin Kline
MySQL Crash Course by David Chappell
PostgreSQL 13 Tutorial by Hans-Jürgen Schönig

Practice: The best way to learn RDBMSs is by practicing. You can download a free RDBMS such as MySQL or PostgreSQL and start creating and managing your own databases.

Personally, I would advise you download the XAMPP Control Panel and learn to use PhpMyAdmin from there. Create some databases and perfrom some CRUD operations.

Here are some more tips for learning RDBMSs:

Understanding the Basics

Before you start your RDBMS journey, it's crucial to understand the fundamental concepts:

Tables: These are like spreadsheets that store data in rows and columns.
Rows: Each row in a table represents a unique data record.
Columns: Columns hold specific types of data, like names, dates, or numbers.
Primary Keys: A primary key uniquely identifies each row in a table.
Foreign Keys: These are used to establish relationships between tables. -Take your time to grasp these basics, as they are the building blocks of RDBMS.

Choosing the Right RDBMS

There are various RDBMS systems available, including MySQL, PostgreSQL, SQL Server, and Oracle. The best one for you depends on your specific needs.

MySQL: It's open source and great for small to medium-sized projects.
PostgreSQL: Known for its advanced features and extensibility.
SQL Server: Ideal for Windows-based environments.
Oracle: A robust option for large enterprises.
Start with a free or open-source system for practice.

3.Setting Up Your Environment

After choosing an RDBMS, it's time to set up your environment. You can install these systems on your local machine or use cloud-based solutions. Tutorials for installation are readily available online.

In Part 2, we will discuss more advanced topics such as SQL joins, subqueries, and transactions.