DEV Community

Jin profile picture

Jin

Hello there! đź‘‹ I'm Jing, a Business Intelligence Developer with a passion for all things data. Proficient in Python, SQL, Power BI, Tableau

Location Germany Joined Joined on  github website twitter website

Education

TU Ilmenau (Germany)

Pronouns

she/her

Work

Data Analyst

Stop Using Spark for Your Small Data - Why Azure Functions is the Right Tool for the Job
luca1iu profile
Jin

Stop Using Spark for Your Small Data - Why Azure Functions is the Right Tool for the Job

#azure #dataanalyst #functions #dataengineering
Comments
3 min read

Want to connect with Jin?

Create an account to connect with Jin. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Data Analyst: Does Your Work Actually Matter?
luca1iu profile
Jin

Data Analyst: Does Your Work Actually Matter?

#analytics #career #data #dataanalyst
Comments
3 min read
How to Fix "command 'claude-vscode.editor.openLast' not found" in VS Code
luca1iu profile
Jin

How to Fix "command 'claude-vscode.editor.openLast' not found" in VS Code

#ai #vscode #claude
1
Comments
1 min read
How to Store JSON and XML in SQL Databases
luca1iu profile
Jin

How to Store JSON and XML in SQL Databases

#sql #database #tutorial #data
Comments
3 min read
Fixing Azure SQL Connection Errors in Azure Scheduled Python Job
luca1iu profile
Jin

Fixing Azure SQL Connection Errors in Azure Scheduled Python Job

#azure #database #automation #python
1
Comments
3 min read
How to Install Python Package in Azure Synapse for Apache Spark pools
luca1iu profile
Jin

How to Install Python Package in Azure Synapse for Apache Spark pools

#azure #tutorial #python #data
Comments
2 min read
How to Calculate a Dynamic Truncated Mean in Power BI Using DAX
luca1iu profile
Jin

How to Calculate a Dynamic Truncated Mean in Power BI Using DAX

#powerbi #tutorial #dax #data
Comments
3 min read
Data Security in SQL: Encryption, Roles, and Permissions
luca1iu profile

Data Security in SQL: Encryption, Roles, and Permissions

#database #tutorial #sql #data
Comments
2 min read
Stuck in a Version Trap - How I Used Azure ML to Deploy an Azure Function
luca1iu profile

Stuck in a Version Trap - How I Used Azure ML to Deploy an Azure Function

#azure #dataanalyst #dataengineering #tutorial
Comments
3 min read
10 Essential Data Science Algorithms & Techniques
luca1iu profile

10 Essential Data Science Algorithms & Techniques

#machinelearning #datascience #algorithms #tutorial
Comments
11 min read
English Speaking Companies in Germany
luca1iu profile

English Speaking Companies in Germany

#germany #job #career
2
Comments
4 min read
Markdown Code Blocks Breaking HTML Rendering: How to Fix Line Break Issues
luca1iu profile

Markdown Code Blocks Breaking HTML Rendering: How to Fix Line Break Issues

#markdown #html #webdev
Comments
4 min read
Draw a Fish and Watch it Swim - Crazy Idea Create Viral Website
luca1iu profile

Draw a Fish and Watch it Swim - Crazy Idea Create Viral Website

#sideprojects #buildinpublic #webdev
Comments
3 min read
The Opportunity Card Germany - My First-Hand Experience and Complete Guide
luca1iu profile

The Opportunity Card Germany - My First-Hand Experience and Complete Guide

#germany #job #career
Comments
6 min read
Python + AI - The Essential Skill Combination for Modern Workers Without Coding Backgrounds
luca1iu profile

Python + AI - The Essential Skill Combination for Modern Workers Without Coding Backgrounds

#python #ai #productivity #pandas
Comments
3 min read
NotionNext - The Ultimate Solution for Notion-Based Website Building
luca1iu profile

NotionNext - The Ultimate Solution for Notion-Based Website Building

#notion #nextjs #webdev #tutorial
Comments 1
3 min read
Do You Really Need a “Second Brain”?
luca1iu profile

Do You Really Need a “Second Brain”?

#discuss #productivity #learning
Comments
2 min read
SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained
luca1iu profile

SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained

