Master the essential tools of data analytics with hands-on training in Excel, SQL, Tableau, and Power BI. Develop the skills to write SQL queries, design dynamic Power BI reports, and create insightful Tableau visualizations before taking the official exams in each subject. Students may also choose to replace the exams with an additional hour of private tutoring. This course is designed to help you pass these exams and includes:
- Microsoft Excel Expert Exam with a free retake.
- Microsoft Power BI Data Analyst Exam with a free retake.
- Tableau Certified Data Analyst Exam with a free retake.
- Oracle Database SQL Certified Associate Exam with a free retake.
What You Will Learn
- Excel for Data Analytics: Use advanced Excel functions, PivotTables, and charts to analyze data efficiently and create clear visual reports for business insights.
- SQL Bootcamp: Write and optimize SQL queries, join and filter data across multiple tables, and manage complex databases using PostgreSQL and DBeaver.
- Tableau Bootcamp: Build interactive dashboards and compelling data visualizations with Tableau, applying advanced formatting and storytelling techniques.
- Power BI Bootcamp: Connect and transform data from multiple sources, use DAX for calculated fields, and publish professional reports through Power BI Service.
- Exam Preparation: Prepare for four industry certifications: Excel Expert, Power BI Data Analyst, Tableau Certified Data Analyst, and the Oracle SQL Associate.
Program Courses
Excel Level I: Fundamentals
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
Excel Level II: Intermediate
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
Excel Level III: Advanced
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
SQL Bootcamp
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
Tableau Bootcamp
Learn how to use Tableau, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. This course will teach you how to connect to datasets, analyze and structure data, customize visualizations, and publish your work.
Power BI Bootcamp
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
Power BI Advanced
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.