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 Twitter 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 Fix the SQL Arithmetic Overflow Error Converting Varchar to Data Type Numeric

SQL Arithmetic Overflow Error Converting Varchar to Data Type Numeric The Arithmetic Overflow Error occurs when converting a numeric or ...
Microsoft Power BI Theme Colors with HEX Codes

Microsoft Power BI Themes Colors with Hex Codes Reference -------------------------------------------------------------------------- List...
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...
What is Commit,Rollback and SavePoint in SQL Server

How to use Commit, Rollback and SavePoint commands in SQL Server The Commit, Rollback and SavePoint are the Transactional Controlling Lang...
What is Full Cache, Partial Cache and No Cache of Lookup Transformaton in SSIS Package

How to Handle the Row yielded no match during lookup and Row disposition Errors in SSIS Lookup Transformation Scenario : Suppose we have ...
What Is the difference between Dim and ReDim Statements in VBA

How to use Dim and ReDim Statements in VBA Dim Statement: Variables declared with Dim at the script level are available to all proced...
VBA Input Box and Message Box Response to Stop or Run a Macro

How Run or Stop a Macro with VBA Input Box and Message Box Responses Sub Run_Stop_Macro() Alert = MsgBox("The Macro will Update the...
What is the difference between rnorm(),runif() and sample() Functions in R

How to generate Random numbers using rnorm(), runif() and sample() Functions in R rnorm () : The rnorm() function is used to generate n ...
How to display numbers from 1 to 100 in 10 rows and 10 columns using Nested For Loop in Python Program

Python Program to display the numbers from 1 to 100 in 10 rows and 10 cols for x in range(1, 11): for y in range(1, 11): print(&...
How to remove a Carriage Return Line Feed (CRLF) from a String of Varchar Column in SQL Server

Removing a Carriage Return, Line Feed (CRLF) from a Column in SQL Server The term CRLF refers to Carriage Return (ASCII CHAR(13), \r) Li...

Content Labels

VBA_Macros (175)
Power_BI (125)
DAX_Exp_Fun (83)
MS-SQL (70)
T-SQL (61)
VBA_Basics (51)
SQL-Basics (40)
Power_M-Query (37)
R_Programming (37)
ETL_SSIS (29)
Python_Basics (27)
SQL_Joins (21)
SQL_Analytics (20)
MS-Access (17)
PowerBI_Basics (12)
Pivot_Tables (11)
VBA_Arrays (8)
Py_ControlStatements (7)
PowerPoint_VBA (6)
WorkSheet_Events (6)
Power_BI_Service (5)
WorkBook_Events (5)
Py_File_Process (4)
SQL_DateTime_Fun (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.