Column Profiling in PowerBi
Using data profiling software The data profiling capabilities in Power Query Editor offer new and straightforward methods to clean, manipulate, …
Identify Data Anomalies
Identify Data Anomalies Anomaly detection improves line charts by automatically recognizing abnormalities in time series data. It also explains the …
Using or Creating a PBIDS file
PBIDS Connection File Creation. If you already have a Power BI Desktop (.PBIX) file that is connected to the data, …
Using Parameters
What is Parameter? Any characteristic that can help define or categorize a specific system is, in general, considered a parameter. …
Choosing an Appropriate Query Type
What is Query object The Query object type defines all of the top-level entry points for queries that clients run …
MAPPING CARDINALITIES AND DATABASE NORMALIZATION
MAPPING CARDINALITIES Cardinality: The number of times an entity from an entity set takes part in a particular relationship set …
MAPPING CARDINALITIES AND DATABASE NORMALIZATION Read More »
Attributes, Relationship set and degree In SQL
Attributes The properties that determine the entity type are called attributes. for instance, the entity type student properties are Roll …
Database Normalization and ER Model
Database Normalization and Entity-Relationship (ER) Model The entity-relationship diagram (ERD) is a popular data modeling approach. Data modeling is a …
Table vs Views In SQL
Table vs Views What exactly is a table? A table is made up of rows and columns that are used …
Analytics Framework and Latest trends
Current Big Data Analytics Trends You’ll be amazed to learn that we generate more data in two days than we …
