Lawal Oluwakemi

As a data analyst with three years of experience, I have developed a strong foundation in Excel, Power BI, and SQL, enabling me to effectively analyze and interpret data for actionable insights. Here's a detailed breakdown of my experience and skills:

1. Excel:

• Proficient in advanced functions and formulas, pivot tables, data validation, and conditional formatting.

• Skilled in data cleaning, data manipulation, and transforming raw data into meaningful information.

• Experience in creating complex spreadsheets, dashboards, and reports to visualize data trends and patterns.

• Able to perform statistical analysis, regression modeling, and data forecasting using Excel.

2. Power BI:

• Extensive experience in creating interactive and visually appealing dashboards, reports, and data visualizations.

• Skilled in connecting to various data sources, including databases, Excel files, and web services.

• Proficient in data modeling, creating relationships between multiple tables, and implementing calculated measures.

• Strong understanding of DAX (Data Analysis Expressions) for creating custom calculations and KPIs.

• Knowledge of Power Query to clean and transform data before loading it into Power BI.

3. SQL:

• Proficient in writing SQL queries to extract, filter, and manipulate data from relational databases.

• Experience in working with complex joins, subqueries, and aggregations to retrieve specific data sets.

• Skilled in database management, including creating tables, views, and stored procedures.

• Knowledge of optimizing queries for performance and database indexing techniques.

4. Data Analysis and Interpretation:

• Ability to define business objectives, gather requirements, and translate them into analytical solutions.

• Strong analytical and problem-solving skills to identify trends, patterns, and outliers in data sets.

• Experience in conducting statistical analysis, hypothesis testing, and A/B testing.

• Proficient in data visualization best practices to communicate insights effectively to non-technical stakeholders.

5. Data Cleaning and Preparation:

• Expertise in data cleaning techniques, such as handling missing values, outliers, and inconsistencies.

• Knowledge of data validation, data standardization, and data quality assurance.

• Experience in transforming and reshaping data for analysis purposes.

6. Reporting and Documentation:

• Skilled in preparing comprehensive reports and presentations summarizing key findings and recommendations.

• Proficient in documenting data analysis processes, methodologies, and assumptions.

• Experience in creating user guides and documentation for data-driven tools and dashboards.

Throughout my three years as a data analyst, I have successfully collaborated with cross-functional teams, effectively communicated complex findings to stakeholders, and delivered data-driven insights that have informed business strategies. My proficiency in Excel, Power BI, and SQL, combined with my strong analytical and problem-solving abilities, positions me well to execute different projects effectively.