Data Analysis - Silver
Issued by
Lumify Group
Earners of the Data Analysis Silver badge will have an advanced understanding of Excel including Analysis and Dashboards, and intermediate proficiency in Power BI. In Excel, the student will understand Solver, data linking, pivot charts, automation using Macros, interactive dashboards, charting tools and visualisation techniques. In Power BI, the student will be competent with data transformations, measures, DAX, Row Level Security, using Power Query and creating advanced visualisations.
- Type Learning
- Level Intermediate
- Time Weeks
- Cost Paid
Skills
- Advanced Visualisations
- Append and Merge Queries
- Chart Elements
- Column Transformations
- Complex Functions
- Conditional Formatting
- Data Modelling
- Data Model & Transformation
- Data Transformations
- Date Transformations
- DAX
- Defined Names
- Essential Functions
- Filling Data
- Formula Referencing
- Load Data
- Number Formatting Techniques
- PivotTables
- Power BI
- Power Query UI
- Quick Measures
- Secure and Share Data
- Time Intelligence Functions
- Validating Data