Lillian Elek — Data Analytics Portfolio

Welcome to my portfolio! I’m a Data Analyst & BI Specialist with a Master’s in Business Intelligence & Data Analytics and 3+ years of experience turning raw data into actionable insights.

I build reliable pipelines and decision-ready dashboards with SQL, Python, Power BI, and Azure Pipelines. My focus is enabling teams to make faster, clearer decisions — especially in clean-energy and SaaS contexts.

View Projects Get in Touch

Featured Projects

A few highlights demonstrating my skills across Power BI, Python, and SQL. See the full list on the Projects page.

Sales Analytics Dashboard (Power BI)

Interactive filters, KPI cards, and YoY DAX. Sample data for safe public sharing.

Power BIDAXTime Intelligence

Repo

Cloud-to-Code: Ordinary Least Squares for Weather (Python)

Can the temperature be predicted from an OLS model? Model utilized a train/test split and full regression diagnostics.

PythonMLseabornscikit-learn

Repo

AdventureWorks2019 Database (SQL)

Contains SQL Code for everyday use and general understanding. Window functions, CTEs, Indexing, and more.

SQLCTEsWindow Functions

Repo