ViSIT
ViSIT
  • 247
  • 675 202
Creating Custom Functions in Excel without using VBA: A Deep Dive into LAMBDA
Traditionally, custom functions in Excel were created using VBA, a programming language. However, Microsoft introduced the LAMBDA function in 2020, allowing users to create custom functions without coding. Inspired by lambda calculus, LAMBDA functions are defined with a name, parameters, and a formula. They can be used directly or named for future reference. By using descriptive parameter names, LAMBDA functions enhance readability and understanding, making complex calculations more transparent. This powerful tool empowers users to create tailored solutions within Excel, streamlining workflows and automating tasks.
#Excel #LambdaFunction #VBA #CustomFunctions #ExcelTips #ExcelTutorial #MicrosoftExcel #Excel2020 #ProductivityTips #AutomateExcel
Переглядів: 9

Відео

Python Lesson 002: Communicating with Python using Print() and Input() Functions
Переглядів 5316 годин тому
Python offers a straightforward way to interact with the user through the print() and input() functions. The print() function displays information on the console, taking one or more arguments like strings, numbers, or variables. It can also be used to format output, write to files, and display results in real time. The input() function prompts the user for input, capturing it as a string. This ...
Python Lesson 001: Introduction, Installation, and Other Options
Переглядів 12114 днів тому
This video provides a comprehensive introduction to Python, covering various aspects from installation to online usage and integration with Excel and Power BI. It highlights the versatility of Python, its applications in diverse fields, and the multiple ways to access and utilize it. The video also demonstrates basic Python code examples, such as variable assignment, arithmetic operations, and ...
Power Pivot Advanced Concepts - A Complete Guide to Power Pivot
Переглядів 29521 день тому
This tutorial provides a comprehensive overview of Power Pivot in Excel, covering topics such as data modeling, creating relationships, working with measures and KPIs, using OLAP tools, calculated columns, perspectives, and synonyms. It also demonstrates how to enable Power Pivot, connect to external data sources, and create pivot tables and charts. Additionally, the tutorial explains how to us...
SQL: Pivot and Unpivot Data in SQL Server Database Including Multiple Columns - A Step-By-Step Guide
Переглядів 269Місяць тому
This tutorial provides a comprehensive guide to pivoting and unpivoting data within SQL Server. We'll delve into the process of transforming data from a row-based to a column-based format, and vice versa. You'll learn how to pivot data based on single or multiple columns, as well as how to unpivot pivoted data to restore its original structure. Through practical examples and step-by-step explan...
Power BI: Creating Business Intelligence Dashboards from SQL Server Tables and Views
Переглядів 498Місяць тому
This tutorial demonstrates how to create a comprehensive Power BI report using data from a SQL Server database. We'll delve into various analytical techniques, including geographic analysis, branch-wise performance, and deposit movement. The report will feature interactive dashboards with visualizations like maps, charts, and tables. By the end, you'll be able to create insightful reports that ...
Analysing Data in SQL Server Database Using Views - Bank Accounts Analysis Example
Переглядів 3072 місяці тому
This video tutorial introduces SQL views and demonstrates how to create and use them for data analysis. It begins by explaining what views are and their purpose, then proceeds to use a hypothetical bank database, Nexus Bank, as an example. The tutorial covers creating tables, importing data from CSV files, and building various views to combine and analyze data from different tables. Topics incl...
Time Intelligence in Power BI: A Visual Guide
Переглядів 6152 місяці тому
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...
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Переглядів 3762 місяці тому
This tutorial demonstrates how to generate HTML documents using SQL queries. By embedding HTML code within SQL queries, you can create dynamic reports containing text, charts, and other elements. This approach eliminates the need for separate applications and streamlines the report generation process. The tutorial covers topics such as creating SQL tables, inserting data, using HTML, JavaScript...
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
Переглядів 3743 місяці тому
The video tutorial demonstrates how to use Gemini to analyze data using SQL without writing SQL queries manually. It covers topics such as describing scenarios in text or providing pictures to Gemini for query generation, modifying queries to achieve desired results, creating views for permanent query results, and using Gemini to create tables and insert data. The tutorial emphasizes the effici...
Using Dropdown Lists Effectively to Summarize Data and Build Dashboards and Reports in MS Excel
Переглядів 4163 місяці тому
The video tutorial demonstrates how to create a comprehensive report in MS Excel using a drop-down list. The tutorial begins by explaining how to set up a data set with quarterly sales information, including location details. It then guides viewers through the process of creating a drop-down list, which allows users to select specific countries, regions, or stores. The tutorial also covers how ...
Build a Stunning Animated Olympics Javelin Dashboard with Power BI
Переглядів 3194 місяці тому
This tutorial demonstrates how to create an animated Power BI dashboard showcasing Olympic javelin gold medalists. Starting with AI-generated data, we guide you through building a dashboard with key metrics like longest throw, athlete information, and historical performance trends. The process involves using various Power BI visuals, formatting for aesthetic appeal, and incorporating a play axi...
Analyse and Visualize Google Forms Responses using Power BI by Integrating Forms with Power BI
Переглядів 1 тис.4 місяці тому
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 within the dashboard...
Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server
Переглядів 1,2 тис.4 місяці тому
Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server
Real time Monitoring with Power BI and SQL
Переглядів 1,1 тис.5 місяців тому
Real time Monitoring with Power BI and SQL
Creating and Using Flow Maps in Power BI with Free Dataset
Переглядів 1,6 тис.5 місяців тому
Creating and Using Flow Maps in Power BI with Free Dataset
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Переглядів 1,1 тис.5 місяців тому
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Переглядів 2726 місяців тому
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Переглядів 3586 місяців тому
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Переглядів 4,9 тис.6 місяців тому
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
Переглядів 6726 місяців тому
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
Complete Guide to Using Drawing Tools in MS Excel #tutorial #drawingtools #excel #howto #learn
Переглядів 3317 місяців тому
Complete Guide to Using Drawing Tools in MS Excel #tutorial #drawingtools #excel #howto #learn
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement
Переглядів 11 тис.7 місяців тому
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement
Monitoring Progress Using Gantt Chart - Indigeno Technologies Part 3
Переглядів 1227 місяців тому
Monitoring Progress Using Gantt Chart - Indigeno Technologies Part 3
Creating a Dashboard of Sales Process and Pregress (Indigeno Technologies Part 2)
Переглядів 1357 місяців тому
Creating a Dashboard of Sales Process and Pregress (Indigeno Technologies Part 2)
Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1)
Переглядів 3047 місяців тому
Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1)
Creating and Publishing Web Applications using HTML and JavaScript: A Unicode Symbol Generator
Переглядів 1047 місяців тому
Creating and Publishing Web Applications using HTML and JavaScript: A Unicode Symbol Generator
Make Your Data Grow: Tree Stats with Power BI
Переглядів 1817 місяців тому
Make Your Data Grow: Tree Stats with Power BI
Power BI: Adding Historical Data to Existing Dashboard in Power BI - Staff Engagement Report Part-II
Переглядів 1,1 тис.8 місяців тому
Power BI: Adding Historical Data to Existing Dashboard in Power BI - Staff Engagement Report Part-II
We asked an AI to create a web application for us. Learn to build apps without any coding.
Переглядів 2128 місяців тому
We asked an AI to create a web application for us. Learn to build apps without any coding.

