![](/wp-content/uploads/2022/09/course-header.jpg.webp)
News & Tips
![Graphic showing the formula to calculate a simple percentage.](/wp-content/uploads/2022/08/Picture1-1-768x160.png.webp)
Complete Guide To Percentages in Excel!
In this article, we will demonstrate how to calculate a percentage in Microsoft Excel, Word and PowerPoint. Additionally, we will go through some other important percentage related calculations. What is a Percentage? A percentage is defined, as a part or…
![Power BI Logo](/wp-content/uploads/2020/02/Power-BI-Logo.png.webp)
Power BI: Connecting Power BI to SQL Server
Power BI supports a variety of data sources such as Blank Queries, Flat Files, SQL Server Database, OData Feed, Azure Cloud Platform etc. The number of import features you have will depend on the version of Power BI that you…
![PowerBI logo](/wp-content/uploads/2022/01/powerbilogo-768x403.png.webp)
Comparing Power BI and SSRS
This article looks at the main differences between the Microsoft SSRS (SQL Server Reporting Services) and the Microsoft Power BI (Microsoft Power Business Intelligence). We compare the two Microsoft business intelligence tools against a number of criteria and then look…
![Box and whisker plot inserted](/wp-content/uploads/2023/11/Imagem38-768x367.png.webp)
Finding Outliers In Excel: A Detailed Guide
Microsoft Excel is an incredibly powerful data analysis tool that empowers users to store, analyse, and visualise data to derive valuable insights out of it. With so many basic and advanced level data analysis tools, Excel provides you with almost…
![Power BI’s merging and appending operations](/wp-content/uploads/2021/12/Power-BI-Merge-Queries-and-Append-Queries-1.png.webp)
Power BI Merge Queries & Append Queries
In this article, we will walk step-by-step through how to use Power BI merge queries, and Power BI append queries to combine data or for data preparation. You will also learn to use fuzzy matching features when merging queries in…
![Power BI Logo](/wp-content/uploads/2020/02/Power-BI-Logo.png.webp)
Power BI: Introduction To DAX
By the end of this introduction to DAX article, you will have a good all-round understanding of Power BI’s Data Analysis Expressions (DAX) language. DAX is the language behind Power BI, meaning all the potential in Power BI comes from…
![PowerBI logo](/wp-content/uploads/2022/01/powerbilogo-768x403.png.webp)
16 Power BI Interview Questions With Answers
Power BI is a data analysis and visualisation tool developed by Microsoft. Currently, it is one of the most sought-after skills for business intelligence analysts in particular and data scientists in general. This article covers some of the most common…
![](/wp-content/uploads/2023/11/Imagem12.png.webp)
Power BI Bubble Chart
Power BI is a powerful and versatile data visualisation tool, developed by Microsoft, that has revolutionised the way organisations make data-driven decisions. This intuitive and user-friendly platform enables users to connect to various data sources, transform raw data into insightful…
![](/wp-content/uploads/2023/11/Screenshot_8-1.jpg.webp)
Mastering Excel’s LEN Function
The LEN function in Excel calculates the number of characters in a text string, including spaces and punctuation. For example, using “=LEN(‘Excel Magic’)” would yield the result “11”. This function is essential for various data analysis tasks. Excel Function Details…
![](/wp-content/uploads/2023/11/Screenshot_9.jpg.webp)
Using The SEARCH Function In Excel
The SEARCH function in Excel is a powerful tool that locates one text string within another. It returns the starting position of the first text. For example, using “=SEARCH(‘Excel’, ‘I love Excel’)” would yield the result “8”, Excel Function Details…
![Influence writen on tiles](/wp-content/uploads/2023/09/pexels-arturoaez220-9168219-768x512.jpg.webp)
How To Win Friends & Influence People In 8 Key Points
In this series of blog posts, we’re going to look at some classic business books and discuss their main ideas. The big idea behind ‘How To Win Friends And Influence People ‘ is that how other people react to you…
![](/wp-content/uploads/2023/08/pexels-luis-gomes-546819-768x510.jpg.webp)
Top 3 SQL Learning Apps
With SQL’s undeniable significance in the current programming landscape, now is an opportune time to delve into this powerful language. In this article, we’ll explore the top 3 SQL learning apps, examining their features, pricing, suitability, and accessibility. If after…