Skills

Data analysis and transferable skills

Please click on any of the navigation links below for more details

Data skills

Microsoft Power Business Intelligence

Overview:

Data Import: Skilled in connecting to various data sources (Excel, CSV, SQL) and using direct query connections.
Power Query: Experienced in data transformation, ensuring consistency and accuracy, including handling null values and parsing data.
Data View: Proficient in refining data types, creating date tables, and designing calculated columns and tables with DAX.
Relationship View: Skilled in managing relationships between fact and dimension tables, avoiding many-to-many connections, and implementing security.
Report View: Expert in creating user-friendly reports with a wide range of visualisations, slicers, filters, and AI-driven tools. Proficient in publishing to Power BI Service.
Power BI Service: Experienced in managing workspaces, reports, and semantic models, ensuring secure content sharing. Practiced in creating dashboard from multiple related reports.

Evidence:

Power BI projects: Personal projects demonstrating the ability to execute the entire workflow outlined above (see Portfolio page for details).
Business data analyst training: Completed a comprehensive training course covering the fundamental use of Power BI, including all core views, Power Query, and DAX (see Portfolio page for details).
Self teaching (Udemy courses): Enhanced knowledge through Udemy courses, focusing on advanced features such as incremental refresh, advanced formatting, integration of uncommon data sources, and time intelligence analysis.

Microsoft Excel

Overview:

Data Import: Proficient in importing data from various sources, including CSV files, Excel, and web scraping tools for seamless analysis.
Data Overview: Skilled in using Excel to inspect, clean, and prepare datasets for detailed analysis.
Filtering and Sorting: Experienced in using Excel’s filtering and sorting tools to clean data and identify anomalies.
Formulas: Expert in applying formulas like SUM, AVERAGE, COUNT, IF, XLOOKUP, MATCH, SWITCH, TRIM, AND, CONCATENATE, and LEN for data summarisation and cleaning.
Pivot Tables: Highly skilled in creating pivot tables to summarise and gain insights into datasets efficiently.
Visualisations: Capable of creating clear, professional visualisations (bar charts, line graphs, KPIs, slicers, filters, matrices) with effective formatting.
Slicers and Filters: Expert in using slicers for dynamic data filtering to tailor insights.
Dashboard Design: Experienced in designing dashboards with intuitive layouts, clean colour themes, and clear insights for specific audiences.

Evidence:

Excel Projects: Personal projects showcasing the ability to execute the entire workflow described above (see Portfolio page for details).
Business data analyst training: Completed comprehensive training in Microsoft Excel, including advanced formulas, dashboard design, and pivot table development.
Consultant data analyst role: As a consultant data analyst for a veterinary stem cell company:
- Extracted, collated, and analysed key customer data for business marketing.
- Conducted experiments on temperature fluctuations during product shipping and on a new product, using Excel for data collation and visualisation in reports presented to the director.

SQL Server

Overview:

Data Import: Proficient in importing data from various sources, including CSV files, Excel, and other databases, into SQL Server using tools such as SSMS and Azure Data Studio.
Data Cleaning: Skilled in identifying and correcting errors in datasets, including handling NULL values, data type mismatches, and ensuring data consistency across tables.
Data Joining: Experienced in using JOIN operations (INNER, LEFT, RIGHT, FULL) to combine data from multiple tables, ensuring accurate relationships and enhancing analysis.
Views and Filtering: Proficient in creating views for simplified access to complex queries and using filters to extract relevant data, enabling more focused insights.
Database Maintenance: Experienced in routine database management tasks such as indexing, query optimisation, and backups to ensure efficient performance and data security.

Evidence:

SQL Projects: Personal and professional projects demonstrating expertise in complex queries, data transformations, and reporting (see Portfolio).
Azure SQL Utilisation: Practical experience in setting up and managing databases in Azure SQL, including integration with Power BI for advanced analytics.
Business Data Analyst Training: Completed a comprehensive training course covering SQL fundamentals, including queries, joins, and data management best practices.
Self-teaching (Udemy): Enhanced knowledge of SQL through self-paced Udemy courses, focusing on advanced techniques like window functions, stored procedures, and performance tuning.

