Data Analytics Classes Fresno, CA

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.

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.

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 introduction to SQL gives students basic and intermediate skills in SQL. Students will learn how to use basic SQL security protocols, so database users have added peace of mind. These protocols include assigning roles to individual users, restricting access, configuring SQL security permissions, encrypting data, and creating audit trails. This program includes free repeats within six months and courseware you can keep for reference later.

This introductory Excel course is meant to get new users up and running with the fundamentals of Excel. Students will learn to perform basic calculations, navigate the workbook, and more as they get comfortable with Excel. This program includes free repeats within six months and courseware you can keep for reference later.

This 2-day advanced Excel course builds off the intermediate course to teach users more advanced skills in Excel. Students will learn to work across multiple sheets and workbooks create sparklines and trendlines, consolidate data, use lookup functions, automate workflows with macros, and forecast data. This program includes free repeats within six months and courseware you can keep for reference later.

This 1-day course in Excel Data Analysis with PivotTables is designed to get students started working with PivotTables and PivotCharts. Students will learn how to analyze data from multiple sources and represent that data with PivotTables. This program includes free repeats within six months and courseware you can keep for reference later.

This course teaches basic and intermediate skills in Microsoft Power BI. BI allows users to transform and combine data from numerous sources. Students will explore concepts like database connection, loading, and grouping, data merges, query syntax, and visualizations. This program includes free repeats within six months and courseware you can keep for reference later.