Data Engineering

Data Analytics

Select a location

Your Location: Remove as default

Close

Choose your location

This course is currently offered in select locations. Candidates must live within commutable distance of the Per Scholas location to be eligible.

This 14-week course prepares learners with a diverse skill set across key domains in the field of Data Analytics. Through an array of interactive labs, captivating lectures, and collaborative projects, individuals will gain practical experience in data analysis, mastering tools such as SQL, Excel, and Power BI while learning how to structure and solve complex real-world problems with data. Recommended starting point for learners with no previous tech work experience or coursework.

  • Hybrid

No catch. Training and job connections at no cost to you.

Offered in collaboration with:

Course level

Suitable for all levels ?

While these courses may include either intermediate or advanced material, technical knowledge specified in these listings will be required as a prerequisite for applicants to be considered for admission.

While anyone may apply for this course, some technical background may be helpful.

Applicants with all levels of experience in tech are encouraged to apply.

The Salesforce Administrator Certification equips you with the knowledge you need to succeed as a Salesforce Administrator.

Most CISCO Network Essentials certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

Most CISCO IT Essentials certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

Gain the knowledge and skills necessary to effectively demonstrate an overall understanding of the AWS Cloud and start a career in cloud computing.

CompTIA Cybersecurity Analyst (CySA+) is an IT workforce certification that applies behavioral analytics to networks and devices to prevent, detect and combat cybersecurity threats through continuous security monitoring.

The Google IT Support Professional Certificate introduces learners to troubleshooting, customer service, networking, operating systems, system administration and security. No prior experience is required.

CompTIA Network+ helps develop a career in IT infrastructure covering troubleshooting, configuring, and managing networks.

Most CompTIA A+ certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

In-person learning takes place at one of our facilities across the US.

Remote learners must live within commutable distance of a Per Scholas campus to best facilitate our professional development and post-training employment support. For individuals who live outside of a commutable distance, you may be eligible for our National training courses.

Hybrid courses allow flexibility for learners to participate in the course remotely or in-person based on several factors. Learn more about the course you're interested in by reaching out to your admissions lead or attending an admissions overview after applying.

?

Have questions?

We can help with course selection, and answer questions about eligibility requirements and special circumstances. Contact an admissions team member

Advance Your Skills to the Next Level

Gain the specific technical skills necessary for Data Analytics openings in your community through live instructor-led training.


Free Technical Training in Only 14 Weeks

Learn 2 years of Data Analytics topics such as data analysis, tools such as SQL, Excel, and Power BI in a fraction of the time.


Professional Development & Growth Opportunities

Before connecting you with employer partners for job opportunities post-training, our Career Coaches prepare you with the tools to secure a role in the tech sector.


Prepare for Real World Data Analytics Scenarios

Apply data analysis skills to real-world scenarios using Power BI to generate actionable insights and support decision-making.

What jobs can I get as a Data Analytics graduate?

As a Data Analytics graduate, you will enhance your fundamentals in data analytics, equipped with the knowledge to fulfill a wide range of technology jobs such as: 

  • Data Analysts
  • Database Administrators
  • Business Intelligence Analysts
  • ETL Developers
  • Data Visualization Specialists

*Remote entry-level roles are difficult to obtain. Regardless of your learning environment, if you do not have more than two years of tech professional experience, be prepared to seek on-premise roles.

*Please note for graduates with less than two years of existing tech professional experience, while you’ll be on the path to your mid-level position, your first role after the training will generally be an entry-level tech support role in order to get the experience needed to advance into beyond entry-level positions.

Career Support


JOB ATTAINMENT PREP

We match Data Analytics graduates to jobs at employer partners with a local career coach dedicated to your success during and after the training.

Per Scholas Graduate, Andre Yates, who is now a software developer
As I was applying and going through interviews, there was a gap between where my college education brought me and where companies expected me to know things about the technology industry. Per Scholas taught me so much that I wasn’t able to learn in school.

Meet Andre Yates


Job Search Prep

Construct a tech professional resume and practice your interviewing skills during mandatory weekly Professional Development sessions.

portrait of Jordan
I used to doubt myself and my abilities. I kept my focus on my training and the image of the person I wanted to become, and I overcame it. Today, I am a full-stack developer and I encourage anyone trying to break into tech to consider Per Scholas

Meet Jordan Wofford


JUMP START YOUR TECH CAREER AS AN DATA ANALYST WHEREVER YOU ARE IN YOUR CAREER

Per Scholas will train you if you are new to tech or looking to advance your existing skills. As an alumni, you also gain access to no-cost continuous upskilling to support your career growth once you're employed.

