07/24/2025 updated
OL
100 % available
Data Analyst with Excel, SQL, and Power BI expertise
Portharcourt, Nigeria
Only remote
B.Sc. in Computer Science (Expected 2027)Data AnalysisBig DataBusiness ProcessesDatabasesData CleansingData IntegrityRelational DatabasesDatabase DesignGoogle DocsLookup TableMaintenanceMicrosoft SQL ServersVisualizationMicrosoft Power BISQL Databases
Data Analysis & Visualization
Data cleaning, transformation, and visualization skills using Excel, Power BI, and Google Sheets. Creation of interactive dashboards to visualize KPIs for non-technical stakeholders.
SQL & Database Management
SQL query writing to extract, join, and filter relational database data. Experience with Microsoft SQL Server and database design principles.
Advanced Excel
Advanced Excel skills including VLOOKUP, PivotTables, and Conditional Formatting for cleaning and transforming large datasets.
Dashboard Development
Creation of interactive dashboards in Power BI and Excel to visualize business metrics and KPIs for strategic decision-making.
DAX for Analytics
Creation of calculated columns and measures using DAX for advanced analytics in Power BI environments.
Data Exploration
Systematic approach to exploring datasets to identify patterns, trends, and insights that drive business strategy refinement.
Database Design
Knowledge of database design principles, schema relationships, and data integrity maintenance using structured databases.
Data cleaning, transformation, and visualization skills using Excel, Power BI, and Google Sheets. Creation of interactive dashboards to visualize KPIs for non-technical stakeholders.
SQL & Database Management
SQL query writing to extract, join, and filter relational database data. Experience with Microsoft SQL Server and database design principles.
Advanced Excel
Advanced Excel skills including VLOOKUP, PivotTables, and Conditional Formatting for cleaning and transforming large datasets.
Dashboard Development
Creation of interactive dashboards in Power BI and Excel to visualize business metrics and KPIs for strategic decision-making.
DAX for Analytics
Creation of calculated columns and measures using DAX for advanced analytics in Power BI environments.
Data Exploration
Systematic approach to exploring datasets to identify patterns, trends, and insights that drive business strategy refinement.
Database Design
Knowledge of database design principles, schema relationships, and data integrity maintenance using structured databases.
Languages
EnglishNative speaker
Project history
Built an interactive dashboard analyzing sales performance by region, product, and profit. Helped identify underperforming categories to refine business strategy.
Created a professional HR dashboard for visualizing workforce trends: promotions, job level, tenure. Used slicers and filters to enhance user-driven exploration.
Designed an academic performance dashboard showing subject strengths and weaknesses. Applied charts and KPIs for strategic academic interventions.