#sql #database #tutorial
Comments
3 min read
Database Design Principles - Normalization and Denormalization
luca1iu profile

Database Design Principles - Normalization and Denormalization

#sql #database #tutorial
Comments
3 min read
Implementing Triggers in SQL - Automating Database Actions
luca1iu profile

Implementing Triggers in SQL - Automating Database Actions

#sql #database #tutorial
1
Comments
3 min read
Handling Dates and Times in Oracle Database
luca1iu profile

Handling Dates and Times in Oracle Database

#sql #database #oracle #tutorial
3
Comments
3 min read
SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python
luca1iu profile

SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

#python #database #sql #tutorial
1
Comments
2 min read
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
luca1iu profile

SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

#sql #database #oracle #tutorial
44
Comments 5
2 min read
SQL Performance Tuning: Best Practices for Faster Queries
luca1iu profile

SQL Performance Tuning: Best Practices for Faster Queries

#sql #database #oracle #tutorial
1
Comments 1
3 min read
Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples
luca1iu profile

Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples

#sql #database #oracle #tutorial
4
Comments
4 min read
A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control
luca1iu profile

A Guide to Manage Access in SQL - GRANT, REVOKE, and Access Control

#sql #database #tutorial #data
1
Comments
3 min read
A Quick Guide to SQL Data Modification Commands with Examples
luca1iu profile

A Quick Guide to SQL Data Modification Commands with Examples

#sql #database #data #tutorial
2
Comments
3 min read
How to chat with Local LLM in Obsidian
luca1iu profile

How to chat with Local LLM in Obsidian

#llm #ai #beginners #tutorial
16
Comments
2 min read
Getting Responses from Local LLM Models with Python
luca1iu profile

Getting Responses from Local LLM Models with Python

#llm #ai #beginners #tutorial
19
Comments
3 min read
Local LLM Models and Game Changing Use Cases for Life Hackers
luca1iu profile

Local LLM Models and Game Changing Use Cases for Life Hackers

#devchallenge #newyearchallenge #future
23
Comments 19
2 min read
Why You Should Try a Local LLM Model—and How to Get Started
luca1iu profile

Why You Should Try a Local LLM Model—and How to Get Started

#llm #ai #beginners #tutorial
8
Comments
2 min read
A Quick Review of SQL Window Functions with Examples
luca1iu profile

A Quick Review of SQL Window Functions with Examples

#sql #database #tutorial #beginners
24
Comments 6
4 min read
How to Publish an Article to DEV Using Python
luca1iu profile

How to Publish an Article to DEV Using Python

#python #tutorial #api #productivity
5
Comments 3
3 min read
How to Schedule Python Scripts on a Mac Using Crontab
luca1iu profile

How to Schedule Python Scripts on a Mac Using Crontab

#python #tutorial #beginners #productivity
1
Comments
3 min read
How to Publish an Article to Medium Using Python and the Medium API
luca1iu profile

How to Publish an Article to Medium Using Python and the Medium API

#python #tutorial #api #productivity
17
Comments 5
2 min read
What Does a -2 Reaction Mean? Is It a Bug?
luca1iu profile

What Does a -2 Reaction Mean? Is It a Bug?

#discuss #writing #beginners
Comments
1 min read
Obsidian - How to create Daily note every day, even if I don't open it
luca1iu profile

Obsidian - How to create Daily note every day, even if I don't open it

#obsidian #tutorial #productivity #mac
Comments
3 min read
Tableau Desktop Public: Try the Free Version for Data Visualization
luca1iu profile

Tableau Desktop Public: Try the Free Version for Data Visualization

#tutorial #tableau #visualization #software
15
Comments
2 min read
How to Use ChatGPT on macOS: Installation and Access Solutions
luca1iu profile

How to Use ChatGPT on macOS: Installation and Access Solutions

#ai #chatgpt #tutorial
23
Comments
2 min read
Effective Strategies for Searching Stored Procedures in Oracle
luca1iu profile

Effective Strategies for Searching Stored Procedures in Oracle

#tutorial #programming #database #oracle
2
Comments 1
2 min read
How to connect to Oracle, MySql and PostgreSQL databases using Python?
luca1iu profile