Python

Overview:

Skilled in data import, cleaning, and visualisation, with experience in personal projects and business data analyst training.
Data Import/Connection: Proficient in importing data from various sources (CSV, Excel, databases) and establishing connections for analysis.
Data Cleaning: Experienced in handling missing values, correcting inconsistencies, and preparing data for analysis through various techniques.
Visualisation: Capable of creating clear, insightful visualisations using charts and graphs for initial data analysis.

Evidence:

Data Cleaning in Personal Projects: Applied data cleaning techniques in personal projects, ensuring accurate, ready-to-analyse datasets (see portfolio).
Business Data Analyst Training: Completed training covering data import, cleaning, and programming fundamentals (see portfolio).

Tableau

Overview:

Experienced in using Tableau for data import, managing relationships, structuring sheets, applying filters, and designing interactive dashboards and stories for impactful visualisation.
Data Import: Proficient in connecting Tableau to various data sources, including Excel, CSV, and databases, for seamless analysis.
Relationships: Skilled in creating data relationships and joins within Tableau to ensure accurate connections across multiple datasets.
Sheets: Experienced in organising data within Tableau sheets, facilitating efficient analysis and visualisation.
Filters: Proficient in using Tableau’s filter functionality to refine and segment data for focused insights.
Dashboards: Expert in designing interactive dashboards in Tableau that highlight key metrics and deliver actionable insights.
Stories: Experienced in creating Tableau stories to communicate data-driven narratives and insights to diverse audiences.

Evidence:

Personal Projects: Applied Tableau skills in real-world projects to manage data and create compelling visualisations (see portfolio).
Self-study: Continuously enhancing Tableau skills through self-paced learning, online courses, and research.

Azure control panel

Experienced in using the Azure control panel for managing SQL databases, including admin control and user/role creation.

SQL Server/Databases: Skilled in managing SQL databases within Azure, ensuring optimal configuration and performance.

Admin Control: Proficient in administering Azure SQL databases, including managing security and access permissions.

User/Role Creations: Experienced in creating and managing user roles and permissions to ensure secure database access.

Evidence:

Azure SQL Databases in Personal Projects: Applied Azure SQL skills in personal projects to manage databases and optimise data workflows (see portfolio).
Self-study: Continuously enhancing Azure SQL skills through practice and exploration with Azure services

Transferable Skills

Logical / detail orientated

Overview:

Logical and detail-orientated, with a strong foundation in data analysis and scientific research.
Analytical Thinking: Skilled in identifying patterns, ensuring accuracy, and making data-driven decisions through meticulous analysis.
Attention to Detail: Experienced in working with complex datasets, paying close attention to consistency, quality, and precision in analysis.

Evidence:

PhD in Biochemistry: Advanced research skills honed during doctoral studies, involving critical analysis and attention to experimental detail (see scientific publications).
Personal Data Projects: Applied analytical and detail-orientated skills to personal data projects, ensuring thorough and accurate insights (see portfolio).
4-year Undergraduate Biochemistry Degree: Developed strong foundational skills in scientific analysis, data handling, and critical thinking (see scientific publications).
Scientist personality: Passionate about data-driven problem solving and evidence-based decision making, with a strong focus on precision and accuracy.

Critical thinking

Overview:

Skilled in critical thinking, with the ability to analyse complex problems, identify patterns, and make data-driven decisions.
Problem-Solving: Proficient in using logical reasoning to address challenges and find effective solutions in data analysis and research.
Analytical Evaluation: Experienced in evaluating information from various sources, synthesising insights, and drawing conclusions based on evidence.

Evidence:

