fbpx

Category

Tutorials

Power Query Helps In Transposing Data

Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an example with the picture is given below.   Transposing Data By Power Query Let’s go through the steps in detail for transposing data. Step 1: Open the data in Power Query Open the...
Read More

Best Tableau Training & Certification Courses

Data Scientists and Analysts always struggled for making reports of the voluminous data generated and the most dangerous thing was to analyze this huge data. Even a minute mistake could cause severe damage to the well-being of the organization. All these worries came to an end as Tableau emerged in the market. Here is the...
Read More

Working with Excel Sumif Formula

When I ask professionals in my workshops – “Which is the ONE formula you’ll pick if you were asked to choose JUST ONE?” Most of the answers hover around INDEX, VLOOKUP and IF. But they tend to forget Excel Sumif. You know what MY answer is – Excel SUMIFS()! And I will tell you why. Excel Sumif...
Read More

How to Attach File in Excel or Object in Excel Spreadsheet

Want to attach an existing or new file in excel? then you land on the perfect page. You can check our ultimate guide about how to attach a file in excel or an object. Still, there are multiple ways to attach a file in excel. Here we discuss some uncommon & common methods to attach...
Read More

Download Power BI Templates | Power BI Tutorials

When you are using Power BI for your report analysis, you also need to create a few dashboards that can be really helpful and used often. You can restructure your process and update your reports by creating Power BI templates that give you the ability to upload a number of data sources and automatically rebuild...
Read More

Data Science Certification Courses That Will Pay Off

The greatest career trends of this era involve the career as a Data Scientist. To become a Data Scientist and to get hired by top MNCs, a professional Data Science certification is a must. Professional Data Science Certification involves to get certified from a known institute and provide rich knowledge that does justice with the...
Read More

Python for Finance Course

Python is gaining its popularity over all the other programming languages. The aspiring learners are gradually seen to incline towards learning Python. The reason for this change is that Python has the best quality of readability. It resembles the known language of English and that is why easy to catch up, unlike other languages that...
Read More

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

Learn How to Update and Delete Using Excel VBA Userform? It’s useful for making a task easy in business areas like Banking records, Personal Finance, Stock Reporting, Recordkeeping, Automate Training room booking, Hotel Room booking, Car Booking, booking IT resources and approval of business expenses such as refreshments, conveyance, stationery, etc. Download Sample FilesThis technique...
Read More

How to Lock Formulas in Excel?

How to Lock Formulas in Excel? Protect formula in Excel? Confused? Here is the blog to know how to lock excel formulas. Imagine Your boss wants you to protect a workbook, but she also wants to be able to change a few cells after you are done. So, before you password protected the workbook (or...
Read More

INDEX Formula in Excel

Excel Index Formula is probably one of the most favorite Excel Formulae of many. In my previous post, I had mentioned my favorite Excel formula. And it was not INDEX(). In my excel training sessions, when I happen to ask my participants about their favorite Excel formula, I am not surprised to hear the answer...
Read More

Create Magnifier Glass Effect in Powerpoint Picture

I frequently visit the “Investor Relations” section of numerous companies. On one such occasion, I stumbled upon an Investor PowerPoint Presentation of a Global Auto major (BMW Jan 2014). I was mesmerized by the look of a PowerPoint picture in certain slides and started exploring techniques on how to highlight in PowerPoint slides.   The...
Read More

Top 5 Essential Power BI Data Types

Power BI is a self-service data analytics and visualization tool. Power BI is now pre-integrated in office 365 product suit. Power BI integrates well with all Microsoft products. In this article, we discussed the top 5 Essential Power BI Data Types & its uses. A data type is necessary whenever you are dealing with the...
Read More

PowerPoint Picture Tools to Create Magnifier Glass Effects

Learn a new PowerPoint trick using picture tools: Magnifier Case Study: Let’s say my company has launched a new water dispenser. I would like to highlight the new features of the product. To do so, I will like to use a magnifier like an effect to attract the viewers attention (Picture tools). This is a...
Read More

Alteryx vs KNIME Comparison | Data Analytics tools

Comparison Between Alteryx vs KNIME Data Analytics Platform. Alteryx is a self-service data analytics tool. Alteryx makes the process of ETL easier. Alteryx is a super tool that combines the functionalities required for Data Preparation, Geo-Spatial Analytics, and Data Science. Before knowing the exact difference between Alteryx and KNIME you should know What is Alteryx...
Read More

QlikSense Vs Power BI

The need of the hour is to carry out the best data analytics of your business to make it successful. To carry out the analytics, it is necessary to have the perfect tools and methods. There are many data analytics tools available in the market but to find which is best suited for you is...
Read More

How to Embed Tableau Dashboard/Reports on the WebPage

The importance of creating reports or dashboards in Tableau is to share it across to the individuals who can get benefit from it. There are many ways to share, but the most interactive way is to embed Tableau Dashboard on a webpage. There are many possible reasons to embed Tableau dashboard in webpages. Here we...
Read More

Quartile Function in Excel

The Quartile Function in Excel helps to return the quartile of a data set in Excel. Going further in this tutorial, you’ll see how to find Quartile using Excel. You’ll observe that the Quartiles are several times used in sales and also while inspecting the sample data. The Quartile Function in Excel will support you while...
Read More

QlikSense Vs Tableau – Comparison Between BI Tools

Qlik Sense vs Tableau: It is no doubt that today’s business relies completely on data analysis for successful strategies and decisions. As the importance of data is increasing there are very few platforms available for the analysis of Big data. There are two most prominent tools for business intelligence and data analytics – Qlik Sense...
Read More
1 2 3 4 16