Data Analyst Training NYC

All Locations NYC Los Angeles Chicago Online Boston Nashville Houston Washington, D.C. San Diego San Francisco Seattle Atlanta Denver San Jose Charlotte New Jersey Brooklyn

Online Intermediate MS Excel 2010

The New York Public Library (Tech) @ 188 Madison Ave, New York, NY

Explore more advanced features of Microsoft Excel 2010. Topics include using formulas and functions, data sorting and conditional formatting. Skill prerequisites: Beginner Excel Must register with a valid email address. The instructor will send out an email two (2) hours before the class starts.  These are registration based classes and spots may fill up quickly. If for any reason we're unable to accommodate your registration, we will...

Excel Genius 5: Pivot Tables

The New York Public Library (Tech) @ 188 Madison Ave, New York, NY

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data.  We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements.  While we recommend that students take the classes in order, there are no attendance requirements, and students are welcome to repeat or skip classes as they choose. Class 1: Logic Functions Class 2: Conditional Stat...

FileMaker Pro

NYIM Training @ 185 Madison Ave, New York, NY

Implementing a Data Warehouse with Microsoft SQL

Corporate Training Group @ 330 West 38th St, New York, NY

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers...

Getting Started with Pivot Tables

Newmark Graduate School of Journalism @ 219 W 40th St, New York, NY

Pivot Tables are a powerful, no-code-necessary, tool used by all data journalists to analyze data in a spreadsheet. If you want to group data by a column (e.g. by zip code or by company), or multiple columns (e.g. by race AND gender), pivot tables will come in handy. In this workshop, we will cover: When and when not to use a pivot table How to set up pivot tables in Microsoft Excel and Google Sheets Summing, counting, averaging, and getting...

Machine Learning: Intermediate Level

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

Duration Hours: 8 + 1 HOURS ONSITE TRAINING (5 Sessions: 2Hrs + 2Hrs + 2Hrs + 2Hrs + 1Hrs) Subscription: 1 Month Online Support Machine Learning has become an integral part of many commercial applications and research projects. This course will teach you practical ways to build your own machine learning solutions. Machine learning is a form of data analysis that gives computers the ability to learn and process information with little human intervention....

SQL Data Analytics: Intermediate Level

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

DURATION: 8 + 1 HOURS ONSITE TRAINING  (5 Sessions: 2 Hrs + 2Hrs + 2Hrs + 2Hrs + 1Hrs) Method: 1 on 1 Schedule is tentative; finalized after enrollment according to student/instructor availability. TOPICS COVERED Introduction to need for SQL and Design Aspects Why do we need SQL? What is wrong with excel? Different distribution packages available from Oracle, microsoft, ibm For example: if we create the information of people attending the...

Introduction to Data Visualization

General Assembly @ 902 Broadway, New York, NY

The Data Visualization workshop provides an overview of how data visualization can be used to improve business insights and decision-making around large sets of data. It also covers the various types of visualizations that can be used to most effectively tell your business story. In the digital age, the ability to explore the visual representation of massive data and detect meaningful patterns and trends is becoming increasingly critical for businesses....

SQL Querying - Level 1 Fundamentals of Querying

New Horizons Computer Learning @ 462 Seventh Ave, New York, NY

In this course, students will compose SQL queries to retrieve desired information from a database. ​Who Should Attend Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Prerequisite(s) or equivalent knowledge Access 2003 - Level 1 Relational Database Design A Practical Approach Outline Lesson 1: Executing a Simple Query Connect...

Data in a Day

Decoded @ 10 E 34th St, New York, NY

The digital revolution has led to an explosion of the data available to businesses and individuals. Yet there is a growing divide between those that realise the potential of that data, and those with the technical skills to process, analyse and visualize it. We will help you break down that barrier. In a single day. Content: Morning Introduction to data. What are the data challenges of today, and how are we equipped to deal with them? Tools...

Intro to Machine Learning

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

