This video tutorial introduces time intelligence calculations and their visualization using Power BI dashboards. It covers various time intelligence concepts, including time series, time bucketing, year-over-year comparison, moving averages, and year-to-date analysis. The tutorial demonstrates how to import data into Power BI, create different visualizations like pie charts and line charts, and perform calculations to…
This tutorial demonstrates how to integrate Google Forms responses with Power BI Desktop to create interactive visualizations. It covers creating a Google Form, collecting responses, and connecting the resulting spreadsheet to Power BI. The video then walks through building a dashboard with various charts to analyze the collected data, including using AI to calculate values…
This video tutorial demonstrates how to use Power BI to perform a weighted decision matrix analysis on a set of projects. We start by loading an Excel file containing project details, criteria, scores, and weights. Then, we create a new table called “Weighted Score” and populate it with the product of score and weight for…
This video tutorial describes the drawing tools available in Excel. It covers adding the Drawing tab to the ribbon if it’s missing, using pens, pencils, and highlighters to draw and erase, selecting drawings, and converting freehand drawings to clean shapes. It also explains how to use the action pen to write text and formulas directly…
Unicode characters are a special coding system that allows computers to display a vast variety of text and symbols from different languages. These characters are not images, but they can be used to represent images and even create fancy lists and other visual elements within your spreadsheets or dashboards. There are different Unicode codes for…
This video tutorial is about creating pivot tables with images in Microsoft Excel, a newly introduced feature. It walks you through the process step-by-step, starting with creating a new sheet for photos and adding images of salespeople next to their names. Then it explains how to use VLOOKUP function to bring those photos into the…
This video tutorial will guide you through using the new chart pane in Microsoft Excel Online to format and style your charts. What you’ll learn:Accessing the chart paneFormatting chart elements (title, legend, axis, gridlines)Data label optionsAdding error barsUsing trendlinesData table settings Video Outline:We’ll use sample data to create a chart.Pivot tables won’t work with the…
Welcome back, everyone! In this unique tutorial, we’ll guide you through creating a dynamic dashboard in Microsoft Excel using Python. Specifically tailored for those keen on mastering Python visualizations, we’ll delve into the world of Excel charts powered by Python’s Matplotlib library. Notably, unlike Excel’s native charts, Python charts seamlessly integrate within cells, providing a…
Welcome to our Python tutorial! In today’s session, we’ll delve into the process of uploading images to Google Colab using Python. We’ll then proceed to resize these images and convert them into base 64 format for integration into Power BI visuals. To get started, open a new notebook in Google Colab and rename/save it. In…
In this YouTube tutorial, we will walk you through the process of Power BI Data Modeling and Visualization. We will start by creating a data model from an MS Excel-based data set, and then proceed to build a dashboard using that data model. Our dataset contains a wide range of information, including sales, products, product…
