Introduction to Excel Dashboards with Power Pivot and DAX

₱ 0.00
Author
Ask Lex Super Admin

English, Filipino ∙ Self-paced (1 hr 30 mins)

Date Published
August 12, 2023
Course Updated
August 12, 2023
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



No frequently asked questions for this course yet.
Recommended For You
Leadership & Management
Digital Marketing for Beginners
Ask Lex Super Admin
Analytics
Data-Driven Governance
Ask Lex Super Admin
Sustainability
Sustainable Entrepreneurship: How Business Can Contribute to Sustainability?
Ask Lex Super Admin