Data Analytics Classes Charlotte, NC

Harness Excel, SQL, and Tableau to drive powerful analysis and insights. Build confidence and credibility to apply this versatile skill set to countless jobs. This course is offered in person and live online, in a remote classroom setting.

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.

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.

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 get them started in their careers.

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.

Create robust predictive models with statistics and Python programming. Build confidence and credibility to tackle complex machine learning problems on the job. This course is offered in person and live online, in a remote classroom setting.

This data analytics course is a 1-day bootcamp designed for individuals interested in learning the best practice of working with data and understanding the data analytics roadmap. In this hands-on bootcamp, students will learn how data can help inform decision making, understand the data analytics workflow, and gain exposure to some of the most common tools used for data analysis. Students will also learn how to ask the right questions that can be answered with data, clean and analyze data with standard spreadsheet software (Excel/Google Sheets), and use Tableau to create dynamic visuals.

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 SQL bootcamp is a beginner-friendly workshop designed for individuals with no prior knowledge of SQL who are eager to learn. In this hands-on workshop, students will learn the basics of SQL syntax and how databases are organized. Students in this course will also learn how to query data, aggregate data with statistical functions (SUM, AVG, COUNT, etc.), group data, and use conditional operators (=, <, >, etc.) to sort and filter data, and much more. Students will also learn when and how to use UNIONs and JOINs to merge data to spot trends and other insights.

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 data science program is a beginner-friendly bootcamp designed for individuals interested in learning the best practice of working with data and understanding how to gain insights from large data sets. In this hands-on bootcamp, students will get an overview of data science, including the various roles within data science and how to recognize and solve problems with data science. Students will also discuss how to use some well-known statistical models and how models fit into a data science project. Finally, students will explore various tools, including data visualization, analytical, and modeling tools essential in the field of data science.

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 advanced SQL course is a 3-hour workshop designed for individuals already familiar with SQL who are looking to take their skills to the next level. In this advanced hands-on workshop, students will dive into advanced calculations and techniques to work with data more effectively through SQL. Students in this course will also learn concepts like Text Searching, Views, and Stored Functions and Procedures. Students will also be provided with resources to hone their skills and practice the concepts covered in the course.