Business Analyst Classes Fort Lauderdale, FL

This 1-day introduction to Microsoft Excel teaches participants how to create, manage and work with spreadsheets. Throughout this experience, students will learn how to use Microsoft Excel to organize and analyze data. They will gain practice with writing formulas, creating tables, and presenting data in charts and reports.

Intermediate Microsoft Excel users can improve their skills with this 1-day program. This program explores the advanced editing tools of Excel, such as text-wrapping, borders, and effects. Students will learn how to adjust page layouts, insert page and section breaks, and handle multiple window views.

This 1-day program teaches experienced Microsoft Excel users how to leverage more advanced tools. This course teaches students how to use PivotTables to analyze data, trace precedents to understand cause and effect within the data, audit worksheets, and convert text. They will learn how to use macros to automate scripts and integrate Excel spreadsheets with other Microsoft Office tools.

In this comprehensive Excel bootcamp, participants learn beginner to advanced Excel techniques, including formulas & functions, VLOOKUP, macros, and more. Students learn how to work more efficiently, summarize, and analyze data with tables, charts, and PivotTables. By the end of this hands-on course, participants will be ready to use Excel for everyday business tasks. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

In this 3-day bootcamp, beginners will be transformed into confident SQL users who can write queries, manipulate tables, and store advanced code. Participants will start by learning about relational databases and SQL fundamentals and will conclude the program having mastered complex retrieval tasks and storing complex code. Topics include composing queries, creating your SQL databases, automating workflow with stored procedures, and step-by-step exercises that will provide an efficient and thorough approach to mastering SQL. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

In this 18-hour SQL Bootcamp open to beginners, participants will discover the essentials of databases and how to write SQL code to retrieve and analyze data. Through hands-on exercises, participants learn everything from data types to basic queries and advanced topics, including aggregating and joining. Topics include SQL GUI basics, fundamental to advanced querying, table creation, joins, views, functions, and external data connections. The course is taught using PostgreSQL and applies to other relational databases, including SQL Server and MySQL. Participants can retake the course for free within one year.

In this comprehensive 2-day course, participants can become an advanced Tableau user able to work with data to create visualizations and use the various tools Tableau Public has to offer. They will learn to identify datasets to create desired visualizations and then master the Tableau tools on a deeper level to customize their visualizations. By the end of this course, participants will have learned to create maps to represent geographical data, and build actions to control visualizations within sheets and dashboards. Tuition includes hands-on training, a free retake, and a course manual. The course offers flexible scheduling and is available online or in NYC.

Develop a solid design foundation in this two-day beginner-level Tableau training class. Through a combination of hands-on learning, instructor guidance, and class discussions, students import data from multiple sources and use it to create strong visualizations and engaging stories. Specific topics include Tableau interfaces, understanding techniques and best practices, leveraging the Tableau paradigm, workflow management, data analysis, data breakdowns, basic calculations, and guided data presentation.

Take your Tableau skills to the next level in this three-day intermediate course. Using more in-depth Tableau features, such as enhanced data visualization, participants solve more advanced problems. Specific topics include a Tableau review, parameters, sets, groups, reference lines, animation features, forecasting, mapping, data sourcing, filed calculations, and advanced charting.

Combine basic and intermediate courses in this fast-paced, five-day Tableau bootcamp. Once they acquire a solid foundation, students move quickly to more advanced areas, through a combination of structured and guided learning. Key concepts include combining visualizations, using interactive dashboards, utilizing data stores, gaining data insights, effective presentation techniques, and sophisticated data charting approaches.

Get started with Microsoft Excel in this beginner-friendly course. Learn calculations, basic formulas and functions, tables, charts, and tips for efficiency with hands-on exercises. By the end of this course, you'll build a strong foundation for using Excel as a vital tool in your daily workflow. The course has flexible scheduling options and is available live online or in NYC. Tuition includes hands-on training, a free retake, course manual, and supporting video tutorials.

This one-day Microsoft PowerPoint introductory class enables participants to create engaging, professional-grade presentations. As the curriculum progresses, students become familiar with ever more sophisticated PowerPoint tools and tips. Through a combination of hands-on learning, class discussions, and instructor leadership, participants master skills like developing and presenting slideshows and supplemental handouts, adding diagrams, graphics, and other visual enhancements, and incorporating dynamic presentation effects.

Enhance basic skills in this one-day Microsoft PowerPoint intermediate class. Participants become familiar with some advanced tools, like SmartArt and Animation Painter. Furthermore, students learn advanced techniques which enhance their presentations and optimize workflow. To prepare students for the MOS Microsoft Office Specialist PowerPoint: Core Presentation Design and Delivery Skills exam, this course covers securing and sharing presentations, creating custom shows, managing hyperlinks and charts, adding special effects, and using templates.

This course teaches the fundamentals of Microsoft Excel. Students attending this 1-day course will learn how to set up workbooks, enter and format data, create charts and graphs, and use formulas to perform calculations. Students will know how to work with multiple versions of Microsoft Excel, including the mobile app and online versions.

This 1-day course is intended to help beginners develop more advanced skills in Microsoft Excel. This intermediate program will teach students how to perform calculations, manage worksheet data, combine data from multiple sources, and analyze alternative data sets. Students will also learn how to collaborate with colleagues, track changes, and export workbooks.

Intermediate users of Microsoft Excel will learn advanced skills in this 1-day course. The topics covered include automation with macros, alternative datasets, and dynamic worksheets. Students will learn important principles of business intelligence data analysis, and how to create forecasts and visualizations. This course is delivered online with live instructors.

This 1-day program builds on foundational knowledge of Microsoft Excel. Students in this course will learn how to create advanced workbooks and worksheets and use them to create dashboards. The use of dashboards in Microsoft Excel will enable students to make business data more accessible, understandable and useful for decision-making.

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.