Data Classes Buffalo, NY

In this comprehensive data science program, individuals will learn a variety of critical skills to become a data scientist. Students will learn to code with Python, create machine learning models, automate tasks like web scraping, and interact with databases using SQL. Topics include data analysis with Python's Numpy and Pandas packages, data visualization, predictive analytics, machine learning, SQL querying, Python automation, and web scraping. Students will learn hands-on by working in Python and SQL and will complete the program with the skills they need to enter the field of data science. This program offers flexible scheduling and provides a free retake for students to refresh the material.

This course covers the skills needed to become a Data Analyst or Business Analyst, including data analytics fundamentals, visualization with Tableau, using Python to clean and manipulate data, and how to work with relational databases. One-on-one mentoring is included.

In this program, participants will learn the key skills and tools needed to succeed as a data analyst, including Excel, SQL, and Tableau. Attendees will learn how to use Excel to create graphs, summarize data with PivotTables, and analyze data. In SQL, attendees will learn the essentials of relational databases, queries, functions, and more. Finally, participants will learn Tableau to create visualizations to express their data. The program is open to beginners and has flexible scheduling options. Tuition includes hands-on training, a free retake, and training manuals for each course.

In this data science bootcamp, students will build programming skills and data analysis skills using Python. This course is open to beginners and is meant to get individuals up and running with Python programming and data science to generate insights from data. Topics covered include programming fundamentals, working with data frames, data analysis, data visualization, and statistical analysis. This course offers flexible scheduling options and a free retake for students to refresh the materials.

Learn to problem solve, and effectively communicate, like an analyst. This course teaches you to use industry-standard tools to make ethical, data-driven decisions. Experience hands-on training to master SQL, Excel, Tableau, PowerBI, and Python – tools listed in virtually every data analytics job posting across industries.

This course on data wrangling with Python offers a 3-day comprehensive introduction. The purpose of this course is to give an immersive foundation that equips students with the most critical data analysis tools. Students will learn how to work with NumPy, Pandas, and MatPlotLib to calculate descriptive statistics, work with alternative data sources, and scrape web pages. The course culminates with a real-life data wrangling project.

This 2-day course provides a deep-dive into using Python for data analysis. Students will get comfortable with the basics of Python programming and start working with Numpy Arrays, pandas, and MATPLOTLIB to perform data analysis and create data visualizations. This intensive course is meant to quickly get beginners in Python up to speed on performing data analysis and visualization in Python.

This course teaches the fundamentals of SQL querying. This 1-day program teaches students how to execute a simple query, perform a conditional search, work with functions, and organize data. Further, students will learn how to retrieve data from multiple sources and export query results via a text or XML file.

This 1-day course builds on the fundamentals of SQL querying. This intermediate program teaches advanced querying techniques. The coursework will cover the use of subqueries to perform advanced querying, manipulating table data and table structure. Students will learn how to work with views, index data and manage transactions.

This 3-day introductory course teaches the basics of SQL databases. Through the use of labs and lectures, students will learn the fundamentals of data modeling, the use of relational databases, and the normalization of raw data. Students will also learn how to design relationships, evaluate query performance, and use stored procedures.

Designed for professionals already using data-management tools, this 2-day course introduces basic functions in Tableau. After exploring the fundamentals, students will learn how to connect to, prepare, and explore data, manage and sort data in fields, and apply advanced worksheet filters. Completion of this course will prepare students to create advanced visualizations, maps, and stories.

This intermediate course in Tableau Desktop teaches advanced skills with this data visualization software. This course teaches students how to blend data in order to visualize relationships, clean and organize PDF data, and troubleshoot joins. Students will learn how to manipulate data and use advanced calculations to create data visualizations.

This 1-day course gives a foundational understanding of Microsoft Excel. Students with novice computer skills will learn how to manipulate and organize data using Excel spreadsheets. They will also learn how to navigate the Excel interface, create, manage and save workbooks, and perform calculations. This program is available both face-to-face and with live online instruction.

In this 1-day course, students will learn how to use some of the more advanced features of Microsoft Excel. With online and in-person options, students will learn how to work with functions, lists, tables, conditional formatting, charts, and PivotTables. After completing this course, students will be able to leverage Excel’s capabilities to analyze and present data.

In this 1-day course, experienced users of Microsoft Excel can gain advanced skills. Students will learn how to work with multiple worksheets, use lookup functions, create and deploy macros, and use the goal seek feature. Completion of the program ensures that students can use Excel to forecast data and create sparklines.

This course in Microsoft Excel for Office 365 is designed to teach foundational skills in the use of this software. Students will learn the basic functions of Excel, as well as how to create workbooks, insert formulas, format text and numbers, and print workbooks. Graduates of this program will be prepared to sit for the Excel Associate certification exam.

This 2-day course on Python with data science is intended for software developers, IT architects, and data scientists. This course will build on their knowledge of statistics and programming, teaching them the theoretical and technical aspects of the use for Python. Students will learn about the history and purpose of data science, life-cycle phases of data analytics, methods for repairing and normalizing data, and how to aggregate and group data. Students will also complete 10 lab exercises.