About Me

Hi, my name is Savitcha Pornmanee. I have a strong interest in data analytics, I'm excited to learn more about coding. I am always striving to improve my skill. I have completed certifications in Microsoft Excel, SQL, Python, Power BI, and Tableau from Westride Institute of technology.

Skills

<aside>

• Microsoft Excel </aside>

<aside>

• MySQL </aside>

<aside>

• Power BI </aside>

<aside>

• Tableau </aside>

Data Analytics Project

<aside> <img src="/icons/forward_yellow.svg" alt="/icons/forward_yellow.svg" width="40px" />

[Data Analytics Project] Online Super Store

(Using Power BI for data preparation, analysis, and visualization)

</aside>

<aside> <img src="/icons/forward_green.svg" alt="/icons/forward_green.svg" width="40px" />

Microsoft Excel Project - Customer Personality Analysis (EN)

(Using Excel for data preparation, cleaning, analysis, and visualization)

</aside>

Dashboard

<aside> <img src="/icons/arrow-southeast_blue.svg" alt="/icons/arrow-southeast_blue.svg" width="40px" />

Dashboard using Power BI

Data Analysis Project with Power BI: Real Estate Sales 2001-2022

</aside>

<aside> <img src="/icons/arrow-southeast_blue.svg" alt="/icons/arrow-southeast_blue.svg" width="40px" />

Excel

Microsoft Excel Project - Customer Personality Analysis (EN)

</aside>

My assignments from studied at Westride

PBIChallenge07.pbix

tableau29_challenge.twbx

SQL homework on One to Many

create table students (
	ID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(50)
);

create table class (
	ID INT PRIMARY KEY AUTO_INCREMENT,
    Student_ID INT,
    Name VARCHAR(50),
    GPA DECIMAL(3,2),
    FOREIGN KEY (Student_ID) REFERENCES students(ID)
);

insert into students (name) values ('Mark'),('Mint'),('Ploy'),('Kevin'),('Ice');
select * from students;
 
insert into class (student_id,name,GPA) values (1,'Science',3.0),(1,'Math',2.5),
(2,'Physics',2.0),(2,'Science',3.5),(4,'Math',3.75);
select * from class;

-- ex6 print Avg GPA null=0
SELECT 
    students.Name AS students_name,
    IFNULL(AVG(GPA), 0) AS average_GPA
FROM
    students
        LEFT JOIN
    class ON students.ID = student_id
GROUP BY students.Name;

-- ex7 print Avg GPA null=0 add status column if GPA >=2.5 'PASS',else 'FAIL'
select students.Name as students_name, ifnull(avg(GPA),0) as average_GPA ,
case 
when ifnull(avg(GPA),0) >= 2.50 then 'PASS'
    else 'FAIL'
end as status
from students left join class on students.ID = student_id group by students_name order by average_GPA desc;

SQLChallenge_OnetoMany.sql

many to many.sql