Welcome to our Power BI tutorial! In today’s session, we dive into creating a comprehensive report using SWOT analysis data for the telecom company X-Com. You can find the link to the source data in the comments below. We’ll guide you through the process step by step, starting with importing data from an MS Excel…
This video is a tutorial that explains how to create a smart, dynamic personal accounts manager using Microsoft Excel and pivot tables. The trainer in the video provides step-by-step instructions, starting with creating a chart of accounts and defining income statement and balance sheet categories. The trainer then goes on to explain how to freeze…
The video is a tutorial on how to use Pareto Charts in MS Excel and Power BI to analyze a hypothetical problem. The problem that is being analyzed is the reasons why people are late to their office. The video explains that a Pareto chart is a combination of bars and lines that displays percentages…
The video is a tutorial that guides the viewer through the process of creating an animated GPS route on a 3D map using Microsoft Excel. The presenter explains that to design this visualization, three columns are required: GPS coordinates in latitude and longitude, and a time column. To begin, the presenter suggests downloading GPS data…
In this video, the speaker explains how to unpivot data in Microsoft Excel and Power BI. The data used in the video is world population data downloaded from the World Bank, which is already pivoted, but not in the form of an Excel pivot table. The speaker wants to convert this data into an unpivoted…
In this video, we will show you how to use the fill features in MS Excel. These features allow you to quickly fill a range of cells with a series of data or a repeated value. This can be especially useful, when you need to enter a large number of similar values, or when you…
In this video, we will show you how to use lookup functions, and what is the difference between various lookup functions provided by MS Excel. #vlookup #vlookupformula #vlookupinexcel #vlookupfunction #xlookup #hlookup
