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…
In this Power BI tutorial, we welcome you to explore new features in Power BI Desktop. The tutorial covers the creation of a dashboard using these features, beginning with loading data into Power BI Desktop using the “Get Excel Workbook” button. The presenter demonstrates the addition of a title to the dashboard, utilizing rounded corners…
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…
In this instructional session, finance professionals are guided through the process of managing assets and presenting financial data in charts. The focus is on calculating depreciation, accumulated depreciation, and net book value using two methods: straight line and declining balance. The tutorial demonstrates how to incorporate these calculations into a Power BI dashboard, emphasizing their…