Michael Okang - Data Analyst | SQL · Power BI · DAX

Q: Where is Michael based?

Michael is based in Vienna, Austria .

Q: What languages does Michael speak?

Michael speaks the following languages: English (Native), German (Elementary) .

Q: How many years of experience does Michael have?

Michael has at least 1 year of experience. During this time, Michael has worked in at least 1 role and for 1 company . The average length of individual experience is 1 year . Note that Michael may not have shared all experience and actually has more experience.

Q: What is Michael's latest experience?

Michael's most recent position is Gas station attendant at Shell .

Q: What companies has Michael worked for in recent years?

In recent years, Michael has worked for Shell .

Q: Which industries is Michael most experienced in?

Michael is most experienced in industries like Energy and Retail .

Q: Which business areas is Michael most experienced in?

Michael is most experienced in business areas like Customer Service and Operations .

Q: What is Michael's education?

Michael holds a Master in Sustainability Assessment and Resource Management from University of Applied Sciences Campus Vienna , a Master in Applied Geoinformatics from University of Salzburg and a Bachelor in Urban and Regional Planning from Olabisi Onabanjo University .

Q: Does Michael have any certificates?

Michael has 4 certificates . Among them, these include: Data Manipulation and Transactions in SQL Server , Mastering Advanced SQL Queries , and Power BI Essentials and Advanced Techniques .

Recommended expert

Vienna, Austria

Check rate

Experience

Feb 2025 - Feb 2026

1 year 1 month

Hof bei Salzburg, Austria

Gas station attendant

Shell

Accurate handling of customer transactions under time pressure, including cash and register processing with high care
Reliable, consistent performance in a fast-paced, customer-focused environment; strengthened organization and multitasking skills

Data Professional Survey Dashboard

Cleaned and modeled survey data from 630 participants (salary bands, multidimensional satisfaction ratings, demographics) into a Power BI dashboard for analyzing job satisfaction and career entry in the data field

Power BI

Retail Sales Performance Dashboard

Built a star schema data model from multi-year retail data with 5 dimension tables; developed custom DAX metrics, including SUMX-based revenue calculation, DATEADD-based year-over-year comparison, and ALLSELECTED-based running total
Identified regional profitability differences (top district outperforms the next one by more than double) to support budget decisions

Power BI, DAX, SQL

SQL Data Cleaning and Analysis (Bike Sales / Layoffs)

Used window functions and CTEs to detect and handle duplicate records without a unique key; used COALESCE with STR_TO_DATE to process date fields in multiple formats; used self-joins to complete missing categorical data
Independently developed analysis queries to solve top-N-per-group problems using ROW_NUMBER() OVER (PARTITION BY ...)

MySQL

Tourism & Cultural Heritage Sustainability Analytics

Modeled a raw dataset with 15,000 rows and 48 columns into a validated SQL Server star schema; discovered and fixed a modeling error (a GROUP BY/MAX() collapse that had silently standardized category data across all 50 locations) by using a junk dimension
Developed DAX metrics, including a Pearson correlation coefficient calculated natively in DAX, to verify four business-relevant relationships (e.g. r = -0.78 between overcrowding and visitor satisfaction) before using them as dashboard KPIs
Built and published a three-page Power BI dashboard with custom theming, a validated data model, and a documented section on the limits of the analysis

SQL Server, Power BI, DAX

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Energy and Retail.

Energy

Retail

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Customer Service and Operations.

Customer Service

Operations

Summary

Data analyst with hands-on experience building SQL Server star schemas and Power BI dashboards from raw data, backed by four Microsoft and industry-recognized certifications as well as four independently completed analytics projects. Latest work: a validated star schema with 15,000 records and DAX-calculated statistical metrics, built end to end from the raw CSV to the published dashboard, including the discovery and fix of a real modeling error.

Skills

Databases & Sql: T-Sql/Microsoft Sql Server, Mysql Joins, Ctes, Window Functions (Row Number, Partition By), Subqueries, Data Cleaning And Transformation
Data Modeling: Star Schema (Kimball Dimensional Modeling), Junk Dimensions, Degenerate Dimensions, Validation Of Referential Integrity
Bi & Visualization: Power Bi And Dax (Time Intelligence, Running Totals, Year-Over-Year Comparisons, Natively Calculated Statistical Metrics), Power Query, Microsoft Excel
Spatial Analysis / Gis: Postgresql, Arcgis Spatial Data Analysis (Geoinformatics Courses)
Tools & Version Control: Git, Github

Languages

English

Native

German

Elementary

Education

Sep 2026 - Present

University of Applied Sciences Campus Vienna

MSc · Sustainability Assessment and Resource Management · Vienna, Austria

Mar 2025 - Mar 2026

University of Salzburg

MSc · Applied Geoinformatics · Salzburg, Austria

Sep 2006 - Jan 2013

Olabisi Onabanjo University

BSc · Urban and Regional Planning · Ago-Iwoye, Nigeria · Second Class Upper

Certifications & licenses

Data Manipulation and Transactions in SQL Server

Microsoft (Coursera)

Mastering Advanced SQL Queries

Coursera

Power BI Essentials and Advanced Techniques

Packt (Coursera)

SQL Foundations

Microsoft (Coursera)

Statistics

Experience

Total positions 5

Experience in Energy 1 y

Avg length 2 m

Longest experience 1 y

Global Experience

Countries worked in 1 (Austria)

Primary country Austria

Expertise

Recent roles Gas station attendant

Main industries Energy, Retail

Main business areas Customer Service, Operations

Qualifications

Highest degree Master

Certifications earned 4

Profile

Created

July 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Michael based?

Michael is based in Vienna, Austria.

What languages does Michael speak?

Michael speaks the following languages: English (Native), German (Elementary).

How many years of experience does Michael have?

Michael has at least 1 year of experience. During this time, Michael has worked in at least 1 role and for 1 company. The average length of individual experience is 1 year. Note that Michael may not have shared all experience and actually has more experience.

What roles would Michael be best suited for?

Based on recent experience, Michael would be well-suited for roles such as: Gas station attendant, Data Professional Survey Dashboard, Retail Sales Performance Dashboard.

What is Michael's latest experience?

Michael's most recent position is Gas station attendant at Shell.

What companies has Michael worked for in recent years?

In recent years, Michael has worked for Shell.

Which industries is Michael most experienced in?

Michael is most experienced in industries like Energy and Retail.

Which business areas is Michael most experienced in?

Michael is most experienced in business areas like Customer Service and Operations.

What is Michael's education?

Michael holds a Master in Sustainability Assessment and Resource Management from University of Applied Sciences Campus Vienna, a Master in Applied Geoinformatics from University of Salzburg and a Bachelor in Urban and Regional Planning from Olabisi Onabanjo University.

Does Michael have any certificates?

Michael has 4 certificates. Among them, these include: Data Manipulation and Transactions in SQL Server, Mastering Advanced SQL Queries, and Power BI Essentials and Advanced Techniques.

What is the availability of Michael?

Michael will be available full-time from July 2026.

What is the rate of Michael?

Michael's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.