Data Analytics Classes Virginia, US

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 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 program provides a comprehensive foundation in data analytics in 24-weeks. This course covers the fundamentals of statistics, Python, Tableau, SQL, and HTML/CSS. Graduates of this program will have a robust professional portfolio to share with their current or future employers.

In this 8-day intensive Data Analytics bootcamp, students with little to no background in data analytics will learn how to use Microsoft Excel, SQL, and Tableau to summarize, display, and discover key insights hidden in data sets. By the end of this bootcamp, students will be able to use Excel to aggregate and summarize data, sort data with PivotTables, create charts and tables in Excel, use SQL to filter and sort large data sets, use advanced database queries, create visualizations with Tableau, and much more. Students will also be able to reinforce what they learn through the numerous projects they encounter throughout the course. This course also offers a free retake within six months to allow students to revisit any concepts needing to be refreshed and walk away with a much stronger grasp of the material.

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.

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 course teaches basic SQL Querying in 2-days. Students learn online, attending live training provided by professional instructors. The course explores database concepts such as grouping and summarizing data, joining tables, and clauses. Working in the online lab environment, students will get hands-on experience writing simple SELECT queries and using built-in functions and expressions.

This 1-day online course teaches students how to compose Advanced queries in SQL. Based on Microsoft’s SQL Server, this program is delivered live by experienced instructors, allowing for real-time feedback. Students will learn how to write advanced queries, advanced WHERE clauses, and create advanced joining tables. They will practice these schools in an online lab environment, where they can collaborate with other students.

This course is a 4-day comprehensive workshop on MySQL workbench data modeling and development. This program uses an online lab environment to allow students to practice what they are learning. The live training covers topics such as creating an ERD, defining the physical schemata, reverse engineering a database, managing security, and more. Students will also learn how to use MySQL Workbench to create and maintain MySQL databases effectively.