Data Analytics Classes Pittsburgh, PA

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.

Data Analytics Flex is a 6-month part-time program designed to get you a job as a data analyst. You will begin by learning how to master Excel and storytell with Powerpoint. Afterwards, you'll learn how to query data using SQL and visualize data using Tableau. Once you've mastered these building blocks, you'll receive business case studies to simulate real-world work projects and you'll also be exposed to statistics. Finally, you'll learn how to clean data using Python and work on your capstone project. This program comes with a tuition backed guarantee if you don't land a job within 6 months of graduation.

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.

This course in data analytics serves as an introduction to data analysis. Professionals who take this course will obtain essential data analysis skills, including the use of Tableau for visualizations. This program offers online and on-campus versions, with instruction by experienced data analysts. Graduates are equipped to solve real-world data problems.

This 1-day Excel course is crafted to introduce beginners to the fundamentals of Excel in order to enable them to feel comfortable working with spreadsheets. This course covers the basics of spreadsheets, the layout of Excel, entering data, using common formulas and functions, and a variety of other helpful tips and tricks.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of building professional looking charts. This course covers a lot of broad chart-related content, including creating and working with charts, incorporating various styles and themes, using print options, and best practices around using excel data in other office applications, like Word or PowerPoint.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of the various database and PivotTables features. This course covers a variety of PivotTable essentials, such as using lists, table features, working with data, making and enhancing PivotTables, and much more.

This 2-day Excel course is designed for individuals with a strong background using Excel but want to refresh their skills and learn some of the newest features to enhance your Excel mastery. This course moves at a fast pace and covers many of the most widely used and popular Excel techniques that will make students faster, more dynamic, and less error prone when working with spreadsheets. Some of the topics include short-cuts, formatting charts and graphs, database features, PivotTables, Formulas, Macros, and more.

This 4-day Tableau Desktop course is designed for students who have no prior knowledge of Tableau but are interested in learning common techniques to create great visualizations and dashboards. This course will help students get started with tableau and covers the basics of working with data, visualization best practices, plus a variety of ad hoc and table calculations. This course also covers dashboard design, advanced analytics like clustering and forecasting, data cleansing, storytelling with data, and more.

This 2-day Tableau Desktop course is designed for students who understand the fundamentals of working in Tableau and are interested in learning advanced techniques to become a Tableau superuser. This course will start with a quick review of the basics and then move on to many more advanced topics, like data preparation, complex joins, data densification, advanced calculations, and moving beyond basic chart types. The course also covers mapping, best practices for presentations, advanced visualizations and dashboarding, interacting with the Tableau server, integrating with R, and more.

Learn to seamlessly move raw data from an Excel spreadsheet to Microsoft BI for analysis in this two-day, basic-level class. Students build on their basic Excel knowledge to model the data then create and publish reports. Participants also master colors, text boxes, interactions, and other data visualization tools. Additionally, students examine sharing and publishing issues, including dashboards, workplaces, and personal gateways.