This course combines engaging instructor-led presentations and practical hands-on labs to equip you with essential skills for data analysis and visualization.

By the end of this course, you will:

• Understand Snowflake's Architecture: Learn the key features and benefits of Snowflake and its relevance for business use.
• Navigate and Connect to Snowflake: Confidently access and explore Snowflake's platform and tools.
• Perform Basic Data Queries: Write SQL queries to retrieve, summarize, and analyze business data.
• Create Visualizations and Reports: Integrate Snowflake with BI tools to build dashboards and present insights effectively.
• Complete Business Workflows: Apply Snowflake's capabilities to end-to-end workflows, from data ingestion to sharing results.

If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals.

This course is ideal for business users, analysts, and team members responsible for analyzing and reporting on data. It's best suited for those with minimal technical backgrounds who need to utilize Snowflake for decision-making and collaboration in data-driven environments.

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We'll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience skill level, interests and participation.

Day 1: Snowflake Fundamentals and Querying

1. Introduction to Snowflake

• What is Snowflake? Key features and benefits.
• Overview of Snowflake's architecture and use cases.
• Exploring Snowflake's relevance for business users.

2. Getting Started with Snowflake

• Setting up and accessing Snowflake.
• Navigating Snowsight and understanding its interface.
• Exploring sample datasets for analysis.
• Hands-On Lab
• Connecting to Snowflake and exploring the platform.
• Loading and navigating sample datasets.

3. Basic Querying in Snowflake

• Writing SQL queries: SELECT, WHERE, GROUP BY, ORDER BY.
• Using basic SQL functions like COUNT, SUM, and AVG.

4. Advanced Querying Techniques

• Introduction to window functions and efficient queries.
• Combining datasets using JOINs.
• Hands-On Lab
• Writing and running SQL queries on sample datasets.
• Using SQL functions to summarize and analyze data.
• Joining multiple datasets for comprehensive insights.

Day 2: Data Visualization, BI Integration, and Workflow

5. Data Visualization Basics

• Exporting data for visualization.
• Connecting Snowflake to BI tools like Tableau and Power BI.
• Building dashboards and reports for business insights.

6. Data Preparation and Enrichment

• Cleansing and transforming data for analysis.
• Creating calculated fields and aggregations.
• Applying SQL for advanced data preparation.
• Hands-On Lab
• Connecting Snowflake to a BI tool.
• Building visualizations and dashboards.
• Preparing datasets for enhanced reporting.

7. End-to-End Data Workflow

• Working with a business scenario: loading, analyzing, and visualizing data.
• Creating dashboards to present findings.
• Exporting and sharing results with stakeholders.

8. Sharing and Collaboration

• Collaborating using Snowflake's sharing features.
• Best practices for collaborative workflows in Snowflake.
• Hands-On Lab
• Completing an end-to-end workflow.
• Sharing dashboards and reports with stakeholders.
• Practicing collaborative features in Snowflake.