Posts

Showing posts from July, 2022

Data Warehouse - Basics Fundamental Notes - Part1

Data warehouse which is build on RDMS is used for analyze the data and based on the nature of data and the analysis, people take the decisions. The objective is to bring intelligence analysis which lead to make the predictive analysis call right. Following are few fundamental notes on data warehouse. Now a days, the Data Lake is being used for Big Data analysis purpose and not limited only in RDMS stored area. In particular, there are three key factors are exist in data warehouse world , and they are three V's - Volume , Velocity , and Variety . In data warehouse, not only structured data maintained or analysis, the data warehouse system should able to handle unstructured data like video, audio, images as well.  Centralize data warehouse using Single RDMS.  Keep a note that data warehouse is NOT as Data mart. Dependent DataMart variation with Corporate Information Factory(CIF). There are four rule of data warehouse Integrated  Subject Oriented Time Variant Non Volatile ETL(Extract,

Simple Power BI Report to Monitor Application Support Activities

Image
Following are few simple Power BI reports which is usually visible in Power BI dashboard as our analytical reports. Reports for Application Dashboard, Incident Analysis, Analysis-By Ticket Priority With Time, Analysis-With Time-With Status and count of resolution will help you to understand your team strength, give you insights of ticket trends, and many more.