Nikolaos Sourtzinos Portfolio

A continuous learner with experience in diverse facets of project delivery, business improvement, data analysis, customer support services, marketing, and sustainable development @nsourt

Film Stock Log

Firm Stock Log

Film Stock Log is a web application for tracking and managing film stock on motion picture productions. Designed for the 1st Assistant Camera, it enables real-time logging of film consumption per shooting day, with cloud synchronization for access from any device.(usernames and passwords for login are admin: 6fHKb$@9iop4 and camera: 9#hIsP&#4ebW). Application features:

  • ✅ Production & Settings: Enter production details (title, director, DOP, company, lab) and define film stocks with custom colors and codes. Configurable waste limit for automatic Short End calculation.
  • ✅ Create days of three types: Shooting, Test and Pre-Shoot. Sort ascending or descending. Each day logs all loaded rolls in detail.
  • ✅ Roll Logging Per roll: can type (NR-1000ft, NR-400ft, Short End, Re-Can), roll ID, film stock, loaded footage, exposed footage, waste, short end, magazine number, ECN rating (Pull/Push) and notes. Short end is calculated automatically based on the waste limit.
  • ✅ Re-Stock: Log incoming film stock per day (1000ft and 400ft cans per stock type) for a complete picture of available inventory.
  • ✅ SE Inventory (Short Ends): Automatic creation and tracking of Short Ends. Each SE has a unique code, records the day it was created and whether it has been used on a subsequent day. Filter by status (available/used) and by film stock.
  • ✅ Dashboard Production overview: total rolls, loaded/exposed/short end/waste footage, available cans per film stock with a visual consumption bar.
  • ✅ Production Report: Detailed day-by-day report with the ability to select specific days. Shows consumption, stock levels and Short Ends per film type. Print-ready in A4 landscape.
  • ✅ Restock Report: Summary of all incoming film stock by day and by stock type.
  • ✅ Print: All pages are print-optimized for A4 landscape, with an automatic header including production details.
  • ✅ Cloud Sync: Automatic synchronization via Supabase. Data is available from any device and browser in real time.
  • ✅ User System: Two access levels: Admin (full access, edit, delete) and Camera (view and add rolls only). Login is protected by a lockout after repeated failed attempts.
  • ✅ Themes: Three display themes: Dark, Light and Medium.
  • ✅ Mobile-friendly: Fully responsive with sidebar navigation for phones and tablets.

Django CRM (Customer Relationship Management)

Django CRM

A modern CRM (Customer Relationship Management) application built with Django, Python, Docker, MySQL, and real-time AJAX search. The project includes:

  • ✅ Django development server running at http://localhost:8001
  • ✅ Fully functional Admin panel at http://localhost:8001/admin
  • ✅ Local MySQL database (only the schema is required)
  • ✅ Automatic database migrations and runserver execution
  • ✅ Data export to Excel
  • ✅ Real-time live AJAX search across multiple fields
  • ✅ Responsive UI using Bootstrap and DataTables (CSS/JS)
  • ✅ Secure environment configuration via .env file

Data Professionals Survey (Tableau)

Data Professionals Survey

Inspired by none other than my favorite and talented YouTuber "Alex the Analyst" Alex Freberg , I took a step further regarding his own “free to use” dataset. Instead of creating a PowerBI report I decided to build a Tableau interactive dashboard to show my insights. Alex conducted a comprehensive survey targeting data professionals and I had the privilege to dive deep into this rich dataset to extract valuable insights.

Case Study covid-19
(SQL analysis)

covid-19

COVID-19 Data exploration using SQL (SQL Server) – Global and Greece Data Exploration.
The project contains an in-depth analysis of Covid Cases, implemented using Excel, SQL. Performed queries, JOINs, CTE, SQL window functions etc.

Case Study Bellabeat
(R + Power BI)

Business Task is to analyze smart device usage data in order to gain insight into how consumers are using their smart devices.
Discover trends in smart device usage and how could these trends apply to Bellabeat customers.