Hi! I'm Charles Ojukwu
Data Analyst Data Analyst Data Analytics Consultant Business Intelligence Analyst Power BI Reporting Analyst Tableau Reporting Analyst Business Analyst
About Me
Data Analyst with a Bachelor’s degree in Business Administration and 5 years of experience in data analysis and visualization. Skilled in transforming raw data into valuable insights using SQL, and proficient in creating interactive dashboards and reports with Power BI, Excel, and Tableau.
My Core Skills
- SQL – 5 Years
- Power BI – 5 Years
- Excel – 10+ Years
- Tableau – 3 Years
- DAX – 4 Years
- Power Query – 3 Years
- Data Modeling – 4 Years
- Pivot Tables – 7 Years
- Pivot Charts – 7 Years
- XLOOKUP- 3 Years
- Python – 1 Year
- Dynamics 365 Business Central – 2 Years
- Project Management (PMI-CAPM) 5 Years
- Web Design – 9 Years
In this project, I developed and delivered a comprehensive Business Intelligence solution using Power BI. The objective was to enable the client to visually track key performance indicators (KPIs) such as sales, revenue, profit, and returns, compare regional performance, analyze product-level trends and forecasts, and identify high-value customers.
Project Overview:
- Client Needs: Visual tracking of KPIs, regional performance comparison, product-level trend analysis, and high-value customer identification.
- Data Source: A folder of raw CSV files containing transactional, return, product, customer, and territorial data.
Data Preparation:
- Data Connection: Connected raw CSV files to Power BI.
- Data Transformation: Utilized Power Query to transform, clean, and shape the messy and disorganized data.
Data Modeling:
- Created a robust Data Model in Power BI.
- Employed DAX to craft calculated columns and measures, incorporating functions such as Date & Time, Logical, Text, COUNT, Math & Stats, CALCULATE, and Time Intelligence formulas.
Visualization:
- Report Design: Developed a three-page interactive report.
- Visual Elements: Implemented various chart types and visuals, including Matrix, Map, and Treemaps.
- Interactive Features: Added bookmarks, date slicers, filtering options, and drill-through filters to enhance data exploration and comprehension.
- Advanced Analytics: Integrated “What-If” Parameters for forecasting and scenario testing.
This project not only highlights my technical proficiency in Power BI but also demonstrates my ability to deliver actionable insights and comprehensive analytics solutions tailored to client needs.
Join my membership program and gain access to exclusive content, early access to posts, monthly 1-on-1 consultation call, monthly shoutouts, and more. My Silver, Gold, and Platinum memberships offer unique benefits tailored to you. Join now and be part of an exclusive community of data and business professionals.
Want to learn Data Analyst Skills?
Use my code “ABNEW20OFF” to get 20% OFF your first course, course bundles, or subscription purchase! Explore amazing courses in SQL, Tableau, Excel, Python, and more. Click the link below and start learning all the fundamental skills to become a Data Analyst in 2024! This is an affiliate link.