This project demonstrates the creation of a data warehouse using SQL Server and SQL Server Integration Services (SSIS). It includes the data warehouse design, ETL processes, and multidimensional cubes. 

I made this project when I studied an online course from udemy. Here this dashboard contains sales statistics along with which products have the most profits and sales. 

This project demonstrates my proficiency in writing SELECT queries (DQL) and CREATE TABLE statements (DDL) for a relational database. I designed an ERD to model a simple schema. Using a RDBMS, I created the tables with DDL statements and inserted dummy data. The focus is on writing SELECT statements to query and retrieve data from the single or joined tables, including filtering, sorting, aggregating, and analyzing the dummy data. Overall, this project showcases my ability to create database tables using DDL, and then query the database using basic to intermediate SELECT statements (DQL).

I created this project with  datasets that i get in the Kaggle. This project projects include a dashboard that tells about sells, enabling clients to make more informed decisions

I made this project when I was in semester 3. I created an application POS for cashier.This app can record fabric sales in stores. User can use this app for adding products and sell history. I create this project using java language.

I made this project when I was in semester 4. I created a business project called Ngoffee. So in this application you can collect coffee beans produced by farmers who serve as sellers and then distribute them to customers and coffee shops who are buyers.

The case study involves designing SQL queries and stored procedures for a database containing information about a music store's employees, branches, customers, and transactions. The queries demonstrate skills in:

• Filtering data using WHERE clauses with comparison operators, LIKE, IN

• Manipulating strings using functions such as SUBSTRING, CHARINDEX, REPLACE

• Formatting dates using CONVERT and DATENAME

• Creating views

• Aggregate functions like COUNT

• Complex joins between multiple tables

• Stored procedures to encapsulate commonly used logic

• Parameterized stored procedures to accept inputs

• Error handling in stored procedures​

This project demonstrates how i able to solve the case from Leetcodes using skills from basic into advanced query in SQL.

This project was created during my third semester. This project was created by me and my friends in teams. So in this working paper there is a design for a complete database including the initial user design, database table names, diagrams ERD, and the application user interface (UI) that you want to develop from the database.

I made a project about the development of covid in 2020 - 2021 in Indonesia. I created this data visualization in semester 4th. This data of covid is separated by province in Indonesia.

I created an  application project in my 3rd semester named "Stim". This application can load a list of a game that has been purchased and can make transactions in purchasing the game. In this application there is also an admin who can upload the latest games for sale.

I created a dashboard project from IMDb database fetched from kaggle. From that database I made a dashboard design which is useful for an analysis.