fbpx

Skillspire – Coding School

Intro to Data Analytics

Ready to start your career in Data Analytics?

Data Anlaytics
In this Intro to Data Analytics course, learn Excel, SQL programming, Power BI to become a junior data analyst, the fastest growing job in the tech world. 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 on 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 Analytics course we will teach you how to use data to make informed decisions. You’ll use industry-standard tools such as Excel and PowerBI to analyze realworld data sets to create dashboards and visualizations to present your findings. 

This 12-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
Start DateDeadline to EnrollTuitionEnrollment StatusCampus
June 4, 2020May 28, 2020$2,499ClosedBellevue
October 6, 2020October 1, 2020$2,499OpenOnline


Tuesdays 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.

Ready to learn more? Your new career could be 16 weeks away

Request Syllabus