Snowflake History
&nb...
Thursday, December 21, 2023
Wednesday, December 20, 2023
What is Snowflake?
Snowflake is a self-managed data platform or data cloudSnowflake makes storing, processing, and analyzing data faster and more flexible compared to traditional optionsSnowflake uses a brand-new SQL query engine designed specifically for the cloudFrom self-managed means:You...
Wednesday, August 2, 2023
Power BI Dashboards
Service Delivery Center's Revenue and Services DashboardCryptocurrency Prices History and Forecasting DashboardDownload PBIX FileHR Attrition DashboardDownload PBIX F...
Wednesday, July 12, 2023
What is Data Science
Data science is to make data useful for decisionsData science encompasses three disciplines: Statistics; decision making under uncertainty on data. Excellence of statistics is rigorous approach.Machine learning; automation of decision making under uncertainty on data. Performance is the excellence of the machine learning.Analytics; find the unknown and don't know how many decisions you want...
Thursday, June 22, 2023
Joins in DAX
DAX relationship has some limitations like:The matching criteria always use the = operator and does not allow the use of other operators such as <>, >=, <, and <= .Supports only one-to-many and one-to-one relationships.In order to overcome these limitations,...
Tuesday, June 20, 2023
Logical Functions in DAX
Logical functions evaluates to TRUE or FALSE.Following are the DAX Logical functions.IF(logical_test, result_true, result_false) Evaluates a condition and returns one value if it is TRUE, and another value if it is FALSE.The IF logical function can also be nested. IF.EAGER(logical_test,...
Relationships in Power BI
When working with multiple tables, it is highly likely that you will need to perform analysis using data from all of them.Relationships are rules that define how two tables can be associated.Relationships connect one table column to another table’s column.Power BI Desktop...
Monday, June 19, 2023
Operators in DAX
Operators are used to create expressions.There are four different types of operators in DAX.Arithmetic Operators perform basic arithmetic calculations.+ (Addition)– (Subtraction)* (Multiplication)/ (Division)^ (Exponentiation)Comparison Operators return true or false when used to compare two values.= (Equal to)== (Strict equal to)> (Greater than)< (Less than)>= (Greater than or equal...
Data Types & Variables in DAX
Data TypesDAX is strongly typed language. DAX data types can be categorized into three groups: NumericNumeric data types include DecimalFixed decimal/currencyInteger/whole numbers, Percentage (same is decimal data type but with formatting as percentage) Date/Time...
Snowflake Schema
The Snowflake schema is an enhanced version of the Star Schema. In this schema, dimension tables are broken down into additional sub-dimensions. For example, the Product dimension table could be further normalized into related tables, such as a SubCategory table.Snowflake...
Tuesday, June 13, 2023
Star Schema
Star Schema is a data modeling approach to classify tables as either lookup tables (dimensions or master data tables) or data tables (fact or transaction tables).Lookup Tables Lookup tables describe business entities e.g. Products, time etc.Lookup tables typically...
Context in DAX
Context describes the environment in which a DAX formula is evaluated. There are two types of context.Filter ContextFilter context is the context that is applied to a whole table or column (set of rows).The filter context is set of filters that are applied to the data...
Subscribe to:
Posts (Atom)
