You can find all of the raw data for this training at https://cspolybasepublic.blob.core.windows.net/cstrainingpublicdata/precon_raw.zip
This includes a folder called raw, which you will upload to a storage account in preparation.
You can find all of the scripts for this training at https://github.com/feaselkl/azure-precon. These are in Synapse format, so they are JSON-based using a Synapse format rather than true SQL or ipynb files.
- Basics of data modeling
- Importance of star schemas
- File formats
- Data types
- Lab: discover a Synapse workspace
- Pipelines in Python
- Configure Key Vault
- Add credentials to Key Vault
- Work with Python and SQL in notebooks
- Organize code
- Lab: work through notebooks to perform development
- Logging
- Error handling
- Alerting
- Monitoring
- Security best practices
- Lab: Setting up Azure Log Analytics, JSON, and proper logging
- Data ingestion
- Organization of data
- Data modeling
- Power Query
- DAX
- Basics of visualization
- Lab: extracting Log Analytics data to Power BI and creating a dashboard. Extracting and organizing data platform data. Creating DAX measures. Creating visuals.