Excel Mastery
Clean raw files, build logic checks, create pivot models and prepare data for reporting.
NKECHIKA JULIAN NNODIOGU PORTFOLIO
I turn raw data into dashboards, insights and predictive models - using Excel, Power BI and SQL and python - so teams can understand performance and act with confidence.
About Me
I began my career as a Medical Laboratory Scientist, where quality control statistics sparked my curiosity to explore patterns and predict outcomes. Today, I am a data analyst and data scientist focused on Excel automation, SQL analysis and Power BI dashboard design. Beyond dashboards, I build predictive models in python - using pandas, scikit-learn and machine learning - to turn raw data into decision, not just reports.
Workflow
Every insight starts with clean data and ends with a clear story. My workflow connects Excel precision, SQL structure and Power BI storytelling and python-driven modeling - from raw file to predictive insight.
Clean raw files, build logic checks, create pivot models and prepare data for reporting.
Join tables, create business-ready datasets and validate numbers before visualization.
Design executive dashboards with DAX, modern UI layout and decision-focused KPIs.
Clean and engineer data with pandas and Numpy, then build predictive models with scikit-lern - classification, regression and clustering - to answer "what happens next."
// DAX Measure
YoY Growth % =
VAR CurrentYear =
CALCULATE(
[Total Revenue],
DATESYTD('Date'[Date])
)
VAR PreviousYear =
CALCULATE(
[Total Revenue],
SAMEPERIODLASTYEAR('Date'[Date])
)
RETURN
DIVIDE(
CurrentYear - PreviousYear,
PreviousYear
)
# Churn Prediction Model
from sklearn.model_selection import train_test_split
from sklearn.ensemble import RandomForestClassifier
from sklearn.metrics import accuracy_score
X_train, X_test, y_train, y_test = train_test_split(
X, y,
test_size=0.2,
random_state=42
)
model = RandomForestClassifier(
n_estimators=200,
random_state=42
)
model.fit(X_train, y_train)
preds = model.predict(X_test)
print("Accuracy:", accuracy_score(y_test, preds))
Selected Work
Horizontally scroll through projects. from BI dashboards to predictive models. Hover each card to reveal business metrics and open the project link in a new tab.
Services
Premium data analytics, business intelligence, and data science solutions tailored to your business, turning raw data into actionable insights and predictive outcomes.
Social Proof
★★★★★"Julian consistently demonstrates a commitment to delivering high-quality work, even when working under tight deadlines. She approaches every task with professionalism, attention to detail, and a genuine willingness to learn and improve. Her ability to understand requirements, deliver thoroghout the process has been impressive.
I have been particularly impressed by the quality of her work and her dedication to achieving excellent results. I look forward to continuing to work with Julian and collaborating with her on future projects. I highly recommend her for her professionalism, reliability, and commitment to excellence."
★★★★"I had the pleasure of working closely with Nkechika julian Nnodiogu, whose insight and dedication distinguish her as a top-tier data analyst. She consistently delivered clear, meaningful insights from complex data, leaving a decisive and positive imprint on our project outcomes."
★★★★★"Julian maintained a strong analytical mindset and an impressive ability to use data for better decision-making. Her understanding of healthcare data and expertise in Analytics allow her to identify patterns and approach challenges from a unique, data-driven perspective. Highly adaptble and committed to accuracy, she consistently delivers practical solutions that improve project outcomes. I am confident that Julian will continue to make a meaningful impact wherever she applies her analytical and data science skills."
Contact
Need a dashboard, report automation, predictive model or a clean portfolio projects? Send a message and I will reply.