ViSIT
ViSIT
  • Видео 254
  • Просмотров 737 903
Looker Studio: Sort Rows, Columns, and Axis in any order you want #sort #lookerstudio #dashboarding
This tutorial explains how to sort data in Looker Studio in a custom order, beyond the standard alphabetical or numerical sorting. Using a hypothetical bank loan portfolio dataset from a Google Sheet (link in description), the tutorial walks through creating a Looker Studio report, connecting to the Google Sheet data source, and setting up the dashboard with a title, logo, and various charts (pivot table, bar charts). The core of the tutorial focuses on creating custom sort orders for loan categories and customer credit history. Since these fields can't be sorted alphabetically or numerically into the desired order, the tutorial demonstrates adding two new columns to the Google Sheet: "ca...
Просмотров: 42

Видео

Python: Leveraging AI to Build a SARIMA Model for Sales Forecasting in Python
Просмотров 5619 часов назад
This tutorial guides viewers through the process of predicting future sales using the SARIMA model in Python. It showcases the power of AI by utilizing Google Colab's built-in AI capabilities to generate the necessary Python code. Starting with data import from Google Sheets, the tutorial progresses to statistical analysis, including stationarity tests and time series decomposition. Subsequentl...
Power BI: Sending Power BI Data through Emails Using Power Automate
Просмотров 305День назад
This tutorial demonstrates how to create a Power BI dashboard to monitor sales and profit data, and then automate the delivery of this data to top management via email using Power Automate. Key steps covered: Data Loading & Dashboard Creation: Importing Excel data into Power BI. Creating visuals (cards, line and column chart) to display key metrics. Power Automate Integration: Adding a Power Au...
Looker Studio: Building a Comprehensive Multi-Page Organizational Performance Dashboard
Просмотров 32114 дней назад
This video tutorial demonstrates how to create a multi-page report in Looker Studio, focusing on organizational performance. It covers data preparation, including unpivoting data in Excel and importing it into Google Sheets. The tutorial then guides viewers through creating a cover page, adding various charts and visuals, utilizing advanced filters and formatting, and applying themes to maintai...
Python Lesson 003: Mastering the Python Syntax
Просмотров 103Месяц назад
This Python tutorial provides a foundational overview of key concepts, including comments, variables, data types (integers, floats, strings, booleans, lists, tuples, dictionaries), operators (arithmetic, comparison, logical), and control flow (if-else, for, while). It explains how to use comments to enhance code readability and temporarily disable code, and how to work with different data types...
Complete Guide to the Looker Studio: Sharing Looker Studio Reports
Просмотров 126Месяц назад
This tutorial provides a comprehensive overview of sharing Looker Studio reports. It covers various sharing methods, including sharing with individuals and groups, using share links with different access levels (restricted, unlisted, public), and scheduling automated report deliveries. The tutorial also discusses report access settings, which allow for granular control over viewer permissions, ...
The DAX Text Detective: Find and Search Functions
Просмотров 102Месяц назад
This video compares and contrasts the DAX functions FIND and SEARCH, both used to locate substrings within a larger text string. While both return the position of the first occurrence of the substring, FIND is case-sensitive, meaning it will only find an exact match, including capitalization. In contrast, SEARCH is case-insensitive, making it more flexible. The video demonstrates how to use the...
Creating Custom Functions in Excel without using VBA: A Deep Dive into LAMBDA
Просмотров 116Месяц назад
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...
Python Lesson 002: Communicating with Python using Print() and Input() Functions
Просмотров 65Месяц назад
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
Просмотров 1282 месяца назад
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
Просмотров 4472 месяца назад
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
Просмотров 4553 месяца назад
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
Просмотров 6393 месяца назад
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
Просмотров 3393 месяца назад
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
Просмотров 7743 месяца назад
Time Intelligence in Power BI: A Visual Guide
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Просмотров 4404 месяца назад
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
Просмотров 5164 месяца назад
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
Using Dropdown Lists Effectively to Summarize Data and Build Dashboards and Reports in MS Excel
Просмотров 4924 месяца назад
Using Dropdown Lists Effectively to Summarize Data and Build Dashboards and Reports in MS Excel
Build a Stunning Animated Olympics Javelin Dashboard with Power BI
Просмотров 3535 месяцев назад
Build a Stunning Animated Olympics Javelin Dashboard with Power BI
Analyse and Visualize Google Forms Responses using Power BI by Integrating Forms with Power BI
Просмотров 1,4 тыс.6 месяцев назад
Analyse and Visualize Google Forms Responses using Power BI by Integrating Forms with Power BI
Advanced Power BI Realtime Project: Using Same Dashboard for Data Input and Output into SQL Server
Просмотров 1,3 тыс.6 месяцев назад
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,4 тыс.7 месяцев назад
Real time Monitoring with Power BI and SQL
Creating and Using Flow Maps in Power BI with Free Dataset
Просмотров 2,2 тыс.7 месяцев назад
Creating and Using Flow Maps in Power BI with Free Dataset
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Просмотров 1,5 тыс.7 месяцев назад
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Просмотров 3477 месяцев назад
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Просмотров 4348 месяцев назад
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Просмотров 7 тыс.8 месяцев назад
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
Просмотров 8128 месяцев назад
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
Просмотров 4618 месяцев назад
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
Просмотров 14 тыс.8 месяцев назад
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement

