Data Transformation and Data Modeling
Efficient transformation of data to building data models that enable business intelligence.
Chisom Nnamani
Data and Analytics Engineer, with a specialty in organizing and optimizing information for businesses. From creating efficient databases to ensuring seamless data flow, I transform raw data into valuable insights to drive informed decision-making. Let's turn your data into a strategic asset.
About Me.
Dedicated to crafting Data Solutions with an emphasis on scalable data architectures. I specialize in implementing robust data pipelines, designing efficient databases, and creating analytics solutions to meet the unique needs of businesses.
- My Skills Are: SQL, Python, NoSQL databases, Database Management Sytems(SQLServer, MySQL, PostgreSQL), dbt, Cloud(Google BigQuery, Microsoft Azure, Amazon Redshift, Snowflake), big data tools (such as Hadoop, Spark), Git & GitHub.
Services.
Database Design
Robust databases to ensure seamless data flow and accessibility.
Data Engineering
Efficient organization and optimization of data from different sources and building scalable data pipelines, ensuring data quality for actionable insights.
Projects.
Data Engineering
Building OLAP Dimensional Model in BigQuery, using dbt as a Data Transformation Tool.
This project is about building a dimensional data warehouse in BigQuery by transforming an OLTP system in MySQL into an OLAP system in BigQuery, using dbt as a data transformation tool.
Data Engineering
Designing a Bank Marketing Database
This project involves creating a comprehensive database to store and manage customer information for a bank’s marketing campaigns. The project uses Python to import, load, and clean data to ensure its quality and reliability.
Using my data cleaning and database design skills, I also authored a script that set up tables in a PostgreSQL databse for the bank marketing campaigns!
Data Analysis
The Look E-commerce Data Analysis
In this project, I utilized SQL to analyze The Look's data; an e-commerce clothing store and answered some business questions regarding the performance of the e-commerce marketplace, gain insights, and provided some recommendations to increase revenue.
Data Analysis
Transaction Data Analysis using SQL
This case study is all about calculating metrics, growth and helping Data Bank; a FinTech startup analyse their data in a smart way to better forecast and plan for their future developments.
Data Analysis
Business Performance Analysis using SQL
This case study centers on leveraging Foodie-Fi’s digital data, which follows a subscription-based model, to analyze critical business metrics relating to the customer journey, payment transactions, and overall business performance.
Data Analysis
Sales Performance Analysis using SQL
I analyzed data from Adventure Works database and conducted a Sales Performance Analysis, answering some pertinent business questions.
Adventure Works is a large multinational manufacturing company that produces and distributes bicycles, parts, and accessories for commercial markets in North America, Europe, and Asia.
Data Analysis
Querying the Database of a Paper-Selling Company using SQL
Parch and Posey is an e-commerce paper selling company that sold 3 diffetrent types of papers to companies(accounts) via different channels at diferent point in time in different regions.
Data Analysis
Covid-19 Data Exploration using SQL Server
In this project, I queried and analyzed a Covid-19 database using SQL. Insights like the continents and countries with the highest recorded cases and deaths were derived and visualized using Tableau.
Data Analysis
Cryptocurrency Data Analysis
In this project, using Python and its libraries, I built a web scrapper, scrapped and analyzed top 10 Cryptocurencies live data from Cryptowatch.
Data Analysis
Amazon Best Selling Books Analysis
In this project, I web-scrapped Amazon best-selling books using Selenium and Beautiful Soup. I wrangled and analyzed the best selling books beginning from 2009 to 2019.
Data Analysis
We Rate Dogs Twitter Analysis
"In God we trust, all others must bring data" - W. Edwards Deming
In this project, I queried Twitter API using Tweepy, wrangled and analyzed the tweet archive of Twitter user @dog_rates, also known as WeRateDogs.
Data Analysis
Medical Appointment Data Analysis
In this project, using Python and its libraries, I wrangled and analyzed more than 100k Medical Appointments in Brazil to derive insights on the reasons why patients showed up or not for their appointments.
Data Analysis
Africa Food Production and Supply
Who Grows and who Eats the food we grow in Africa? The project focuses on finding insights, patterns and trends through visualizations on food Production and Supply data in Africa using Seaborn and Matplotlib.
Data Analysis
Tackling the Health Crisis in Africa
I participated in a hackathon and worked on the case study; Tackling the Health Crisis in Africa and provided recommendations on how to curb this crisis using Power BI.
Data Analysis
Sales and Market share Analysis using Excel
The CMO of VarnArsdel, a fictitious manufacturing company wanted to keep an eye on the company's performance both internally and externally.
As the Business Intelligence Analyst, I analyzed the sales and market share data of the company and its competitors and built an interactive Excel dashboard answering the relevant business questions.
Contact Me.
I will read all emails. Send me any message you want and I'll get back to you.
I need your Name and Email Address, but you won't receive anything other than your reply.
Send Me A Message