Duration: 3 Hours + 1 Month Subscription for Online Support (for non-coders or someone who is new to the concept)  Machine Learning has become an integral part of many commercial applications and research projects. This course will teach you practical ways to build your own machine learning solutions. Machine learning is a form of data analysis that gives computers the ability to learn and process information with little human intervention....

Relational Database Design, Tools and Techniques

Learning Tree International @ 1601 Broadway, New York, NY

Relational Database Design Training: Tools and Techniques This Relational Database Design training course delivers the groundwork for building and working with relational databases — including Oracle, SQL Server, and MySQL — and enables you to develop and use relational databases in your environment. You will learn to design your database to model your business requirements, normalize and denormalize data to optimize performance, and automatically...

Introduction to SQL

Learning Tree International @ 1601 Broadway, New York, NY

Master the SQL programming language and optimize data accessibility and maintenance with the Introduction to SQL course at Learning Tree International. Build, query, and manipulate databases using PostgreSQL or Microsoft SQL Server, and gain the skills to identify deviations from the standard in Oracle and Microsoft SQL Server. Choose from flexible learning options and receive ongoing support for your SQL journey.

SAS SQL 1: Essentials (SQ1)

Global Knowledge @ 787 7th Ave, New York, NY

This course teaches you how to process SAS data using Structured Query Language (SQL). What You'll Learn Query and subset data Summarize and present data Combine tables, including complex joins and merges Create and modify table views and indexes Replace multiple DATA and PROC steps with one SQL query Who Needs to Attend SAS programmers and business analysts Prerequisites Have an ability to: Submit SAS programs on your operating system...

Artificial Intelligence: How do we fight back?

Scifn @ One Penn Plaza, New York, NY

Join us for a full day deep dive into artificial intelligence for executives. If you are an executive, entrepreneur, coder or disruptor and want to figure out how to incorporate artificial inteligence into your strategy or learn about what AI is in a very real way then this masterclass is for you. We present very technical material in a way that easy to absorb for non-technical people. In this course we will cover all the major topics in AI including:...

Advanced SQL Course

Learning Tree International @ 1601 Broadway, New York, NY & Virtually Online

Structured Query Language (SQL) is the cornerstone of all relational database operations. In this hands-on Advanced SQL course, you will learn how to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation....

Microsoft Excel - Level II

Holt Computer Training @ 469 7th Avenue, New York, NY

Participants gain hands-on experience in Excel by completing 10 instructed led electronic spreadsheets and workbooks.  Target Audience: This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks. Completion Results: Upon successful completion participants will be able...

Data Analytics Bootcamp

NYC Career Centers

Take a deep dive into the top data analytics tools: Excel, SQL, & Tableau. This 8-day intensive bootcamp covers everything you need to know about summarizing, analyzing, and charting data to obtain actionable insights. After taking this bootcamp, you'll have a versatile skillset and preparation for a data analyst role. Our data analytics bootcamp trains you through real-world projects in Excel, SQL, and Tableau. By the end of this bootcamp,...

Big Data Demystified: Hadoop and NoSQL for Beginners

General Assembly @ 10 E 21st St, New York, NY

You’ve probably heard about “big data,” but chances are you haven’t been told what it means. In this class, you’ll receive a comprehensive overview of the technologies powering big data — including the history of databases and storage, the difference between relational and “document” databases, the challenges of big data and the tools it necessitates, and demystifying “map reduce” and Hadoop. Whether you’re a product manager,...

Data Science Immersive

General Assembly @ Online Class
, New York, NY

This is a 12-week full-time career accelerator course. Learn the tools and techniques you need to make better decisions through data, and land a job in one of the most sought after fields in tech. Learn from Experts: Create predictive models by learning to wrangle, analyze, and visualize data from our team of professional Data Scientist instructors. Gain Hands-On Experience: Develop hard skills like Unix, Git, SQL, Python, machine learning, and...