Position: Data Analyst
Category: Data Analyst
English level: upper
Years of experience: 1.5


Super Store Sales Dashboard
• Analyzed 199,900 rows of a four-year data, cleaned with Microsoft Power Query, built data 
models, analyze the dataset and prepare the report with DAX measures in Power Bi.
• The analysis revealed that the highest sales by average was generated in the month of March 
from the southern part of the country with Virginia taking the second on the top 5 states by 
average.
• I wrote a detailed report on my analysis and created visualizations that showcased the results.
• The tools used for this analysis include Microsoft Excel, Power Query and Power Bi with DAX 
measures.
Operations dashboard
• Analyzed 11,128 rows of data to update all rates by 20% increment and add VAT, decentralized 
the data into the 6 geopolitical zones and create a pivot table and charts for all the geopolitical 
zones in one sheet.
• The analysis revealed that the highest revenue was generated in the southwestern part of the 
country with highest distance covered and topping the list Lagos and Ogun state.
• I wrote SQL queries to clean, analyze, explore and derive insights from the data.
• The tools used for this analysis include Microsoft Excel, MySQL, Power Query and Power Bi.
• I published a detailed report and created data visualization with Power bi that help tell the story 
of the analysis.
HR Analytics for employee attendance
• Analyzed 10,000 rows of a 3-month data to understand the working preference of people 
between work from home and work from office, percentage presence of people, sick leave 
percentage, and work from home percentage by date.
• The analysis revealed that 10% percent of the total employee work from home, one percent of 
the total employee took sick leave. Report further revealed that Monday among the days of the 
week recorded the highest percentage in attendance while Friday has the highest percentage of
Work from Home.
• The tools used for this analysis include Microsoft Excel, Power Query and Power Bi with the DAX 
measures.
• Power bi was used to create a database and to implement data automation.
• I created data visualization with Microsoft Power Bi and wrote a detailed report on the findings 
of the analysis.