Charts & Visualizations in Power Bi | Full Tutorial

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

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

KSR Datavizon

Күн бұрын

Пікірлер: 73

@aspectoflife 20 күн бұрын

Short and compact information, highly appreciated

@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 2 ай бұрын

You're most welcome, Please subscribe our channel for regular updates

@Bucksclub Ай бұрын

First of ALL i need to thank this KSR TEAM FOR WONDERFUL EXPLANATION 🎉

@KSRDatavizon Ай бұрын

We are glad you found the explanation helpful, keep learning!

@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 3 ай бұрын

Thanks for liking, Please subscribe our channel for regular updates.

@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 Жыл бұрын

Thank You so much

@gourabsjourney 10 ай бұрын

Thanks a lot mam...It made my day❤❤❤❤

@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 Жыл бұрын

you are welcome, please subscribe our channel for regular updates

@TwoMinutesisEnough 7 ай бұрын

Best video on charts...thanks and best wishes

@KSRDatavizon 7 ай бұрын

Thank you so much for your kind words! I'm glad you found the video helpful.

@lakshminarayana3168 Жыл бұрын

all ksr trainers are from Microsoft ,good

@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 6 ай бұрын

Very Useful Session, Thank you!

@KSRDatavizon 3 ай бұрын

You are welcome! please subscribe our channel for regular updates.

@MrRajesh0055 Ай бұрын

Really wonderful time watching these and missing paretos, gantt, histogram, fishbone are they available or not

@maheshkoritala1419 7 ай бұрын

Good learning for beginners

@KSRDatavizon 3 ай бұрын

Thank you, Please subscribe our channel for regular updates,

@sekoudiallo3516 11 ай бұрын

Merci beaucoup pour cette vidéo. J'ai trop aimé 🤗

@KSRDatavizon 9 ай бұрын

Thank you for your comment, Please share and like and subscribe our channel for updates.

@aspectoflife 20 күн бұрын

Hi, can we have the practice tables please?

@nhinvalerabayugao1418 Жыл бұрын

new subscriber here! Thanks for sharing

@KSRDatavizon Жыл бұрын

Thanks for subbing!

@Jai_Radhe_Radhe 9 ай бұрын

Thanku 😊

@KSRDatavizon 9 ай бұрын

you are welcome, Thanks for comment, Please share , like and subscribe our channel it motivates us

@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 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 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 3 ай бұрын

Use a index to assign values as per order you want and sort the region by index column in data view

@amansalimshaikh1725 10 ай бұрын

Please provide the link of the dataset so that we can do in parallel.

@KSRDatavizon 8 ай бұрын

drive.google.com/drive/folders/1_MrrzHizjFRSeiXVwzbb4SCQf4lfAQqa?usp=sharing

@rashmimishra99 4 ай бұрын

Wonderful

@KSRDatavizon 3 ай бұрын

Thank you! Cheers! Please share with your friends too. and subscribe our channel

@sandipansarkar9211 Жыл бұрын

finished watching

@KSRDatavizon Жыл бұрын

Thank You

@Nayadaur11 Жыл бұрын

Mam how to add fields panel?

@jyothsnabandi2552 Жыл бұрын

What is the description which you mentioned as readable and non readable ?

@KSRDatavizon Ай бұрын

readable - if someone sees your visual they should understand by themelves. non-readable - if visual is not clear for explaination

@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 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 5 ай бұрын

Amazing!!!!

@KSRDatavizon 5 ай бұрын

Thanks!! Please subscribe our channel for regular updates

@akupatichiranjeevi6159 11 ай бұрын

Kindly please do a video on types of licenses and their differences

@KSRDatavizon 3 ай бұрын

ure sir, will make the video. Please subscribe our channel for regular updates.

@gourabsjourney 10 ай бұрын

Please make a detailed video on Power Bi service as well

@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 Жыл бұрын

Ma'am please provide dataset for every video....

@rajivbhokare632 Жыл бұрын

Data Is not able to Download From Github Plz Share The link

@KSRDatavizon 2 ай бұрын

sure we will update latest one

@rajivbhokare632 2 ай бұрын

@@KSRDatavizon yes plz

@MoonShine-bs6cl Жыл бұрын

Pls share the file... How do we practice

@KSRDatavizon Жыл бұрын

github.com/ksrpowerbi/KSR_DAX_Datasets

@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 Жыл бұрын

sure will check on the same will update in future sessions

@Sunilkumar-l7g5w 2 ай бұрын

Very good lecture, mam can you share the file pls

@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."