Mastery of SQL Queries for Data Analysis
Showcasing progressively more advanced SQL for data analysis, including table creation, manipulation and queries.
Introduction
My name is Lucas. I am a Business Lawyer with analytical expertise across SQL, Python and Power BI.
I am passionate about uncovering patterns and translating complex problems into actionable solutions.
I have experience in compliance, reconciliation, analytics, mediation, product development and event facilitation.
What I Offer
I offer assistance with business and product development, event facilitation, compliance and reconciliation.
Compliance
Determining what is legally required within fields of business.
Reconciliation
Controlling, investigating and fixing inconsistencies in numbers.
SQL
Database creation and manipulation and data extraction using PostgreSQL.
Python
Pandas data cleaning and analysis using matplotlib and seaborn, as well as machine learning with scikit-learn.
Power BI
Power query data cleaning, modeling with DAX and reporting.
Excel
Formulas, conditional formatting and pivot tables.
Mediation
Conflict resolution, motivation boosting and streamlining interdisciplinary communication.
Business Process Modeling
Modeling business processes, finding bottlenecks and optimizing for productivity.
Product Development
Ideation, Strategizing, Development and Testing of digital products.
Event Facilitation
Planning, presenting and facilitating events.
Certificates
Projects
I have made projects across a variety of different tools and programming languages.
Here is a curated selection.
SQL
Python
Pandas Customer Call List Data Cleaning
Cleaning a customer call list using pandas.
Telecom Customer Churn Classification
Developing a classification model to classify customers of a telecommunications company in California, USA as churn or non-churn.
Superstore Time Series Sales Forecasting
Developing a sales forecasting model of future monthly sales of a global superstore, to assist in pricing and marketing strategies.
Social Media Comments Sentiment Analysis
Developing a sentiment analysis model for a social media platforms comment system, to warn users about whether the comment they are about to post is negative.
Power BI
Webshop Sales Analysis
Analyzing artificial webshop data using a star schema model.
Excel
Global Bike Sales Analysis
Analysing bike sales across North America, the Asia-Pacific and Europe.
Unity (C#)
Adventures of Chirpie
Endless runner featuring 8 different world with a unique environment and ambience, powerups, collectibles, minigames and more.
Typescript
Forum project with Node.js
Backend project, creating a forum with users, posts and replies using Node.js, Express, PostgreSQL and Prisma.
Javascript
Express Library System
CRUD-operated library system used to manage authors, books, bookinstances and genres.
Weather Forecast for Copenhagen
One week weather forecast for Copenhagen showing temperature, wind speed, precipitation and more.
Get in touch
If my profile resonates with you, feel free to download my resumé and get in touch: