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...
Monday, June 12, 2023
What is Data Modeling in Power BI
A Data model is a collection of data, tables, relationship between different tables, formatting rules, calculations/measures, and hierarchies.Power Pivot is used for data modeling in Power BI.The first step of data modeling is loading of data from Power Query, which are stored in tables in the form of columns. A single column usually primary key column is used to define relationships, in Power...
What is Data Analysis Expressions (DAX)
DAX is a functional and, query language.Functional means DAX primarily use functions to generate results.Query means DAX can only filter or query data from table in Power BI, SSAS Tabular or PowerPivot.DAX is used in:MeasuresMeasure is a calculated value or expression that...
Sunday, June 11, 2023
xVelocity
With the introduction of Microsoft SQL Server 2012, a cutting-edge technology called xVelocity was unveiled, revolutionizing the way data is processed in-memory.In the realm of Data Warehousing, the xVelocity memory-optimized columnstore index offers an exceptional acceleration for frequently encountered data warehouse queries. For Business Intelligence purposes, xVelocity introduces an advanced...
Wednesday, May 31, 2023
Data Connection Methods in Power BI
There are three different ways to connect to data sources in Power BI.Import DataIn this method Power BI extracts data from source and stores it in the in-memory engine called xVelocity. xVelocity engine is optimized for data storage and performance.Import data offers superior...
Monday, May 29, 2023
Table, Matrix, Key Influencers, Decomposition Tree Visuals
The following dashboard uses the Sample - Superstore datasets to demonstrate the creation of:TableThe Table visual is a grid where related data is displayed in 2D format i.e. rows and columns.Table visual is flat, means duplicate values are displayed...
Friday, May 26, 2023
Map, Filled Map, Gauge, Multi-row Card, KPI Visuals
The following dashboard uses the Sample - Superstore and Financial Sample datasets to demonstrate the creation of:MapMap enables to track and analyze data on a geographic level.Map is integrated with Bing Maps to provide default map coordinate (called geo-coding).Map...
Wednesday, May 24, 2023
Waterfall Chart, Funnel Chart, Scatter Chart, Pie Chart, Donut Chart, Treemap Visuals
The following dashboard uses the Sample - Superstore dataset to demonstrate the creation of:Waterfall ChartWaterfall chart visualizes positive and negative changes to a value or displays each individual component that contributes to the final value.In...
Thursday, May 18, 2023
Line Chart, Area Chart, Stacked Area Chart, Line & Stacked Column Chart, Line & Clustered Column Chart, Ribbon Chart Visuals
The following dashboard uses the Sample - Superstore dataset to demonstrate the creation of:Line ChartLine chart depicts data which changes over the time e.g. showing the difference in profit over the time. The horizontal axis shows the continuous values...
Wednesday, May 17, 2023
Card, Slicer and Bar Charts Visuals in Power BI Visuals
The following dashboard uses the Sample - Superstore dataset to demonstrate the creation of:SlicerSlicers are visuals that filter data in the report through one or more fields.By default slicer filter data on the same report page, however; through sync slicers pane...
Tuesday, May 16, 2023
What is Power BI
Power BI is a business analytics and data visualization tool developed by Microsoft. Power BI is available in several versions:Power BI Desktop; for creating reports and visualizationsPower BI Service; for sharing and collaborationPower BI Mobile; for accessing and...
Subscribe to:
Posts (Atom)
