DataExplained
Data with Senthil !
As you swim through an era of Data, why don't you learn "the how to" ?
Data Explained will help you learn a big deal in data analytics, data warehousing, Business Intelligence, programming & so on.
All it takes, is your coffee time ! So, let's get it started right now !
What is the difference between UNION and UNION All ( SQL)?
Write Stored Procedures in SQL Server(Create|Alter|Drop|Execute) #sqlstoredprocedures #updatesql
Append vs Merge in Power Query (Power BI Illustration)
Pivot Unpivot in Power Query/Power BI (Change your Data Structure/Layout)
UPDATE QUERY IN SQL
Create Insert Delete Truncate in SQL
Install SSMS and MS Server Local Host
How to Import | Attach | Restore Adventure Works DW database into MS SQL Server
Extract/Import Data from Web into PowerBI using PowerQuery
Summarize() vs AddColumns() vs SummarizeColumns() Which of these has the best performance & how ?
DAX Calculate() and What are Row vs. Filter vs. Query Contexts ?
Multiple Linear Regression using R ( All about it )
Incremental load in SSIS using Lookup task: Incremental Load (DELETE) | Manage Deleted Source Data
SSIS Series: Incremental Load using Lookup Task (Logic + ETL)
Introduction to SSIS Data Load
Linear Regression Scoring using Alteryx Predictive Tool kit
Rank() vs. Dense Rank () vs. Percent Rank () vs. Cumulative Distribution in SQL
Running Total, Rolling Average, First & Last (Value) using SQL window Functions.#sqlwindow functions
Lead and Lag Functions in SQL Server (Analytical Functions) #windowfunction #partitionby #overclause
Quick but Powerful Dashboard in PowerBI(DAX)
Switching Relationships Dynamically in DAX
Bi-Directional Cross Filtering in Power BI
Logistic Regression using R (Simple / Detailed)
Analytic App in Alteryx Designer( Detailed )
Regression using Alteryx (Detailed Residual Analysis)
Data Filtering in R using Indexes/Subsets (Detailed)
Handle Missing Values: Imputation using R ("mice") Explained