PROJECT 01Sales analysis
Excel / Sales reportingAdidas Poland Sales Dashboard
An interactive Excel dashboard exploring sales trends, provinces, retailers and sales methods.
ExcelPivot tablesPivot charts
EUGENE TURDATA ANALYST.
Data. Context. Clear decisions.
Current work
At Accenture, I support internal reporting and the delivery of clear, structured information to colleagues through Excel reports and PowerPoint presentations.
Portfolio work
Explore selected projects in Excel, SQL, Python and business intelligence, with case studies and source material.
ILLUSTRATIVE WORKFLOW
01UnderstandDefine the question and business context.
02PrepareCollect and clean the data.
03AnalyseExplore patterns and build models.
04ExplainCommunicate findings with a clear view.
SELECTED WORK
Showing 5 of 5 projects / ALL DISCIPLINES
PROJECT 02SQL analysis
MySQL / Public-data explorationCOVID-19 SQL Exploration
Deaths and vaccination data were held in separate tables.
MySQLJoinsCTEs
PROJECT 03Portfolio project
Power BI / Hospitality reportingHotel Revenue & Booking Insights
A hotel report showing revenue, average daily rate, nights, discounts and parking, with hotel, country and date filters.
Power BIInteractive filtersTime-series charts
PROJECT 04Portfolio project
Tableau / Public-data visualisationCOVID-19 Tableau Dashboard
A Tableau dashboard showing reported cases and deaths, population-infected measures, country trends and continent totals.
TableauCountry mapsDashboard design
PROJECT 05Community analysis
Python / Community-data explorationReddit SQL Community Analysis
A study using the Reddit API and Pandas to collect SQL-community posts and comments, then explore posting years, topics, sentiment and emotions.
PythonPRAWPandas
et.
Eugene Tur
Junior Data Analyst
At Accenture, I update Excel reports and PowerPoint presentations for internal reporting.
Operations experience
Worked in parcel logistics at DHL.
Business ownership
Ran an ecommerce business through OLX.ua.
Business education
Master’s degree in Business Administration and Management.
03 / THE TOOLKITThe right tool.
The right tool.
For the question.
Open a discipline to see how I have used it, then follow the link to the relevant work.
01SQL (MySQL & PostgreSQL)
Queries & relational data
Portfolio projects
Relational tables, joins, grouping and window functions, with original SQL available to inspect.
- Common Table Expressions (CTEs)
- Joins and aggregate functions
- Rolling SUM window functions
- Relational tables and foreign keys
- Data cleaning queries
02Power BI
Reports & dashboards
Portfolio projects
Portfolio reports combining filters, summary measures and charts for hotel and project-management data.
- Interactive report filters
- Revenue and daily-rate reporting
- Time-series charts
- Summary tables
- Report layout
03Tableau
Visual analysis
Portfolio projects
A public COVID-19 dashboard with country search, a map, time-series comparisons and continent totals.
- Country maps
- Country search and highlighting
- Time-series comparisons
- Dashboard composition
- Aggregate measures
04Excel
Spreadsheets & reporting
Portfolio projects
Sales dashboards, pivot tables, formulas and VBA, alongside Excel reporting in my work.
- Pivot tables and charts
- Interactive slicers
- Lookup and text formulas
- Conditional formatting
- VBA
05Python (Pandas & APIs)
Collection & exploration
Portfolio projects
A portfolio project collecting SQL-community posts and comments with PRAW and exploring them with Pandas.
- PRAW / Reddit API
- Pandas data frames
- CSV export and cleaning
- Exploratory charts and word clouds
- Sentiment and emotion exploration
06Reporting & presentation
Excel & PowerPoint
Workplace use
At Accenture, I update Excel reports and PowerPoint presentations for internal reporting.
- Updating recurring Excel reports
- Maintaining PowerPoint presentations
- Internal reporting
04 / DIRECT CONTACT
DIRECT EMAIL[email protected]
PROFILE & CREDENTIALS
