Course DescriptionCreate PivotTables and PivotCharts from large, multi-source data sets. Import data directly from the source, or build queries to extract specific parts of data from very large sources. Learn how to relate multiple data tables through key fields, allowing fact tables to lookup information from other parts of the data model. Add calculated columns and measures directly in the data model within DAX (data analysis expressions). Break the data down with user-defined hierarchies. Generate dynamic key performance indicators (KPI) for display. Utilize date intelligence functions to pinpoint trends within the data, allowing end users to make informed data-driven decisions.
PrerequisitesIntroduction to PivotTables or equivalent experience.
Applies Towards the Following Certificates
- Data Analysis Certificate : Electives