Samuel Lam Email & Phone Number

London Area, United Kingdom

London, England, United Kingdom

• Effectively communicated with clients to develop comprehensive Power BI reports and dashboards, facilitating in-depth business performance analysis• Utilised SQL and advanced Power Query techniques to extract meaningful insights from MySQL databases• Implemented complex DAX formulas to calculate key business KPIs, establishing a framework for data-driven decision-making• Leveraged Python, including API calls, to acquire additional insights into business performance

London, England, United Kingdom

• Intensive programme for essential knowledge and skills as a Data Analyst, including core data concepts, processes of data collection, cleansing, processing, transformation, visualisation, as well as presentation on the results and actionable insights which help making data-driven decision• Hands-on experience on technical skills (Excel, SQL, Python, Power BI), such as the usage of function, pivot table, chart and dashboard in Excel, querying and managing relational databases via SQL, exploring and analysing datasets using Python and relevant libraries like NumPy and Pandas, as well as visualising results using Power BI• Completed 2 data analysis team projects which utilised Microsoft SQL Server, Python, PowerBI (report and dashboard), Excel

London, England, United Kingdom

• Extensive job-ready training covering entire scope of data analysis process, from collecting data to visualising and communicating insights effectively to stakeholders• Practical experience on data analytics platforms and tools including SQL, R, Excel / Google Sheets, Tableau, Google BigQuery• Completed 2 personal data analysis projects which utilised SQL, R, Excel, Tableau, and Google BigQuery

• Showcased excellent problem-solving skills through providing clients with data-driven insights and solutions in lighting system design by analysing lighting data• Achieved 20 to 40% cost reduction in lighting projects while maintaining the desired lighting effects• Produced reports and developed Excel template that improved efficiency by over 50%

• Delivered high quality lesson to students from ages 4 - 70+, both individual and group classes• Communicated effectively with students and deliver complex musical concepts and techniques clearly and concisely, achieved 100% passing rate among students taking public grading examinations• Retained successfully over 98% students after trial-classes with satisfaction in the teaching quality

• Collaborated with different musicians, worked and performed in various music events and performances, such as music festival, wedding party, and company ceremony, as well as studio recording• Demonstrated remarkable collaboration and communication with various musicians • Excellent time management and organisational skills evidenced through working on multiple gigs simultaneously

Education record

Bachelor Of Science (Bsc)