I have a strong interest in leveraging cutting-edge technologies to streamline processes and enhance business outcomes. In addition to analytics, I'm deeply fascinated by the possibilities of Generative AI and how it’s reshaping industries. My projects reflect my curiosity, technical skills, and drive to solve real-world problems through innovative solutions.
My resume/cv is available upon request :)
This is a repository to showcase skills, share projects and track my progress in Data Analytics related topics.
- MySQL
- PowerBI
- Excel / Google Sheets
- Windows 10 Pro (22H2)
-
- MySQL, PowerBI, Excel, Power Query Editor
In this section I will list data analytics projects briefly describing the technology stack used to solve cases.
Goal: To unlock sales insights that are not visible before for sales team for decision support & automation to reduce manual time spent in data gathering.
Code: Computer_Hardware Sales Analysis
Description: The dataset for the hardware project includes customer information, sales transactions, product details, and regional data. Key components consist of unique identifiers for customers and transactions, sales amounts, order dates, market codes, and product categories. This comprehensive dataset will facilitate the analysis of sales trends and customer behavior, enabling the sales director to make informed decisions to enhance business performance.
Skills: understanding the problem, requirement gathering, data collection, data preperation, data modelling, data cleaning, dashboard building, deployment, generating insights
Technology: MySQL, PowerBI, ETL, Power Query Editor, Excel
Results: An automated dashboard providing quick & latest sales insights in order to support data driven decision making.
- Dashboard Homepage Visualization
- Second landing page Visualization
- Check out my Medium article here!
Syntax: 'Twitch Queries'
Goal: The goal of this project is to analyze gender representation on Twitch, with a specific focus on identifying whether women are underrepresented among streamers and viewers.
Description: By leveraging data from Twitch’s API and third-party platforms, this analysis will explore key metrics such as the proportion of female streamers, their viewer engagement, and their presence in top-streamer rankings. The project aims to provide insights into the challenges faced by female streamers and examine trends across game genres, categories, and audience demographics. Ultimately, this analysis seeks to contribute to a better understanding of gender disparities on Twitch and inform future strategies to promote gender equity on the platform.
Skills: SQL, data analysis, problem-solving, data cleaning, storytelling with data
Technology: MySQL, Excel, PowerBI
Results: TBD.
University of Illinois at Urbana-Champaign
Bachelor's Degree - Industrial/Product Design (STEM-certified)
Business Minor
Aug 2020 - May 2023
Continuing to actively build confidence in my growing technical skills.
Listed below are the ones I have finished (in reverse-chronological order, with the date of completion in brackets):
- Microsoft Certified: Power BI Data Analyst Associate (TBD 2024) (Microsoft)
- Microsoft Certified: Power Platform Fundamentals (PL-900) (TBD 2024) (Microsoft)
- Microsoft Power Platform Fundamentals (PL-900) (TBD 2024) (Udemy)
- Data Analyst Associate Certification (TBD 2024) (DataCamp)
- LinkedIn: @morganckang
- Email: morganckang@gmail.com