intro to data analytics
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
Field of Data Analytics:
- #1 in the List of Best Jobs in America
- #1 in the List of 25 Jobs with Work-Life Balance
- The 10 Hardest Jobs to Fill Right Now
- Harvard Business Review calls it sexiest job of 21st century
- 190,000 predicted shortage in Data Scientists by 2018
Jobs for Data Scientists:
https://www.glassdoor.com/Salaries/data-scientist-salary-SRCH_KO0,14.htm
| Area | Description | Topics |
| Introduction | Overview | Introduction to Analytics Introduction to Excel |
| Excel | Intro to Excel | Common functions Conditional aggregation Pivot tables & charts Slicers & time slicers |
| Excel | Data in Excel | Conditional formatting Importing Data Adding to data models Creating Relationships Pivot using multiple related tables |
| Excel | Analysis in Excel | PowerQuery PowerPivot DAX Measures KPIs What-if analysis Data Analysis tool package |
| SQL | Basic | SELECT, LIMIT/TOP, WHERE Comparison Operations Logical Operators LIKE, IN, BETWEEN, IS NULL, AND, OR, NOT, ORDER BY |
| SQL | Intermediate | COUNT, SUM, MIN/MAX, AVG, GROUP BY, HAVING, DISTINCT, CASE, Joins, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN |
| SQL | Advanced | Joins on Multiple Keys, Self Joins, UNION, Windowing functions, CTE, Subqueries, temp tables, string and date functions, IIF ISNULL, COALESCE, INSERT, UPDATE, DELETE |
| SQL | Advanced | View, Stored Procedure, Jobs, Importing and Exporting data, cross database queries, tips & tricks, review complex topics |
| PowerBI | Basic | Data visualization best practices High level overview & components Importing data & creating visuals |
| PowerBI | Intermediate | Data Transformation Creating Relationships Intermediate Visuals |
| PowerBI | Advanced | Publishing reports Creating dashboard Real-time visuals Custom visuals Security and Sharing Usage |
| Review & Wrap up | Next steps | Review Career Discussion Wrap up |
| Start Date | End Date | Tuition | Enrollment Status | Campus |
|---|---|---|---|---|
| Jun. 4th, 2020 | – | $2,999 | Closed | Bellevue, WA |
| October 6th, 2020 | – | $2,999 | Open | Online |
| UPCOMING 2021 COURSES | ||||
| Jan. 12th, 2021 | Mar. 30th, 2021 | $2,999 | Open | Online |
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.
