Projects
-
Optimizing Excel functions and tools such as Lookup functions, Logical functions, Text Functions, Statistical functions, Date and time functions, Dynamic Array, Pivot tables, solver, conditional formatting, Data Validation, power pivot, Power Query, Data tables for the cleaning, manipulation, analyzing and visualization of data effectively.
_edited.jpg)
-
Built Power interactive reports and dashboards based on data, derive insights the data and give recommendations.
-
Load data sources from different data warehouse system
-
Analyze and display reports to aid decision making.
-
Run DAX queries and functions
-
Create Models and relationships with data to make more interactive.
-
Build end to end BI Cycle
_edited.jpg)
SQL
-
Build and manage databases, interact with the databases to retrieve and manipulate relevant data
-
Ensure integrity of the data
-
Optimize DDL,DML,DCL and TCL functions to manipulate and transform data to generate insights.
PYTHON AND R PROGRAMMING
-
Data manipulation {Pandas and NumPy ( Python), dplyr and tidyr in( R)}
-
Data Visualization {Matplotlib and seaborn (python), ggplot2, highcharter(R)}
-
Web scraping (Python)
-
Machine learning (R)
_edited.jpg)