Комментарии

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

    how do you do this on linux? i been searching for 2 hours on how to conenct workbench to looker..

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

      I am sorry. We dont use Linux here. Only Windows.

  • @Yz40000
    @Yz40000 3 дня назад

    Hi, how to show multiple assignees

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

    Good easy to follow video - Thanks! On mine I will add an option to refresh or not refresh, in case people want to print or take screenshots. I assume this readings are for the server where the python code is running from (I personally would compile it with py2exe to run a Exe on the server and be immune to changes on python libraries in the future) Also will add code in python to only keep 2-3 days worth of data to keep the database lean, and an option in PBI to select if user wants to see data back in time!, options like these can be a parameters in a file outside the python but that it can read, plus users can modify those parameters directly if they are scared of python :) been a Power BI Admin ( for 6 years) - All your comments are great!

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

    XPath has always confused me, but this walkthrough makes it seem doable. Anyone else prefer using HasData for scraping on different platforms?

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

    Thank you for this video. The best I have watched so far regarding data blends.

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

    Google Sheets: docs.google.com/spreadsheets/d/1Vphx5JGhDGR9YP4Zh69r4Hb3fHAY2_fG4loylzCVhBs/edit?usp=sharing Google Colab Notebook: colab.research.google.com/drive/1ba4Ef0fUeiP5UI0mRsyQo-PhMjn4l7_H?usp=sharing

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

    thanks

  • @seyiabayomi
    @seyiabayomi 15 дней назад

    Why was direct query used instead of import?

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

      Because this let's you automatically update the dashboard as per defined interval. Ecommerce based reports are not annual or monthly reports. You may want to observe changes several time a day, and with direct query you can do that. Otherwise you can select import as well. It is just matter of choice and requirement.

  • @mnir007
    @mnir007 16 дней назад

    you can skip the first 3 minutes. they are very unnecessary

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

      So, if someone does not know how to cennect to a data source, and get data into the report, how would they do it without watching the first three minutes?

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

    More than perfect, just please show your mouse cursor for upcoming videos, keep this good work up. Thanks

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

    Link to the report/dashboard and dataset: virtual-school.org/looker-studio-building-a-comprehensive-multi-page-organizational-performance-dashboard/

  • @nandasetiawan3562
    @nandasetiawan3562 19 дней назад

    Amazing video What algorithm that used for the forecasting?

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

      Power BI primarily uses Exponential Smoothing (ETS) algorithms for forecasting when drawing a forecast line (ETS AAA/AAN). These algorithms work by creating a weighted average of past observations, giving more weight to recent data points. The weights are determined by smoothing parameters that are automatically optimized by Power BI to minimize forecasting errors within the training data. Seasonality is ignored when it has no or very little impact on future prediction of data.

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

      Woah thanks a lot❤ Its really help

  • @sairajesh9936
    @sairajesh9936 19 дней назад

    But its getting like butter&eggs&apple is there any way to show the grouping values vertically like single valued

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

    Once i click the web portal url, they ask me to put in username and password to sign in. I followed everything same as your video using Express version. How to fix that?

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

      Create user name and password in lusrmgr.msc and then add that user name to yout report server.

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

      @@virtual_school how to add to report server? also is this related to some office AD restriction since i installed in local office laptop.

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

      @everywwswe goto start run and enter lusrmgr.msc. if local users and groups window appears and lets you add users and groups, then ok, otherwise you nay be restricted.

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

      Once you have created user, click on manage folder on top right corner of report server and then click on add group or user button.

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

    Great Video but where is the link

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

    my status is not showed up complete and not complete

  • @HJ-yb1rg
    @HJ-yb1rg 29 дней назад

    thank you very much... i am using power bi pro version.. i have created a dashboard using APIs of SAP. Now i want to share it on my local intranet of organisation. Is it possible.

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

      Yes you can. You can embed it on any page of your organization. I am assuming it is on BI service right?

    • @HJ-yb1rg
      @HJ-yb1rg 25 дней назад

      @virtual_school is there any way that I can contact you i need help in this project

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

    Your videos are always great and they are my must-sees

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

      That is very kind of you. I try my best.

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

    View the embedded report here: virtual-school.org/complete-guide-to-the-looker-studio-sharing-looker-studio-reports/

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

    Official Page: virtual-school.org/topics/data-analysis-expression-dax/the-dax-text-detective-find-and-search-functions/

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

    you can't train and test with the same data... this results in data leakage and spurious results.

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

    Hello, how to expand Parent and Task column?

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

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

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

      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 2 месяца назад

    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 2 месяца назад

    Why the auto refresh is not displaying?

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

      Are you sure you chose DirectQuery and not Import?

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

      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 2 месяца назад

      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 2 месяца назад

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

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

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

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

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

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

    As identified by @sapelko80, discount (at ruclips.net/video/GivV2lBkXYA/видео.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 2 месяца назад

    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 2 месяца назад

      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 2 месяца назад

    How does one show percent complete at the parent level?

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

      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 2 месяца назад

      @@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 2 месяца назад

      @@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 2 месяца назад

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

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

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

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

      Data is available in online sql server as mentioned here: ruclips.net/video/1OxFtV-SKKo/видео.html

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

    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 2 месяца назад

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

  • @jamesm.sumojr8486
    @jamesm.sumojr8486 2 месяца назад

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

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

    does it needs a seperate time table in the model ?

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

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

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

    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 2 месяца назад

      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 2 месяца назад

      @virtual_school That's great. Thanks for the reply

  • @1ndin414
    @1ndin414 3 месяца назад

    Thank you so much

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

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

  • @akhtarjavaid6183
    @akhtarjavaid6183 3 месяца назад

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

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

      ruclips.net/user/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 3 месяца назад

    Thanks for the detailed video.

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

      Thanks Arsal. Glad we could help.

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

    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: ruclips.net/video/7O9dHPGd_CM/видео.html

  • @betagav
    @betagav 3 месяца назад

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

  • @productreviews-q7p
    @productreviews-q7p 3 месяца назад

    Python code is not working please help me out

  • @anisnajwa1640
    @anisnajwa1640 3 месяца назад

    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 3 месяца назад

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

    • @jerrygault6860
      @jerrygault6860 3 месяца назад

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

  • @aghanawazan
    @aghanawazan 3 месяца назад

    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 2 месяца назад

      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 3 месяца назад

    it is not working. Can you help me.

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

      Do you have the latest version of excel? 365?

  • @Naruto-td7oo
    @Naruto-td7oo 3 месяца назад

    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 3 месяца назад

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