ViSIT
ViSIT
  • Видео 241
  • Просмотров 604 629
Analysing Data in SQL Server Database Using Views - Bank Accounts Analysis Example
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 include creating views for data analysis, summarizing data by branch, performing interest rate and year-wise analysis, tracking account movements, and analyzing new account openings. The tutorial concludes by emphasizing the usefulness of views for efficient data analysis and providing a glimpse into fu...
Просмотров: 200

Видео

Time Intelligence in Power BI: A Visual Guide
Просмотров 48614 дней назад
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)
Просмотров 27021 день назад
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
Просмотров 283Месяц назад
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
Просмотров 346Месяц назад
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
Просмотров 2782 месяца назад
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
Просмотров 6142 месяца назад
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
Просмотров 9943 месяца назад
The provided subtitle describes an advanced Power BI tutorial on creating real-time data connectivity through change detection and auto-refresh. Goal is to create a Power BI project enabling real-time data entry into a SQL Server database from the Power BI dashboard. - Create new tables in the SQL Server database (buyers, products, sales). - Modify table structures (change data type, add column...
Real time Monitoring with Power BI and SQL
Просмотров 8593 месяца назад
This video tutorial demonstrates how to set up a real-time call center monitoring dashboard using Power BI and SQL Server. The data for the dashboard comes from call logs stored in a SQL Server database. The call logs include information such as the date and time of the call, the origin and destination of the call, the call duration, and the call rating. The dashboard uses a variety of visuals ...
Creating and Using Flow Maps in Power BI with Free Dataset
Просмотров 1 тыс.3 месяца назад
This tutorial explains how to create a flow map visualization in Power BI to show product exports from China to various countries around the world. It covers downloading a custom flow map visual, preparing the data, and using the visual to create a dashboard. #PowerBI #FlowMap #DataViz #ExportMap #Tutorial #BusinessIntelligence #Dashboard #CustomVisual #StarInternational
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Просмотров 6814 месяца назад
This Looker Studio tutorial creates a data model (blend) from a sample Atlas Furniture dataset with multiple tables in Google Drive. It covers how to add data sources (tables), create relationships between them, manage data sources, and edit blends. It also demonstrates how to add calculated fields and handle limitations when working with many tables. Finally, it shows how to create a basic das...
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Просмотров 1904 месяца назад
Power Pivot is a powerful tool in Excel that allows you to work with large and complex datasets. It can import data from various sources and create data models with connected tables. You can also use DAX functions to create new columns and perform calculations. Finally, you can create pivot tables and charts to analyze your data. This tutorial guides you through the process of setting up Power ...
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Просмотров 2634 месяца назад
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 each project-criteria combination. Using various visualizations like bar ...
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Просмотров 2,7 тыс.4 месяца назад
This tutorial explains how to use custom SQL queries in Power BI to manipulate data before loading it. It covers connecting to a SQL Server database, entering a custom SQL statement, and modifying the query afterwards. The video also demonstrates how this can be used to filter data based on specific criteria and create visualizations. #PowerBI #SQL #Tutorial #CustomQueries #DataCleaning #DataMa...
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
Просмотров 5035 месяцев назад
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
Просмотров 2035 месяцев назад
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
Просмотров 8 тыс.5 месяцев назад
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement
Monitoring Progress Using Gantt Chart - Indigeno Technologies Part 3
Просмотров 1085 месяцев назад
Monitoring Progress Using Gantt Chart - Indigeno Technologies Part 3
Creating a Dashboard of Sales Process and Pregress (Indigeno Technologies Part 2)
Просмотров 1295 месяцев назад
Creating a Dashboard of Sales Process and Pregress (Indigeno Technologies Part 2)
Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1)
Просмотров 2865 месяцев назад
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
Просмотров 926 месяцев назад
Creating and Publishing Web Applications using HTML and JavaScript: A Unicode Symbol Generator
Make Your Data Grow: Tree Stats with Power BI
Просмотров 1706 месяцев назад
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
Просмотров 8636 месяцев назад
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.
Просмотров 1946 месяцев назад
We asked an AI to create a web application for us. Learn to build apps without any coding.
Power BI: Staff Engagement Dashboard with Data Transformation from MS Excel
Просмотров 5426 месяцев назад
Power BI: Staff Engagement Dashboard with Data Transformation from MS Excel
Using Unicode Symbols in Excel and Power BI and Converting Symbols to Code and Back in Excel
Просмотров 4036 месяцев назад
Using Unicode Symbols in Excel and Power BI and Converting Symbols to Code and Back in Excel
Power BI: Timesheet Analysis | Construction Co. Example | Worker Hours Report | Project Management
Просмотров 2 тыс.6 месяцев назад
Power BI: Timesheet Analysis | Construction Co. Example | Worker Hours Report | Project Management
Time Machine for Your Database: Track Every Change with SQL Server
Просмотров 3936 месяцев назад
Time Machine for Your Database: Track Every Change with SQL Server
Azure Data Studio - Complete Guide for Beginners including SQL, Python, Sanddance and Dashboards
Просмотров 7826 месяцев назад
Azure Data Studio - Complete Guide for Beginners including SQL, Python, Sanddance and Dashboards
Power BI: Creating a Stunning HR Performance Dashboard using Images and Slicers and Visuals
Просмотров 3316 месяцев назад
Power BI: Creating a Stunning HR Performance Dashboard using Images and Slicers and Visuals

