- Type Learning
- Level Advanced
- Time Weeks
- Cost Paid
Data Analysis - Gold
Issued by
Lumify Group
Earners of the Data Analysis Gold Badge will have an expert understanding of Excel, and an advanced understanding of Power BI and also DAX. In Excel, the student will be able to work with large data sources, transform & clean data using Power Query and create advanced data models in power pivot. They will be able to use cloud automation, office scripts and the power platform to automate spreadsheets. Badge recipients will understand the theory of DAX and be proficient in its use.
- Type Learning
- Level Advanced
- Time Weeks
- Cost Paid
Skills
- Context in Calculated Columns
- Data Types
- Date Dimesion
- DAX
- DAX - Contexts and Relationships
- DAX - Evaluation Contexts
- DAX – Measures and Filters
- DAX Optimisation
- DAX - Rules of Evaluation
- DAX - The CALCULATE Function
- DAX Tools
- DAX - Variables
- Formula auditing
- Functions and FILTER
- Importing and Exporting
- LookUp Functions
- Office Script
- Open Power Query
- PivotCharts
- PivotTables
- Power BI
- Power Pivot
- Protecting Data
- Recorded Macros
- Row Contexts in Measures
- Transform Data
- Validating Data
- Working with Columns
- Working with Queries