I worked 12 hours straight nearly every day, weekends included, and missed out on the lives of my friends and family. Per Scholas helped me to discover both a career path and how to have a work-life balance so that I could spend time with my loved ones.

Meet Matt Yamarino

What You'll Learn From Data Analytics Courses


Master critical Data Analytics skillsets

Dive into the different types of Data Analysis, explore the Data Analysis process, master Data Analysis tools and techniques.


Hands-On Understanding of Data Analytics with SQL

Proficiency in SQL will enable graduates to process efficiently and wrangle data, while insights into big data processing will prepare them for contemporary data challenges.


Process Large Scale Data for Analytics and Machine Learning

Identify big data strategies that can support new insights and predictable outcomes for businesses and industries alike.

Curriculum

Hands-on training along with career development and guest speakers

Learner Onboarding

Asynchronous  

  • Introduction to the Program
  • Succeeding with the Program
  • Digital Citizenship

Synchronous 

  • Program and Technology Onboarding
  • Canvas Training
  • Microsoft Office 365
Project Management Methodologies
  • Introduction to Agile SDLC
  • Definition and overview of Agile SDLC
  • Principles of Agile SDLC
  • Agile Manifesto and its values
  • Overview of Lifecycle Phases (Planning, Iterative development, Requirements Management, Design and Development, Testing, Continuous Improvement)
  • Case studies will be used throughout all other modules to reinforce the concepts above
Relational Databases and SQL
  • Overview of RDBMS and MySQL
  • Introduction to SQL, The SQL Language
  • Normalization of Data
  • SQL Data Integrity, SQL Joins, Clauses, and Operators
  • Aggregate Functions, Subqueries
  • Working with Subprograms
  • Control Flow Functions and Expressions
Advanced RDBMS and SQL
  • Creating indexes for increased query performance
  • Database constraints: key, referential integrity, and “check” constraints
  • Work with Database triggers
  • Creating Database Views
  • Authorization in relational databases
Python Programming and Database Integration
  • Python Programming Basics Review
  • Overview of Built-In Functions
  • Working Python Modules
  • Python and Data structures 
  • Processing JSON Data using Python for data pipeline
  • Processing Relational Databases using Python for Data Pipeline
  • Writing Python programs to interact with the database and perform basic database operations.
  • Data wrangling using Python for Data Pipeline
Introduction to Data Warehousing and ETL
  • Data Warehousing and Data Mart
  • Introduction to Big Data and ETL
  • Data Warehouse Overview
  • Data Mart Styles
Overview to Spark and Spark SQL
  • Fundamentals of Apache Spark, Role of Driver in Spark Architecture
  • Set up a full environment for developing Spark applications, Spark Shell and PySpark
  • Fundamentals of RDD, Loading data into RDD, Transformations, and Actions
  • Fundamentals of DataFrame and Spark SQL
  • Spark SQL performance optimization, Libraries of Spark SQL
  • Manipulating the Data with Spark SQL, Loading data into DataFrame, and Basic operation with PySpark
Introduction to Data Analysis
  • Introduction to Statistics and Measure of Variability
  • Introduction to data analysis and visualization
  • Conceptualizing Data Analysis as a Process
  • Types of Data Analysis
  • Data Analysis Process
  • Data Analysis Tools and Techniques
Power BI
  • Introduction  to Power BI Desktop
  • Connecting and Shaping Data
  • Relationships and Data Models
  • Data Analysis using Power BI
  • Data Analysis Expressions (DAX)
  • Data Visualization using Power BI
Capstone
  • Investigate a Challenging Problem in an authentic context
  • Develop Ideas or solutions through sustained Inquiry with problem-solving approaches
  • Evaluate instructor and peer review and use feedback to revise and improve work
  • Present the Product showcasing the key learnings and accomplishments
Professional Development and Graduation
  • Elevator Pitch
  • Resume Development 
  • LinkedIn Profile 
  • Habits of Success
  • Emotional Intelligence 
  • Communications 
  • IT and Interpersonal Skills

Curriculum

Hands-on training along with career development and guest speakers

View

Sample Schedule

  • Morning Lecture
  • Break for lunch
  • Hands on training and lab assignments
  • Wrap up for the afternoon and prepare for tomorrow

Participate in Hands-on Labs

To provide an innovative, hands-on learning experience, ActivateWork provides learners with a tech kit based on their training track and delivery model, whether in person or remote. These kits are designed to enhance the learning experience and will be utilized in labs throughout the course.



Learn to Think Like An IT Professional

Prepare to handle real workplace demands by challenging your understanding of course material and scenario problem solving.


Career Training with Employer Partners

