A SQL and PowerBI oriented project.
Apart from coding, listening and playing
music are Alvis' favorite hobbies. This project analyzes his own preferences in music as well as some
general patterns in different types of music are analyzed directly from data retrieved in the Music
Extraction project. Utilising statistics from a prior project, the data undergoes further cleaning,
transformation and visualisation processes using SQL, Python and Power Query to create
a captivating dashboard that showcases the playlist in a statistical and interesting format.
A Python Oriented Project.
Incorporating musical mathematics and ML, a series of data is extracted from a
private collection of music into CSV files. Including musical notation, the highest note, vocals language, artist gender,
official spotify title and other data of over 130 tracks.
Regression Analysis and Results Visualization
A R and Latex oriented project.
A comprhensive data exploration, regression and classification analysis
on a housing dataset.
The project includes an exploratory analysis, five regression and classification
modelling classes each and personal interpretations and summaries.
Attribute-based File Management Toolkit
Currently a PowerShell and JS oriented project.
Embarking on this project with minimal prior
PowerShell knowledge, my initial intention was to play around with PowerShell. Overtime, it evolved into
a small-scale project where I integrate and apply the knowledge I acquired, thereby enhancing the script's functionality.
A SQL server oriented project.
Serveral small demo scripts that reads document data and transforms the data for analytical and
importing usages. This closely resembles how data management systems (DMS) used by lawers handle their legal documents. Although the original
data and utilities are withheld from the public, but these demos here still serve to showcase and illustrate the functionality of the SQL and SSMS,
providing a glimpse into its operations.
With a keen eye for detail and a passion for uncovering insights, Alvis is well equipped to populate
this area with a personal project inspired from your organization. Let's connect and discover how Alvis can contribute to your
organization's success!