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.