Day 1
Power BI Download & Installation
In case you have not installed Power BI, here is the link :-
https://www.microsoft.com/en-us/download/details.aspx?id=58494
- Click on download
- Select x64 version
- Click on download again
- Double click on downloaded file and Install it in your system
Raw Dataset
https://drive.google.com/uc?export=download&id=1EnGhqtPTxTFJd60ioVcBHOpHSQPAP8WR
Chatgpt
https://chatgpt.com/
Day 1
Power BI Download & Installation
In case you have not installed Power BI, here is the link :-
https://www.microsoft.com/en-us/download/details.aspx?id=58494
- Click on download
- Select x64 version
- Click on download again
- Double click on downloaded file and Install it in your system
Raw Dataset
https://drive.google.com/uc?export=download&id=1EnGhqtPTxTFJd60ioVcBHOpHSQPAP8WR
Chatgpt
https://chatgpt.com/
Prompt 1
Write an excel formula to give value "Delay" if the difference between dates in cell C2 and B2 is greater than 4,
otherwise, the value should be "On time"
Solution 1
=IF(C2 - B2 > 4, "Delay", "On time")
Prompt 2
write an excel formula to extract name from email id in F2 with @ as a separator
Solution 2
=LEFT(F2, FIND("@", F2) - 1)
Prompt 3
I have comma separated value in G2. Write 3 excel formula to extract value as comma as a separator in H2, I2
and J2
H2
=TRIM(LEFT(G2, FIND(",", G2) - 1))
I2
=TRIM(MID(G2, FIND(",", G2) + 1, FIND(",", G2, FIND(",", G2) + 1) - FIND(",", G2) - 1))
J2
=TRIM(MID(G2, FIND(",", G2, FIND(",", G2) + 1) + 1, LEN(G2)))
Final Dataset
https://drive.google.com/uc?export=download&id=1Fypty-6maIEB4rrZRMnWEaC2_P4ZswvS
Day 2
SQL - Structured Query Language
Why do we use SQL ?
Big data(exponentially growing data) is stored in a database in a structured format(in the form of rows &
columns). To interact with the data in the database, we need a language - SQL
4 Primary use case - CRUD Operations
- Creating new data in the database
- Reading the existing data from the database
- Updating the data in the database
- Deleting the data from the database
Lesson 1
https://sqlbolt.com/lesson/select_queries_introduction
SELECT title from movies ;
SELECT director from movies ;
SELECT title, director from movies ;
SELECT title, year from movies ;
SELECT * from movies ;
Lesson 2
https://sqlbolt.com/lesson/select_queries_with_constraints
SELECT * FROM movies
where id = 6 ;
SELECT * FROM movies
where year between 2000 and 2010 ;
select * FROM movies
where year not between 2000 and 2010 ;
select * FROM movies
limit 5 ;
Lesson 3
https://sqlbolt.com/lesson/select_queries_with_constraints_pt_2
SELECT * FROM movies
where title like "Toy Story%" ;
SELECT * FROM movies
where director = "John Lasseter" ;
SELECT * FROM movies
where director is not "John Lasseter" ;
SELECT * FROM movies
where title like "WALL%" ;
Lesson 4
https://sqlbolt.com/lesson/filtering_sorting_query_results
SELECT distinct DIRECTOR FROM movies
order by director asc ;
SELECT * from movies
order by year desc
limit 4 ;
SELECT * from movies
order by title asc
limit 5;
SELECT * from movies
order by title asc
limit 5 offset 5 ;
