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)