Introduction to Excel Dashboards with Power Pivot and DAX
₱ 0.00
English, Filipino ∙ Self-paced (1 hr 30 mins)
Date Published
August 12, 2023
Course Updated
October 19, 2024
Categories:
Analytics
Tags:
#Analytics
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/
No frequently asked questions for this course yet.
5.0
7 months
The course is very informative.
13 days
The webinar offers an insightful overview of building dynamic dashboards in Excel using advanced tools like Power Pivot for data modeling and DAX (Data Analysis Expressions) for custom calculations.
7 days
Very detailed explanation !
Recommended For You
Analytics
Automation for a non-coder using Power Automate
Innovation
Sustainability
Preventive Maintenance Primer
Innovation
Leadership & Management
Practical Applications of Simulation of Business