Guide to Data Analytics

This page contains the basics of Data Analytics and provides access to various resources such as guides, websites, video tutorials, and tools that can be helpful in understanding and practicing the subject

How be a Data Analyst

Explore methods, tools and practices for an Analyst

Welcome to my data analytics portfolio! My name is Ahmet Ozkaya and I am a data analyst with experience in using spreadsheets, SQL, Python, and R to process and analyze data.

In this portfolio, you will find a selection of my past projects and the tools that I used to complete them. Each project highlights a different aspect of my analytical skills and demonstrates my ability to use various tools and techniques to extract valuable insights from data.

Whether you are an experienced data analyst or just starting out, I hope that my portfolio can provide you with some inspiration and guidance on different ways to process and analyze data. Thank you for visiting, and please feel free to reach out to me with any questions or comments.

Basics of Data Analytics

Data Wrangling Methods

Python

  • Pandas
  • Numpy
  • matplotlib
Details
The Best

R

  • Tidyverse
  • Readr
  • ggplot2
Details

SQL

  • Select
  • Group By
  • Aggregate
Details

Spreadsheet

  • Pivoting
  • Sorting
  • Filtering
Details

Basic Data Analytics

Resources

Data Wrangling Checklist

A checklist for data data wrangling

Details

Useful Resources

List of useful resources for Data Analytics

Details

Tutorials

Great Tutorials for Data Analytics Novices

Details

Data Analytics

Tools