Learn

Intro to Data Analytics and Data Science

"Intro to Data Analytics and Data Science" is a comprehensive 16-week, part-time program designed to equip you with the knowledge and skills necessary to become a proficient junior data analyst. Throughout the course, you'll gain expertise in data analytics tools such as  Excel, Power BI, SQL, Python, and ChatGPT AI for data analysis, ensuring data quality, and crafting engaging data visualizations. Moreover, the course has a dedicated section for statistics in order to deepen your understanding about utilizing data for decision making. The curriculum also emphasizes professional development and job readiness, incorporating resume development and effective interview strategies. Upon completing the course, you'll possess a strong understanding of the data analytics process, along with the ability to address real-world data challenges using ChatGPT AI.
I'm InterestedCall Now: 206-944-3969
Your Instructor
Guzal Noori
Guzal got her Bachelor's Degree in Computer Science in Central Washington University. She is an experienced Data Analyst and Big Data Engineer, generating data by writing T-SQL and PROC-SQL queries in Microsoft SQL Server and SAS platform. She has been in the I.T. industry for 9 years. and also has experience as a Software Developer
Course Overview

"Intro to Data Analytics and Data Science" is a comprehensive 16-week, part-time program designed to equip you with the knowledge and skills necessary to become a proficient junior data analyst. Throughout the course, you'll gain expertise in data analytics tools such as  Excel, Power BI, SQL, Python, and ChatGPT AI for data analysis, ensuring data quality, and crafting engaging data visualizations. Moreover, the course has a dedicated section for statistics in order to deepen your understanding about utilizing data for decision making. The curriculum also emphasizes professional development and job readiness, incorporating resume development and effective interview strategies. Upon completing the course, you'll possess a strong understanding of the data analytics process, along with the ability to address real-world data challenges using ChatGPT AI.

What you’ll learn

The "Intro to Data Analytics" course equips learners with data analysis expertise using prominent tools such as Excel, Power BI, SQL, Python, Statistics, and ChatGPT AI. The curriculum encompasses data visualization, professional development strategies, SQL and Python programming for data analysis, utilizing ChatGPT AI for enhancing analytics, and practical guidance on crafting compelling resumes and succeeding in job interviews. Upon completion, participants will be prepared to tackle real-world data challenges, either by pursuing a data analytics career or by enhancing their current roles with data skills.

Course Objectives

Course Prerequisites

What does this course look like?

This course comprises 2-3 hour classroom sessions, hands-on practice with Excel, Power BI, SQL, Python, Statistics, and ChatGPT AI, interactive quizzes and exercises to reinforce learning, and a final project that demonstrates mastery of the skills acquired. The objective is to provide a thorough understanding of data analytics and its application in real-world problem-solving, including leveraging ChatGPT AI, whether you're embarking on a career in the field or enhancing your current role with data skills.

Who is it for?

The "Intro to Data Analytics" course is tailored for a diverse audience, including beginners, professionals, career changers, and those with an interest in data analysis. The course offers an extensive introduction to data analysis and the tools employed by industry professionals, such as ChatGPT AI, enabling them to:

  • Enhance their current roles with valuable data analysis skills and increase their marketability.
  • Gain the necessary foundation for a successful career transition to the field of data analytics.
  • Access the course regardless of skill level and background.
  • Achieve their goals by actively applying the lessons learned, including the use of ChatGPT AI.
  • Obtain an edge over the competition by having a deeper understanding of statistical analysis.

Course Syllabus

Course Program Stages
Duration:
Total Hours:
Week
Stage
1
-
Intro to Analytics and Excel
  • Focus on Excel as a crucial tool for data analysis
  • Learn the importance and practical uses of Excel
  • Explore workbook creation
  • Understand common Excel functions
  • Study conditional aggregation
  • Discover pivot tables and charts
  • Examine slicers and time slicers
  • Build a strong foundation for the remainder of the course
Week
Stage
2
-
Learn Microsoft Excel
  • Learn to apply conditional formatting in Excel
  • Discover how to import data effectively
  • Understand the process of adding to data models
  • Master pivoting using multiple tables
  • Gain expertise in Excel's PowerQuery and PowerPivot
  • Dive into Data Analysis Expressions (DAX)
  • Explore creating measures and KPIs
  • Perform what-if analysis in Excel
  • Get acquainted with the data analysis tool package
  • Participate in cohort quizzes, assignments, and exercises to reinforce learning
Week
Stage
3
-
SQL for Data Analysis (Part 1)
  • Understand the anatomy of an SQL query
  • Learn about Common Table Expressions in SQL
  • Explore generating data and creating a Date Dimension
  • Dive into random data generation and sampling techniques
  • Grasp train/test split implementation with SQL
  • Test your knowledge with a Basic SQL for Data Analysis quiz
  • Delve into describing a series in descriptive statistics
  • Discover how to describe a categorical series
  • Assess your understanding with a Descriptive Statistics quiz
Week
Stage
4
-
SQL for Data Analysis (Part 2)
  • Master the concept of grouping in SQL
  • Learn about conditional aggregates and subtotals
  • Evaluate your understanding with a Grouping and Subtotals quiz
  • Discover aggregate expressions in SQL
  • Understand window frames and their application
  • Explore accessing next and previous rows in SQL
  • Dive into SQL ranking functions
  • Test your knowledge with a Running and Cumulative Aggregation quiz
