Data Literacy: Most common data mistakesThe process of converting raw data into actionable insights is full of pitfalls which you, dear data bender, should be weary of. From the quality of data we use to how we communicate our findings, each step requires careful consideration. Here are so...Feb 2, 2024 · 2 min readcodewise.hashnode.dev
Data Literacy: What is Data context and why is it important?What are the circumstances behind my writing this article? You wouldn't know if I didn't tell. While learning Data Literacy on Datacamp, in this course Introduction to data, the instructor talks about data context. I thought, why not dig deeper?After...Feb 1, 2024 · 4 min readcodewise.hashnode.dev
Excel VlookupWhat is VLOOKUP? VLOOKUP, short for Vertical Lookup is an Excel function that lets you join data from different tables or find data that is in a different table based on a search criteria and returns the first matched value. VLOOKUP simplifies tasks ...Aug 23, 2023 · 3 min readcodewise.hashnode.dev
Import CSV Files into MySQL in 5 Easy StepsStep 1: Open Table data import wizard Make sure you are in the schema you want to import the table to. Right-click on the schema name and select Table Data Import Wizard. Step 2: Select the file to import With the Table data import wizard opened, br...Aug 17, 2023 · 1 min readcodewise.hashnode.dev
8 WEEKS SQL CHALLENGE - Case study 2As part of my SQL learning journey, I did another challenge from the series #8WeekSQLchallenge by Danny Ma. It's something about pizza, you'll see. The database for this challenge consisted of 6 tables. I created them from scratch following the schem...Aug 11, 2023 · 6 min readcodewise.hashnode.dev
