Luca Liu

Hello there! 👋 I'm Luca, a Business Intelligence Developer with passion for all things data. Proficient in Python, SQL, Power BI, Tableau, SAP Business Objects.

Germany Joined on Dec 10, 2023 https://blog.luca-liu.com/

Education

TU Ilmenau (Germany)

Pronouns

she/her

Work

Data Analyst

Cover image for NotionNext - The Ultimate Solution for Notion-Based Website Building

Luca Liu

Aug 8

NotionNext - The Ultimate Solution for Notion-Based Website Building

#notion #nextjs #webdev #tutorial

3 min read

Want to connect with Luca Liu?

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

Create Account

Already have an account? Sign in

Cover image for Do You Really Need a “Second Brain”?

Luca Liu

May 2

Do You Really Need a “Second Brain”?

#discuss #productivity #learning

2 min read

Cover image for SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained

Luca Liu

Feb 21

SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained

#sql #database #tutorial

3 min read

Cover image for Database Design Principles - Normalization and Denormalization

Luca Liu

Feb 14

Database Design Principles - Normalization and Denormalization

#sql #database #tutorial

3 min read

Cover image for Implementing Triggers in SQL - Automating Database Actions

Luca Liu

Jan 27

Implementing Triggers in SQL - Automating Database Actions

#sql #database #tutorial

3 min read

Cover image for Handling Dates and Times in Oracle Database

Luca Liu

Jan 21

Handling Dates and Times in Oracle Database

#sql #database #oracle #tutorial

3 min read

Cover image for SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

Luca Liu

Jan 20

SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

#python #database #sql #tutorial

2 min read

Cover image for SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

Luca Liu

Jan 16

SQL Recursive Queries - Understanding Common Table Expressions (CTEs)

#sql #database #oracle #tutorial

2 min read

Cover image for SQL Performance Tuning: Best Practices for Faster Queries

Luca Liu

Jan 15

SQL Performance Tuning: Best Practices for Faster Queries

#sql #database #oracle #tutorial

3 min read

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

Luca Liu

Jan 13

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

#sql #database #oracle #tutorial

4 min read

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

Luca Liu

Jan 6

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

#sql #database #tutorial #data

3 min read

Cover image for A Quick Guide to SQL Data Modification Commands with Examples

Luca Liu

Jan 5

A Quick Guide to SQL Data Modification Commands with Examples

#sql #database #data #tutorial

3 min read

Cover image for How to chat with Local LLM in Obsidian

Luca Liu

Jan 4

How to chat with Local LLM in Obsidian

#llm #ai #beginners #tutorial

2 min read

Cover image for Getting Responses from Local LLM Models with Python

Luca Liu

Jan 3

Getting Responses from Local LLM Models with Python

#llm #ai #beginners #tutorial

3 min read

Cover image for Local LLM Models and Game Changing Use Cases for Life Hackers

Luca Liu

Jan 2

Local LLM Models and Game Changing Use Cases for Life Hackers

#devchallenge #newyearchallenge #future

2 min read

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

Luca Liu

Jan 1

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

#llm #ai #beginners #tutorial

2 min read

Cover image for A Quick Review of SQL Window Functions with Examples

Luca Liu

Dec 29 '24

A Quick Review of SQL Window Functions with Examples

#sql #database #tutorial #beginners

4 min read

Cover image for How to Publish an Article to DEV Using Python

Luca Liu

Sep 5 '24

How to Publish an Article to DEV Using Python

#python #tutorial #api #productivity

3 min read

Cover image for How to Schedule Python Scripts on a Mac Using Crontab

Luca Liu

Sep 2 '24

How to Schedule Python Scripts on a Mac Using Crontab

#python #tutorial #beginners #productivity

3 min read

Cover image for How to Publish an Article to Medium Using Python and the Medium API

Luca Liu

Aug 31 '24

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

#python #tutorial #api #productivity

2 min read

Cover image for What Does a -2 Reaction Mean? Is It a Bug?

Luca Liu

Aug 30 '24

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

#discuss #writing #beginners

1 min read

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

Luca Liu

Aug 30 '24

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

#obsidian #tutorial #productivity #mac

3 min read

Cover image for Tableau Desktop Public: Try the Free Version for Data Visualization

Luca Liu

May 23 '24

Tableau Desktop Public: Try the Free Version for Data Visualization

#tutorial #tableau #visualization #software

2 min read

Cover image for How to Use ChatGPT on macOS: Installation and Access Solutions

Luca Liu

May 20 '24

How to Use ChatGPT on macOS: Installation and Access Solutions

#ai #chatgpt #tutorial

2 min read

Cover image for Effective Strategies for Searching Stored Procedures in Oracle

Luca Liu

May 20 '24

Effective Strategies for Searching Stored Procedures in Oracle

#tutorial #programming #database #oracle

2 min read

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

Luca Liu

Apr 29 '24

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

#programming #tutorial #python #database

2 min read

Cover image for Active Directory (AD) vs Azure Active Directory (AAD)

Luca Liu

Apr 22 '24

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

#microsoft #beginners #devops #python

2 min read

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

Luca Liu

Apr 4 '24

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

#programming #python #api #tutorial

2 min read

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

Luca Liu

Mar 28 '24

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

#programming #python #jupyter #tutorial

2 min read

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

Luca Liu

Mar 20 '24

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

#powerbi #tutorial #beginners #data

2 min read

Cover image for How to read and write JSON files in Python

Luca Liu

Mar 19 '24

