Business Analytics Business Analytics with Excel eLearning

Product type

Business Analytics Business Analytics with Excel eLearning

Adding Value Consulting EN
Logo Adding Value Consulting EN

Need more information? Get more details on the site of the provider.

Description

 Business Analytics Business Analytics with Excel eLearning

Learn how to understand data and make data-driven decisions

The Business Analytics with Excel training course has been designed to introduce you to the world of analytics by using the most commonly used analytics tool - Microsoft® Excel. It provides an excellent foundation of concepts and skills needed in the analytics field by teaching you how to understand data and make data-driven decisions.

ABOUT THE COURSE

The Business Analytics with Excel training course will boost your analytics career with powerful new Excel skills. You'll learn the basic theory of data analysis and statistics but the course will also delve into the st…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Web Analytics, Microsoft Excel, IT Security, Web Accessibility, and Digital Publishing & Editing.

 Business Analytics Business Analytics with Excel eLearning

Learn how to understand data and make data-driven decisions

The Business Analytics with Excel training course has been designed to introduce you to the world of analytics by using the most commonly used analytics tool - Microsoft® Excel. It provides an excellent foundation of concepts and skills needed in the analytics field by teaching you how to understand data and make data-driven decisions.

ABOUT THE COURSE

The Business Analytics with Excel training course will boost your analytics career with powerful new Excel skills. You'll learn the basic theory of data analysis and statistics but the course will also delve into the statistical concepts that are important in acquiring insights from available data in order to present findings using executive level dashboards.

You will also become trained in Power BI, currently the best tool provided by Microsoft for data analytics and visualisation, so you can better represent and present your data analysis findings. Your new knowledge of these two commonly used tools combined with official business analytics certification is guaranteed to boost your career.

PRE-REQUISITES

There are no prerequisites for this business analytics course other than an analytical mindset. However, it's expected to have a basic knowledge of working with Microsoft Excel.

LEARNING OBJECTIVES

By the end of the course you will be able to:

  • Understand the meaning of business analytics and its importance in the industry
  • Grasp fundamentals of Excel analytics functions and conditional formatting
  • Learn how to use pivot tables and slices for analysing complex datasets
  • Resolve theoretical and analytical problems using tools like scenario manager, solver and goal seek
  • Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using Excel
  • Represent your findings using charts and dashboards

WHAT'S INCLUDED

  • One year access to the platform
  • Duration approx. 12 hours
  • Practical industry-based projectsDownloadable PDF documents with detailed content (pictures, explanations) for each lesson
  • Access around the clock

WHAT'S COVERED?

The course has the following modules:

Lesson 1 - Introduction to business analytics

Lesson 2 - Conditional formatting and important functions

Lesson 3 - Analysing data with pivot tables

Lesson 4 - Dashboarding

Lesson 5 - Business analytics with Excel

Lesson 6 - Data analysis using statistics

Lesson 7 - Power BI

There are two projects included in this course:

Project 1 (submission and evaluation) - E-commerce. The analytics team of an online e-commerce company wants to design a sales dashboard to analyse the sales based on various product categories. The company’s main interest is to add user control for product category, so they can select a category and then see the trend by month and product. The analytics team also wants to create a histogram to analyse the number of shipping days.

Project 2 (practice) – Pharmaceuticals and healthcare. The analytics team of a pharmaceutical company wants to design a dashboard to analyse the sales of products across various regions and brands. They need a chart with user control functionality to enable users to easily see the total sales and commissions paid to external agents as categorised by brands and region.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.