Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Hier kannst du dein Wissen und Können an Millionen von Teilnehmer:innen in aller Welt weitergeben und damit richtig Geld verdienen!
Weitere Infos
Dein Einkaufswagen ist leer.
Weiter einkaufen
Business Analyst Bootcamp: Excel, Stats, SQL, Tableau
Bewertung: 4,5 von 5(822 Bewertungen)
3.524 Teilnehmer:innen
Erstellt vonLeo Zhu
Zuletzt aktualisiert 7/2024
Englisch

Das wirst du lernen

  • 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

Programmierübungen

Dieser Kurs enthält unsere neuen Programmierübungen, damit du deine frisch erworbenen Skills direkt praktisch anwenden kannst.

Demo ansehen
Bild einer Beispielprogrammierübung

Kursinhalt

12 Abschnitte95 Lektionen23 Std. 31 Min. Gesamtdauer
  • What will we learn?6:13
  • What do BAs do?5:59
  • What is agile software development?8:14
  • What are the different types of analytics?8:46
  • What is the role of AI in modern workflows?1:56
  • Why do we use living documents and mobile apps?4:11
  • What are no-code/low-code softwares?3:44

Anforderungen

  • 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

Beschreibung

Welcome to my Business Analytics/Intelligence course with over 30+ practical examples!

With the meteoric rise of AI-based technologies, the world of work is changing once again to demand data-driven decisions as industries scramble to become agile and augment with new technology. In this course, I will 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 + tools, 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:


  1. Introduction: Welcome to the course where you'll learn about how agile and AI-powered workflows enable the modern agile business analyst.

  2. Data Pipeline: You'll learn about big data and how data is collected, stored, and organized.

  3. Spreadsheets & Descriptive Statistics: You'll explore spreadsheets and descriptive statistics, understanding normal distributions and relationships between data points.

  4. Probability: You'll study random variables and probability distributions, calculating statistics and making decisions.

  5. Inferential Statistics: You'll dive into inferential statistics, learning about hypothesis testing and decision making based on expected value.

  6. Machine Learning 1: You'll be introduced to machine learning and artificial intelligence, including linear and non-linear regressions.

  7. Time Series: You'll forecast with time series and predict future events.

  8. Machine Learning 2: You'll learn about classification, clustering, and reinforcement learning.

  9. SQL: You'll understand databases, reading, changing and working with multiple tables.

  10. Visualization & Presentation: You'll study business intelligence, creating visualizations (Tableau) and presenting data effectively.

  11. Non-Technical Skills: You'll evaluate businesses and work within teams, prioritizing projects and understanding KPIs.

  12. Conclusion: Quick wrap up of everything that you have learned

Are you ready to dive into the world of Business Analytics? Let's get started!


Shoutout to Mike Yang for dev reviews

Für wen eignet sich dieser Kurs:

  • 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