Today was our first day of dashboard week, focused on data modeling and schemas in Snowflake and Tableau!
Here are some general tips to consider:
- Ask for help ASAP! - You will only have a few hours to plan, troubleshoot, and prepare for your presentation. Unlike longer projects, you won’t have the luxury of time to figure out a solution on your own. Ask for help from those around you.
- Have a schedule in mind. Set deadlines for each section of the project and try your best to stick to them.
- Prioritize data quality over quantity. Make sure to double check your work as you go. This is important to keep in mind as you transition into placements.
When it came to building my data tables in Snowflake, I hit a few blockers along the way. Some takeaways I learned today are:
- Snowflake has a file limit. If you’re working with a large dataset (originally my dataset consisted of 1 million rows), consider filtering it before uploading it to Snowflake.
- Be careful with formatting. For this particular project, I found that Snowflake can be sensitive to _ and spaces for headers. For example, if your Excel dataset has a header named “ON STREET NAME” and your schema column is written “ON_STREET_NAME”, you may run into an error when uploading your data to Snowflake.
It was a hectic but informative first day, especially since I’ve never connected data from Snowflake to Tableau. I can't wait to see what else I learn this week!