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…


This content originally appeared on DEV Community 👩‍💻👨‍💻 and was authored by Sakshi

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.


This content originally appeared on DEV Community 👩‍💻👨‍💻 and was authored by Sakshi


Print Share Comment Cite Upload Translate Updates
APA

Sakshi | Sciencx (2022-10-04T11:32:13+00:00) DP-900 Part 15. Retrieved from https://www.scien.cx/2022/10/04/dp-900-part-15/

MLA
" » DP-900 Part 15." Sakshi | Sciencx - Tuesday October 4, 2022, https://www.scien.cx/2022/10/04/dp-900-part-15/
HARVARD
Sakshi | Sciencx Tuesday October 4, 2022 » DP-900 Part 15., viewed ,<https://www.scien.cx/2022/10/04/dp-900-part-15/>
VANCOUVER
Sakshi | Sciencx - » DP-900 Part 15. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2022/10/04/dp-900-part-15/
CHICAGO
" » DP-900 Part 15." Sakshi | Sciencx - Accessed . https://www.scien.cx/2022/10/04/dp-900-part-15/
IEEE
" » DP-900 Part 15." Sakshi | Sciencx [Online]. Available: https://www.scien.cx/2022/10/04/dp-900-part-15/. [Accessed: ]
rf:citation
» DP-900 Part 15 | Sakshi | Sciencx | https://www.scien.cx/2022/10/04/dp-900-part-15/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts