86|EXCEL – Smarty’s School Supplies

Challenges
, , ,
21

Challenge86_Data.xlsx (14.8 KB)
To normalize the data, I practiced using the xlookup function to start with my customer table. I then used data parsing to split up the customer address parts. I used the delete duplicate data tool to create the rest of the tables.

22

0204_Smarty School Supplies_Humpherys.xlsx (10.0 KB)

Here is my solution for the data normalization (class homework for 10.25.23). Thanks for the opportunity to practice my normalization, Boston!

23

Challenge86_Solution.xlsx (11.5 KB)

Here is my response, thanks for the help on normalization. It was nice to review it after learning everything.

24

I like how you separated the first and last names and different elements of the address into separate cells!

25

Challenge86_Data_Semadeni.xlsx (10.9 KB)

This was a good review of normalization. I highlighted the primary keys for easy visualization

1 Like
26

This was such good practice of normalization and data parsing. I found it super helpful!
Excel Challenge Normalization.xlsx (11.3 KB)

27

Challenge86_Data.xlsx (11.0 KB)
Here is my solution! ^^

28

Challenge86_Data.xlsx (10.2 KB)

Pretty close. Thanks for the reminder of 3rd normal form and cell splitting.

1 Like
29

0104_TECHHUB_GASSSAWAY.xlsx (9.9 KB)
Great review of data normalization!

30

Super fun to do this challenge and use all the skills learned in class!
Challenge86_Data.xlsx (14.0 KB)

1 Like
31

Thanks for the challenge! Text-to-column and the remove duplicates features were really helpful for creating the tables.
Challenge86_Data.xlsx (14.4 KB)

32

This was a great challenge! I really thought it was a smart idea to simplify the data in a way that makes it easier to read.
Challenge86_Data.xlsx (11.0 KB)

33

Challenge86_Data.xlsx (10.3 KB)

34

Here are my solutions, to any admirers :wink:
Dylan Segal’s Solution Challenge 86.xlsx (10.1 KB)

1 Like
35

I created separate worksheets for each table that I needed to create. I ended up with four tables to turn this data into third normal form.
Challenge86_TechHub.xlsx (15.1 KB)

36

Here is my solution. It was great review of normalization
Challenge86_Data.xlsx (10.2 KB)

1 Like
37

TechHubNormalization.xlsx (14.4 KB)

38

Challenge86_Data.xlsx

39

A good review on data normalization. I ended up creating 4 additional tables to normalize. I left in the dollar symbols in the price column in the product table. I was not aware until after I completed the challenge and compared to the solution that it is good practice to simplify data characters in this way. Learned something new!
HMorrey Challenge86_.xlsx (14.4 KB)

40

OReilly_Challenge86_Data.xlsx (12.4 KB)
I enjoyed the normalization practice and I also used the TEXTBEFORE and TEXTAFTER functions to separate the data in the columns which was a good challenge for me to think through.

1 Like