How to connect to Oracle, MySql and PostgreSQL databases using Python?

#programming #tutorial #python #database
3
Comments
2 min read
Active Directory (AD) vs Azure Active Directory (AAD)
luca1iu profile

Active Directory (AD) vs Azure Active Directory (AAD)

#microsoft #beginners #devops #python
Comments
2 min read
How to Download All Your Published Articles from DEV.to in Markdown Format
luca1iu profile

How to Download All Your Published Articles from DEV.to in Markdown Format

#programming #python #api #tutorial
1
Comments
2 min read
Setting Up Jupyter Notebook on a Windows Server: A Step-by-Step Guide
luca1iu profile

Setting Up Jupyter Notebook on a Windows Server: A Step-by-Step Guide

#programming #python #jupyter #tutorial
16
Comments
2 min read
Power BI: Two ways to Union Tables - DAX and Power Query
luca1iu profile

Power BI: Two ways to Union Tables - DAX and Power Query

#powerbi #tutorial #beginners #data
4
Comments
2 min read
How to read and write JSON files in Python
luca1iu profile

How to read and write JSON files in Python

#programming #python #tutorial #beginners
1
Comments
3 min read
Python: Effective Techniques for Managing Dates in DataFrame
luca1iu profile

Python: Effective Techniques for Managing Dates in DataFrame

#programming #python #tutorial #beginners
Comments
4 min read
Four Types of Bar Charts in Python - Based on Tabular Data
luca1iu profile

Four Types of Bar Charts in Python - Based on Tabular Data

#programming #python #tutorial #beginners
Comments
2 min read
Four Types of Bar Charts in Python - Based on Array Data
luca1iu profile

Four Types of Bar Charts in Python - Based on Array Data

#programming #python #tutorial #beginners
Comments
2 min read
How to Use the Concat Function in Pandas for Horizontal or Vertical Table Concatenation
luca1iu profile

How to Use the Concat Function in Pandas for Horizontal or Vertical Table Concatenation

#programming #python #tutorial #beginners
Comments
2 min read
How to Convert Rows to Columns and Columns to Rows in Pandas DataFrame using Python?
luca1iu profile

How to Convert Rows to Columns and Columns to Rows in Pandas DataFrame using Python?

#programming #python #tutorial #beginners
2
Comments
2 min read
Oracle Database: How to Create/Delete New User and Grant Privilege?
luca1iu profile

Oracle Database: How to Create/Delete New User and Grant Privilege?

#programming #tutorial #sql #database
Comments
2 min read
Power BI: How to Create Dynamic Show Hide Slicer Panel
luca1iu profile

Power BI: How to Create Dynamic Show Hide Slicer Panel

#powerbi #dataanalysis #tutorial #beginners
5
Comments
2 min read
Automating Time-Based Tasks: Scheduling Functions at Flexible Intervals
luca1iu profile

Automating Time-Based Tasks: Scheduling Functions at Flexible Intervals

#programming #python #productivity
Comments
2 min read
Understanding Nested IF vs. SWITCH in Power BI: A Comparative Analysis
luca1iu profile

Understanding Nested IF vs. SWITCH in Power BI: A Comparative Analysis

#tutorial #powerbi #dax #data
Comments
2 min read
Python: Updating and Appending pandas DataFrame using Dictionary
luca1iu profile

Python: Updating and Appending pandas DataFrame using Dictionary

#programming #python #pandas #dataanalysis
8
Comments
3 min read
Use Python to Fetch Followers and Monitor Post Status on DEV.to
luca1iu profile

Use Python to Fetch Followers and Monitor Post Status on DEV.to

#programming #python #tutorial #api
4
Comments
3 min read
Will Python replace Stored Procedures?
luca1iu profile

Will Python replace Stored Procedures?

#discuss #sql #python #programming
1
Comments
2 min read
Use Python to Refresh Tableau Dashboard
luca1iu profile

Use Python to Refresh Tableau Dashboard

#programming #python #tutorial #api
1
Comments
3 min read
Comparing Two Lists in Python: Differences, Intersections, and Unions
luca1iu profile

Comparing Two Lists in Python: Differences, Intersections, and Unions

#programming #python #tutorial #beginners
Comments
3 min read
loading...