Data Analyst Exercises
These exercises support Microsoft course DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
| ILT Module | Lab |
|---|---|
| Setup your own environment | Setup your own environment |
| Model, query, and explore data in Azure Synapse | Query files using a serverless SQL pool |
| Model, query, and explore data in Azure Synapse | Analyze data in a data lake with Spark |
| Model, query, and explore data in Azure Synapse | Explore a relational data warehouse |
| Prepare data for tabular models in Power BI | Create a star schema model |
| Prepare data for tabular models in Power BI | Create a dataflow |
| Design and build tabular models | Work with model relationships |
| Design and build tabular models | Create calculation groups |
| Design and build tabular models | Create a composite model |
| Design and build tabular models | Enforce model security |
| Optimize enterprise-scale tabular models | Improve performance with hybrid tables |
| Optimize enterprise-scale tabular models | Improve query performance with dual storage mode |
| Optimize enterprise-scale tabular models | Improve query performance with aggregations |
| Optimize enterprise-scale tabular models | Use tools to optimize Power BI performance |
| Implement advanced data visualization techniques by using Power BI | Monitor data in real time |
| Manage the analytics development lifecycle | Create reusable Power BI assets |