Omer Khan - Data Analyst | ContraWork by Omer Khan
Omer Khan

Omer Khan

Data Analyst | Power BI, SQL & Excel | Turning Data into Ins

New to Contra

Omer is building their profile!

Cover image for ๐Ÿ“Š ๐——๐—ฎ๐˜† 1/๐Ÿฏ๐Ÿฌ ๐—ช๐—ต๐—ฎ๐˜ ๐—ฐ๐—ฎ๐—ป
๐Ÿ“Š ๐——๐—ฎ๐˜† 1/๐Ÿฏ๐Ÿฌ ๐—ช๐—ต๐—ฎ๐˜ ๐—ฐ๐—ฎ๐—ป ๐—ฎ ๐—ฟ๐—ฒ๐—ฎ๐—น ๐—ฒ๐˜€๐˜๐—ฎ๐˜๐—ฒ ๐—ฑ๐—ฎ๐˜€๐—ต๐—ฏ๐—ผ๐—ฎ๐—ฟ๐—ฑ ๐—ฎ๐—ฐ๐˜๐˜‚๐—ฎ๐—น๐—น๐˜† ๐˜๐—ฒ๐—น๐—น ๐˜†๐—ผ๐˜‚? ๐Ÿ ๐Ÿ“Š While working on my ๐—”๐˜‚๐˜€๐˜๐—ถ๐—ป ๐—ฅ๐—ฒ๐—ฎ๐—น๐˜๐˜† project, I started with a simple question: ๐—ช๐—ต๐—ฎ๐˜ ๐—ฎ๐—ฐ๐˜๐˜‚๐—ฎ๐—น๐—น๐˜† ๐—ฑ๐—ฟ๐—ถ๐˜ƒ๐—ฒ๐˜€ ๐—ฝ๐—ฟ๐—ผ๐—ฝ๐—ฒ๐—ฟ๐˜๐˜† ๐—ฝ๐—ฟ๐—ถ๐—ฐ๐—ฒ๐˜€? After analyzing ๐Ÿญ๐Ÿฑ,๐Ÿญ๐Ÿณ๐Ÿญ ๐—ฝ๐—ฟ๐—ผ๐—ฝ๐—ฒ๐—ฟ๐˜๐—ถ๐—ฒ๐˜€, a few things caught my attention: ๐Ÿ  ๐Ÿญ๐Ÿฑ,๐Ÿญ๐Ÿณ๐Ÿญ properties analyzed ๐Ÿ’ฐ $๐Ÿฐ๐Ÿฌ๐Ÿฑ๐—ž typical property value ๐Ÿข ๐Ÿฎ+ story properties showed higher values ๐Ÿšฟ Bathrooms & garage capacity also played a role ๐Ÿ“ Location & school ratings showed interesting patterns The best part? Using ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐—ž๐—ฒ๐˜† ๐—œ๐—ป๐—ณ๐—น๐˜‚๐—ฒ๐—ป๐—ฐ๐—ฒ๐—ฟ๐˜€ to dig a little deeper instead of just looking at numbers. Thatโ€™s what I enjoy about data ๐—ง๐—ต๐—ฒ๐—ฟ๐—ฒโ€™๐˜€ ๐˜‚๐˜€๐˜‚๐—ฎ๐—น๐—น๐˜† ๐—ฎ ๐˜€๐˜๐—ผ๐—ฟ๐˜† ๐—ต๐—ถ๐—ฑ๐—ถ๐—ป๐—ด ๐—ฏ๐—ฒ๐—ต๐—ถ๐—ป๐—ฑ ๐˜๐—ต๐—ฒ ๐—ป๐˜‚๐—บ๐—ฏ๐—ฒ๐—ฟ๐˜€. ๐Ÿ‘€ Whatโ€™s your favorite Power BI feature?
0
8
๐—ง๐˜‚๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—–๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฒ โ˜• ๐—ถ๐—ป๐˜๐—ผ ๐—œ๐—ป๐˜€๐—ถ๐—ด๐—ต๐˜๐˜€ ๐Ÿ“Š | ๐—š๐—ฟ๐—ฎ๐—ป๐—ป๐˜† ๐—–๐—ฎ๐—ณ๐—ฒ ๐——๐—ฎ๐˜€๐—ต๐—ฏ๐—ผ๐—ฎ๐—ฟ๐—ฑ ๐—ฅ๐—ฒ๐˜ƒ๐—ฒ๐—ฎ๐—น ๐Ÿ”ฅ Hey Contra Fam ๐Ÿ‘‹ Super excited to share my latest projectย the ๐—š๐—ฟ๐—ฎ๐—ป๐—ป๐˜† ๐—–๐—ฎ๐—ณ๐—ฒ ๐—˜๐˜…๐—ฒ๐—ฐ๐˜‚๐˜๐—ถ๐˜ƒ๐—ฒ ๐—ฃ๐—ฒ๐—ฟ๐—ณ๐—ผ๐—ฟ๐—บ๐—ฎ๐—ป๐—ฐ๐—ฒ ๐——๐—ฎ๐˜€๐—ต๐—ฏ๐—ผ๐—ฎ๐—ฟ๐—ฑ, built using ๐—ฃ๐—ผ๐˜„๐—ฒ๐—ฟ ๐—•๐—œ ๐Ÿ’ปโœจ This wasnโ€™t just about creating visualsโ€ฆ It was about turning raw data into ๐—ฟ๐—ฒ๐—ฎ๐—น ๐—ฏ๐˜‚๐˜€๐—ถ๐—ป๐—ฒ๐˜€๐˜€ ๐—ถ๐—ป๐˜€๐—ถ๐—ด๐—ต๐˜๐˜€ that actually matter ๐Ÿ“ˆ ๐Ÿ”ฅ ๐—ž๐—ฒ๐˜† ๐—›๐—ถ๐—ด๐—ต๐—น๐—ถ๐—ด๐—ต๐˜๐˜€: ๐Ÿ’ฐ $๐Ÿฐ.๐Ÿฏ๐Ÿฎ๐—  ๐—ฅ๐—ฒ๐˜ƒ๐—ฒ๐—ป๐˜‚๐—ฒ ๐—š๐—ฒ๐—ป๐—ฒ๐—ฟ๐—ฎ๐˜๐—ฒ๐—ฑ โ†’ Strong month-over-month growth ๐Ÿš€ ๐ŸŒ ๐—ก๐—ผ๐—ฟ๐˜๐—ต๐—ฒ๐—ฎ๐˜€๐˜ = ๐—ฅ๐—ฒ๐˜ƒ๐—ฒ๐—ป๐˜‚๐—ฒ ๐—ž๐—ถ๐—ป๐—ด ๐Ÿ‘‘ โ†’ $๐Ÿญ.๐Ÿณ๐Ÿญ๐—  (~๐Ÿฐ๐Ÿฌ%)** contribution ๐Ÿ’Ž ๐Ÿฒ๐Ÿฒ% ๐—ฅ๐—ฒ๐˜ƒ๐—ฒ๐—ป๐˜‚๐—ฒ ๐—ณ๐—ฟ๐—ผ๐—บ ๐—Ÿ๐—ผ๐˜†๐—ฎ๐—น๐˜๐˜† ๐— ๐—ฒ๐—บ๐—ฏ๐—ฒ๐—ฟ๐˜€ โ†’ Retention is driving the business ๐Ÿ’ฏ ๐Ÿ“ฆ Top Subscription Plan โ†’ โ€œ2 Meal Kits/3โ€ is the most popular ๐Ÿ”ฅ ๐Ÿ“Š ๐—ฃ๐—ฒ๐—ฟ๐—ณ๐—ผ๐—ฟ๐—บ๐—ฎ๐—ป๐—ฐ๐—ฒ ๐˜ƒ๐˜€ ๐—ง๐—ฎ๐—ฟ๐—ด๐—ฒ๐˜ โ†’ +๐Ÿญ๐Ÿฌ.๐Ÿฒ๐Ÿฎ% ๐—ฅ๐—ฒ๐˜ƒ๐—ฒ๐—ป๐˜‚๐—ฒ ๐—š๐—ฟ๐—ผ๐˜„๐˜๐—ต โ†’ +๐Ÿฏ๐Ÿญ.๐Ÿฑ% ๐—ฆ๐—ต๐—ถ๐—ฝ๐—บ๐—ฒ๐—ป๐˜๐˜€ ๐—œ๐—ป๐—ฐ๐—ฟ๐—ฒ๐—ฎ๐˜€๐—ฒ ๐Ÿ› ๏ธ What skills I used: โšก ๐——๐—”๐—ซ ๐— ๐—ฎ๐—ด๐—ถc โ€“ PM comparisons, targets vs actuals, ARPC ๐Ÿ”— ๐——๐—ฎ๐˜๐—ฎ ๐— ๐—ผ๐—ฑ๐—ฒ๐—น๐—ถ๐—ป๐—ด โ€“ connecting multiple datasets like a puzzle ๐ŸŽจ ๐—จ๐—œ/๐—จ๐—ซ ๐——๐—ฒ๐˜€๐—ถ๐—ด๐—ป โ€“ clean dark theme for premium feel ๐Ÿ’ก Why this project matters? For me, data analytics isnโ€™t just about chartsโ€ฆ Itโ€™s about answering: ๐Ÿ‘‰ ๐—ช๐—ต๐˜† ๐—ถ๐˜€ ๐˜๐—ต๐—ถ๐˜€ ๐—ต๐—ฎ๐—ฝ๐—ฝ๐—ฒ๐—ป๐—ถ๐—ป๐—ด? ๐Ÿ‘‰ ๐—ช๐—ต๐—ฒ๐—ฟ๐—ฒ ๐—ถ๐˜€ ๐˜๐—ต๐—ฒ ๐—ผ๐—ฝ๐—ฝ๐—ผ๐—ฟ๐˜๐˜‚๐—ป๐—ถ๐˜๐˜†? ๐Ÿ‘‰ ๐—ช๐—ต๐—ฎ๐˜ ๐˜€๐—ต๐—ผ๐˜‚๐—น๐—ฑ ๐˜๐—ต๐—ฒ ๐—ฏ๐˜‚๐˜€๐—ถ๐—ป๐—ฒ๐˜€๐˜€ ๐—ฑ๐—ผ ๐—ป๐—ฒ๐˜…๐˜? And this dashboard does exactly that ๐Ÿ’ฏ
0
22
Austin Realty Insights I built this interactive Power BI dashboard to explore Austinโ€™s real estate market using a dataset of 15,171 properties. I cleaned and transformed the data using Power Query, created DAX measures and KPIs, and built interactive visuals with cross-filtering and Key Influencers. The main challenge was turning a large dataset with many attributes into a dashboard that stayed simple, useful, and easy to navigate. Through this project, I strengthened my skills in Power BI, DAX, Power Query, data modeling, and business-focused data visualization. Key result: Median property price of $405K, with insights into the factors associated with property values.
0
28
Cover image for Built an interactive Power BI
Built an interactive Power BI retail dashboard to analyze sales, profit, products, stores, and customer performance through clear and actionable insights.
1
53