Data Classes Inland Empire, CA

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.

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.

In this 2-day course, students can learn how to use Tableau Desktop’s advanced tools to create data visualizations. While attending this online program, students will learn how to interact with Tableau Server, get their data ready, improve their level of detail calculations, and integrate with R. This course uses live instruction by experienced professionals. Students get to learn and gain hands-on experience in an online lab environment.