Charts & Visualizations in Power Bi | Full Tutorial | Power Bi| KSR DATAVIZON

  Рет қаралды 26,363

KSR Datavizon

KSR Datavizon

Күн бұрын

Пікірлер: 73
@aspectoflife
@aspectoflife 20 күн бұрын
Short and compact information, highly appreciated
@akshaykhobragade8494
@akshaykhobragade8494 8 ай бұрын
what a beautiful leacture. only video on you tube where every chart is explained with clear concepts. thankyou madam for this amazing video.
@KSRDatavizon
@KSRDatavizon 2 ай бұрын
You're most welcome, Please subscribe our channel for regular updates
@Bucksclub
@Bucksclub Ай бұрын
First of ALL i need to thank this KSR TEAM FOR WONDERFUL EXPLANATION 🎉
@KSRDatavizon
@KSRDatavizon Ай бұрын
We are glad you found the explanation helpful, keep learning!
@anubhad767
@anubhad767 7 ай бұрын
I must say this is one of the best video ,Each and every chart you have explained so well ,Thank u so much .
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
Thanks for liking, Please subscribe our channel for regular updates.
@TheRamyababu
@TheRamyababu Жыл бұрын
Thank you Uma for this wonderful video. I would say this is the best video for revising all the charts which we have learned. Thanks a lot KSR team.
@KSRDatavizon
@KSRDatavizon Жыл бұрын
Thank You so much
@gourabsjourney
@gourabsjourney 10 ай бұрын
Thanks a lot mam...It made my day❤❤❤❤
@MANOJSINGHMEHRA-k8k
@MANOJSINGHMEHRA-k8k Жыл бұрын
Your guidance and shared experiences have been invaluable.Thanks for always listening to my troubles and trying your best to help me out. 🙏
@KSRDatavizon
@KSRDatavizon Жыл бұрын
you are welcome, please subscribe our channel for regular updates
@TwoMinutesisEnough
@TwoMinutesisEnough 7 ай бұрын
Best video on charts...thanks and best wishes
@KSRDatavizon
@KSRDatavizon 7 ай бұрын
Thank you so much for your kind words! I'm glad you found the video helpful.
@lakshminarayana3168
@lakshminarayana3168 Жыл бұрын
all ksr trainers are from Microsoft ,good
@KSRDatavizon
@KSRDatavizon Жыл бұрын
Hi Lakshmi Narayana, we have only 2 trainers from Microsoft Santosh and Uma. Mr. Mahesh previously worked with Cargill, Novozymes and MicroLabs . Mr. koti worked with AT&T, Nutanix, HSBC and now he was director in analytics department for one of the famous bank ( HSBC). Mrs Jenny worked with Amazon, IBM, ABB. Mr. Krishna ( Snowflake ) worked with Robert Bosch and he was relocating to USA very soon .. Mr. Mohamad ( snowflake ) he was worked with Mecafee.. Similarly we have couple of other trainers working for corporate trainings. You may watching only powerbi videos and these 2 people are frequently taking the youtube sessions it’s might be the reason you are thinking all our trainers from Microsoft… However we are hiring more trainers as we are expanding the organization, if any one interested on teaching please approach us
@shanthidinakaran5574
@shanthidinakaran5574 6 ай бұрын
Very Useful Session, Thank you!
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
You are welcome! please subscribe our channel for regular updates.
@MrRajesh0055
@MrRajesh0055 Ай бұрын
Really wonderful time watching these and missing paretos, gantt, histogram, fishbone are they available or not
@maheshkoritala1419
@maheshkoritala1419 7 ай бұрын
Good learning for beginners
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
Thank you, Please subscribe our channel for regular updates,
@sekoudiallo3516
@sekoudiallo3516 11 ай бұрын
Merci beaucoup pour cette vidéo. J'ai trop aimé 🤗
@KSRDatavizon
@KSRDatavizon 9 ай бұрын
Thank you for your comment, Please share and like and subscribe our channel for updates.
@aspectoflife
@aspectoflife 20 күн бұрын
Hi, can we have the practice tables please?
@nhinvalerabayugao1418
@nhinvalerabayugao1418 Жыл бұрын
new subscriber here! Thanks for sharing
@KSRDatavizon
@KSRDatavizon Жыл бұрын
Thanks for subbing!
@Jai_Radhe_Radhe
@Jai_Radhe_Radhe 9 ай бұрын
Thanku 😊
@KSRDatavizon
@KSRDatavizon 9 ай бұрын
you are welcome, Thanks for comment, Please share , like and subscribe our channel it motivates us
@rajatsehgal4249
@rajatsehgal4249 11 ай бұрын
In pie chart where you have told that the category is subdivided into the region and its showing the sales category wise not region wise. But we can figure out on top of pie chart that each region is showing the percentage sales.
@KSRDatavizon
@KSRDatavizon 2 ай бұрын
It seems you're describing a pie chart where sales data is being presented category-wise but visually annotated or grouped by region, possibly with percentages indicating the regional sales share. This scenario can arise when you're trying to present both categorical and regional data simultaneously. Here’s how I interpret the situation and explanation for clarity: What's Happening in the Pie Chart: Primary Data Breakdown (Category-wise): The main division in the pie chart is by sales categories (e.g., Electronics, Furniture, Office Supplies). Each segment in the pie chart represents the total sales for each category, regardless of the region. Regional Context on Top: Even though the pie chart is breaking down data category-wise, percentages on top of the chart (or additional visual clues) show regional sales distribution. These percentages may represent the share of sales from each region across all categories (e.g., 50% of total sales from the North region, 30% from the West). How This Works Visually: The pie chart itself is not splitting by region-it's focused on category-wise sales. However, on top of the pie chart, you see regional percentage annotations, giving you a sense of how different regions contribute to overall sales. Why This Might Be Confusing: Mixing Two Dimensions (Category and Region): It can be a bit confusing if both category and regional data are shown together without clear distinction. While the chart shows categories, the percentages might make it look like it’s splitting by region. Visual Design: If the chart does not explicitly show which percentage belongs to which region, it can seem like the pie chart is trying to represent both region and category at once, leading to potential misinterpretation. Example to Visualize: Imagine a pie chart with three slices representing Furniture, Electronics, and Office Supplies. Above the chart, you see regional percentages: North: 50% (meaning 50% of all sales across all categories came from the North region) West: 30% South: 20% Although the chart is category-wise, the top annotations are giving you regional context.
@itsall5180
@itsall5180 7 ай бұрын
Instacked bar chart central is the the begining what if i want East at 1st, central at 2nd West at 3rd and South at End . is that possible to do ?
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
Use a index to assign values as per order you want and sort the region by index column in data view
@amansalimshaikh1725
@amansalimshaikh1725 10 ай бұрын
Please provide the link of the dataset so that we can do in parallel.
@KSRDatavizon
@KSRDatavizon 8 ай бұрын
drive.google.com/drive/folders/1_MrrzHizjFRSeiXVwzbb4SCQf4lfAQqa?usp=sharing
@rashmimishra99
@rashmimishra99 4 ай бұрын
Wonderful
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
Thank you! Cheers! Please share with your friends too. and subscribe our channel
@sandipansarkar9211
@sandipansarkar9211 Жыл бұрын
finished watching
@KSRDatavizon
@KSRDatavizon Жыл бұрын
Thank You
@Nayadaur11
@Nayadaur11 Жыл бұрын
Mam how to add fields panel?
@jyothsnabandi2552
@jyothsnabandi2552 Жыл бұрын
What is the description which you mentioned as readable and non readable ?
@KSRDatavizon
@KSRDatavizon Ай бұрын
readable - if someone sees your visual they should understand by themelves. non-readable - if visual is not clear for explaination
@devanathanelangovan4961
@devanathanelangovan4961 9 ай бұрын
When we want to compare Current quarter sale with next Quarter sale --> next quarter sales = calculate([Total Sales], nextquarter(Date_TB[Date])) QoQ growth % = divide([Total Sales] - [next quarter sales]),[next quarter sales]) When we want to compare Current day sale with next day sale --> next day sales = calculate([Total Sales], nextday(Date_TB[Date])) QoQ growth % = divide([Total Sales] - [next day sales]),[next day sales])
@KSRDatavizon
@KSRDatavizon 2 ай бұрын
Calculating Quarter-over-Quarter (QoQ) and Day-over-Day (DoD) Growth Rates in Power BI: Understanding the Formulas: The provided DAX formulas effectively calculate QoQ and DoD growth rates using the CALCULATE, NEXTQUARTER, and NEXTDAY functions. Here's a breakdown of how they work: QoQ Growth Rate: [next quarter sales]: This calculated column uses CALCULATE to calculate the total sales for the next quarter based on the Date_TB[Date] column. QoQ growth %: This calculated column calculates the percentage change in total sales between the current quarter and the next quarter using the DIVIDE function. DoD Growth Rate: [next day sales]: This calculated column uses CALCULATE to calculate the total sales for the next day based on the Date_TB[Date] column. QoQ growth %: This calculated column calculates the percentage change in total sales between the current day and the next day using the DIVIDE function. Key Points: Correctness: The formulas are accurate and provide the desired QoQ and DoD growth rates. Flexibility: These formulas can be adapted to different scenarios by modifying the [Total Sales] measure or the date-related functions. Contextual Awareness: The CALCULATE function ensures that the calculations are performed in the appropriate context, considering any filters or slicers applied to the data. Additional Considerations: Data Quality: Ensure that your data is clean and accurate, especially the date column, to obtain reliable results. Date Format: Verify that the Date_TB[Date] column is formatted as a date. Measure Definition: If [Total Sales] is a calculated measure, ensure that it is defined correctly and includes the appropriate filters or calculations. Example: Assuming you have a table named Sales with columns Date, Product, and Sales Amount, you can create the following calculated columns to calculate QoQ and DoD growth rates: Code snippet next quarter sales = CALCULATE([Total Sales], NEXTQUARTER(Sales[Date])) QoQ growth % = DIVIDE([Total Sales] - [next quarter sales], [next quarter sales]) next day sales = CALCULATE([Total Sales], NEXTDAY(Sales[Date])) DoD growth % = DIVIDE([Total Sales] - [next day sales], [next day sales]) Use code with caution. By using these formulas, you can effectively analyze the growth trends of your sales data at both the quarter and day levels.
@cesarsaldana3429
@cesarsaldana3429 5 ай бұрын
Amazing!!!!
@KSRDatavizon
@KSRDatavizon 5 ай бұрын
Thanks!! Please subscribe our channel for regular updates
@akupatichiranjeevi6159
@akupatichiranjeevi6159 11 ай бұрын
Kindly please do a video on types of licenses and their differences
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
ure sir, will make the video. Please subscribe our channel for regular updates.
@gourabsjourney
@gourabsjourney 10 ай бұрын
Please make a detailed video on Power Bi service as well
@KSRDatavizon
@KSRDatavizon 9 ай бұрын
sure will do a video on the same veru shortly , please subscribe our channnel for regular updates and it motivates us a lot
@sudipsen3677
@sudipsen3677 Жыл бұрын
Ma'am please provide dataset for every video....
@rajivbhokare632
@rajivbhokare632 Жыл бұрын
Data Is not able to Download From Github Plz Share The link
@KSRDatavizon
@KSRDatavizon 2 ай бұрын
sure we will update latest one
@rajivbhokare632
@rajivbhokare632 2 ай бұрын
@@KSRDatavizon yes plz
@MoonShine-bs6cl
@MoonShine-bs6cl Жыл бұрын
Pls share the file... How do we practice
@KSRDatavizon
@KSRDatavizon Жыл бұрын
github.com/ksrpowerbi/KSR_DAX_Datasets
@TheHanuman65
@TheHanuman65 Жыл бұрын
At 18 : 30 Its a Requesting you Please consider the India Map its not showing the actual Map. Consider Regional Setting to India.
@KSRDatavizon
@KSRDatavizon Жыл бұрын
sure will check on the same will update in future sessions
@Sunilkumar-l7g5w
@Sunilkumar-l7g5w 2 ай бұрын
Very good lecture, mam can you share the file pls
@KSRDatavizon
@KSRDatavizon 2 ай бұрын
"Thank you for the feedback! I'd be happy to share the file with you. Please check your inbox shortly, and feel free to reach out if you have any further questions."
@ananyamitra6645
@ananyamitra6645 3 ай бұрын
Please share the pbix file
@KSRDatavizon
@KSRDatavizon 2 ай бұрын
Hi , its there in Description, Please let me know if you not able to find
@Nitish_Mehta
@Nitish_Mehta Жыл бұрын
Hi ma'am, Thank you for such an informative video with detail explanation but You haven't taken the correct Map of our Payara Bharat
@KSRDatavizon
@KSRDatavizon Жыл бұрын
my apologies, will update in future videos
@soumyajha6759
@soumyajha6759 6 ай бұрын
Please share the pbi file
@KSRDatavizon
@KSRDatavizon 3 ай бұрын
Hi, its available in description. please check and let us know if not able to find.
@aspectoflife
@aspectoflife 20 күн бұрын
Your sound volume is down and varying, hope to increase next times, thanks
@chandrukb6646
@chandrukb6646 10 ай бұрын
Please share the file..
@KSRDatavizon
@KSRDatavizon 9 ай бұрын
will share it ASAP in Description
@gourabsjourney
@gourabsjourney 10 ай бұрын
Please share the file so that we can also practice....Thanks a lot again
@KSRDatavizon
@KSRDatavizon 8 ай бұрын
drive.google.com/drive/folders/1_MrrzHizjFRSeiXVwzbb4SCQf4lfAQqa?usp=sharing
@Prashant_Kumar_Srivastav
@Prashant_Kumar_Srivastav Жыл бұрын
Please Share File
@KSRDatavizon
@KSRDatavizon Жыл бұрын
github.com/ksrpowerbi/KSR_DAX_Datasets
@rajivbhokare632
@rajivbhokare632 Жыл бұрын
Data is not able to download @@KSRDatavizon
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 28 МЛН
If people acted like cats 🙀😹 LeoNata family #shorts
00:22
LeoNata Family
Рет қаралды 45 МЛН
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 257 М.
Power BI Developer Interview Insider Secrets Revealed!
20:11
KSR Datavizon
Рет қаралды 126 М.
Popular Visualizations in Power BI | Microsoft Power BI for Beginners
14:14
Visualizations in Power BI - Full Tutorial
1:33:34
Simon Sez IT
Рет қаралды 117 М.
Data Visualization Crash Course | Consulting Best Practices
25:57
Analyst Academy
Рет қаралды 189 М.
MASTERING Bar Charts in Power BI | No more Cut Labels
15:34
How to Power BI
Рет қаралды 136 М.
How To Create these useful Power Bi Visuals that Excel Lacks
10:55
Leila Gharani
Рет қаралды 480 М.
Power BI Upgrade: Easy Vertical Waterfall Charts with Visual Calcs
10:49
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 28 МЛН