Nuwan Fernando's Portfolio

I am a Data Analyst that uses Microsoft Excel, SQL, Tableau, Power BI, Python, Java, and R to tell stories through data.

E-news Express Project

This project used statistical analysis, a/b testing, and visualization to decide whether the new landing page of an online news portal (E-news Express) is effective enough to gather new subscribers or not. The simulated dataset has certain important metrics such as converted status and time spent on the page that will help to conclude the effectiveness of the new landing page. Apart from that, the dependence of conversion on the preferred language will also be analyzed in this project.

Covid-19 Data Exploration In SQL

Open source data was pulled from Coronavirus (Covid-19) Deaths. The data was transferred from Excel to SQL for data exploration. The exploration was completed using skills such as Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, and Creating Views

Covid-19 Tableau Visualizations

Converted Covid-19 SQL queries were used to create visualizations in Tableau. The dashboard is focused on the global and country level of the data.

Mobile Notary Data Exploration In SQL

Used mobile notary data within PostgreSQL to answer questions and gain insight on business functions.


Locations

Irvine, CA 12345-67890
Dallas, TX 12345-67890

Phone

(949) 421-8338

Email

nuwan.m.f@gmail.com

Social