Power BI Analytics Kingdom | Blog

The Power BI Blog for Professional Learning of the Microsoft Power BI, SQL Server, T-SQL, ETL, R Programming and Excel VBA Macros

Search This Blog

Microsoft SQL Server | T-SQL
Power BI
ETL
R | Python
VBA Macros
Admin-Login

R | Python

How to Analyze and Impute the Missing Data with VIM and Mice Packages in R
How to Detect,Impute or Remove Outliers from a Dataset using Percentile Capping Method in R
How to Visualize data with Box and Whisker Plot using ggplot2 Package in R
How to Visualize data with Histogram using ggplot2 Package in R
What is the difference between rnorm(),runif() and sample() Functions in R
How to Reshape or Tidy the data using tidyr() Package in R
How to use dplyr() Package for Data Wrangling in R Programming
How to manipulate the Text Strings data with Regular Expressions in R
How to manipulate the Text Strings data with String Functions in R
How to Format the Date values in R Programming
How to do Subsetting the data from a Dataframe in R
How to Join Datasets with dplyr() Package in R Programming
How to Merge or Join the two Dataframes in R using base Merge Function
How to Connect and Read data from SQL Server Databse in R
How to Read the data from an Excel file into R
How to read tab delimited input data from a Text file in R
How to read the data from a User input in R Programming
How to use While loop in R Programming
How to use Repeat loop in R Programming
How to use For loop and Nested For Loop in R Programming
How to use Switch Case Statement in R Programming

What is Data Frame and How to Create a Data Set in R Programming
What are the Factors and How to Create them in R Programming
What is List Indexing and How to Access,Add and Delete the List Elements in R Programming
What is List and How to Create it in R Programming
What is an Array and How to Create it in R Programming
How to do Indexing, Filtering and Resizing the Matrix in R Programming
How to Perform basic Arithmetic and Linear Algebra Operations on Matrices in R Programming
What is the Matrix and How to Create it in R Programming
How to use Ifelse() Function in Vectors of R Programming
How to Test the Equality of Vectors in R Programming
How to Filter Indices or Elements from a Vector in R Programming
How to handle NA and NULL values in Vectors of R Programming
What are the Vectorized Operations in R Programming
How to Generate Vector Sequences and Repeating Vector Constants in R Programming
What is Vector Indexing in R Programming and How to form a SubVector
What is Recycling of Vector Elements in R Programming
What is Vector in R Programming and how to Add and Delete Vector Elements
An Introduction to R Programming

Python : ( Yet to update )

Note :
For more Tutorials please search and refer in blog posts.

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.

Subscribe to: Posts (Atom)

Featured Post from this Blog

How to compare Current Snapshot Data with Previous Snapshot in Power BI

How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...

Popular Posts from this Blog

How to change Pivot Chart Slicer, Filter Item dynamically and and Print the Chart of each Slicer Item on Power Point Slides using Macro

Excel VBA Macro to change Pivot Chart Slicer, Filter Item dynamically and Print the Chart of each Slicer Item on Power Point Slides Let us...
Excel VBA Pivot Table Standard Operations

Pivot Table Standard Operations with Excel VBA Suppose we have a Pivot Table as Follows : Pivot Field list as follows : On the above P...
Access VBA DAO CopyFromRecordset Method to Copy Selected Fields Data from Access Table to Excel

Access VBA DAO CopyFromRecordset Method to Copy Selected Fields or SQLQuery Results Data from Access Table to Excel How to Transfer Se...
Microsoft Power BI Theme Colors with HEX Codes

Microsoft Power BI Themes Colors with Hex Codes Reference -------------------------------------------------------------------------- List...
How to Sort Pivot Table Row, Column Field Labels and Values with Excel VBA Macro

Macro To Sort Pivot Table Row Labels, Column Field Labels and Data Values Sub Sort_Pivot_Row_Column_Data() Range("G3").Sel...
How to calculate Growth from Previous Non Consecutive Dates in Power BI

How to use DAX to calculate Growth from Previous Non Consecutive Dates in Power BI Scenario: Suppose we have a Sample Data with Sales (Qnty_...
How to Calculate the Cumulative Sum or Running Total in SQL Server

SQL Query to Calculate the Cumulative Sum or Running Total Scenario : Suppose we have a Table " TblSample " as follows.. ...
How to get the All Selected Values from a Slicer using DAX in Power BI

How to get the All Selected Values from a Slicer using SelectedValue, AllSelected, and ConcatenateX Functions in Power BI Scenario : Supp...
How to Copy and Paste Excel Range as Picture in VBA

Excel VBA Macro to Copy an Excel Range as Picture and Pasting as Picture Sub Copy_Paste_As_Picture() 'Method -I : Copying the Range a...
What is Vector in R Programming and how to Add and Delete Vector Elements

How to Add and Delete Vector Elements in R Programming Vectors are one-dimensional arrays that can hold numeric data, character data, or l...

Content Labels

VBA_Macros (175)
Power_BI (94)
DAX_Exp_Func (84)
MS-SQL (70)
T-SQL (61)
VBA_Basics (51)
SQL-Basics (40)
Power_Query (38)
R_Programming (37)
Power_BI_Analytics (36)
ETL_SSIS (29)
Python_Basics (27)
SQL_Joins (21)
SQL_Analytics (20)
MS-Access (17)
PowerBI_Basics (12)
Pivot_Opera (11)
VBA_Arrays (8)
Py_Conditional (7)
PowerPoint_VBA (6)
WorkSheet_Events (6)
Power_BI_Service (5)
WorkBook_Events (5)
Py_File_Process (4)
SQL_DateTime_Func (4)
Outlook_VBA (2)

Translate to Native

Admin / Author

Tamatam Reddy, MBA: Bengaluru, India; The Soul of Integrity

View my complete profile

Blog Total Views:

Privacy Statement /Disclaimer

The ‘Excel Kingdom Blog’ Admin/Author believes that the information herein was Prepared by Author as well as some content written here by studying some reliable sources and posted here as is but does not guarantee its accuracy or completeness of information which is contained in the Blog Posts and accepts no liability for any consequential losses arising from the use of this information. All or Some data posted as of the date hereof and are subject to change.

The Blog Admin/Author is not responsible for the contents of any off-site pages referenced. The user specifically acknowledges that the Blog Admin/Author is not liable for the defamatory, offensive, or illegal conduct of other users, links, or third parties and that the risk of injury from the foregoing rests entirely with the user. If any Links from the this Blog to the other Web sites do not constitute an endorsement from the Blog Admin/Author. These links are provided as an information service only. It is the responsibility of the web user to evaluate the content and usefulness of information obtained from other sources. The Admin/Author do not Recommend/Promote any Content/Site/Company/Method/Anything/Anybody. The Author just study and write his Own Posts and also some of the Content is Posted here by studying some reliable sources which will be helpful to Learners/Users.

If any one feel that the Content/Anything posted here from other reliable sources is Copyrighted, Please let us know Immediately, we will remove it.

All the information contained in this Blog is Non Commercial and only for the sake of Information/Learning purpose. Also, please note that, this Blog does not have (not associated to) any Social Network /Channel/Group/Page on Youtube/Facebook/Twitter.

Tamatam Reddy, MBA. Watermark theme. Powered by Blogger.