Business Analysis Masterclass Using Excel, PowerBI & Python

业务分析是一种植根于数据的管理方法，用于识别问题、解决问题并发现增长机会。除了这三者之外，业务分析还包括就问题和机会进行清晰的沟通。因此，业务分析师应具备以下技能

数据分析能力

解决问题的能力

沟通技巧

该计划充分涵盖了所有三个要素，因此您可以成功！

在本课程中，我们将通过 Excel、PowerBI 和 Python 三种工具进行数据分析。因此，程序中广泛涵盖了数据分析的程序化和非程序化方式。

通过 PowerBI，您可以在短时间内构建具有令人惊叹的视觉效果的仪表板。来自 Microsoft 家族的 PowerBI 正在成为企业首选的商业智能工具，因此，这将是您未来获得的一项关键技能。

方差分析和账龄分析是每月业务分析的两个重要分析。该计划不仅从概念角度分析，而且从实施角度分析。

这是一个动手程序。该计划中使用的数据集可在资源下获得，我们希望学习者在各自的视频讲座旁边或在各自的视频讲座之后进行练习。

该课程由一位在过去两年半中见证了商业分析发展的从业者教授。

Variance Analysis | Ageing Analysis | Problem Solving Approaches | Dashboards | Story Telling

Published 08/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 57 lectures (5h 51m) | Size: 1.82 GB

What you’ll learn

What is business analysis
What is story telling in business analysis
How to build dashboards using Power BI
How to analyze data using Excel
What is variance analysis
What is ageing analysis
Why knowledge of problem solving approaches are important for business analysts
How to use Python to create visuals

Requirements
None

Description

Business analysis is a management approach rooted in data to identify problems, solve those problems and spot opportunities for growth. In addition to these three, business analysis also involves communicating clearly about problems and opportunities. Thus, a business analyst should possess the following skills

Data analysis skills

Problem Solving skills

Communication skills

This program covers all the three elements in adequate measure so you can succeed!

In this program, we are covering data analysis through three tools – Excel, PowerBI and Python. So, both the programmatic and the non-programmatic way of data analysis are covered extensively in the program.

Through PowerBI, you can build dashboards with stunning visuals in a short time. PowerBI that comes from Microsoft family is emerging as a business intelligence tool of choice among businesses and hence, this will be a key skill to gain for your future.

Variance and ageing analyses are two important analysis that are expected of business analysis every month. This program covers both the analysis not only from a conceptual perspective but also from an implementation perspective.

This is a hands on program. The datasets used in the program are available under resources and we expect the learners to practice alongside the respective video lectures or just after the respective video lectures.

This program is taught by a practitioner who has seen the evolution of business analysis over the last two and a half decades.

Who this course is for
Business Analysts
Data Analysts
Managers and Sr. Managers
CXO’s who want to learn the latest in business analysis
Finance & Accounting professionals
Professionals who prepare dashboards and reports
Business Planners
Business owners
Data science professionals