Construct a tech professional resume and practice your interviewing skills with employees from some of our employer partners.


Meet Your Instructors

Learn from certified teachers with years of real-world training experience. Our instructors don't just teach you what you need to know, but how to learn it.

Per Scholas Java Developer Graduate Mira Winkel

Meet Our Graduates

It's huge knowing that I don't just have a beginner skill set. I have a very focused skill set that is highly in demand. Per Scholas gave me the base of my knowledge to go out and be successful.

Meet Mira Winkel

How to Be Considered

Meet the Learner Profile Requirements

You may qualify to become a Per Scholas Data Analytics Learner if you:

  • Live within eligible distance of the Per Scholas Site
  • Have basic digital literacy
  • Meet the pre-training income policy guidelines
  • Can attend classes full-time for the entire duration of the course
  • Are aged 18 or older
  • Have a High School diploma, equivalent, or higher
  • Must be able to provide proof of valid U.S. work authorization
  • Can read, write, and speak in English
  • Are able to start a full-time job after course completion
  • Ready to make an important commitment to building your future
  • Do not plan to travel outside the U.S. during the duration of the course (learners cannot participate in program activities or access materials during such travel)

Per Scholas is committed to equal opportunity in admission and employment. It is the policy of Per Scholas to provide equal opportunity for all qualified applicants, learners, and employees and to prohibit discrimination based on race, color, gender, religion, national origin, age, sexual preference, disability, or marital status. Admissions decisions will not be made based on race, color, gender, religion, national origin, age, sexual preference, disability, or marital status.

Complete the Multi-Step Admissions Process

1. Submit an Eligibility Form

2. Admissions Overview: Once you submit an Eligibility Form, you’ll be directed to our Admissions Overview registration page. During this virtual webinar, you’ll learn more about our admissions process and next steps.

3. Assessments: Each training requires either an academic assessment, tech assessment, or both. Information will be provided in detail in the Admissions Overview.

4. Interview: Individuals who meet the assessment score requirements will be invited to attend a behavioral interview.

5. Offer Letter and Onboarding: The Admissions team will review assessment scores, completed Pre-Work, and interview results and offer seats to eligible candidates. Learners are required to submit Enrollment Documentation as part of Onboarding.

Please note, this application process is very competitive and not all applicants will be accepted for our limited slots.

Submit Enrollment Documentation, Including Pre-Work Information

Get a head start on your course at Per Scholas!

Required Data Analytics Pre-Work

To begin with the pre-work, learners should follow the instructions on NetAcad Pre-Work Course Enrollment and Badge Acquisition

Courses:

Submission Portal:

Help Resources:

Frequently Asked Questions

What kinds of jobs can I get after completing this training?

This course opens doors to careers in Data Analytics. Some possible jobs may include: Data Analysts, Database Administrators, Business Intelligence Analysts, ETL Developers, and Data Visualization Specialists.

How can the course be free? Are there hidden fees?

Most people who learn about us think: “Too good to be true.” We know it seems that way, but it’s true. Our services are provided at no cost to you, using funds we raise from foundations, corporations, government and generous individuals.

The costs you can prepare for include transportation or childcare—expenses that take care of you so you can focus on your studies.

What if I don’t have a Laptop? What are the computer requirements?

Computer requirements are determined by each specific curriculum track. During the onboarding process, we will review each learner’s needs on a case-by-case basis. If you have any concerns about your situation, please elevate to the admissions team during the admissions process.

Is there a learner pre-training income policy?

Yes, Per Scholas learners must meet the pre-training income policy requirements. View our Learner Pre-Training Income Policy here.

I receive unemployment insurance benefits or other benefits that require me to spend time working or looking for work. Can I still enroll?

Yes. Generally, Per Scholas courses are approved for people receiving unemployment insurance, as well as other benefits that would ordinarily require them to spend time working or looking for work. Your benefits should not be affected. If you have questions or concerns about your situation, please contact us.

I meet other requirements, but I am not a U.S. citizen and haven’t received my work authorization yet. Can I still apply?

Due to the nature of government contracts, learners must be eligible for employment based on Federal Contract employment eligibility.

I have a disability. Can you accommodate me?

We comply fully with the Americans with Disabilities Act and other relevant laws and regulations. Please contact [email protected] to discuss your specific situation and needs.

Does Per Scholas have a Non-Discrimination policy?

We’re proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or national origin. See our full EEO statement here.

Questions? Contact Us!

Have an admissions question? Ask an admissions team member

Phone: 718-991-8400

Close

Choose a location for
Your Course

This course is only offered at select Per Scholas locations. Choose a location to get the most accurate course information.