- 254
- 734 692
ViSIT
United States
Приєднався 10 гру 2020
Welcome to our tutorial UA-cam channel, where we provide expert instruction and guidance on a variety of business intelligence and data visualization tools, including Power BI, SQL, JavaScript, Python, and MS Excel. Whether you're a beginner or an experienced professional, our comprehensive video tutorials will help you take your skills to the next level and unlock the full potential of these powerful tools. With our clear, easy-to-follow instruction and hands-on demonstrations, you'll be able to master the latest techniques and best practices for data analysis and visualization. So, whether you're looking to boost your career or just want to improve your skills, subscribe to our channel and start learning today!
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: "category order" and "history order." These columns use VLOOKUP or a similar method to assign a numerical sequence to each category and history item, reflecting the desired custom order. After reconnecting the Looker Studio report to the updated Google Sheet, the tutorial shows how to use these new "order" columns in the chart and pivot table sort settings, ensuring the data is displayed precisely as intended. The tutorial concludes by emphasizing the importance of this technique for non-standard sorting needs and encourages viewers to like, subscribe, and hit the notification bell for more content.
docs.google.com/spreadsheets/d/1djhAQXTVtnio-GO4nqLy_HlCIgzac3D_iwzUjKJE2G4/edit?usp=sharing
lookerstudio.google.com/reporting/8ad023a5-553e-4050-8cbc-325a61ba13e0
#lookerstudio #datastudio #googlelooker #datavisualization #dashboarddesign #customsorting #datasorting #googlesheets #spreadsheet #vlookup #tutorial #learndata #dataanalysis #businessintelligence #bi #dataanalytics #reportdesign #charting #pivot table #bar chart #diydata
docs.google.com/spreadsheets/d/1djhAQXTVtnio-GO4nqLy_HlCIgzac3D_iwzUjKJE2G4/edit?usp=sharing
lookerstudio.google.com/reporting/8ad023a5-553e-4050-8cbc-325a61ba13e0
#lookerstudio #datastudio #googlelooker #datavisualization #dashboarddesign #customsorting #datasorting #googlesheets #spreadsheet #vlookup #tutorial #learndata #dataanalysis #businessintelligence #bi #dataanalytics #reportdesign #charting #pivot table #bar chart #diydata
Переглядів: 21
Відео
Python: Leveraging AI to Build a SARIMA Model for Sales Forecasting in Python
Переглядів 5014 годин тому
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
Переглядів 28419 годин тому
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
Переглядів 31214 днів тому
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
Переглядів 10328 днів тому
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
Переглядів 124Місяць тому
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
Переглядів 98Місяць тому
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
Переглядів 4442 місяці тому
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
Переглядів 4352 місяці тому
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
Переглядів 6343 місяці тому
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
Переглядів 3363 місяці тому
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
Переглядів 7613 місяці тому
Time Intelligence in Power BI: A Visual Guide
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Переглядів 4344 місяці тому
SQL Magic: Auto-Generating HTML Reports (With Google Charts and JavaScript)
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
Переглядів 5094 місяці тому
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
Переглядів 4894 місяці тому
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,1 тис.7 місяців тому
Creating and Using Flow Maps in Power BI with Free Dataset
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Переглядів 1,4 тис.7 місяців тому
Dashboard with Relational Database in Looker Studio Data Blending and Modeling
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Переглядів 3467 місяців тому
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Переглядів 4318 місяців тому
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
Переглядів 8028 місяців тому
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
Переглядів 4578 місяців тому
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
how do you do this on linux? i been searching for 2 hours on how to conenct workbench to looker..
I am sorry. We dont use Linux here. Only Windows.
Hi, how to show multiple assignees
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!
XPath has always confused me, but this walkthrough makes it seem doable. Anyone else prefer using HasData for scraping on different platforms?
Thank you for this video. The best I have watched so far regarding data blends.
Thanks for your kind words.
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
thanks
welcome
Why was direct query used instead of import?
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.
you can skip the first 3 minutes. they are very unnecessary
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?
More than perfect, just please show your mouse cursor for upcoming videos, keep this good work up. Thanks
Thanks, will do!
Link to the report/dashboard and dataset: virtual-school.org/looker-studio-building-a-comprehensive-multi-page-organizational-performance-dashboard/
Amazing video What algorithm that used for the forecasting?
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.
Woah thanks a lot❤ Its really help
But its getting like butter&eggs&apple is there any way to show the grouping values vertically like single valued
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?
Create user name and password in lusrmgr.msc and then add that user name to yout report server.
@@virtual_school how to add to report server? also is this related to some office AD restriction since i installed in local office laptop.
@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.
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.
Great Video but where is the link
my status is not showed up complete and not complete
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.
Yes you can. You can embed it on any page of your organization. I am assuming it is on BI service right?
@virtual_school is there any way that I can contact you i need help in this project
Your videos are always great and they are my must-sees
That is very kind of you. I try my best.
View the embedded report here: virtual-school.org/complete-guide-to-the-looker-studio-sharing-looker-studio-reports/
Official Page: virtual-school.org/topics/data-analysis-expression-dax/the-dax-text-detective-find-and-search-functions/
you can't train and test with the same data... this results in data leakage and spurious results.
Hello, how to expand Parent and Task column?
with out autorefresh is that we can schedule refresh in the direct query mode
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.
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.
Why the auto refresh is not displaying?
Are you sure you chose DirectQuery and not Import?
I created a template.xlam path directory Microsoft>AddIns, the template.xlam is already have vba code. And I already check the template
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"
@@Albert_Taban Sorry, plz ignore my previous reply, let me look into it.
@@virtual_school okay sir/ma'am thank you for your guidance.
My power Bi formate not understanding the comman "Timestamp".
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.
Great video. At 11.00 it's slightly confusing that Discount has been formatted as Currency but then treated as a Percentage.
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.
How does one show percent complete at the parent level?
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.
@@virtual_school yes, but the % is not showing up in the parent level in Power BI using the Microsoft Gantt Chart
@@carltonseymour869 Unfortunately this visual does not have that option for parent. Parent is meant for grouping and organizing only in this visual.
Link to the excel file: docs.google.com/spreadsheets/d/1Tx0AFbIfbp2EI0mdfKfxRIeOG1xH6hNp/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true
can u plz send me the data what which you are applied
Data is available in online sql server as mentioned here: ua-cam.com/video/1OxFtV-SKKo/v-deo.html
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
Thanks for this. Please how can I find my username and password to access the report from another device?
Your Video hub is of knowledge and it take my experience to another level.
Thanks for your kind words 🙏
does it needs a seperate time table in the model ?
You have to tell the chart when a task is starting and when it is ending.
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.
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).
@virtual_school That's great. Thanks for the reply
Thank you so much
Thanks for your kind words.
Link to the dataset: docs.google.com/spreadsheets/d/1lzMWDdQNZq9WREZSRjxiXRHaxFpeItvE/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true
Where is the data file (excel ) that u import to power Bi..?
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
Thanks for the detailed video.
Thanks Arsal. Glad we could help.
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
Just what've spent the last 2 days trying to find! Thank you.
So glad I could help 😁
Python code is not working please help me out
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" ?
You can get all Power BI custom visuals from Microsoft Store which is online.
@@anisnajwa1640 There is a free Microsoft Gantt chart available, or you can buy one of many.
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.
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/
it is not working. Can you help me.
Do you have the latest version of excel? 365?
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.
Good catch. Data -> Data Tools -> Data Model -> 3D Maps