Ciência de Dados para Negócios usando Excel

Unlock the Power of Data Analysis with Excel!

Are you ready to transform your data into actionable insights? This course will show you how to leverage Excel, one of the world's most popular and user-friendly software programs, for advanced data analysis techniques. While often used for basic operations and charts, Excel has far more to offer. Learn to go beyond simple summaries and visualizations and truly extract value from your data.

The course is structured into three key sections:

• Descriptive Techniques: Deep dive into understanding your data. Discover central tendency, variability, and identify outliers using advanced statistical charts. Gain a comprehensive understanding of your datasets.
• Probabilistic Techniques: Analyze the likelihood of events within your company. Learn to calculate and interpret probability to make more informed and strategic business decisions.
• Inferential Techniques: Focus on predictive analysis. Develop skills to forecast future events based on data-driven probabilities.

What You'll Learn:

• Data Visualization: Understand your business through insightful statistical charts.
• Outlier Detection: Identify and analyze unusual data points – find outliers and understand their impact.
• Probability Calculation: Understand and calculate the probability of events occurring.
• Time Series Analysis: Comprehend the probability of event occurrence over time intervals.
• Statistical Distributions: Practice applying key statistical distributions in Excel.
• Predictive Modeling: Make predictions based on event probabilities.
• Key Metrics: Extract relevant information using metrics like medians and standard deviations.
• Regression Analysis: Learn simple and multiple linear regression.
• Time Series Forecasting: Develop predictive models using time series.
• Dashboard Creation: Build interactive dashboards within Excel.

Practical Application:

Develop a hands-on project connecting an analytical spreadsheet to a real-time database. Apply your new skills to real-world scenarios and build practical data solutions.

Course Resources:

Downloadable materials include:

• Excel spreadsheets used throughout the course.
• PDF slides for easy reference.

Elevate your data analysis skills with Excel and unlock a new level of business intelligence!