Week
Stage
5
-
SQL for Data Analysis (Part 3)
  • Learn to compare missing values in Interpolation
  • Explore back filling and forward filling techniques
  • Understand linear interpolation
  • Test your knowledge with an Interpolation quiz
  • Discover the concept of binning in data analysis
  • Learn about equal-height binning
  • Dive into equal-width binning
  • Assess your understanding with a Binning quiz

View the full program syllabus, click for access!

Start Date
June 26, 2024
End Date
October 16, 2024
Enrollment Status
Open
Location
Remote/Classroom*
Start Date
November 8, 2023
End Date
February 10, 2024
Enrollment Status
Closed
Location
Online
Start Date
May 8, 2023
End Date
August 7, 2023
Enrollment Status
Closed
Location
Online
Start Date
February 4, 2023
End Date
April 26, 2023
Enrollment Status
Closed
Location
Online
Start Date
November 16, 2022
End Date
February 15, 2023
Enrollment Status
Closed
Location
Remote/Classroom*
Start Date
September 12, 2022
End Date
December 5, 2022
Enrollment Status
Closed
Location
Remote/Classroom*

Cohort Schedule

Start Date
End Date
Enrollment Status
Location
June 26, 2024
October 16, 2024
Open
Remote/Classroom*
Start Date
June 26, 2024
End Date
October 16, 2024
Enrollment Status
Open
Location
Remote/Classroom*
Start Date
November 8, 2023
End Date
February 10, 2024
Enrollment Status
Closed
Location
Online
Start Date
May 8, 2023
End Date
August 7, 2023
Enrollment Status
Closed
Location
Online
Start Date
February 4, 2023
End Date
April 26, 2023
Enrollment Status
Closed
Location
Online
Start Date
November 16, 2022
End Date
February 15, 2023
Enrollment Status
Closed
Location
Remote/Classroom*
Start Date
September 12, 2022
End Date
December 5, 2022
Enrollment Status
Closed
Location
Remote/Classroom*

Cohort Time Schedule

Mon
05:00 PM - 08:00 PM PST (Lecture/Lab)
Tue
05:00 PM - 08:00 PM PST (Lecture/Lab)
Wed
05:00 PM - 08:00 PM PST (Lecture/Lab)
Thu
05:00 PM - 08:00 PM PST (Lecture/Lab)
Fri
Sat
09:00 AM - 03:00 PM PST (Lecture/Lab)
Sun

Cohort Schedule

Course
Start Date
End Date
Enrollment Status
June 26, 2024
October 16, 2024
Open
Start Date
June 26, 2024
End Date
October 16, 2024
Enrollment Status
Open
Location
Remote/Classroom*
Start Date
November 8, 2023
End Date
February 10, 2024
Enrollment Status
Closed
Location
Online
Start Date
May 8, 2023
End Date
August 7, 2023
Enrollment Status
Closed
Location
Online
Start Date
February 4, 2023
End Date
April 26, 2023
Enrollment Status
Closed
Location
Online
Start Date
November 16, 2022
End Date
February 15, 2023
Enrollment Status
Closed
Location
Remote/Classroom*
Start Date
September 12, 2022
End Date
December 5, 2022
Enrollment Status
Closed
Location
Remote/Classroom*

Not sure about

Intro to Data Analytics and Data Science

Here’s what our instructor has to say

We now have Classroom* and Remote courses in WA state.
*Veterans can only attend Classroom/In-person Classes
Scholarship
We offer scholarships based on eligibility upon receiving an application. Apply For Consideration

Want to learn full stack web development but don’t know where to start? Consider signing up to learn full stack with Python.

Python is easy to learn and great for back-end coding. The popularity of Python as a programming language is on the upsurge, thanks to its readability and ability to do more with less coding. If you are looking for a course that offers Python web development for beginners, look no further. Our online course allows you to learn full stack web development with Python at your own pace from the comfort of your home.

Vetrans
computer
As part of our full stack development course, you’ll also learn JavaScript and a suite of frameworks and tools that work with Java.

Our Java full stack developer course is designed to kickstart your programming career as a Java full stack developer. We regularly update our Java full stack developer course to make sure it is relevant and useful for our students. If you want to join our full stack JavaScript course, but aren’t sure if you have time to attend the classes, don’t worry. We schedule our classes on weekends and weekday evenings. Even if you work full-time, you can still attend our classes.

The opportunity is yours. We help you take it.
1
Submit your application and receive emails
2
Take skillspire coding skills assessment
3
Receive offers to join for the portfolio project
Start your application today
Apply
The opportunity is yours. We help you take it.
1
Submit Your Application
2
We’ll go over different class and payment options
3
You’ll start learning skills for a new career
Start your application today
Apply
Frequently asked questions
Do I need programming experience for your courses?

No, a basic level of computer literacy and a motivation to learn is all you need for most of our courses.

Who should take your courses?

The course is designed for diverse backgrounds; If programming or tech is a career track you really want to pursue, you can sign-up for our courses whether you are software engineer, product/program manager, analyst, researcher, consultant, student etc.

How much time do I need to spend studying outside of the classroom?

It can vary depending on your unique background. However, it usually takes 1-15 hours/week outside of the classroom for homework and study time.

Will I be given a certificate after the completion of the course?

Yes, you will be given a certificate of completion for this course after you pass your final exam.

Do you accept GI Bill®?

Yes, please refer to our Veterans page for more details.

Still Have Questions? Let's talk!

Book a call below and we can answer your questions and gide you through your opportunities.