MASTERY-PROJEKT 3 - Marketing Funnel Analysis for Metrocar Car Sharing App: User funnels and target group insights (June 2023)

     

project description

Metrocar is a ride-sharing app. A funnel analysis will be conducted to answer Metrocar's business questions to improve specific areas of the customer funnel. It should be clarified whether and where in the various phases from downloading the app to registration, the first inquiry to the completed journey and Transfer aborts are there to identify optimization areas. Furthermore, it was analyzed in which age groups most of the users are, whether their behavior differ from each other in how the demand varies throughout the day and how often and via which platforms the app is downloaded.

Screenshots of the interaktive dashboards:

MASTERY-PROJEKT 2 - Short term rental market analysis in NYC based on Airbnb data for real estate startup Pillow Palooza (June 2023)

       

project description

With the goal of helping Pillow Palooza identify opportunities for growth and success, Airbnb listing data was examined to gain insights into the short-term rental market in New York City. Key business questions to answer relate to key trends in popular neighborhoods, rental rates, property types, length of stay and demand over time to make informed business decisions. To achieve this, Airbnb listing data from multiple sources was collected, cleaned and analyzed. It was visualized in two tableau dashboards.

Screenshots of the interaktive dashboards:

MASTERY-PROJEKT 1 - Statistic A/B to compare two versions of a website (April 2023)

     

project description

An A/B test was run for the e-commerce company GloBox to evaluate the success of a new website version compared to the previous version. Users of the new website should be made aware of new product offers. A higher conversion rate as well as increased expenditure per user were to be increased. In a previous two-week test phase, one of the versions was randomly presented when the site was called up, along with data on behavior on the site and on purchasing behavior collected. These were available for exploration via SQL and Excel as well as for further statistical analysis. The results are summarized in a report and with a Tableau dashboard been visualized.

Screenshot of the interaktive dashboard:

CAPSTONE-PROJECT- Data exploration and processing via SQL and Excel and visualization with TABLEAU (march 2023)

     

project description:

Data from the e-commerce company Unicorn from 2015-2018 was explored via SQL and adjusted with Excel. Important insights into the distribution and type of customers, the profitability of individuals products or categories and how they have changed over the years visualized in a data story with three dashboards (a data story) in Tableau.

Screenshots of the interaktive dashboards:

    

link zur Tableau Data-Story

TABLEAU - Project data visualization for US Census data (february 2023)

 

project description:

The US Census data is from a Kaggle dataset that includes census data for all counties in 2015. The project includes 3 dashboards (a data story). Questions that were answered:
Which states have the best transportation? What is income and poverty like across America? And one own research: How does the richest country in terms of income per capita differ from one of the poorest countries (with the exception of Puerto Rico) in terms of unemployment rates, Labor sectors, ethnic population distribution and transport to work?

Screenshots of the interaktive dashboards:

     

link to report

link to Tableau Data Story

SQL - Project Deforestation with data on the world's forest cover from the World Bank (december 2022)

 

project description:

In the project, the following questions on the deforastation of the earth were answered using SQL queries from the World Babnk database: Global Situation, Regional Outlook, Country Level Details, Recommendations, Appendix: SQL Queries used

link to report and SQL-Queries

Analysis and forecasting of historical New York Stock Exchange (NYSE) data with EXCEL/ Google Sheets (november 2023)

 

project description:

Dataset: Kaggle's S&P 500 dataset from the New York Stock Exchange In this project, real data from the New York Stock Exchange was analyzed. The following skills were demonstrated in this project: - interpret measures of central tendency and dispersion (mean, median, standard deviation, range), - Using a combination of Excel or Google Sheets functions (e.g. IF statements, INDEX and MATCH, calculate descriptive statistics using the IF statement, dropdowns, data validation, VLOOKUP). - Analyze and forecast financial metrics using Excel or Google Sheets. - Create visualizations of a business metric and use Excel or Google Sheets to create a financial forecast model

Screenshot to Excel Forecast:

Personal Homepage - with About Me and Javascript-Projects

 

project description

-Self-programmed homepage after self-taught learning of HTML, CSS and Javascript with Javascript projects: 1st holiday home homepage, 2nd Wichtel app for random assignment to choose another person without choosing yourself, 3. learn Germany's geography: assign federal states, mountains and rivers correctly

link to homepage (german)