- 244
- 641 089
ViSIT
United States
เข้าร่วมเมื่อ 10 ธ.ค. 2020
Welcome to our tutorial TH-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!
SQL: Pivot and Unpivot Data in SQL Server Database Including Multiple Columns - A Step-By-Step Guide
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 explanations, you'll gain the skills to efficiently manipulate and analyze your data using SQL Server's powerful pivot and unpivot functions.
#SQL #Tutorial #DataAnalysis #PivotTable #UnpivotTable #SQLServer #Database #DataScience #DataEngineering #LearningSQL #TechTutorial #DataTransformation
#SQL #Tutorial #DataAnalysis #PivotTable #UnpivotTable #SQLServer #Database #DataScience #DataEngineering #LearningSQL #TechTutorial #DataTransformation
มุมมอง: 188
วีดีโอ
Power BI: Creating Business Intelligence Dashboards from SQL Server Tables and Views
มุมมอง 45321 วันที่ผ่านมา
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
มุมมอง 277หลายเดือนก่อน
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
มุมมอง 541หลายเดือนก่อน
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)
มุมมอง 327หลายเดือนก่อน
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
มุมมอง 3352 หลายเดือนก่อน
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
มุมมอง 3772 หลายเดือนก่อน
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
มุมมอง 2953 หลายเดือนก่อน
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
มุมมอง 7953 หลายเดือนก่อน
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.1K4 หลายเดือนก่อน
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
มุมมอง 1K4 หลายเดือนก่อน
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.3K4 หลายเดือนก่อน
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
มุมมอง 8845 หลายเดือนก่อน
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
มุมมอง 2335 หลายเดือนก่อน
Power Pivot and Data Modeling in MS Excel - Learn in Five Minutes
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
มุมมอง 3005 หลายเดือนก่อน
Power BI: Project Weighted Decision Matrix Dashboard #projectmanagement
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
มุมมอง 3.7K5 หลายเดือนก่อน
Using Custom SQL Queries in Power BI #sql #powerbi #tutorial #customsqlqueries #customqueries
Diversity, Equity, and Inclusion (DEI) Initiative Tracker Using RAG Status - Project Management
มุมมอง 5765 หลายเดือนก่อน
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
มุมมอง 2626 หลายเดือนก่อน
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
มุมมอง 9K6 หลายเดือนก่อน
Gantt Chart in Power BI: Complete Guide #tutorial #ganttchart #powerbi #projectmanagement
Monitoring Progress Using Gantt Chart - Indigeno Technologies Part 3
มุมมอง 1176 หลายเดือนก่อน
Monitoring Progress Using Gantt Chart - Indigeno Technologies Part 3
Creating a Dashboard of Sales Process and Pregress (Indigeno Technologies Part 2)
มุมมอง 1306 หลายเดือนก่อน
Creating a Dashboard of Sales Process and Pregress (Indigeno Technologies Part 2)
Data Modeling, Creating Relationships, and Tables using DAX (Indigeno Technologies - Part 1)
มุมมอง 2906 หลายเดือนก่อน
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
มุมมอง 966 หลายเดือนก่อน
Creating and Publishing Web Applications using HTML and JavaScript: A Unicode Symbol Generator
Make Your Data Grow: Tree Stats with Power BI
มุมมอง 1807 หลายเดือนก่อน
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
มุมมอง 9967 หลายเดือนก่อน
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.
มุมมอง 1997 หลายเดือนก่อน
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
มุมมอง 5877 หลายเดือนก่อน
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
มุมมอง 4627 หลายเดือนก่อน
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.5K7 หลายเดือนก่อน
Power BI: Timesheet Analysis | Construction Co. Example | Worker Hours Report | Project Management
Time Machine for Your Database: Track Every Change with SQL Server
มุมมอง 4597 หลายเดือนก่อน
Time Machine for Your Database: Track Every Change with SQL Server
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..?
th-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: th-cam.com/video/7O9dHPGd_CM/w-d-xo.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
Awesome, thanks
You are very welcome.
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?
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.
Thanks so much
You're welcome! 🤗
Link to the datasets: drive.google.com/file/d/1cZTgMxA3MY9k2KXQ4PnUrRmFa18a1VV3/view?usp=sharing
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.
It is good that you found your problem. Good luck.
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
The indentations of the HTML code were lost after pasting it from the VSCode editor. How can this issue be resolved? Thanks.
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
Is there a reason to use cross filtering between the Timesheet Fact table and the other Dimension Tables
No perticular reason, you can use other filter options as well (as long as they work perfectly).
Don’t use crap voice over software
If your focus is that, my friend you will face difficulty learning about Gantt Charts and Power BI.
Dataset and Power BI file drive.google.com/file/d/1BoFTm4LIfVG4Eo5PfgaqghtuH2bggm7P/view?usp=drive_link
If i am using other than Huawei network, Then configure from here only?
Configuration is more or less same on all devices. You can also take help from your service provider. You pay them for that.
One more doubt, I am using AWS VM, How can i get this network setting for bridged adapter?
Amazing!
i'm from Brazil, tank you so much for very valuable content
Thanks for your kind words.
How can we do same thing for Telegram channels?
They have APIs as well, and you will have to study it and find a way.
@@virtual_school Than you for answering. I need some adcives. How Can I get insights from vizualized data and tell to the manager?
I used superstore dataset will it affect my work
In what way?
Hello
Hi!
Your video tutorials are so creative. I benefit a lot from each video, both in terms of skills and inspiration. Thank you.
Thanks. Thats very kind of you. I try to share what I am working on and find it to be unique.
Excel file: docs.google.com/spreadsheets/d/1yXErU2jVp9OBsAPbxEdi2qPu_0RJHxcL/edit?usp=sharing&ouid=110287700425339553017&rtpof=true&sd=true
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.
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.
Well Done!!!
Thaks for appreciation.
Great job. Well done!!!
Thanks for your kind words.
This is really very helping video. Could you provide the detail video for the same topic or any course video
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.
Getting error while opening report url you dont have permission
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.
gannt visual automatically sorts by alphabetical order. how can we fix this
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.
Special thanks to the visitors who engage by liking, commenting and sharing the tutorials and encourage us to make more videos.
Good job
Thanks 🙏
can I connect many custom query in one connection ?
you save my life, thank you
Thanks for your kind words 🙏
thx alot
You are welcome.
Link to the excel file: docs.google.com/spreadsheets/d/1DRJMqBf1RnKwGNuxnBhR5DQeLQnHx7iA/edit?usp=drive_link&ouid=110287700425339553017&rtpof=true&sd=true
Thank you very much for this awesome class. It is good and awesome.
Thanks for your kind words.
You happened to have the same router as i do lol, cool, thanks
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
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.