Introduction to Excel Dashboards with Power Pivot and DAX
SD
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/
It was a very informative and thorough discussion. I enjoyed it a lot. It enabled me to expand my knowledge and experience in handling data in Excel.
Very informative
Engineer Sandy's tutorial on Power Pivot and DAX for Excel was comprehensive and insightful. Covering data analysis expressions and dashboard creation, it provided practical guidance for optimizing data visualization. The session was engaging and left attendees feeling empowered to apply newfound skills. Highly recommended for Excel enthusiasts.
"Excel Dashboards with Power Pivot and DAX" is a student's guide to dynamic data visualization. It unveils the power of Power Pivot and DAX functions, transforming Excel into a robust analytics tool. From creating interactive dashboards to data modeling, it equips me with practical skills for effective data presentation and analysis.
The information is somehow overwhelming, but I think if I rewatch and follow through the steps again, it would help me familiarize with Power Pivot and DAX. Thank you Ask Lex PH and Engr. Sandi for letting us learn these things for free!
RT
FV
JA