How to use gspread to get and update Google Sheets
A guide to using gspread to get data and update data in Google Sheets. Summary of cases where Data Analysts often use gspread
Data Analysis
This section shares knowledge about Data Analysis. Includes analytical skills, how to use analytical tools, and experiences.
How to create Client Secret in Google Cloud with OAuth 2.0
Instructions on how to create a Client Secret JSON in Google Cloud with OAuth Client ID, along with steps to configure a simple OAuth consent sceen
How to create a chart on Looker Studio
Instructions on how to create a chart on Looker Studio in an in-depth and detailed way. Introduces important chart formatting and settings.
How to choose the right chart for data and dashboard
Share how to choose the right chart according to the method that satisfies three criteria. Introduce charts and explain when to use them.
How to add data sources to Looker Studio
Instruction to add data sources to Looker Studio, add Google Sheets, BigQuery, and Google Ads to Looker Studio. Set up data refresh frequency
How to add Google Analytics measurement ID to Looker
Add Google Analytics measurement ID to Looker to track dashboard views. Instantly know which dashboards are forgotten with reports.
How to create a percentage of column pivot table in Looker
Instructions for creating a percentage pivot table on Looker Studio so that the total percentage of column or row is 100%
How to create a Python virtual environment using Conda
How to install Conda (Anaconda and Miniconda) to create a Python Virtual Environment and install packages professionally.
How to create Service Account and enable Google Cloud API
The fastest way to create Service Account and enable Google Cloud API to work with all types of applications. Get the JSON file just in a minute.
How to run a Python file in CMD or Terminal
The best way to run a Python file in CMD, Terminal, and IDLE on Windows and Mac. How to fix errors when running a PY file. 100% successfully.
How to add a Conda environment to PyCharm and DataSpell
Instructions for adding the Conda environment to Pycharm and DataSpell to use the packages you have added to the Conda environment.
How to install Python on Windows, Mac, Ubuntu
A-Z instructions on how to install Python on Windows, Mac, and Ubuntu. How to create a Python virtual environment and install libraries professionally