Year Up's Data Analytics curriculum provides students with basic skills in programming, databases, software development fundamentals and business intelligence. Students are exposed to problem solving techniques such as algorithms, flow-charts and decision trees; concepts and processes such as version control, Agile development, software development roles and environments, introductory programming, relational database terminology, database design tools; and techniques to create, update and query databases, big data concepts, business intelligence, and data visualization and reporting techniques.

Skills Development at a Glance: What Students Learn

• Understand big data, data mining, data lakes, data warehouses, Extract-Transform-Load (ETL), and NoSQL databases
• Perform simple data preparation tasks such as data cleansing, validation and transformation 
• Utilize techniques for reporting; charts, graphs and heat maps, and basic features of data visualization tools, such as Power BI or Tableau, for practical applications
• Load, clean and organize data in Excel
• Interpret and make business-related inferences about data using Excel data analysis tools (i.e. Sorting, Filtering, Conditional Formatting, Charts, Tables, PivotTable, VLOOKUP)
• Utilize Excel, PowerPoint and data visualization tools (i.e. Tableau or Power BI), to develop and present reports that demonstrate effective storytelling with data 
• Utilize decision trees, flow charts, algorithms and pseudo-code as tools to effectively communicate solutions to business problems
• Utilize version control and team management tools to manage, track, and organize code across a team
• Understand programming concepts and where and how to apply them to build a basic software program
• Utilize an Integrated Development Environment (IDE) such as Eclipse, NetBeans or Visual Studio to write, build, execute and debug code
• Identify and analyze similarities in structure, syntax, and semantics of different coding languages
• Utilize software quality control processes such as peer code reviews, code refactoring and standards, code navigation in a debugger, and using comments for code documentation
• Utilize SQL to build tables, specify constraints, and apply indexes
• Utilize SQL to query tables using filters, calculated fields, sorting, aggregates and joins

Specialty Training Focus Areas:

• Data Management, Analysis, and Reporting
• Business Intelligence Fundamentals
• Programming
• Databases
• Software Development Fundamentals
• Year Up’s Standard Training  

Training at Work: Typical Job Tasks

• Gather business requirements, analyze, and propose data solutions to meet requirements
• Compile, validate, clean, and transform data for analysis
• Analyze, interpret, and summarize data and develop reports and presentations

Path to a Career: Training-Enabled Role Pathways

• Data Preparation
• Data Analysis & Reporting/Business Intelligence
• Database Development

Example Roles Filled by Graduates:

• Data Analyst
• Business Intelligence Analyst
• Business Analyst