Skillspire – Coding School

Intro to Data Analytics

Ready to start your career in Data Analytics?

learn data analytics bootcamp

Data is considered as new gold, and data scientists are the new gold miners. Learn the skills you need for this hottest job of our time. This 12-week hands-on course will take you an an end-to-end journey in data science career.

Ready to reinvent yourself and become a data scientist? Please fill out an application so that we can learn more about you and determine if this course is the best fit for you and your goals. As soon as we receive your application, we’ll be in contact. Get started.

In our Bellevue Data Science course you will learn an overview of the various data jobs and where data science stands, some statistics, some machine learning, how to acquire data from various sources, how to visualize data in meaningful way, how to do exploratory analysis to get an understand of the data and its quality, how to perform classification of data, how to predict/forecast what might happen in future, how to optimize decision making and how to tell an impactful data story. You will also get tips on advancing your career in the data science field.

This 6-week bootcamp will cover the following: 

  • Common Excel functions
  • Conditional aggregation, pivot charts, slicers
  • Importing data, creating data models, creating relationships in Excel
  • Basic, intermediate and advanced SQL
  • Data visualization, transformation, and relationship building in PowerBI
  • Publishing reports, creating real-time visuals and dashboards in PowerBI

Market research on the field:

Jobs for data scientist:

https://www.glassdoor.com/Salaries/data-scientist-salary-SRCH_KO0,14.htm

AreaDescriptionTopics
IntroductionOverviewIntroduction to Analytics
Introduction to Excel
ExcelIntro to ExcelCommon functions
Conditional aggregation
Pivot tables & charts
Slicers & time slicers
ExcelData in ExcelConditional formatting
Importing Data
Adding to data models
Creating Relationships
Pivot using multiple related tables
ExcelAnalysis in ExcelPowerQuery
PowerPivot
DAX
Measures
KPIs
What-if analysis
Data Analysis tool package
SQLBasicSELECT, LIMIT/TOP, WHERE
Comparison Operations
Logical Operators
LIKE, IN, BETWEEN, IS NULL, AND, OR, NOT, ORDER BY
SQLIntermediateCOUNT, SUM, MIN/MAX, AVG, GROUP BY, HAVING, DISTINCT, CASE, Joins, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
SQLAdvancedJoins on Multiple Keys, Self Joins, UNION, Windowing functions, CTE, Subqueries, temp tables, string and date functions, IIF ISNULL, COALESCE, INSERT, UPDATE, DELETE
SQLAdvancedView, Stored Procedure, Jobs, Importing and Exporting data, cross database queries, tips & tricks, review complex topics
PowerBIBasicData visualization best practices
High level overview & components
Importing data & creating visuals
PowerBIIntermediateData Transformation
Creating Relationships
Intermediate Visuals
PowerBIAdvancedPublishing reports
Creating dashboard
Real-time visuals
Custom visuals
Security and Sharing
Usage
Review & Wrap upNext stepsReview
Career Discussion
Wrap up

Let’s Get Started!

1 Start Application
2 Select Program
3 Your Background
4 Tell us about Yourself

Arif Samad

Start DateDeadline to EnrollTuitionEnrollment StatusCampus
Oct. 24th, 2020Oct. 17th, 2020$1999Open


Tuesdays & Thursdays 6pm – 9pm

Bellevue Campus

2265 116th Ave NE

Bellevue, WA 98004

Do I need programming experience for this course?

While knowledge of programming is helpful, it is not mandatory for this course. We will cover R/Python as part of the course. As long as you bring lot of passion to learn, can follow basic algebraic concepts, have some literacy in computer tools like Excel and work hard, you should be fine.

Do I need statistics knowledge for this course?

We will teach you any statistics concepts needed as part of the course.

Who should take this course?

The course is designed for diverse backgrounds; however, our Intro to Data Analytics course is highly recommended if you don’t have knowledge or experience with the basics of ​Excel, SQL, and Power BI used in data analytics. If this is a field you really want to learn, you can sign-up for the course whether you are software engineer, product/program manager, analyst, researcher, consultant, statistician, student etc. We will adjust the approach based on the attendees.

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

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

What types of problems we will be solving as part of the course?

The business problems for demo, labs and homework will be taken from a wide variety of industries representing practical problems.

Would I become a data scientist after finishing the course? How can I transition to ‘Data Science’ career?

We cannot promise that you will become a data scientist with a 36 hours course. It depends on how well you are able to analyze and use the data you have in front of you. This course is jam packed with topics starting from basic to advanced data science topics and follows the Gartner Maturity Model for Analytics. We will show you some potential paths to a career in Data Analytics or Data Science based on your personal abilities and accomplishments.

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.

More FAQ available here.