DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Cover image for DP-900 Part 15
Sakshi
Sakshi

Posted on • Updated on

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.

Top comments (0)

Regex for lazy developers

regex for lazy devs

You know who you are. Sorry for the callout πŸ˜†