DEV Community

allan-pg profile picture

allan-pg

Tech enthusiastic

Joined Joined on  Email address carsonallan71@gmail.com Personal website https://www.linkedin.com/in/allan-mwangi-data-analyst/ github website

Education

BSC Mathematics and Computer Science

Work

Data Analyst/Data Modeller/Data Architect

Pin Pinned

Designing a Modern Data Warehouse: Combining Bill Inmon and Ralph Kimball in a Hybrid Medallion Architecture
allan-pg profile

Designing a Modern Data Warehouse: Combining Bill Inmon and Ralph Kimball in a Hybrid Medallion Architecture

#database #datawarehouse #dataarchitecture #dataengineering
2
Comments
3 min read
Beginners guide to Machine Learning
allan-pg profile

Beginners guide to Machine Learning

#machinelearning #ai #datascience #data
1
Comments
3 min read
Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries
allan-pg profile

Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

#sqlserver #sql #database #datascience
Comments 1
3 min read
5 Essential Excel Features Every Data Analyst Should Master
allan-pg profile

5 Essential Excel Features Every Data Analyst Should Master

#datascience #data #analytics #excel
1
Comments 4
3 min read
SQL(Structured Query Language) Road Map for beginners
allan-pg profile

SQL(Structured Query Language) Road Map for beginners

#sql #sqlserver #database #mysql
6
Comments 2
2 min read
From Messy to Masterpiece: Cleaning FIFA Data with Python ⚽🚀
allan-pg profile

From Messy to Masterpiece: Cleaning FIFA Data with Python ⚽🚀

#datascience #data #dataengineering #python
Comments
3 min read

Want to connect with allan-pg?

Create an account to connect with allan-pg. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Beyond the Code: The Non-Technical Superpowers Every Data Analyst Needs to Succeed.
allan-pg profile

Beyond the Code: The Non-Technical Superpowers Every Data Analyst Needs to Succeed.

#dataanalysis #datascience #dataengineering #softskills
2
Comments
2 min read
Mastering Data Wrangling: A Simple Guide for Developers
allan-pg profile

Mastering Data Wrangling: A Simple Guide for Developers

#beginners #python #datascience #tutorial
1
Comments
2 min read
Beginners guide to master web scrapping in python
allan-pg profile

Beginners guide to master web scrapping in python

#python #webscraping #datascience #data
Comments
3 min read
Handling Outliers 101: Why the IQR Method is Your Go-To Tool
allan-pg profile

Handling Outliers 101: Why the IQR Method is Your Go-To Tool

#python #datascience #dataengineering #data
2
Comments
3 min read
Generate ER Diagrams in MYSQL workbench
allan-pg profile

Generate ER Diagrams in MYSQL workbench

#mysql #database #datascience #postgres
1
Comments 1
2 min read
Cast for type conversion in SQL
allan-pg profile

Cast for type conversion in SQL

#sql #database #mariadb #mysql
1
Comments
2 min read
IMPORTING DATA USING PYTHON TO MYSQL
allan-pg profile

IMPORTING DATA USING PYTHON TO MYSQL

#python #database #datascience #sql
1
Comments
2 min read
TITANIC DASHBOARD IN POWER BI
allan-pg profile

TITANIC DASHBOARD IN POWER BI

#data #dataanalysis #powerbi
4
Comments
3 min read
Exploratory Data Analysis using SQL
allan-pg profile

Exploratory Data Analysis using SQL

#database #sql #data
9
Comments 2
3 min read
loading...