How to read and write JSON files in Python

#programming #python #tutorial #beginners

3 min read

Cover image for Python: Effective Techniques for Managing Dates in DataFrame

Luca Liu

Mar 18 '24

Python: Effective Techniques for Managing Dates in DataFrame

#programming #python #tutorial #beginners

4 min read

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

Luca Liu

Mar 15 '24

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

#programming #python #tutorial #beginners

2 min read

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

Luca Liu

Mar 14 '24

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

#programming #python #tutorial #beginners

2 min read

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

Luca Liu

Mar 13 '24

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

#programming #python #tutorial #beginners

2 min read

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

Luca Liu

Mar 12 '24

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

#programming #python #tutorial #beginners

2 min read

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

Luca Liu

Mar 11 '24

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

#programming #tutorial #sql #database

2 min read

Cover image for Power BI: How to Create Dynamic Show Hide Slicer Panel

Luca Liu

Mar 7 '24

Power BI: How to Create Dynamic Show Hide Slicer Panel

#powerbi #dataanalysis #tutorial #beginners

2 min read

Cover image for Automating Time-Based Tasks: Scheduling Functions at Flexible Intervals

Luca Liu

Mar 6 '24

Automating Time-Based Tasks: Scheduling Functions at Flexible Intervals

#programming #python #productivity

2 min read

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

Luca Liu

Mar 5 '24

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

#tutorial #powerbi #dax #data

2 min read

Cover image for Python: Updating and Appending pandas DataFrame using Dictionary

Luca Liu

Mar 4 '24

Python: Updating and Appending pandas DataFrame using Dictionary

#programming #python #pandas #dataanalysis

3 min read

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

Luca Liu

Feb 25 '24

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

#programming #python #tutorial #api

3 min read

Cover image for Will Python replace Stored Procedures?

Luca Liu

Feb 6 '24

Will Python replace Stored Procedures?

#discuss #sql #python #programming

2 min read

Cover image for Use Python to Refresh Tableau Dashboard

Luca Liu

Feb 2 '24

Use Python to Refresh Tableau Dashboard

#programming #python #tutorial #api

3 min read

Cover image for Comparing Two Lists in Python: Differences, Intersections, and Unions

Luca Liu

Jan 30 '24

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

#programming #python #tutorial #beginners

3 min read

Cover image for How to Use DAX Studio to Retrieve All Measures in Power BI

Luca Liu

Jan 29 '24

How to Use DAX Studio to Retrieve All Measures in Power BI

#powerbi #businessintelligence #beginners #tutorial

2 min read

Cover image for Using the Logger Class in Python for Effective Logging

Luca Liu

Jan 25 '24

Using the Logger Class in Python for Effective Logging

#programming #python #tutorial #coding

4 min read

Cover image for Creating Divider Lines in Python

Luca Liu

Jan 23 '24

Creating Divider Lines in Python

#programming #python #beginners #tutorial

1 min read

Cover image for How to use Python automatically get the Sap BO Temporary License keys?

Luca Liu

Jan 21 '24

How to use Python automatically get the Sap BO Temporary License keys?

#python #programming #dataanalyst #tutorial

3 min read

Cover image for Python: Setting data types when using to_sql

Luca Liu

Jan 17 '24

Python: Setting data types when using to_sql

#python #database #programming #tutorial

2 min read

Cover image for Solving Pandas .to_sql Double Quotes Issue When Writing to Database

Luca Liu

Jan 16 '24

Solving Pandas .to_sql Double Quotes Issue When Writing to Database

#python #database #dataengineering #tutorial

1 min read

Cover image for Saving Dataframes into Oracle Database with Python

Luca Liu

Jan 15 '24

Saving Dataframes into Oracle Database with Python

#python #database #pandas #dataengineering

1 min read

Cover image for How to Use Pyinstaller to Generate an EXE File

Luca Liu

Jan 10 '24

How to Use Pyinstaller to Generate an EXE File

#python #dataanalysis #dataengineering #programming

3 min read

Cover image for Using Python to Retrieve Data Through Tableau REST API

Luca Liu

Jan 6 '24

Using Python to Retrieve Data Through Tableau REST API

#python #tableau #restapi #tutorial

3 min read

Cover image for How to specify the data format when saving Excel via Python?

Luca Liu

Jan 4 '24

How to specify the data format when saving Excel via Python?

#python #dataanalysis #excel #xlsxwriter

5 min read

Cover image for Accessing Power BI Data with Python Using the Power BI REST API

Luca Liu

Jan 2 '24

Accessing Power BI Data with Python Using the Power BI REST API

#python #powerbi #api #restapi

5 min read

Luca Liu

Dec 29 '23

How to Change Number of rows fetched by SAP BusinessObjects Report?

#sap #sapbo #data

2 min read

Luca Liu

Dec 27 '23

How to Create Calendar Table in Power BI?

#powerbi #businessintelligence #data

3 min read

Cover image for Automate SAP Report Extraction with PyAutoGUI

Luca Liu

Dec 25 '23

Automate SAP Report Extraction with PyAutoGUI

#python #sap #automation #dataanalysis

4 min read

Cover image for Sending Emails with Python: A Step-by-Step Guide

Luca Liu

Dec 20 '23

Sending Emails with Python: A Step-by-Step Guide

#python #email #smtp #automation

2 min read

2025 New Year Writing Challenge Completion Badge

One Year Club

Writing Debut

1 Week Community Wellness Streak

4 Week Writing Streak

Want to connect with Luca Liu?