Course Overview
English, Filipino ∙ Self-paced (1 hr 30 mins)
About the Course
In this course, the participant will learn how to import data from different sources and prepare its data for analysis using Power Pivot. This course is also designed to expand and advance knowledge about Excel functions, and creative visualizations.
Course Objectives
- Discuss the Power Pivot and Dax
- To learn how to gather and transform data from multiple sources
- To learn about data model creation and dashboards
- To analyze and visualize data
- To learn how to build relationships between data
Course Outline
- What is Pivot Table and Chart
- What is Power Query and Power Pivot
- How to Create Relationships using Power Pivot Diagram View
- How to Create DAX Measures and Calculated Columns
- How to Create Power Pivot Tables
- How Create Basic Dashboard Layout
Target Participants
Anyone who wants to advance their excel knowledge and become an excel power user.
Certificate Requirements
- Completion of recorded webinar + quiz
- Pass the quiz with 80% mark
- Comment your feedback to the main page of the course
- https://asklexph.com/courses/introduction-to-excel-dashboards-with-power-pivot-and-dax/
Thank you for sharing your knowledge about Excel Dashboards with Power Pivot and DAX! I have more idea now how to use power pivot, I hope I can apply this 😀
I appreciate the speaker’s effort in thoroughly demonstrating all commands and formulas used in Power Pivot and Dax. Excellent presentation, I might add. I must remark that the presentation of all the material is excellent. I appreciated watching while simultaneously learning.
Very informative and straightforward video, I’ve learned that using power pivot provided ease and it is less consuming, with lotsof options and formulas to be used,now creating dashboards will never be a hassle.
I can say that this is so informative and I learned a lot. It helps me gain more knowledge about excel and I know I can use this knowledge sooner or later. Thank you!
As a beginner like me, this is incredibly useful information and guide. Thank you.
Very informative and straightforward video, I’ve learned that using power pivot provided ease and it is less consuming, with lotsof options and formulas to be used,now creating dashboards will never be a hassle.
This is very informative. I am currently taking up a subject that is focused on Excel and this course really helped me to further understand my subject. Thank you!
I enjoy the course. I can say that I have learn a lot.
I learned a lot of formulas to make the task less consuming and easier. I was also able to gain information on how to use Power Pivot Tables, Pivot Chart, and to create DAX measures. I would say that I can now produce a simple dashboard layout with the help of this tutorial.