EXCEL DASHBOARD & POWER BI
介绍...
40多个课程,分步练习,4个小时的视频课程
To Help you Thrive in the Most Prestigious Jobs on Wall Street...
HERE’S JUST SOME OF WHAT YOU’LL GET IN THIS COURSE
介绍和设置(6个视频课程)
In this module, we use6个视频课解释创建Excel仪表板时的关键组件和最佳实践。这包括逐步演练of a company sales dataset and an explanation of important metrics pertinent to our case study.
KPI Squares and Speedometer Charts (7 video lessons)
In this module, we use7个视频课程to provide a walkthrough on how to修改我们的数据集以创建几个关键图表和指标在我们的Excel仪表板中。我们通过探索组合图来结合此模块,这是一种比较数据的有效而动态的方法。
Using COUNTIF and Dynamic Charts (6 video lessons)
In this module, we use8个视频课to expand upon the charts we created in previous modules by adding Dynamic Charts and Net Promoter Score (among other topics). This module also includes atutorial on how we can use dynamic coding to make our data malleable和有条件的格式以提供视觉吸引人的仪表板。
Drawing Conclusions (2 video lessons)
In this module, we use2 video lessons将不同的图表我们创造联系在一起ed in previous modules,using the dashboard to provide conclusive datathat can be presented. We wrap things up by offering several tips to continue improving on your Excel Dashboards.
Power BI概述(5个视频课程)
In this module, we use5 video lessons要潜入Power BI,该工具提供了Excel中无法使用的其他自定义和过滤器。这包括简短Power Bi功能,可自定义的切片机和自动数据链接和分类的概述。
Basic Charts (5 video lessons)
In this module, we use5 video lessons探索列图表,饼图和条形图以及如何完全使用Power BI到create dynamic visualizations。我们通过学习如何使用切片机来控制不同图表之间的相互作用来总结该模块。
高级可视化(7个视频课程)
In this module, we use7个视频课程深入研究更高级的可视化,例如填充的地图可视化,散点图和漏斗图。该模块还包括一个逐步演练关于如何创建这些可视化。
Power BI Online(2个视频课)
In this module, we use2 video lessonsto explore the special features of Power BI online such as interconnectivity with clients. We wrap up this module by exploring见解和相关性该电源BI能够使用您的数据自动生成。
WSO Excel Dashboards & Power BI Course - Video Preview
课程摘要 - 目录
Below you will find a list of the modules and lessons included in this course.
- 仪表板介绍(2分钟)
- 仪表板的关键组件(7分钟)
- 引入案例研究pt。I (4 Min)
- 引入案例研究pt。II(6分钟)
- 设置我们的数据pt。我(8分钟)
- 设置我们的数据pt。II(8分钟)
- 创建KPI方形PT。I (9 Min)
- 创建KPI方形PT。II(9分钟)
- 创建KPI方形PT。III(2分钟)
- 创建一个速度计图表PT。我(7分钟)
- 创建一个速度计图表PT。II(7分钟)
- 创建一个速度计图表PT。III(5分钟)
- 创建组合图(9分钟)
- 比较CY与PY销售PT。我(8分钟)
- 比较CY与PY销售PT。II (4 Min)
- Creating a Dynamic Chart with a Spin Button pt. I (5 Min)
- Creating a Dynamic Chart with a Spin Button pt. II (7 Min)
- 使用Countifs和推荐图表PT。我(6分钟)
- 使用Countifs和推荐图表PT。II (5 Min)
- Drawing Conclusions from out Data pt. I (9 Min)
- 从我们的数据pt中得出结论。II(6分钟)
- 下载电源BI(2分钟)
- Overview of the Power BI visualizations (8 Min)
- Power BI概述(4分钟)
- 将数据导入Power BI(3分钟)
- 连接和更新我们的数据源(8分钟)
- 创建列图(6分钟)
- Formatting Data in Power BI (3 Min)
- 创建饼图(3分钟)
- 创建条形图和切片机(7分钟)
- Editing the Interaction between Charts (3 Min)
- 创建填充的地图可视化(6分钟)
- 创建一个散点图(6分钟)
- Creating a Speedometer Chart (4 Min)
- 创建漏斗图(3分钟)
- 创建KPI正方形(4分钟)
- 使用自定义计算PT创建组合图。我(7分钟)
- 使用自定义计算PT创建组合图。II (4 Min)
- 在BI云上创建仪表板(6分钟)
- 对我们的数据有更多的见解(4分钟)
- Dashboards Outro (3 Min)
我们的学生在所有顶级华尔街公司的职位上降落并蓬勃发展,包括:
Don’t Take Our Word For It
听到我们的一些57,000+ students。。。
[Testimonials to Come! New Course...]
听到我们的一些57,000+ students。。。
[Testimonials to Come! New Course...]
Get the Excel Dashboards & Power BI Course Certification
After completing the course, all students will be granted the WSO Excel Dashboards and Power BI Certification. Use this certificate as a signal to employers that you have the technical Excel and Power BI skills to immediately add value to your team.
证明您已经在大学课程之外投入了工作,以使自己更加高效,并掌握在财务职业中取得成功的最关键计划。轻松分享LinkedIn和其他社交媒体网站,以突出您的技能并加强您作为候选人的个人资料。
何这是你的
Finance Career Worth?
你得到什么 |
价值 |
---|---|
WSO Excel Dashboards & Power BI Course 由CPA的4大审计师教授的9个模块中的40多个视频课程... |
$500 |
全面的顶峰案例研究 Gain realistic practice drilling the concepts taught in the course so that you can apply them to the real world. |
$ 450 |
实际财务专业人士的24个月无限精英支持 Have a technical question? Easily drop a comment into any lesson and get a response from a pro within 48hrs. |
$ 300 |
6个月的免费访问Macabacus Full access to this Excel plug-in that makes financial modeling even easier, including tools for PowerPoint and Word. |
$ 120 |
总价值 |
$1,370 |
Get Unlimited Lifetime Access To The WSO Excel Dashboards & Power BI Course For 93% Off
$1,370
$97
...或今天仅以$ 37获取访问权限
安全支付
100%无条件退款保证
12个月无风险担保
Your investment is protected by our 12-Month Risk-Free Guarantee. If, for any reason, you don't think the WSO Excel Dashboards & Power BI is right for you, just send us an email, and we'll refund every penny. No questions asked.简而言之,您将获得丰厚的投资回报,或者您可以拿回钱。It's that simple.