Business Analytics with Excel

$399.00

Dooey Business Analytics certification online course with Excel equips you with vital concepts & BI skills required to become a ✔️Business Analyst.

Business Analytics with Excel

$399.00

SKU: 2c46a492b675 Category:

Program Overview:

Get a boost in your business analytics career by mastering the full functionality of Microsoft
Excel. This Business Analytics certification course teaches you the basic concepts of data
analysis and statistics to help data-driven decision making. This training introduces you to
Power BI and delves into the statistical concepts that will help you derive insights from data
and present your findings through intuitive and executive-level dashboards.

Program Features:

  • 12 hours of online self-paced learning
  • Two hands-on industry-based projects on healthcare and ecommerce
  • Includes training on business intelligence using Power BI
  • 8 practical exercises
  • Lifetime access to self-paced learning

Delivery Mode:

Online self-paced learning

Prerequisites:

There are no prerequisites for this Business Analytics certification training other than an
analytical mindset. However, we do expect the participants to have a basic knowledge of
working with Microsoft Excel.

Target Audience:

This course is best suited for the following professionals:

  • Beginners in the business analytics field
  • Professionals looking to dive deeper into analytics
  • IT developers and testers
  • Data analysts
  • Junior data scientists
  • Analytics professionals
  • BI and reporting professionals
  • Project managers

Key Learning Outcomes:

When you complete this Business Analytics with Excel course, you will be able to
accomplish the following:

  • Understand the basic concepts of business analytics
  • Analyze data with pivot tables
  • Understand the principles of dashboard design and how to create charts in Excel
  • Learn data analysis using statistics
  • Understand conditional formatting and logical functions

Certification Details and Criteria:

Online Self-Learning

  • Complete 85% of the Business Analytics with Excel course content
  • Complete one project

Course Curriculum:

Lesson 01 – Introduction to Business Analytics

  • Introduction
  • What Is in It for Me
  • Types of Analytics
  • Areas of Analytics
  • Key Takeaways
  • Conclusion

Lesson 02 – Formatting Conditional Formatting and Important Functions

  • Introduction
  • What Is in It for Me
  • Custom Formatting Introduction
  • Custom Formatting Example
  • Conditional Formatting Introduction
  • Conditional Formatting Example
  • Conditional Formatting Example
  • Conditional Formatting Example
  • Logical Functions
  • Lookup and Reference Functions
  • VLOOKUP Function
  • HLOOKUP Function
  • MATCH Function
  • INDEX and OFFSET Function
  • Statistical Function
  • SUMIFS Function
  • COUNTIFS Function
  • PERCENTILE and QUARTILE
  • STDEV, MEDIAN and RANK Function
  • Exercise Intro
  • Exercise
  • Key Takeaways
  • Conclusion

Lesson 03 – Analyzing Data with Pivot Tables

  • Introduction
  • What Is in It for Me
  • Pivot Table Introduction
  • Concept Video of Creating a Pivot Table
  • Grouping in Pivot Table Introduction
  • Grouping in Pivot Table Example
  • Grouping in Pivot Table Example
  • Custom Calculation
  • Calculated Field and Calculated Item
  • Calculated Field Example
  • Calculated Item Example
  • Slicer Intro
  • Creating a Slicer
  • Exercise Intro
  • Exercise
  • Key Takeaways
  • Conclusion

Lesson 04 – Dashboarding

  • Introduction
  • What Is in It for Me
  • What is a Dashboard
  • Principles of Great Dashboard Design
  • How to Create Chart in Excel
  • Chart Formatting
  • Thermometer Chart
  • Pareto Chart
  • Form Controls in Excel
  • Interactive Dashboard with Form Controls
  • Chart with Checkbox
  • Interactive Chart
  • Exercise Intro
  • Exercise1
  • Exercise2
  • Key Takeaways
  • Conclusion

Lesson 05 – Business Analytics With Excel

  • Introduction
    • 5.002 What Is in It for Me
      5.003 Concept Video Histogram
      5.004 Concept Video Solver Addin
      5.005 Concept Video Goal Seek
      5.006 Concept Video Scenario Manager
      5.007 Concept Video Data Table
      5.008 Concept Video Descriptive Statistics
      5.009 Exercise Intro
      5.10 Exercise
      5.012 Key Takeaways
      5.013 Conclusion

Lesson 06 – Data Analysis Using Statistics

  • Introduction
  • What Is in It for Me
  • What is a Dashboard
  • Principles of Great Dashboard Design
  • How to Create Chart in Excel
  • Chart Formatting
  • Thermometer Chart
  • Pareto Chart
  • Form Controls in Excel
  • Interactive Dashboard with Form Controls
  • Chart with Checkbox
  • Interactive Chart
  • Exercise Intro
  • Exercise1
  • Exercise2
  • Key Takeaways
  • Conclusion

Lesson 07 – Power BI

  • Introduction
  • What Is in It for Me
  • Power Pivot
  • Power View
  • Power Query
  • Power Map
  • Key Takeaways
  • Conclusion