# Business Analyst Certificate Canonical URL: ## Overview Build the foundational skills required for a successful career in business analysis. This certificate program focuses on practical training in Excel, SQL, Python, and Tableau to equip you with the tools and techniques to interpret data and communicate insights. - **Data Management in Excel:** Start with the essentials and progress to advanced Excel techniques. Learn how to work with functions, formulas, PivotTables, and macros to manage large datasets and support decision-making. - **Querying with SQL:** Learn to extract, filter, and manipulate data using SQL. Write queries, use joins, apply aggregates, and manage large datasets with PostgreSQL to generate clear and reliable insights. - **Analyzing Data with Python:** Build a solid foundation in Python programming and data analysis. Clean and structure datasets with pandas and create visualizations with Matplotlib as you prepare for advanced analytical work. - **Visualizing Insights with Tableau:** Turn data into compelling visual stories with Tableau. Create interactive dashboards and a wide range of visualizations to clearly communicate your findings to diverse audiences. - **Bonus Elective Courses:** Strengthen your understanding of business concepts and communication tools through supplemental training in financial accounting, PowerPoint, and Google Ads. ## What you'll learn - Organize, clean, and analyze large datasets using Excel functions, formulas, PivotTables, and macros - Write SQL queries to retrieve, filter, group, and join data from relational databases - Use Python with libraries like pandas and Matplotlib to manipulate data and create visualizations - Build interactive dashboards and compelling data visualizations in Tableau for diverse audiences - Apply statistical and analytical techniques to uncover insights and support data-driven decisions - Translate complex data into clear presentations that inform business strategies and solutions ## Curriculum 1. **Excel Level I: Fundamentals** 2. **Excel Level II: Intermediate** 3. **Excel Level III: Advanced** 4. **Financial Accounting Bootcamp** 5. **Google Ads Bootcamp** 6. **PowerPoint Level I** 7. **PowerPoint Level II** 8. **SQL Bootcamp** 9. **Python for Data Science Bootcamp** 10. **Tableau Bootcamp** ## Instructors ### Grace Hochheiser — Instructor After a successful career traveling internationally as a fashion executive, Grace Hochheiser journeyed back to her first love, the English language, and wrote her next chapter as a proofreader, copy editor, and business-writing instructor. She has edited everything from plays and photography books to an award-winning non-fiction book. After spending over a decade leading personal development classes to help others find their confidence and self-expression, she is focused on making a difference for students of every skill level in the professional development arena. Whether customizing training classes for diverse corporate clients or leading hybrid classes on site, Grace truly enjoys creating an interactive learning environment in which students feel comfortable to participate, expand, and thrive. She has effectively delivered both full-day classes and focused one-hour modular sessions for organizations ranging from small non-profits such as OnPointNYC to large network systems like the NYPD and NYU Langone Health. Grace is grateful for the opportunity to contribute to each student's growth and success, and is continually inspired by the diverse groups of people she gets to work with as an instructor. ### Jerron Smith — Program Director & Senior Instructor Jerron has more than 25 years of experience working with graphics and video and expert-level certifications in Adobe After Effects, Premiere Pro, Photoshop, and Illustrator along with an extensive knowledge of other animation programs like Cinema 4D, Adobe Animate, and 3DS Max. He has authored multiple books and video training series on computer graphics software, such as After Effects, Premiere Pro, Photoshop, Illustrator, and Flash (back when it was a thing). He has taught at the college level for over 20 years at schools such as NYCCT (New York City College of Technology), NYIT (The New York Institute of Technology), and FIT (The Fashion Institute of Technology). ## Pricing **Tuition:** $2995 Payment options: Student financing available; see the current application terms and pay-as-you-go installments.