An Interest In:
Web News this Week
- April 18, 2024
- April 17, 2024
- April 16, 2024
- April 15, 2024
- April 14, 2024
- April 13, 2024
- April 12, 2024
October 4, 2022 11:32 am GMT
Original Link: https://dev.to/bellatrix/dp-900-part-15-3981
DP-900 Part 15
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.
Original Link: https://dev.to/bellatrix/dp-900-part-15-3981
Share this article:
Tweet
View Full Article
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To