Data Analysis Cheatsheets Collection

Welcome to the Data Analysis Cheatsheets Collection! This repository contains a comprehensive set of cheatsheets for various data analysis tools and techniques. Whether you're a beginner or a seasoned data analyst, you'll find these resources helpful for quick reference.

Table of Contents

1. Overview
2. Cheatsheets Included
3. How to Open
   • Using GUI
   • Using CLI
   • Using VS Code
4. Contributing
5. License

Overview

This repository includes cheatsheets for the following tools and languages:

• SQL
• Power BI
• Statistics
• Git/GitHub
• Excel

Each cheatsheet is available in PDF format for easy viewing and printing.

Cheatsheets Included

• SQL:

  • SQL Basics Cheatsheet
  • Advanced SQL Cheatsheet

• Power BI:

  • Power BI Dashboard Cheatsheet
  • Power BI Data Modeling Cheatsheet

• Statistics:

  • Descriptive Statistics Cheatsheet
  • Inferential Statistics Cheatsheet

• Git/GitHub:

  • Git Commands Cheatsheet
  • GitHub Workflow Cheatsheet

• Excel:

  • Excel Formulas Cheatsheet
  • Excel PivotTables Cheatsheet

How to Open

Using GUI

1. Download the repository:

   • Click the green "Code" button on the top right.
   • Select "Download ZIP" and unzip the file to your preferred location.

2. Open the cheatsheet:

   • Navigate to the unzipped folder.
   • Open the desired PDF file using any PDF viewer (e.g., Adobe Acrobat Reader, Preview on Mac).

Using CLI

1. Clone the repository:

   git clone https://github.com/yourusername/DA-Cheatsheets-Collection.git

2. Navigate to the repository:

   cd DA-Cheatsheets-Collection

3. Open the cheatsheet using a CLI-based PDF viewer (e.g., evince for Linux):

   evince cheatsheets/sql-basics.pdf

Using VS Code

1. Clone the repository:

   git clone https://github.com/yourusername/DA-Cheatsheets-Collection.git

2. Open the repository in VS Code:

   code DA-Cheatsheets-Collection

3. Open the cheatsheet:

   • Navigate to the cheatsheets folder in the VS Code file explorer.
   • Click on the desired PDF file to open it in the VS Code PDF viewer.

Contributing

We welcome contributions! Please follow these steps to contribute:

1. Fork the repository.
2. Create a new branch (git checkout -b feature-branch).
3. Make your changes and commit them (git commit -m 'Add some feature').
4. Push to the branch (git push origin feature-branch).
5. Create a new Pull Request.

License

This repository is licensed under the MIT License. See the LICENSE file for more details.