fbpx

Category

Tutorials

Microsoft Business Intelligence(MSBI)

MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here we discussed different Business Intelligence tools including SSIS, SSRS, SSAS & many more. Similarly, What is MSBI? and its benefits. Data & Information Data is a technical term. A layman would not understand...
Read More

Tips & Tricks and Common Pitfalls of KNIME

KNIME Analytics Platform is the strongest and most versatile free platform for drag and drops analytics, statistics, and machine learning. This tool is best for any data mining operations. Before checking the tips & tricks for KNIME first know the What is KNIME & its advantages.   Tips and Tricks of KNIME 1. How to...
Read More

Excel Vs Tableau

Most of the Excel users still have one particular doubt. They regularly keep on enquiring why one needs to move to software like Tableau as they are fully comfortable in working with Excel. They are able to do all the things which Tableau offers with the help of Excel. For all these uses, I can...
Read More

Different Types of KNIME Components (USER INTERFACE)

Components are KNIME nodes that you create with a KNIME workflow. They compress and abstract functionality and can have their own classy, interactive views. Components can be reused in the same workflows and also can be shared with others using KNIME Server or the KNIME Hub. They can also represent web pages in an Analytical...
Read More

Data Analyst Interview Questions and Answers [Q&A]

To crack the interview, it is very important to know what are the possible Data Analyst Interview Questions. It gives you an idea about how the interview questions will be like, whether you know the answers and if you know the answers, then to ultimately boost your confidence. Confidence is the key to crack any...
Read More

How to Calculate Ratio in Excel | Excel Formula

This article is been written to find calculate the ratio in Excel Ratio: In simple mathematics, relationship or comparison between two more numbers is known as ratios. Ratios are normally written as “:” to show the connection between two numbers, for instance. You can learn such an advanced excel tutorial in our advanced excel dashboard...
Read More

Importance of KNIME Analytics Platform

Why KNIME? KNIME Analytics Platform is open-source software built for powerful analytics. It is free and easy with drag and drop based Graphical User Interface (GUI). KNIME is designed in such a way that the user need not have to know how to code to derive insights. Users can perform functions ranging from basic I/O...
Read More

How to Create a Workflow in KNIME?

KNIME is a great tool for building analytical workflows. Creating a workflow using KNIME involves dragging and dropping built-in nodes into a canvas. There is a privilege to extend KNIME by adding nodes developed by the KNIME community or adding your nodes. The creation of workflows is very fast and user-friendly with KNIME. In this...
Read More

Features of KNIME Analytics Platform

The KNIME system can operate on multiple operating systems. In other words, it is compatible with the Windows 32bit and Windows 64bit version and stays updated with Vista and all machines under Windows 7. It can also function with numerous Linux systems like RHEL4/5 and Open SUSE 10.2/10.3/11.0. KNIME version 2.1 can also work on...
Read More

Alteryx Hotkeys – Alteryx Keyboard Shortcuts

Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows in Alteryx by quickly blending and preparing the data without any programming skills. As it is used so extensively it is very handy to know Alteryx Shortcuts. Dive into the following Alteryx Shortcuts...
Read More

Basics of Nodes and Workflow in KNIME | KNIME Tutorials

KNIME is one of the best analytics platforms. The knowledge of the KNIME Analytics Platform store in the Node Repository. So before Leaning the KNIME, you should first understand What is Nodes? and What are Workflows in KNINE? This gives you a good glimpse of the KNIME Analytics Platform. If you want to know more...
Read More

Tableau File Types and their uses – Tableau Tutorial

Each file is created to serve a definite purpose in software. The workflow of the software develops separate data at each stage. In the same way, Tableau has different types of file types too. Let’s discuss the file types in Tableau and their purpose and usage. Top 10 Reasons Why Tableau is a necessity for...
Read More

Read How to Remove Rows With Errors Using Power Query

Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware of this feature then go through the below steps. Remove Rows With Errors By Power Query Let’s take an example. As shown in the below picture there is some revenue that has invalid...
Read More

Learn How to Split Queries In Power Query

As explained in the above example, we have generated a conditional column for the given query. If we want to split this query into two, Power Query will help us in doing so. To get more in-depth knowledge about Power Query, then check our latest Power Query Course that provides high-class videos with life time...
Read More

How to Use First Row As Headers in Power Query

One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take an example where you have the data set as shown below. Use First Row As Headers By Power Query Here, the headers are not meaningful as it is showing the headers as Column1,...
Read More

Top 10 Reasons Why Tableau is a necessity for Business

Why Tableau is a necessity for Business? Due to the proliferation of the internet, data is increasing day by day. Thanks to the advent of Business Intelligence tools that help to manage vast amounts of data. One of the most popular tools that fall under this category is Tableau. Learn about the Introduction of Tableau...
Read More

Split Column in Power Query

Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a column by the number of characters easily. How to Split Column in Power Query This is helpful when you have columns that you want to split by an equal number of characters, for...
Read More

Working with Excel Formula Shortcuts | Excel tips & tricks

What will you get in excel formula shortcuts? You will come to know every single excel formula shortcuts and how to use it. You can use this shortcuts you optimize your daily work. With the help of this tutorial, I had helped almost 10000+ visitors to improve the skills and save time at the office....
Read More

Pivot Table in Excel for Beginners to Advanced User’s

INTRODUCTION TO PIVOT TABLE IN EXCEL When you have a large amount of data in your worksheet and you can’t analyze or sort the data then Pivot Table in Excel helps you to carry out the task easily and more conveniently. Pivot Tables are powerful functions in excel. We are going to start with what...
Read More
1 2 3 4 5 15