Identify and retrieve data from data sources and understand the different connection methods.
Optimize query performance
Profile and examine the data and apply data shape transformations
Develop a scalable and performance data model
Enhance the data model with DAX using measures, calculated columns and tables
Use variables and aggregations to optimize model performance
Design and create reports and dashboards
Select and add appropriate visualizations
Create paginated reports
Perform Advanced Analytics
Create and manage workspaces
Manage datasets and dataset refresh
Apply row-level security