Mariam AdekanyeDATA WAREHOUSE ARCHITECTUREData warehouse architecture refers to the structure, components, and design principles that govern how data is collected, stored…Aug 24, 2023Aug 24, 2023
Mariam AdekanyeDATA EXPLORATION IN EXCELData exploration is an important part of any data analysis project, and Excel can be a powerful tool for exploring your data. Here are some…Mar 28, 2023Mar 28, 2023
Mariam AdekanyeDATA CLEANING AND TRANSFORMATION IN EXCEL.In this project, we worked on a bike share dataset where we cleaned, transformed and draw meaningful insights using dashoard for the data…Jan 5, 2023Jan 5, 2023
Mariam AdekanyeANALYSIS ON UNICORN COMPANIESIn finance, a unicorn is a privately held startup company with a current valuation of US$1 billion or more, across technology centers…Aug 16, 2022Aug 16, 2022
Mariam AdekanyeANALYSIS ON GOLDEN AGE OF VIDEO GAMESVideo games are big business: the global gaming market is projected to be worth more than $300 billion by 2027 according to Mordor…Aug 11, 20221Aug 11, 20221
Mariam AdekanyeAnalyzing American Baby Name Trends Using SQLIn this project, I analyzed the American baby names data using Intermediate and sql joins. The objective of this project is to observe…Aug 5, 20221Aug 5, 20221
Mariam AdekanyeAnalysis of the World Bank’s international debt data using basic SQL queriesHere is a mini project where i analyze international debt data collected by The World Bank using some basic SQL queries codes i learnt from…Aug 4, 2022Aug 4, 2022
Mariam AdekanyeUdemy Project Description Using ExcelAnalysis on the Udemy course was performed to obtain some important information that can be used by the management of Udemy to make…Jul 25, 2022Jul 25, 2022
Mariam AdekanyeTruncating and padding string dataThe first function that we’ll look at is the TRIM function. The TRIM function will remove characters from either the start or end of the…Jul 22, 2022Jul 22, 2022
Mariam AdekanyeReformatting string and character dataThe string concatenation operatorJul 21, 2022Jul 21, 2022