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…
This video tutorial is about creating a mobile-friendly dashboard in Power BI. It starts by guiding you through how to import data from a website and design visuals in the desktop layout view. Then it explains how to switch to the mobile layout view and arrange the visuals appropriately for mobile devices. Finally, it demonstrates…
This Power BI tutorial introduces new features like DAX Query View, New Card Visual, New Button Slicer, Visual Calculations, On Object Interaction, Build a Visual Button, Dynamic Values, Pane Switcher, Analyzer, etc. It then demonstrates how to create a dashboard using these features, explaining each step along the way. The video covers connecting to data,…
In this power BI visualization tutorial, we focus on comparing sales data from a vertical dataset across different years. Beginning with data transformation in the Power Query Editor, we progress to creating a comparative visual for a dashboard. Step by step, we navigate through loading data, adding visual elements like text boxes and line charts,…
This video tutorial explores various methods for generating data in Power BI without relying on external sources. It starts by highlighting the limitations of manual data entry and then introduces M language, a powerful tool for data manipulation and transformation. Different techniques are demonstrated, including creating lists, tables from rows or columns, and generating random…
This video tutorial explores various methods for generating data in Power BI without relying on external sources. It starts by highlighting the limitations of manual data entry and then introduces M language, a powerful tool for data manipulation and transformation. Different techniques are demonstrated, including creating lists, tables from rows or columns, and generating random…
In this Python forecasting tutorial, we delve into predicting future global temperature changes using the SARIMA model, utilizing both Python and MS Excel. We start by acquiring data from NASA’s global climate change website and loading it into Python using the Pandas library. After cleaning and formatting the data, we construct our SARIMA model, setting…
The tutorial starts by guiding you through creating a table in SQL Server to store game data like turn number, player scores, and dice rolls. Then, it demonstrates writing DAX code in Power BI to calculate turn order, roll dice, update scores, and determine the winner. Finally, it shows how to create an interactive dashboard…
In this MS Excel tutorial, the instructor introduces the newly added group by function to create a live search engine without using macros, coding, or add-ins. The tutorial begins by setting up the data in a sheet named “data” with product details. The process involves renaming sheets, adding freeze panes, and formatting. The instructor then…