Technical Business Analytics for Agile Decision Making 2023

For aspiring analysts and data-eager professionals to learn Excel, SQL, Tableau, and relevant communication skills
What you'll learn
Learn what happens to data as they flow through a typical pipeline
Learn how to use SQL to query databases and pull data for analysis
Learn how to use Excel functions and features to analyze data and implement machine learning methods
Learn how to use Tableau to generate appropriate visualizations to communicate your insights
Learn how to communicate analytical insights to various audiences
Requirements
No prior experience required
An interest in asking questions and digging deeper
A desire to apply classroom theory to practical case studies
Description
Welcome to my Business Analytics course! The data-driven business analyst role is a key entry point into working in technology / agile environments, and I'm beyond excited to teach you ALL of the necessary skills using free tools such as Google Sheets (Excel, Analysis ToolPak), MySQL, and Tableau (trial)! This is an introductory self-paced course with an MBA-level curriculum tailored to suit students from all backgrounds! Whether you're currently a student preparing for the job market, a seasoned professional looking to up-skill / pivot, or a business owner looking to accelerate your growth, you will finish this course with a fundamentally different understanding of how the world operates today. Our course will consist of theoretical videos, hands-on tutorials where we work through short assignments together, and mock cases to dive into a wide range of topics, including data pipelines, intro/advanced spreadsheets functions, descriptive/inferential statistics, machine learning, time series, SQL, visualization, and nontechnical skills.I will be constantly updating this course with industry breakthroughs regularly, and adjusting materials based on student feedback to provide an optimized learning experience. By the end of this course, you'll have a comprehensive understanding of Business Analytics and how to use various tools and techniques to analyze data and make informed business decisions.So, what exactly will you be learning? Here's a brief breakdown of the course units:Introduction: Welcome to the course where you'll learn about software development and data analytics.Data Pipeline: You'll learn about big data and how data is collected, stored, and organized. Spreadsheets & Descriptive Statistics: You'll explore spreadsheets and descriptive statistics, understanding normal distributions and relationships between data points. Inferential Statistics: You'll dive into inferential statistics, learning about hypothesis testing and decision making based on expected value. Probability: You'll study random variables and probability distributions, calculating statistics and making decisions. Machine Learning 1: You'll be introduced to machine learning and artificial intelligence, including linear and non-linear regressions. Machine Learning 2: You'll learn about classification, clustering, and reinforcement learning. Time Series: You'll forecast with time series and predict future events. SQL: You'll understand databases, reading, changing and working with multiple tables. Visualization & Presentation: You'll study business intelligence, creating visualizations (Tableau) and presenting data effectively. Non-Technical Skills: You'll evaluate businesses and work within teams, prioritizing projects and understanding KPIs.Conclusion: Quick wrap up of everything that you have learnedAre you ready to dive into the world of Business Analytics? Let's get started!
Who this course is for
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
Homepage