I'm a data analyst with a knack for turning complex data into actionable insights. Leveraging my expertise to bridge the business-data gap. My expertise lies in data analysis using SQL, Python, and Power BI, allowing me to automate dashboards, streamline workflows, and empower stakeholders with clear and concise communication.
View My LinkedIn Profile: https://www.linkedin.com/in/ipek-ba%C5%9Fman/
View My Notion Portfolios: https://ipekbasman.notion.site/Ipek-Basman-s-Portfolio-8e31eddec07f4d7990dbb1da23f255f8?pvs=4
View My Projects on GitHub
Portfolios
Featured Projects
Google Merchandise Store Dashboard (Google Analytics, BigQuery, BI, Tableau)
- Worked with Google Merchandise Store, connected customer online behavior and conversion to sales and profitability, made recommendations with impact on business outcomes
- Used Google Analytics, BigQuery and Data Studio to analyze data collected by JavaScript tags, measure effectiveness of marketing strategies, tell marketers what works and what doesn’t
- Determined the best digital marketing tactics to reach target audience, drive them through conversion funnel AIDA (awareness, interest, desire, action), and maximize traffic and conversions
- Collaborated with marketers to create data-driven campaigns, measure, analyze and optimize campaign performance, gain proficiency in core digital marketing tactics including direct, display, organic search, paid search, referral, social
- Applied Pareto principle (80/20 rule), focus on actionable head data, focus on SEO to get more free traffic, combine web data with customer and product data to find more insights, help organizations increase revenue, reduce costs, improve customer satisfaction and loyalty

Retail Analytics (Power BI, Python)
- The Adventure Works dataset analysis revealed that the most popular product categories are accessories, bikes, and clothing, generating a total of $23.6 million in revenue.
- Sales from online channels have shown a significant increase over the past year, with a 15% growth rate and a total of $5.8 million in revenue generated through this channel.
- The most profitable customer segments are from the Pacific region, generating a total of $6.2 million in revenue, followed by the South Atlantic and Mountain regions.
- A key finding from the analysis is that the company’s marketing campaign focusing on discounting products has not been effective, as the revenue generated from discounted products only accounts for 7% of the total revenue. It may be more effective to focus on other marketing strategies to increase sales.

Page template forked from evanca