Hello!
Azure Data Explorer
- Stand alone service for data analysis
- Encapsulated in Azure synapse
- Enables to manage analytical solution
- Data is ingested into data explored through connector
- It supports batching, and streaming in real time
- For capture/analyze data in real time
- Explore filter and aggregate
Kusto query language
- used to query explorer tables
- fast read operations
- for data analysis
Data Visualization
- It powers reporting and decision making that helps organzation succeed.
Power BI tools and workflows
- It is used by data analysts to build interactive visualization.
- A cloud service in which reports can be published
Data Modelling
- Models are based on related tables of data
- Define numeric values you want to analysis
- Model forms multi dimensional structure called cube
Tables and Schema
- Dimension tables :
Represents table entities by which you want to aggregate numeric measure
Numeric measures aggregated from tables are stored in fact tables.
When more than one dimension is there, it is n-star schema. Here n is the number of dimension.
Thanks for reading…
This is second last blog in this series
YESS! I will write my next blog within 2-4 days, where I will tell you how you can get certification for free from Microsoft.
