.png){kind=logo}
Data Analytics
Master Excel, SQL, and Tableau to jumpstart your data career with 100% remote cohorts available across the U.S. Veterans & VA Benefit Users: To comply with VA regulations, instruction must be completed in-person at our main campus in SeaTac, WA.
What you’ll learn
Course Objectives
Course Prerequisites
What does this course look like?
Who is it for?
This foundational program is designed for:
- U.S. Career Changers: Individuals nationwide looking to pivot into data-driven roles with the flexibility of remote, instructor-led sessions.
- Veterans & Military Spouses: Service members in Washington State seeking a transition into the tech economy via VA-approved, hands-on training at our SeaTac campus.
- Business Professionals: Managers and analysts who want to enhance their decision-making skills through modern data visualization and query tools.
Course-Specific FAQ
Q: Can I take the Intro to Data Analytics course if I live outside of Washington?
A: Yes! Our Data Analytics course is available 100% remote for students across the United States. You will learn to manipulate data and build dashboards in a live, interactive environment from any state.
Q: I am a Veteran; can I take this course online using my GI Bill®?
A: No. To ensure VA compliance and provide the necessary hands-on lab support for technical tools like SQL, all VA-funded programs must be taken in-person at our SeaTac, Washington campus.
Q: Do I need prior coding experience for this course?
A: No. This is a beginner-friendly course. We start with the fundamentals of Excel and SQL, making it the perfect entry point for those with no previous technical background.
How much does this course cost?
Course Syllabus
- 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
- 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
- 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
- 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
- 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!
Cohort Schedule
Cohort Time Schedule
How much does this course cost?
We believe cost shouldn’t hold you back. Ask us about our budget-friendly plans.
Contact us to learn more:📞 425-868-8200 📧 info@skillspire.net
• One-Time / Upfront
• Save $500 instantly
• No monthly hassle — one simple payment
• Best value for your tech career investment
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.
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.
No, a basic level of computer literacy and a motivation to learn is all you need for most of our courses.
Our courses are designed for diverse backgrounds; If programming or tech is a career track that you really want to pursue, you may sign-up for our courses whether you are software engineer, product/program manager, analyst, researcher, consultant, student, etc.
It can vary depending on your unique background. However, it usually takes 18 hours/week outside of the classroom for homework and study time.
Yes, you will be given a certificate of completion for any course, after you pass the final exam.
.png)
