Customer Churn Project using Excel and PowerBi
In this project, Excel was used to clean and prepare the churn data, perform initial analysis, and create calculated fields such as churn rate and revenue loss. Power BI was then used to design and develop an interactive dashboard, incorporating KPI cards, charts, and tables to visualize churn patterns by gender, age group, and subscription type. Filters and slicers were added for deeper insights, while branding and conditional formatting enhanced the dashboard’s clarity and usability.
FURNITURE REVENUE OVERVIEW USING EXCEL
In this project, Excel was utilized to clean and structure the sales data, perform preliminary analysis, and generate key metrics such as total revenue, profit, and sales growth. Excel was then employed to build an interactive dashboard, featuring KPI cards, charts, and maps to visualize sales performance, shipping trends, and regional distribution. Slicers and filters were integrated for dynamic exploration, while design elements and conditional formatting improved clarity and user experience.
Nigerian Car Market Analysis using Excel and Power BI
In this project, Excel was used to clean and organize the Nigerian car market dataset, perform preliminary analysis, and calculate key vehicle metrics such as average price, mileage, horsepower, and engine size. Power BI was then utilized to design and develop an interactive dashboard, showcasing KPI cards, bar charts, and maps to highlight popular car brands, preferred transmission types, and color choices in Nigeria. Slicers were added to filter by car condition (brand new, foreign used, Nigerian used), while custom visuals, branding, and conditional formatting enhanced the dashboard’s interactivity, clarity, and overall user experience.