Комментарии

  • @fantasy-371
    @fantasy-371 День назад

    Python code is not working please help me out

  • @anisnajwa1640
    @anisnajwa1640 2 дня назад

    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 2 дня назад

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

    • @anisnajwa1640
      @anisnajwa1640 2 дня назад

      @@virtual_school need to buy or it is free download? how can I get it, sir?

  • @aghanawazan
    @aghanawazan 2 дня назад

    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.

  • @sumitbhadrecha8211
    @sumitbhadrecha8211 2 дня назад

    it is not working. Can you help me.

  • @Naruto-td7oo
    @Naruto-td7oo 2 дня назад

    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 2 дня назад

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

  • @anthonytomastomontanez9929
    @anthonytomastomontanez9929 4 дня назад

    Awesome, thanks

  • @chavezjjavier2517
    @chavezjjavier2517 5 дней назад

    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 3 дня назад

      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 8 дней назад

    Thanks so much

  • @virtual_school
    @virtual_school 10 дней назад

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

  • @p22caroj
    @p22caroj 12 дней назад

    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 12 дней назад

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

  • @Tech_with_Srini
    @Tech_with_Srini 12 дней назад

    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 12 дней назад

    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 12 дней назад

      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 12 дней назад

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

    • @virtual_school
      @virtual_school 10 дней назад

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

  • @martinbooth6040
    @martinbooth6040 14 дней назад

    Don’t use crap voice over software

    • @virtual_school
      @virtual_school 14 дней назад

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

  • @virtual_school
    @virtual_school 17 дней назад

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

  • @pushpendrakumar1361
    @pushpendrakumar1361 18 дней назад

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

    • @virtual_school
      @virtual_school 18 дней назад

      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 16 дней назад

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

  • @birdywen8608
    @birdywen8608 20 дней назад

    Amazing!

  • @matheusfariaseng
    @matheusfariaseng 20 дней назад

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

  • @teachtime3094
    @teachtime3094 22 дня назад

    How can we do same thing for Telegram channels?

    • @virtual_school
      @virtual_school 21 день назад

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

    • @teachtime3094
      @teachtime3094 21 день назад

      @@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 24 дня назад

    I used superstore dataset will it affect my work

  • @osuohauchechi9316
    @osuohauchechi9316 24 дня назад

    Hello

  • @birdywen8608
    @birdywen8608 24 дня назад

    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 24 дня назад

      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 25 дней назад

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

  • @kurienillirickal7195
    @kurienillirickal7195 25 дней назад

    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 25 дней назад

      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 28 дней назад

    Well Done!!!

  • @EdwinOduol-n8c
    @EdwinOduol-n8c 28 дней назад

    Great job. Well done!!!

  • @KrishnaChandraJha-f9n
    @KrishnaChandraJha-f9n 28 дней назад

    This is really very helping video. Could you provide the detail video for the same topic or any course video

    • @virtual_school
      @virtual_school 24 дня назад

      Thanks for appreciation. Maybe in future, however there are so many topics to cover that it is highly unlikely for me to find time to cover an already covered topic. If any thing new comes into my mind regarding this topic, I will be happy to do a detailed video. Most of my tutorials are to the point btw.

  • @GeekUpdates
    @GeekUpdates 29 дней назад

    Getting error while opening report url you dont have permission

    • @virtual_school
      @virtual_school 28 дней назад

      Creating, managing and granting rights to users can be tricky. You must create users, then grant them rights in PBIRS. Follow all step after 8:15 please. Since there are so many things that can go wrong, I cannot guess where you are having problem.

  • @ramsrinivasan9940
    @ramsrinivasan9940 Месяц назад

    gannt visual automatically sorts by alphabetical order. how can we fix this

    • @virtual_school
      @virtual_school Месяц назад

      That should not happen, that is only possible if all tasks start and end at the same time. Make sure you have proper flow, like next task should start when previous task ends.

  • @virtual_school
    @virtual_school Месяц назад

    Special thanks to the visitors who engage by liking, commenting and sharing the tutorials and encourage us to make more videos.

  • @DennchenLama
    @DennchenLama Месяц назад

    Good job

  • @qqq3016
    @qqq3016 Месяц назад

    can I connect many custom query in one connection ?

  • @carmenchowable
    @carmenchowable Месяц назад

    you save my life, thank you

  • @EndroCpl
    @EndroCpl Месяц назад

    thx alot

  • @virtual_school
    @virtual_school Месяц назад

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

  • @HarrisonAdiko
    @HarrisonAdiko Месяц назад

    Thank you very much for this awesome class. It is good and awesome.

  • @IglesiaNuevaJerusalen-lk1vi
    @IglesiaNuevaJerusalen-lk1vi Месяц назад

    You happened to have the same router as i do lol, cool, thanks

  • @TopTop55-bs3bf
    @TopTop55-bs3bf Месяц назад

    Cool content as always! But why is the design so modest? There could be a lot more views. Btw, the new slicer visual is bugging tho? The force selection seems catastrophic

    • @virtual_school
      @virtual_school Месяц назад

      Design is not always the target of my video. I sometime try to present an idea, like race chart etc. Its up to every user how they implement it in their own reports. Presenting something different is always my objective over more views.

  • @RoamStrong_Abhishek
    @RoamStrong_Abhishek Месяц назад

    How can i change the color of the status ?

  • @izuchukwumatthewmmaji
    @izuchukwumatthewmmaji Месяц назад

    where is the dataset used

    • @virtual_school
      @virtual_school 23 дня назад

      In the pinned comment. ruclips.net/user/redirect?event=comments&redir_token=QUFFLUhqbmZUWUlsV3NOWW9Lc2tnTWhOLWRoNzJuV0lzUXxBQ3Jtc0trS1drcWtaYVZidC1haTA2dVJYbTRXWkgtTS1xWDlvUzRVZFlkMm5IMGM5d2R5RzJaYWk0Sk9RWVoxcDBjaDFEMWV5Yk5vbkg5MWlvcmlXQktkMWRZMExCYkxVQzhxUHNRZ1c5d29BV3Q5TTJ6U2EwWQ&q=https%3A%2F%2Fwww.kaggle.com%2Fdatasets%2Fvirtualschool%2Frestaurant-cost-and-sales-dataset

  • @AiBusiness-io2sm
    @AiBusiness-io2sm Месяц назад

    When I try to connect to SQL Server in Power BI I get this error message: CANNOT CONNECT Details: “Microsoft SQL: A connection to the server was successfully established, but an error occurred during the login process (provider: SSL Provider, error: 0 - The certification chain was issued by an untrusted entity).”????

    • @virtual_school
      @virtual_school 10 дней назад

      There is an option asking for if you trust your server, check it if you do, and then it will not require certificate.

  • @birdywen8608
    @birdywen8608 Месяц назад

    This is so amazing!

  • @birdywen8608
    @birdywen8608 2 месяца назад

    This is so amazing! Please update JavaScript series tutorial soon!

    • @virtual_school
      @virtual_school Месяц назад

      Thanks for appreciation, I will try my best to add more javascript tutorials in future.

  • @ChaqBI-ld8ot
    @ChaqBI-ld8ot 2 месяца назад

    Hello, please tell me how access the dataset through OData feed, since Shared Dataset arent supported on Report Server. Thanks

  • @giorgospap7615
    @giorgospap7615 2 месяца назад

    What is the visual name? Not mentioned in the video 🤣🤣

  • @moulalid3439
    @moulalid3439 2 месяца назад

    Ok

  • @marclukombo2
    @marclukombo2 2 месяца назад

    I have a GesEcole sql server database with the Sections and Options tables. In my python tkinter GUI application, I provide two comboboxes for Sections and Options. I would like when I select a section, the options combobox only displays the options that only concern the section chosen in the combobox and then insert that into the database. The Options table will have the primary key of the Section table. How to achieve it ?

  • @kp7688
    @kp7688 2 месяца назад

    Brilliant☆ This video is what I am looking for which answered my doubts. Thank you.

  • @arsalraza3997
    @arsalraza3997 2 месяца назад

    I have a question , how can i sign up in power bi ? I'm student and i tried to sign up login by my gmail account and my university mail but it did not work. what should i do ? I want to public my dashboards like this ... but only i can do that export to pdf but animation things and filters/slicer worked not there in pdf you know..

    • @virtual_school
      @virtual_school 2 месяца назад

      There are hacks and 'way around' on the internet as to how to get a power bi logon. One of them is creating @onmicrosoft email id. Search the web and see which methods works now a days.