Hello! I’m Fullwin. I'm born and raised in New York. I have 5+ years of experience conducting data analysis and ~4+ years of experience in the marketing and advertising industry. I have extensive experience conducting measurement & reporting for various of client’s marketing campaigns (Meta, EY, Walgreens).
Fun Fact: 5+ years of experience in the education sector, weightlifting, cycling, portrait photography, traveling and exploring new cuisines.
Created interactive dashboards to define KPI and visualize data in various ways to seek for trends and patterns utilizing Tableau Desktop.
ViewDesigned a relational database by utilizing RDMS and peformed Ad-Hoc analytical queries with SQL. Performed dimensional modeling and ETL to transition OLTP to OLAP.
ViewPerformed exploration data analysis in Jupyter Notebooks by utilizing Python's Pandas library and other analytical libraries.
ViewLearned how to import data from various sources, detecting data anomalies and profiling the data. Performed cleaning, transforming and loading data with Power Query M formulas. Designed data models with DAX Language and created multiple data visualizations and dashboards with Power BI to extract insights from data.
Learned about cloud concepts and core Azure services. Gained conceptual knowledge of networking, security, storage, compute, application support and development on Azure.
Learned how to modify data connections and manage data properties. Gained understanding of Tableau concepts such as the differences between dimensions, measures, discrete and continuous fields. Learned how to create interactive dashboard and storyboards to extract insights from data.
Covered general concepts for data analysis, data visualization and data science. Utilized tools such as Microsoft Excel (Pivot Tables), Python (Pandas,Numpy), SQL and IBM Cognos Analytics to perform data analysis and data visualizations to seek for trends and patterns within data.
Learned about how Google Analytics collect and process data. Covered digital marketing concepts such as CPC, CPM, Conversion Rates, Impressions, Bounce Rate, Churn Rate, SEO, etc. Learned how to analyze data and segment/filter data for insights.
© 2020 Fullwin Liang