Munich, Bavaria, Germany
• Analysing customer behaviour o Generate insights from raw data and prepare comprehensible analysis as basis for decision making using SQL and Tableau o Collaboration with Stakeholders from different departments to identify information needs of business teams to bridge the gap between data and business o Design and maintain dashboards that provide reporting on project success and KPI´s to deliver actionable insights •Analysis of A/B Tests for upsell campaigns o Evaluating test configurations with respect to conversion and cancellation rates
• Building automated reports and data visualisation o Preparation of data sets with MySQL using snowflake data warehouse o Data visualisation with Power BI • Creation of an Offer Calculator with Excel o The Calculator is used in the Sales team for offer creation and calculation of upgrade/upsell cases
Ifo center for Macroeconomic and Surveys • Support for the implementation of the quarterly publication “ifo World Economic Survey” Analysing and forecasting the economic climate of different coun-tries with the help of qualitatively information • Conducting of quantitative data analysis with the statistic program STATA Collecting and preparation of panel data Quantitative data interpretation and visualisation
Economic Policy Center • Preparation of panel data for gravidity analysis with the statistic program STATA Procuring and processing of statistical information Analysis of regional and sectoral foreign trade structure
Internship, Performance Attribution • Support monthly performance analysis of various customer portfolios • Data quality checks and corrections of investment data for different asset classes