Corinna Zennig

Corinna Zennig

Madison, Wisconsin, United States
3K followers 500+ connections

About

Give me a call and I show you how your data can make you more money today…

Services

Contributions

Activity

Join now to see all activity

Experience

  • LazyAnalyst Graphic

    LazyAnalyst

    BI | Data Analytics | Data Warehousing | Visualization & Reporting | Automation

  • -

  • -

    London, United Kingdom

  • -

    Madison, Wisconsin Area

  • -

    Amsterdam Area, Netherlands

  • -

    Amsterdam, Netherlands

  • -

    Yokohama, Kanagawa, Japan

  • -

    Osnabrück Area, Germany

Education

  • University of Amsterdam Graphic

    Universiteit van Amsterdam / University of Amsterdam

    -

    Activities and Societies: Het Amsterdams Gemengd Koor (Amsterdam's mixed choir)

    Studies focused on Cognitive Psychology: Theories of Decision Making, Attention, Memory, Sleep, and Consciousness. Methods and tools for research in Cognitive Neurosciences were learned such as Transcranial Magnetic Stimulation (TMS), Electroencephalography (EEG), and functional Magnetic Resonance Imaging (fMRI).

    Most time was spend on research projects: applying learned techniques and getting experience in different research environments. One year was spend on two projects at The…

    Studies focused on Cognitive Psychology: Theories of Decision Making, Attention, Memory, Sleep, and Consciousness. Methods and tools for research in Cognitive Neurosciences were learned such as Transcranial Magnetic Stimulation (TMS), Electroencephalography (EEG), and functional Magnetic Resonance Imaging (fMRI).

    Most time was spend on research projects: applying learned techniques and getting experience in different research environments. One year was spend on two projects at The Netherlands Institute for Neurosciences (NIN) in Eus van Someren's Sleep and Cognition Group, and 6 months for a project at the University of Wisconsin-Madison in Giulio Tononi's Center for Sleep and Consciousness.

    Title of Master thesis: "The impact of long-term meditation training on spontaneous brain activity during sleep using high-density-EEG polysomnography"

  • -

    Activities and Societies: International Student Organisation

    Semester abroad. Studies consisted of Japanese language and culture. Researched human emotion recognition using eye-tracking at Katsunori Okajima's Lab for Visual Processing.

  • -

    Activities and Societies: Universitätschor (University choir), Aikido

    Cognitive Sciences consists of 8 modules at the University of Osnabrück: Mathematics, Statistics, Cognitive Linguistics, Cognitive Psychology, Neurobiology, Philosophy of Mind, Computer Sciences, and Artificial Intelligence. Courses have to be taken in all of them.

    Worked as a teaching assistant for classes in Cognitive Psychology and Linguistics, as well as Philosophy of Mind.

    Did research in cross-cultural emotion recognition at Peter Koenig's Lab for…

    Cognitive Sciences consists of 8 modules at the University of Osnabrück: Mathematics, Statistics, Cognitive Linguistics, Cognitive Psychology, Neurobiology, Philosophy of Mind, Computer Sciences, and Artificial Intelligence. Courses have to be taken in all of them.

    Worked as a teaching assistant for classes in Cognitive Psychology and Linguistics, as well as Philosophy of Mind.

    Did research in cross-cultural emotion recognition at Peter Koenig's Lab for Neurobiopsychology.

    Title of Bachelor Thesis: "Cross-Cultural Comparison of Visual Attention and Emotion Recognition"

Licenses & Certifications

Volunteer Experience

  • Translators without Borders Graphic

    German Translator

    Translators without Borders

    - Present 8 years

    Translators without Borders (TWB) is a non-profit organization offering language and translation support for humanitarian and development agencies, and other non-profit organizations on a global scale.

    I provide free English to German translations.

  • TrustedHousesitters Graphic

    Cat Whisperer

    TrustedHousesitters

    - Present 7 years 4 months

    Animal Welfare

    I take care of cats while their parents are away on vacation or business trips. I do admit that I volunteer my services for my own enjoyment. I am available worldwide.

Publications

  • Short Meditation Trainings Enhance Non-REM Sleep Low-Frequency Oscillations.

    PLoS One

    We have recently shown higher parietal-occipital EEG gamma activity during sleep in long-term meditators compared to meditation-naive individuals. This gamma increase was specific for NREM sleep, was present throughout the entire night and correlated with meditation expertise, thus suggesting underlying long-lasting neuroplastic changes induced through prolonged training. The aim of this study was to explore the neuroplastic changes acutely induced by 2 intensive days of different meditation…

    We have recently shown higher parietal-occipital EEG gamma activity during sleep in long-term meditators compared to meditation-naive individuals. This gamma increase was specific for NREM sleep, was present throughout the entire night and correlated with meditation expertise, thus suggesting underlying long-lasting neuroplastic changes induced through prolonged training. The aim of this study was to explore the neuroplastic changes acutely induced by 2 intensive days of different meditation practices in the same group of practitioners. We also repeated baseline recordings in a meditation-naive cohort to account for time effects on sleep EEG activity.

    Other authors
    See publication
  • Neural and Behavioral Correlates of Extended Training during Sleep Deprivation in Humans: Evidence for Local, Task-Specific Effects

    The Journal of Neuroscience

    Recent work has demonstrated that behavioral manipulations targeting specific cortical areas during prolonged wakefulness lead to a region-specific homeostatic increase in theta activity (5–9 Hz), suggesting that theta waves could represent transient neuronal OFF periods (local sleep). In awake rats, the occurrence of an OFF period in a brain area relevant for behavior results in performance errors. Here we investigated the potential relationship between local sleep events and negative…

    Recent work has demonstrated that behavioral manipulations targeting specific cortical areas during prolonged wakefulness lead to a region-specific homeostatic increase in theta activity (5–9 Hz), suggesting that theta waves could represent transient neuronal OFF periods (local sleep). In awake rats, the occurrence of an OFF period in a brain area relevant for behavior results in performance errors. Here we investigated the potential relationship between local sleep events and negative behavioral outcomes in humans.

    Volunteers participated in two prolonged wakefulness experiments (24 h), each including 12 h of practice with either a driving simulation (DS) game or a battery of tasks based on executive functions (EFs). Multiple high-density EEG recordings were obtained during each experiment, both in quiet rest conditions and during execution of two behavioral tests, a response inhibition test and a motor test, aimed at assessing changes in impulse control and visuomotor performance, respectively. In addition, fMRI examinations obtained at 12 h intervals were used to investigate changes in inter-regional connectivity.

    The EF experiment was associated with a reduced efficiency in impulse control, whereas DS led to a relative impairment in visuomotor control. A specific spatial and temporal correlation was observed between EEG theta waves occurring in task-related areas and deterioration of behavioral performance. The fMRI connectivity analysis indicated that performance impairment might partially depend on a breakdown in connectivity determined by a “network overload.”

    Present results demonstrate the existence of an association between theta waves during wakefulness and performance errors and may contribute explaining behavioral impairments under conditions of sleep deprivation/restriction.

    Other authors
    • Giulio Bernardi
    • Francesca Siclari
    • Xiaoqian Yu
    • Michele Bellesi
    • Emiliano Ricciardi
    • Chiara Cirelli
    See publication
  • Experienced mindfulness meditators exhibit parietal-occipital EEG gamma activity during sleep

    PLoS ONE

    Over the past several years meditation practice has gained increasing attention as a non-pharmacological intervention to provide health related benefits, from promoting general wellness to alleviating the symptoms of a variety of medical conditions. However, the effects of meditation training on brain activity still need to be fully characterized. Sleep provides a unique approach to explore the meditation-related plastic changes in brain function. In this study we performed sleep high-density…

    Over the past several years meditation practice has gained increasing attention as a non-pharmacological intervention to provide health related benefits, from promoting general wellness to alleviating the symptoms of a variety of medical conditions. However, the effects of meditation training on brain activity still need to be fully characterized. Sleep provides a unique approach to explore the meditation-related plastic changes in brain function. In this study we performed sleep high-density electroencephalographic (hdEEG) recordings in long-term meditators (LTM) of Buddhist meditation practices (approximately 8700 mean hours of life practice) and meditation naive individuals. We found that LTM had increased parietal-occipital EEG gamma power during NREM sleep. This increase was specific for the gamma range (25-40 Hz), was not related to the level of spontaneous arousal during NREM and was positively correlated with the length of lifetime daily meditation practice. Altogether, these findings indicate that meditation practice produces measurable changes in spontaneous brain activity, and suggest that EEG gamma activity during sleep represents a sensitive measure of the long-lasting, plastic effects of meditative training on brain function.

    Other authors
    See publication

Projects

  • Uncovering TTV Growth Opportunities & Revenue Drivers through Data for a Major Travel Company

    Our client was facing critical challenges: understanding key revenue drivers, evaluating agent performance, and lacking data management standards. The CTO, with a small team of 1, was lacking a Chief Data Officer, leading to inefficiencies in data reporting and decision-making.

    We supported the CTO by strengthening their data infrastructure and improving data capabilities for strategic growth. First, we conducted a Data Quality Audit that uncovered significant issues undermining data…

    Our client was facing critical challenges: understanding key revenue drivers, evaluating agent performance, and lacking data management standards. The CTO, with a small team of 1, was lacking a Chief Data Officer, leading to inefficiencies in data reporting and decision-making.

    We supported the CTO by strengthening their data infrastructure and improving data capabilities for strategic growth. First, we conducted a Data Quality Audit that uncovered significant issues undermining data accuracy. Resolving these was essential to move forward.

    Next, we built custom data models and algorithms within the client’s MS SQL Server to streamline financial reporting and enable complex analysis like Price Volume Mix. Once validated, we developed dynamic Tableau dashboards for the CTO, CFO, and investors, providing new insights into financials, agent productivity, and yield trends.

    Key Challenges:

    • Driving TTV Growth: Fragmented data delayed time-to-value (TTV) for products, impacting revenue growth.
    • Understanding Yield Trends: Inconsistent data visibility hindered optimization of underperforming regions.
    • Improving Agent Productivity: Lack of clear performance metrics led to workforce inefficiencies.
    • Customer Insights: Limited insights affected targeted marketing strategies.

    Solutions:

    • Data Quality Audit: Identified and fixed data issues to ensure accuracy.
    • Stakeholder Collaboration: Worked with investors, CTO, and CFO to align project goals.
    • Data Algorithms: Built MS SQL Server algorithms to automate reporting.
    • Tableau Dashboards: Delivered interactive dashboards for real-time insights.

    Results:

    • Clear Financial Visibility: Improved communication and trust with the equity firm through transparent financials.
    • Yield Optimization: Enhanced efficiency in underperforming regions.
    • Increased Agent Productivity: Improved performance tracking and agent profitability.
    • Customer Insights: Boosted sales conversions through better-targeted marketing.

  • Unlocking Customer Journey Optimization and Email Engagement Improvements through Data for a Healthcare E-Commerce Company

    Testimonial:
    "The new insights we have are quite eye-opening for all of us."

    Challenges:

    Allermi, an e-commerce healthcare client, needed to funnel their data into an AWS Redshift data warehouse to track customer interactions across funnel stages and better analyze the customer journey. They initially had no data connection set up and required guidance to develop the right data strategy and architecture. Supermetrics was our first choice, with a 50% subscription discount…

    Testimonial:
    "The new insights we have are quite eye-opening for all of us."

    Challenges:

    Allermi, an e-commerce healthcare client, needed to funnel their data into an AWS Redshift data warehouse to track customer interactions across funnel stages and better analyze the customer journey. They initially had no data connection set up and required guidance to develop the right data strategy and architecture. Supermetrics was our first choice, with a 50% subscription discount negotiated. However, the Klaviyo connector for their email marketing software did not integrate well with AWS. Budget constraints ruled out Fivetran, and a lesser-known tool was tested but introduced several bugs within three months that needed constant monitoring. In addition, their onboarding conversion rates were below target, requiring data-driven insights to optimize their processes.

    Solutions:

    LazyAnalyst guided Allermi in developing a data strategy and selecting the right architecture. We designed and implemented an end-to-end data pipeline, integrating Klaviyo data through Hevo into Redshift. We transformed the data to ensure it was actionable and connected it to Looker Studio for real-time analysis. We also conducted a thorough analysis of customer interactions, tracking key stages such as account activation and medical questionnaire completion. These efforts provided Allermi with deeper insights into their funnel performance and user behavior. Following the project phase, we have remained on retainer to expand the data architecture and maintain the systems to ensure ongoing performance and scalability.

    Value:

    With the new data pipeline and strategic guidance, Allermi is now positioned to improve onboarding conversion rates, enhance the user experience, and execute more effective customer engagement strategies. The solution allows them to track and respond more efficiently to customer behaviors. Early results show improvements in the customer journey.

  • PoC & Successful Reporting Adaptation - Breaking the Data Gatekeeping Barrier

    Testimonial:

    "Corinna repeatedly delivers a great product and shows tremendous knowledge of the tools. She saved us hundreds of dollars by coming up with creative solutions for issues that could have taken us many hours to solve. We really appreciate the honesty of not overcounting her hours and always being clear about the workload. She is really great to work with. Very knowledgeable and willing to explain and teach us how things work. She has gone above and beyond to help…

    Testimonial:

    "Corinna repeatedly delivers a great product and shows tremendous knowledge of the tools. She saved us hundreds of dollars by coming up with creative solutions for issues that could have taken us many hours to solve. We really appreciate the honesty of not overcounting her hours and always being clear about the workload. She is really great to work with. Very knowledgeable and willing to explain and teach us how things work. She has gone above and beyond to help us."

    Challenges:

    A client in the legal industry offering Dashboard-as-a-Service (DaaS) faced multiple issues with data inefficiencies. They manually downloaded and uploaded CSV files due to budget constraints, which was labor-intensive and slow. Critical insights were inaccessible via the front-end interfaces of Lead Docket and RingCentral, limiting the value they could provide and delaying real-time decision-making.

    Solutions:

    LazyAnalyst stepped in with a custom solution. During the Proof of Concept (PoC), we manually imported Lead Docket and RingCentral data into Looker Studio via Google Sheets to quickly deliver insights. Building on the PoC's success, we developed bespoke data connectors for both Lead Docket and RingCentral, enabling direct data transfers to BigQuery and unlocking deeper insights. This automation empowered the client to independently onboard and manage new customers while reducing manual processes. We continued to enhance the connector infrastructure and BigQuery views to ensure reliability and scalability.

    Value:

    The solution transformed the client’s operations, enabling them to onboard 20 new DaaS customers within the first year. Manual processes were eliminated, providing real-time data access and leveraging insights previously out of reach. We enabled the capture of deleted leads, ensured automated database views for new customers, reduced onboarding time, and achieved SOC2-compliant API key storage, providing security and adaptability to API changes.

    Other creators
  • Fractional Chief Data Officer @ Wingman Coaching

    Testimonial:

    "Corinna has astounded with her innovative solution to a previously "impossible" display challenge in sales data. Her dashboards not only led to a significant uptick in sales and profits but have set a new industry standard, earning rave reviews from clients. Combining efficiency, meticulous detail, and brilliant data design, Corinna's work epitomizes professionalism and quality. A true game-changer in data science, I highly recommend her expertise and eagerly anticipate our…

    Testimonial:

    "Corinna has astounded with her innovative solution to a previously "impossible" display challenge in sales data. Her dashboards not only led to a significant uptick in sales and profits but have set a new industry standard, earning rave reviews from clients. Combining efficiency, meticulous detail, and brilliant data design, Corinna's work epitomizes professionalism and quality. A true game-changer in data science, I highly recommend her expertise and eagerly anticipate our continued collaboration."

    Story:

    As a member of the Wingman Coaching team, I spearheaded the development of their data collection process. This involved transitioning from manual spreadsheet entries by multiple stakeholders to an automated system using Google Forms. I designed a data model and facilitated the integration of their sales software with Zapier. This automation now populates a suite of dashboards in Looker Studio, which I constructed for use by all company stakeholders. Our efforts continue to evolve, with monthly expansions in reporting, including the recent addition of new reporting capabilities for our customers.

  • Klipfolio Dashboarding for Email Marketing Insights

    - Present

    My team specializes in creating Klipfolio dashboards for this client's customers, with a focus on integrating Infusionsoft (Keap) data. We align this data with various paid media advertising sources, as well as with data from email and team management software like Teamwork. This project presents specific challenges, particularly in navigating the complex pagination of the Infusionsoft XML API and the Teamwork REST API.

    Other creators
  • RingCentral Data Pipeline - API development

    -

    Testimonial:

    "Corinna and her team were really great to work with! Extremely knowledgeable and organized. The quality of their work and their communication is top-notch. Every time we have a complex project, I bring it to Corinna and her team, and I'm confident they will deliver a high-quality product."

    Story:

    Our client faced the struggle of getting their data and their customers’ data out of the RingCentral cloud-based communication platform. None of the off-the-shelve…

    Testimonial:

    "Corinna and her team were really great to work with! Extremely knowledgeable and organized. The quality of their work and their communication is top-notch. Every time we have a complex project, I bring it to Corinna and her team, and I'm confident they will deliver a high-quality product."

    Story:

    Our client faced the struggle of getting their data and their customers’ data out of the RingCentral cloud-based communication platform. None of the off-the-shelve data connection software had a data pipeline available. We built a bespoke API connection for our client in their BigQuery database.

    Other creators
  • Fractional CDO & Water Leak Detection for a Smart Water Meter Company

    -

    Testimonial:
    "Wizard behind the drapes"
    "Corinna walks on water."

    Story:

    We assisted a major smart meter technology company in the United States, which was struggling with an inefficient system that processed millions of data rows daily into their business intelligence tool. After they experienced significant challenges with previous data consultants and firms, we successfully reduced their data storage from 1.5 billion rows to 240 million.

    Additionally, we provided…

    Testimonial:
    "Wizard behind the drapes"
    "Corinna walks on water."

    Story:

    We assisted a major smart meter technology company in the United States, which was struggling with an inefficient system that processed millions of data rows daily into their business intelligence tool. After they experienced significant challenges with previous data consultants and firms, we successfully reduced their data storage from 1.5 billion rows to 240 million.

    Additionally, we provided an effective solution to their issue of high-frequency updates paired with slow ETL (Extract, Transform, Load) runtime. Our ongoing responsibilities include auditing their datasets and flows, creating optimized data ETLs and dashboards, and managing a few of their external data engineer team members. Our work involves adding new custom API connections to DOMO, as well as overseeing their BigQuery database and its connections. Moreover, we established their documentation system from the ground up.

    One of the significant achievements my team and I accomplished for this client was the prompt halt of a hacking attempt on their Google Cloud Project. Since then, we have taken over the administration of their Google Cloud Platform, conducting a security audit and implementing best practice security measures. I led this endeavor as the de-facto fractional Chief Data Officer until the client had the budget to hire in-house.

    Other creators
  • Shopify Reporting Done Better For A Fashion E-Commerce

    -

    Testimonial:

    "Corinna is an excellent data analyst. She is 100% the best choice on probably the entire internet for Domo work. She is extremely intelligent, insightful, and hard working. She built an entire Domo instance our from scratch for us. She is also well versed in other more reasonable and affordable reporting systems than Domo. She did a great job of matching our Domo reporting up to how Shopify displays the reporting (which is entirely different than what its back end data…

    Testimonial:

    "Corinna is an excellent data analyst. She is 100% the best choice on probably the entire internet for Domo work. She is extremely intelligent, insightful, and hard working. She built an entire Domo instance our from scratch for us. She is also well versed in other more reasonable and affordable reporting systems than Domo. She did a great job of matching our Domo reporting up to how Shopify displays the reporting (which is entirely different than what its back end data systems say).

    I cannot sing her praises enough. The only reason our contract eventually ended was due to current direction of our eCommerce store - I hope as the economy picks up we have the business need to work with Corinna again, she is definitely my go to data analyst."

    Story:

    Shopify reporting can be challenging for e-commerce companies. For a fashion brand, I successfully extracted their data from Shopify and integrated it into the Domo reporting tool. Having access to the raw data outside of Shopify allowed me to generate reports that were unachievable within Shopify's frontend limitations. Ensuring that the sales numbers align with Shopify's existing reports necessitates advanced ETL (Extract, Transform, Load) skills, as Shopify's API has its complexities and pitfalls. Whenever the CFO required additional reporting, I took the initiative to enhance and expand our original setup.

  • Dashboard Suite Overhaul For A Sales Team

    -

    We came in after this client had a poor dashboard contractor experience. They needed their Grow dashboards optimized and expanded. We went in and quickly found the issues at hand - poor data governance. We set up proper documentation that uncovered data quality issues preventing this company from accurate reporting. Only then did we actually implement the dashboard requirements.

  • Fractional Chief Data Officer @ Indagodata

    -

    Testimonial:
    "Corinna is the best Chief Data Officer I have ever had for this company. I actually transferred her services over to another one of my companies."

    Story:
    Indagodata's CEO hired me to work as an external Chief Data Officer setting up their DOMO reporting capability from scratch to serve their healthcare industry clients with actual data insight in a HIPAA compliant way.

  • Utilization & Profitability Analysis in Google Data Studio

    -

    I connected the Harvest software via Supermetrics to Google Data Studio. This involved Beta testing this new connector at Supermetrics. Setting up reports for employee versus contractor utilization and company profitability.

  • Membership Analytics in Grow.com

    -

    A membership app with financial data in an MS SQL Server database required data ingestion and reporting setup in Grow.

    Other creators
  • Business Intelligence Performance Improvements For A Sales Company

    -

    The challenge of this project was the integration of calculation-heavy Google Sheets into Funnel.io, the creation of an actual timeline for the data in Funnel.io, and the combination with ad data sources. I had to pull out all the tricks to speed up Google Data Studio performance and make the Funnel.io API limits happy on the Google Data Studio dashboard.

  • Salesforce Reporting Improvements

    -

    We worked with a Certified Salesforce Partner to fix and enhance existing Tableau CRM dashboards for their client.

    Other creators
  • Client Reporting Automation for a Marketing Agency

    -

    I automated the reporting for a marketing agency for all their clients. Used the software Funnel to gather all their clients' ad performance data and marketing insights from Google Ads, LinkedIn Ads, Facebook Ads, SEMRush, Google Analytics, Google Search Console, Hubspot, and Salesforce in one place. I cleaned and standardized the data and visualized it in Google Data Studio. All the agency has to do at the end of the day is to copy and paste the insights into their monthly client reporting.

  • Growth Hacking for E-Commerce Companies via Actionable Data Insights

    -

    I was part of this client's advanced data team developing and maintaining DOMO dashboards for their e-commerce clients. We helped visionary e-commerce companies who wanted exponential growth by providing customized, actionable insights from data in the form of streamlined dashboards in order to drive better business decisions and behaviors that eliminate waste and increase profits.

    Data sources I frequently worked with and extracted insights from in Domo were:
    All social media (ads)…

    I was part of this client's advanced data team developing and maintaining DOMO dashboards for their e-commerce clients. We helped visionary e-commerce companies who wanted exponential growth by providing customized, actionable insights from data in the form of streamlined dashboards in order to drive better business decisions and behaviors that eliminate waste and increase profits.

    Data sources I frequently worked with and extracted insights from in Domo were:
    All social media (ads) platforms, Amazon, Clikbank, ClickCRM, Google Analytics, Infusionsoft, Limelight, Salesforce, Shopify

  • Membership and Subscription Performance Analysis for NPO Leisure Centers

    -

    Testimonial:

    "Corinna brought specialist skills that we do not have inhouse. She understood the outcomes of the project and what I wanted even when I didn't have a clear idea! She explained complex analytical issues in a way the team could understand. She advised and guided us through the entire process of building our digital dashboard. Her use of little videos to explain points was very helpful. She was particularly good at providing updates on progress and offering feedback on the…

    Testimonial:

    "Corinna brought specialist skills that we do not have inhouse. She understood the outcomes of the project and what I wanted even when I didn't have a clear idea! She explained complex analytical issues in a way the team could understand. She advised and guided us through the entire process of building our digital dashboard. Her use of little videos to explain points was very helpful. She was particularly good at providing updates on progress and offering feedback on the next step. She was very understanding and flexible when I had to change the agreed timeframe for the project. I would thoroughly recommend Corinna."

    Story:

    Building Google Data Studio (now Looker Studio) reports for a leisure industry client. In the proof-of-concept phase, we looked at sales, cancellations, and other important subscription metrics for their membership data. We then transitioned to their course data analysis to unlock growth potential.

  • Data Centralization and Reporting Dashboard Suite for Financial Industry

    -

    Testimonial:

    "Choosing someone who understands the technical and visual parts of setting up the data flows and dashboards was not easy. Choosing to work with Corinna was a great decision. She is extremely knowledgeable, detail oriented and reliable. A pleasure to work with. We look forward to continuing to phase 2 of the project."

    Story:

    Built a data model in Amazon's postgres database environment. Sourced and integrated data from FB Page Insights, Google Analytics…

    Testimonial:

    "Choosing someone who understands the technical and visual parts of setting up the data flows and dashboards was not easy. Choosing to work with Corinna was a great decision. She is extremely knowledgeable, detail oriented and reliable. A pleasure to work with. We look forward to continuing to phase 2 of the project."

    Story:

    Built a data model in Amazon's postgres database environment. Sourced and integrated data from FB Page Insights, Google Analytics, YouTube, LinkedIn Organization Insights, Intercom, Salesforce, SEMRush, and Bing Ads with the software XPlenty. Created a dashboard suite in Tableau that combines data from all these sources for executive insights and department views.

  • Unlocking Infusionsoft (Keap) Data Insights

    -

    I developed GROW dashboards for this client's customers. We set Infusionsoft data in relation to various paid media ad sources as well as email and team management software data. We switched to a different BI tool called Klipfolio in June 2019.

  • Social Media Marketing & Retail Performance Analysis for a Cosmetics E-Commerce

    -

    My e-commerce client had data flying around their social media marketing accounts as well as their sales performance accounts (FB, Instagram, and Google Ads, Shopify, Amazon Seller Central, and Klaviyo). I sourced all of that into a new database and attached management dashboards.

    They are now able to get up in the mornings and see all their updated insights they need for their team and management. Instead of paying an analyst to spend at least 3h each day for years going through all…

    My e-commerce client had data flying around their social media marketing accounts as well as their sales performance accounts (FB, Instagram, and Google Ads, Shopify, Amazon Seller Central, and Klaviyo). I sourced all of that into a new database and attached management dashboards.

    They are now able to get up in the mornings and see all their updated insights they need for their team and management. Instead of paying an analyst to spend at least 3h each day for years going through all their marketing accounts, downloading reports, and comparing vastly different reports with each other, they now save time and money and put them to use elsewhere.

    I set them up on the data integration software XPlenty, the database software MS SQL Server, and the dashboarding tool Tableau.

    See project
  • Social Media Marketing and Retail Performance Analysis for an Online Fashion Retailer

    -

    My retail client already had a big SQL database going and needed analysis about their brand, country, and product performances. I build dashboards that connected to their database and automated the data flow.

    On top of that, I integrated all their data from social media marketing accounts (FB Ads, FB Insights, Google Ads, Google Analytics, and Matomo) into their database and built dashboards that showed differences in performance across these accounts.

    I used the data integration…

    My retail client already had a big SQL database going and needed analysis about their brand, country, and product performances. I build dashboards that connected to their database and automated the data flow.

    On top of that, I integrated all their data from social media marketing accounts (FB Ads, FB Insights, Google Ads, Google Analytics, and Matomo) into their database and built dashboards that showed differences in performance across these accounts.

    I used the data integration software XPlenty, the database software MySQL, and Tableau for dashboarding.

    See project
  • Unlocking HR Data Insights for a Private School

    -

    I created insights dashboards in Tableau for a big international school (ES, MS & HS grade levels). They were just starting out on their journey to fast actionable dashboard reporting and a lot of their data still came from various software sources. It was a challenge integrating all of it into various data models.

    For the admissions department, I worked through application and enrollment KPIs. For the DSLO department, I visualized learning standards and provided quick insights into…

    I created insights dashboards in Tableau for a big international school (ES, MS & HS grade levels). They were just starting out on their journey to fast actionable dashboard reporting and a lot of their data still came from various software sources. It was a challenge integrating all of it into various data models.

    For the admissions department, I worked through application and enrollment KPIs. For the DSLO department, I visualized learning standards and provided quick insights into assignment scoring.

  • Facebook Data Extraction & Sentiment Analysis for a Newspaper

    -

    My client was a big British newspaper with a strong social media presence. They were interested in doing a sentiment analysis of their FB posts and comments.

    Getting FB insights data out of FB is a very challenging task and usually requires a data integration expert like myself. FB seems to have little interest in giving you access to your own data when it comes to page & post insights (FB ads is a different issue altogether).

    With the help of a data integration tool, I set up…

    My client was a big British newspaper with a strong social media presence. They were interested in doing a sentiment analysis of their FB posts and comments.

    Getting FB insights data out of FB is a very challenging task and usually requires a data integration expert like myself. FB seems to have little interest in giving you access to your own data when it comes to page & post insights (FB ads is a different issue altogether).

    With the help of a data integration tool, I set up the collection of historical page & post insights. FB only allows you to see today's and yesterday's insights for a number of KPIs and measures. To collect historical data I implemented a SQL Server database to host and organize the FB insights data. I programmed a sentiment analysis in R and visualized insights and analysis on a Tableau dashboard.

    My client can now adjust their FB post strategy in a timely manner to cater to user sentiment.

  • End-to-End Marketing and Sales Funnel Reporting for a Business Continuity Insurer

    -

    My client worked with a variety of marketing and sales funnels that kept them busy with downloading reports individually every day and filling spreadsheets manually with the results.

    I went into Facebook Ads, Google Analytics, Google Ads, LinkedIn Ads, Twitter Ads, Salesforce, Pardot, Terminus and Bing Ads and streamlined all that data via their APIs into a software called XPlenty. I directed the output to my clients SQL database and connected an interactive Tableau report to it that I…

    My client worked with a variety of marketing and sales funnels that kept them busy with downloading reports individually every day and filling spreadsheets manually with the results.

    I went into Facebook Ads, Google Analytics, Google Ads, LinkedIn Ads, Twitter Ads, Salesforce, Pardot, Terminus and Bing Ads and streamlined all that data via their APIs into a software called XPlenty. I directed the output to my clients SQL database and connected an interactive Tableau report to it that I had set up with their KPI requirements.

    I saved my client hours of manual data and reporting work every day that they can now use to actually implement opportunities from insights my automated report is producing. Thus, increasing reach, ROI, and revenue on all their channels.

  • Proof of Concept Tableau Dashboards

    -

    Testimonial:

    "I would like to say thanks to Corinna for a great piece of work. I found her very professional and courteous. She quickly understood the scope of the assignment and communicated very clearly her capacity, timelines, etc. We were specific in what we asked of her and she delivered precisely what we wanted in the timeline we agreed. She is clearly technically skilled and made it easy for us to work with her. Thank you Corinna."

    Story:

    Trained the client to…

    Testimonial:

    "I would like to say thanks to Corinna for a great piece of work. I found her very professional and courteous. She quickly understood the scope of the assignment and communicated very clearly her capacity, timelines, etc. We were specific in what we asked of her and she delivered precisely what we wanted in the timeline we agreed. She is clearly technically skilled and made it easy for us to work with her. Thank you Corinna."

    Story:

    Trained the client to understand at a high level how data visualisation tools might be employed within their business. Created an example dashboard in Tableau that helped my client understand what their products might look like in dashboard form and how those dashboards might be used by their customers.

  • Tableau Statistical Product Analysis

    -

    Testimonial:
    "Corinna is a very smart, very hard working data scientist and Tableau graphing expert. I hesitate to recommend her publicly because I'd love to keep her as my secret. But others need to benefit from her talents as well. I will definitely ask for her help again."

    Story:
    Educated a business client on the proper use of statistics for product performance. Stats and visualizations were done in Tableau.

  • Unlocking Sales Data Insights

    -

    Testimonial:
    "Our experience with Corinna could not possibly have gone better! She is a first rate professional, fantastic with data visualization, and extremely intuitive when it comes to data cleanup and structuring. We hope to work with her in the future, and hope that every future experience of hours on Upwork will be as positive as this one!"

    Story:
    Created a sales dashboard for product performance in Tableau.

Languages

  • German

    Native or bilingual proficiency

  • English

    Full professional proficiency

  • French

    Limited working proficiency

  • Dutch

    Limited working proficiency

  • Japanese

    Elementary proficiency

Organizations

  • Fractionals United

    Member

    - Present

    https://www.fractionalsunited.com/ Fractionals United is the leading global community for Fractional Leaders. It's the go-to place for Fractionals to grow their expertise and business, network with other like-minded executives, and access valuable resources and support. Companies can also take advantage of the community if you're in need of Fractional Leaders to help grow your business.

  • DataWrk

    Member

    - Present

    https://www.datawrk.com/de/about-us We are a close-knit network of proven, pragmatic and independent data professionals, focused on delivering outstanding work for its clients.

  • Umbrex/Veritux

    Member

    - Present

    https://umbrex.com/ https://veritux.com/ Umbrex/Veritux connects the world’s top independent professionals. We take our name from the Latin words veritas (truth) and dux (guide), as our members seek to be true guides to their clients. By connecting with one another, members build relationships, share lessons learned, and discover opportunities to collaborate, allowing us to serve our clients better.

Recommendations received

13 people have recommended Corinna

Join now to view

More activity by Corinna

View Corinna’s full profile

  • See who you know in common
  • Get introduced
  • Contact Corinna directly
Join to view full profile

Other similar profiles

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Add new skills with these courses