КОМЕНТАРІ

  • @reggieledoux7983
    @reggieledoux7983 9 днів тому

    Hello, how to expand Parent and Task column?

  • @RajarshiKallaagunta
    @RajarshiKallaagunta 9 днів тому

    with out autorefresh is that we can schedule refresh in the direct query mode

    • @virtual_school
      @virtual_school 9 днів тому

      Microsoft has removed support for various real time methods for power bi. And in power bi desktop, autorefresh is the best method their is. Alternate methods require other applications, and they are not as simple and efficient.

  • @mujibulhaque4914
    @mujibulhaque4914 11 днів тому

    I am from Bangladesh and a 70 years old retired designer as well as an artist And thinking to start learning animation video. Its a very helpful tutorial for the beginner. I generally use hand drawing, illustrator, Photoshop, krita etc. for my design & painting. Thank you very much for your nice tutorial.

  • @Albert_Taban
    @Albert_Taban 12 днів тому

    Why the auto refresh is not displaying?

    • @virtual_school
      @virtual_school 12 днів тому

      Are you sure you chose DirectQuery and not Import?

    • @Albert_Taban
      @Albert_Taban 12 днів тому

      I created a template.xlam path directory Microsoft>AddIns, the template.xlam is already have vba code. And I already check the template

    • @Albert_Taban
      @Albert_Taban 12 днів тому

      I tried to add the realtime_updater from you google drive and copied into the AddIns folder, when I add as an addins it says "This file type is not supported in Protected Vie"

    • @virtual_school
      @virtual_school 12 днів тому

      @@Albert_Taban Sorry, plz ignore my previous reply, let me look into it.

    • @Albert_Taban
      @Albert_Taban 12 днів тому

      @@virtual_school okay sir/ma'am thank you for your guidance.

  • @Wild_Creations
    @Wild_Creations 18 днів тому

    My power Bi formate not understanding the comman "Timestamp".

  • @virtual_school
    @virtual_school 20 днів тому

    As identified by @sapelko80, discount (at ua-cam.com/video/GivV2lBkXYA/v-deo.html) is in percentage but wrongly formatted as currency. Please treat it as percentage. The formatting has no affect on the calculation. Answer will be same in any case.

  • @sapelko80
    @sapelko80 20 днів тому

    Great video. At 11.00 it's slightly confusing that Discount has been formatted as Currency but then treated as a Percentage.

    • @virtual_school
      @virtual_school 20 днів тому

      Thanks for your worthy feedback. And good catch by the way. Discount is actually in percentage, but I wrongly formatted the column as currency. Although has no affect on end result.

  • @carltonseymour869
    @carltonseymour869 20 днів тому

    How does one show percent complete at the parent level?

    • @virtual_school
      @virtual_school 20 днів тому

      By parent you mean group (which in this tutorial is project name)? when you collapse children, the percentage of group is created. It is derived from children.

    • @carltonseymour869
      @carltonseymour869 20 днів тому

      @@virtual_school yes, but the % is not showing up in the parent level in Power BI using the Microsoft Gantt Chart

    • @virtual_school
      @virtual_school 19 днів тому

      @@carltonseymour869 Unfortunately this visual does not have that option for parent. Parent is meant for grouping and organizing only in this visual.

  • @virtual_school
    @virtual_school 21 день тому

    Link to the excel file: docs.google.com/spreadsheets/d/1Tx0AFbIfbp2EI0mdfKfxRIeOG1xH6hNp/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true

  • @KADAPADHANUNJAY
    @KADAPADHANUNJAY 24 дні тому

    can u plz send me the data what which you are applied

    • @virtual_school
      @virtual_school 23 дні тому

      Data is available in online sql server as mentioned here: ua-cam.com/video/1OxFtV-SKKo/v-deo.html

  • @benpienaar2310
    @benpienaar2310 26 днів тому

    I am having some serious issues with the date format that is in your spreadsheet. It keeps transforming in the completely wrong format in BI. Please advise

  • @Ola-iu6zc
    @Ola-iu6zc 28 днів тому

    Thanks for this. Please how can I find my username and password to access the report from another device?

  • @jamesm.sumojr8486
    @jamesm.sumojr8486 Місяць тому

    Your Video hub is of knowledge and it take my experience to another level.

  • @ck2610
    @ck2610 Місяць тому

    does it needs a seperate time table in the model ?

    • @virtual_school
      @virtual_school Місяць тому

      You have to tell the chart when a task is starting and when it is ending.

  • @bharaths5906
    @bharaths5906 Місяць тому

    Hey, hope you are doing well. I am building a report in power bi for which my source is from SQL. I had joined two tables and did some transformations in SQL itself. Now i am having a derived table from the exiting tables. I need to connect this cleaned table to power bi. Can i create a view for the transformed table and connect to power bi. If yes, will the views table get updated if the underlying tables are being updated. Kindly help I created a view and connected it to power bi, but want to know if there are any other ways.

    • @virtual_school
      @virtual_school Місяць тому

      Views work just as tables. Any data updated in tables, will automatically be updated in views, and subsiquently in your power bi dashboard. (You have to refresh if using import, otherwise it will update automatically if using direct query).

    • @bharaths5906
      @bharaths5906 Місяць тому

      @virtual_school That's great. Thanks for the reply

  • @1ndin414
    @1ndin414 Місяць тому

    Thank you so much

  • @virtual_school
    @virtual_school Місяць тому

    Link to the dataset: docs.google.com/spreadsheets/d/1lzMWDdQNZq9WREZSRjxiXRHaxFpeItvE/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true

  • @akhtarjavaid6183
    @akhtarjavaid6183 Місяць тому

    Where is the data file (excel ) that u import to power Bi..?

    • @virtual_school
      @virtual_school Місяць тому

      ua-cam.com/users/redirect?event=video_description&redir_token=QUFFLUhqa25GVGdldlU5VlhvNTBuN08xNGNmRE5lVkxtUXxBQ3Jtc0ttUGd5ai1hZkY5aVRrdGEySTVWdGhnMWZ5OEE3TzE5YmRONFpZNjhVMXhvQ2Z0aVpsTjRLX3BQOE1IUFA4emJvY09uUHNPVDNnVk9ZTEhQRTUwbHgzVURMNEFFd1IwVTNJODg5b25CUDZ6V1M3SVU2VQ&q=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1RnC45-pz-R-oRV3AjVyNU11bPlZwqj5g%2Fedit%3Fusp%3Dshare_link%26ouid%3D110287700425339553017%26rtpof%3Dtrue%26sd%3Dtrue&v=duvQJEH1Als

  • @arsalraza3997
    @arsalraza3997 Місяць тому

    Thanks for the detailed video.

  • @virtual_school
    @virtual_school Місяць тому

    Link to the SQL server database, Power BI file, and Custom Visual used in the tutorial: drive.google.com/file/d/1Ewxf714AsZzeIhK9AZsCVEPLaSS8skmX/view?usp=sharing Previous Video related to this one: ua-cam.com/video/7O9dHPGd_CM/v-deo.html

  • @betagav
    @betagav Місяць тому

    Just what've spent the last 2 days trying to find! Thank you.

  • @productreviews-q7p
    @productreviews-q7p Місяць тому

    Python code is not working please help me out

  • @anisnajwa1640
    @anisnajwa1640 Місяць тому

    Hi sir. I am not understand at minute 7:15, what do you mean for "but you can get one from online store as well" ?

    • @virtual_school
      @virtual_school Місяць тому

      You can get all Power BI custom visuals from Microsoft Store which is online.

    • @jerrygault6860
      @jerrygault6860 Місяць тому

      @@anisnajwa1640 There is a free Microsoft Gantt chart available, or you can buy one of many.

  • @aghanawazan
    @aghanawazan Місяць тому

    Thanks but It works with only desktop, what about after publishing the report. we need to connect with gateway and schedule to refresh the data.

    • @virtual_school
      @virtual_school Місяць тому

      Power BI is going through major changes. They have removed realtime support on power bi service. It was expected, therefore I never used one of those in my tutorials. powerbi.microsoft.com/en-us/blog/announcing-the-retirement-of-real-time-streaming-in-power-bi/

  • @sumitbhadrecha8211
    @sumitbhadrecha8211 Місяць тому

    it is not working. Can you help me.

    • @virtual_school
      @virtual_school Місяць тому

      Do you have the latest version of excel? 365?

  • @Naruto-td7oo
    @Naruto-td7oo Місяць тому

    For those that are wondering why they just can't find the 3D map button, Microsoft moved it to another location: It is now in Data -> Data tools (Sub-category) -> Manage Data Model (Little green icon) -> 3D maps.

    • @virtual_school
      @virtual_school Місяць тому

      Good catch. Data -> Data Tools -> Data Model -> 3D Maps

  • @anthonytomastomontanez9929
    @anthonytomastomontanez9929 Місяць тому

    Awesome, thanks

  • @chavezjjavier2517
    @chavezjjavier2517 Місяць тому

    Hello, i can't access to the xampp dashboard with my public ip address even when i did the port mapping on my router page, what do you think is happening?

    • @virtual_school
      @virtual_school Місяць тому

      Your ISP may not be allowing this. Consult with your internet service provider, they will guide you. They may charge something for this in your monthly bill as well.

  • @luiscahuana310
    @luiscahuana310 2 місяці тому

    Thanks so much

  • @virtual_school
    @virtual_school 2 місяці тому

    Link to the datasets: drive.google.com/file/d/1cZTgMxA3MY9k2KXQ4PnUrRmFa18a1VV3/view?usp=sharing

  • @p22caroj
    @p22caroj 2 місяці тому

    Thanks for your step-by-step video. I finished the tutorial because I wasn't able to find my error. My problem was that I made incorrect links between tables.

    • @virtual_school
      @virtual_school 2 місяці тому

      It is good that you found your problem. Good luck.

  • @Tech_with_Srini
    @Tech_with_Srini 2 місяці тому

    You have Used YTD in complex way, We can achieve simply by TOTALYTD , And For 2023 and 2022 sales, we can simply apply FILTER in CALCULATE Function

  • @birdywen8608
    @birdywen8608 2 місяці тому

    The indentations of the HTML code were lost after pasting it from the VSCode editor. How can this issue be resolved? Thanks.

    • @virtual_school
      @virtual_school 2 місяці тому

      Sir, you must understand that SSMS or any SQL Editor is SQL Editor, not HTML editor, therefore it will not keep any formatting, indents etc. You will have to enter html code inside ' ', and use the TAB button to create indents for yourself. Like: Insert '<div>' union all Insert ' This is a div element' union all Insert '</div> So use TAB button to create indents and use HTML code inside SQL code, not just HTML copied from VSCode. Thanks

  • @carltonseymour869
    @carltonseymour869 2 місяці тому

    Is there a reason to use cross filtering between the Timesheet Fact table and the other Dimension Tables

    • @virtual_school
      @virtual_school 2 місяці тому

      No perticular reason, you can use other filter options as well (as long as they work perfectly).

  • @TwilightError
    @TwilightError 2 місяці тому

    Don’t use crap voice over software

    • @virtual_school
      @virtual_school 2 місяці тому

      If your focus is that, my friend you will face difficulty learning about Gantt Charts and Power BI.

  • @virtual_school
    @virtual_school 2 місяці тому

    Dataset and Power BI file drive.google.com/file/d/1BoFTm4LIfVG4Eo5PfgaqghtuH2bggm7P/view?usp=drive_link

  • @pushpendrakumar1361
    @pushpendrakumar1361 2 місяці тому

    If i am using other than Huawei network, Then configure from here only?

    • @virtual_school
      @virtual_school 2 місяці тому

      Configuration is more or less same on all devices. You can also take help from your service provider. You pay them for that.

    • @pushpendrakumar1361
      @pushpendrakumar1361 2 місяці тому

      One more doubt, I am using AWS VM, How can i get this network setting for bridged adapter?

  • @birdywen8608
    @birdywen8608 2 місяці тому

    Amazing!

  • @matheusfariaseng
    @matheusfariaseng 2 місяці тому

    i'm from Brazil, tank you so much for very valuable content

  • @teachtime3094
    @teachtime3094 2 місяці тому

    How can we do same thing for Telegram channels?

    • @virtual_school
      @virtual_school 2 місяці тому

      They have APIs as well, and you will have to study it and find a way.

    • @teachtime3094
      @teachtime3094 2 місяці тому

      @@virtual_school Than you for answering. I need some adcives. How Can I get insights from vizualized data and tell to the manager?

  • @osuohauchechi9316
    @osuohauchechi9316 2 місяці тому

    I used superstore dataset will it affect my work

  • @osuohauchechi9316
    @osuohauchechi9316 2 місяці тому

    Hello

  • @birdywen8608
    @birdywen8608 2 місяці тому

    Your video tutorials are so creative. I benefit a lot from each video, both in terms of skills and inspiration. Thank you.

    • @virtual_school
      @virtual_school 2 місяці тому

      Thanks. Thats very kind of you. I try to share what I am working on and find it to be unique.

  • @virtual_school
    @virtual_school 2 місяці тому

    Excel file: docs.google.com/spreadsheets/d/1yXErU2jVp9OBsAPbxEdi2qPu_0RJHxcL/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true

  • @kurienillirickal7195
    @kurienillirickal7195 2 місяці тому

    How to add different excel sheets in one power bi and connect it thru labels or buttons on the left side? Means by clicking on each label, power bi sheets are changing with different information.

    • @virtual_school
      @virtual_school 2 місяці тому

      It is easy. Just add all sheets into power bi data pane and then use information from all of them to create power bi report with multiple pages. I will try to create a tutorial on that.

  • @EdwinOduol-n8c
    @EdwinOduol-n8c 2 місяці тому

    Well Done!!!

  • @EdwinOduol-n8c
    @EdwinOduol-n8c 2 місяці тому

    Great job. Well done!!!