PhD in Biochemistry: Developed critical thinking skills through extensive research, hypothesis testing, and data interpretation (see scientific publications).
Personal Data Projects: Applied critical thinking to analyse and synthesise datasets from various sources, ensuring reliable and actionable insights (see portfolio).
4-year Undergraduate Biochemistry Degree: Built a solid foundation in analytical thinking and scientific problem-solving (see scientific publications).
Scientist Personality: Naturally inquisitive, with a focus on evidence-based analysis, critical evaluation, and systematic problem-solving.

Teamwork/communication

Overview:

Skilled in teamwork and communication, with experience in training, collaboration, and customer relations across diverse settings.
Collaboration: Proficient in working with diverse teams, facilitating clear communication, and promoting cooperation towards shared goals.
Training & Mentorship: Experienced in providing training, creating materials, and mentoring colleagues to ensure smooth knowledge transfer and team development.

Evidence:

Private Tutor: Experienced in developing personalised teaching materials, mentoring students, and communicating complex topics effectively.
Consultant Data Analyst: Developed training manuals, conducted new product training, and managed customer relations in Scotland, ensuring clear communication and effective collaboration.
PhD in Biochemistry: Co-authored two publications with individuals from diverse backgrounds, fostering collaboration across disciplines and cultures.
4-year Undergraduate Biochemistry Degree: Collaborated on multiple group research projects, enhancing teamwork and communication skills in academic settings.

Adaptable

Overview:

Highly adaptable, with experience in working with diverse datasets, tools, and techniques. Demonstrated flexibility in career transitions and adapting to evolving practices in research and data analysis.
Learning & Growth: Skilled in quickly learning new tools and techniques through self-study, courses, and hands-on practice, with a focus on adapting to various data types and analysis methods.
Career Transitions: Successfully transitioned from scientist to tutor and then to data analyst, showcasing the ability to adapt to new roles and environments.

Evidence:

Personal Data Projects: Worked with varied datasets and tools, continuously learning and applying new techniques through self-study, courses, and practice (see portfolio).
PhD in Biochemistry: Adapted to constantly changing experimental techniques, data review processes, and evolving scientific theories.
Change of Careers: Transitioned from a scientific role to tutoring and later to data analysis, effectively applying transferable skills across diverse domains.

Science Skills

Laboratory skills

Overview:

Microbiology: Experienced in microbiological techniques and research.
Standard Laboratory Practice: Skilled in adhering to lab protocols and maintaining laboratory safety and accuracy.
Crystallography: Knowledgeable in crystallography techniques for studying protein structures.
Protein Biochemistry: Proficient in protein analysis, purification, and characterisation.
Genetics and Cloning: Experienced in genetic manipulation and cloning techniques for research purposes.

Evidence:

PhD in Biochemistry: Applied advanced laboratory skills in various techniques, including microbiology, protein biochemistry, and crystallography.
4-year Undergraduate Biochemistry Degree: Gained foundational laboratory experience, including genetics, cloning, and standard laboratory practices.

Science knowledge/acumen

Overview:

Strong foundation in scientific principles and research methodologies, with a focus on biochemistry and related fields.
Research & Analysis: Proficient in analysing complex scientific data and applying research findings to advance knowledge in biochemistry.
Critical Evaluation: Experienced in critically evaluating scientific literature, experimental results, and theories to contribute to scientific understanding.

Evidence:

PhD in Biochemistry: Conducted advanced research, applying in-depth scientific knowledge to produce valuable insights and contribute to the field.
4-year Undergraduate Biochemistry Degree: Developed a solid understanding of scientific concepts, experimental techniques, and data analysis, laying the foundation for advanced study and research.

Report writing

Overview:

Skilled in writing clear, concise, and well-structured reports, particularly for scientific research and analysis.
Data Presentation: Proficient in presenting complex data and findings in a structured, understandable format, ensuring clarity and relevance.
Research Communication: Experienced in effectively communicating research objectives, methods, and results to both technical and non-technical audiences.

Evidence:

PhD in Biochemistry: Authored detailed research reports, including publications and thesis, demonstrating strong report writing skills.
4-year Undergraduate Biochemistry Degree: Produced scientific reports and research papers, focusing on data analysis, methodology, and research findings.