Business Analyst Bootcamp: Excel, Stats, SQL, Tableau

30+ Data Analysis, Business Intelligence, and Decision Making Exercises for Agile Business Analytics

Created by: Leo Zhu
Product Manager & Instructor

What Will I Learn?

• Excel: Mine data and generate actionable insights with Pivot Tables, Lookup Functions, Index/Match, and Graphs
• Excel: Create machine learning model and make predictions with Analysis Toolpak
• SQL: Understanding the data life cycle and how data moves from a pipeline into a data warehouse/lake
• SQL: Query, clean, and prepare data for analysis and real-time reporting
• Tableau: Create visualizations and dashboards to communicate data insights
• Tableau: Storytelling technical information to executives and business stakeholders

Requirements

• No prior experience required, everything is taught from the basics
• All software will be FREE to use
• Classroom theory will be applied in guided worksheets and practical case studies
• Contact me if you have financial difficulties - education is a right, not a priviledge

Target audience

• University/College students who want to enter the workforce as a business analyst or prepare for a course
• Experienced professionals who want to improve data literacy, implement agile practices, or do a career pivot
• Small business owners who want to implement data-drive decision making in their operations
• Businesses looking to enrol new business analysts in a data training bootcamp