instead of writing this big dax for calculating growth% after calculating previous year sales we can follow these steps: calculate 1. Total sales = Sum(sales) 2. Growth % = DIVIDE([Total sales]-[Previous year sales],[Previous year sales])
Hi, can u make a video on this question plzzzz...... Add all 3 tables from the model and create a table to show the detailed information for each day wise the sum of order quantity, shipped quantity, and delivered quantity. Kindly use a card visual to show the difference between the total order quantity and the shipped quantity, the 2nd difference between total order quantity and delivered quantity, using quick measure.
Refer to Financials sample data. 1. Create a clustered column chart referring to the order date and sales, then apply bookmarks based on date year, quarter, and month.
2. Create a country overview page and add another page that contains detailed information about the country with drill through options. 3. Add the reset image in which all the filters should get removed and the report page should be default in the country information page.
Create a basic scatter plot using sales and Profit information and represent it (refer to region column), which helps identify the highest green color and lowest sales red color. please expalin this que
Please make video on -Create the Hierchey and rename with Location for Country-State-Region-City -Postal Code and Show the Location wise Sales using Superstore Dataset
Question - for Power BI - Create the Hierchey and rename with Location for Country-State-Region-City -Postal Code and Show the Location wise Sales using Superstore Dataset
Refer to Financials sample data. 12. Create a clustered column chart referring to the order date and sales, then apply bookmarks based on date year, quarter, and month.
13. Create a country overview page and add another page that contains detailed information about the country with drill through options. 14. Add the reset image in which all the filters should get removed and the report page should be default in the country information page.
qustion for tableau Assignment 2 --- From the Netflix Titles dataset, merge tables using Inner Joins and identify the actor/actress with the highest number of appearances in Sports Movies. Provide the name of the actor/actress and the corresponding movie titles they've starred in.
Sir Growth % measure hum dusre tarekese bhi find out kar sakte he first we have to find YOY Change ..........YOY Change = SUM(Superstore[Sales])-[Last Year Sales] then for Growth% Divide YOY Change bye last year sales ...............Growth % = DIVIDE([YOY Change],[Last Year Sales]) And here it is..
6. Import data from 2023 Worldwide Box Office - Box Office Mojo and add the past 3 years of data in the Power Query editor, create a master table of the past 3 years of data, and load only master data in the power bi query editor or power bi desktop? 7. Delete unwanted columns, replace, or remove the error value in the master table and format the data and represent the column quality.
Add all the three tables from the model and create a table to show the detailed information for each day wise the sum of order quantity shipped quantity and delivered quantity. kindly use a card visual to show the difference between the total order quantity and the ship quantity the second difference between total order quantity and delivered quantity using quick measure.
This lesson ws amazing really looking forward to learn more sir thanks for explation on growth% parth Thanks so so Much
instead of writing this big dax for calculating growth% after calculating previous year sales we can follow these steps:
calculate 1. Total sales = Sum(sales)
2. Growth % = DIVIDE([Total sales]-[Previous year sales],[Previous year sales])
Thank you it helped me alot
your teaching skill are amazing sir
thank u
Hi, can u make a video on this question plzzzz......
Add all 3 tables from the model and create a table to show the detailed information for each day wise the sum of order quantity, shipped quantity, and delivered quantity. Kindly use a card visual to show the difference between the total order quantity and the shipped quantity, the 2nd difference between total order quantity and delivered quantity, using quick measure.
I have already made video on this topic you can checkout in my channel
this was assignment in exelr class thank you
This helped me a lot. Thank you sir. well explained.
Thank you for solving this question
Refer to Financials sample data.
1. Create a clustered column chart referring to the order date and sales, then apply bookmarks based on date year, quarter, and month.
2. Create a country overview page and add another page that contains detailed information about the country with drill through options.
3. Add the reset image in which all the filters should get removed and the report page should be default in the country information page.
I already made video on all this topic u can checkout in my channel
@@all_about_data_ 2nd and 3rd?
Question - for Power BI -
Create the Waterfall Chart to show Category-wise, Yearly Analysis using Superstore Dataset.
Question - for Power BI
Create Donut Chart to Show region wise Profit and Drill through the other page with West Region using Superstore Dataset
Create a basic scatter plot using sales and Profit information and represent it (refer to region column), which helps identify the highest green color and lowest sales red color. please expalin this que
Please make video on -Create the Hierchey and rename with Location for Country-State-Region-City -Postal Code and Show the Location wise Sales using Superstore Dataset
Question - for Power BI -
Create the Hierchey and rename with Location for Country-State-Region-City -Postal Code and Show the Location wise Sales using Superstore Dataset
Refer to Financials sample data.
12. Create a clustered column chart referring to the order date and sales, then apply bookmarks based on date year, quarter, and month.
13. Create a country overview page and add another page that contains detailed information about the country with drill through options.
14. Add the reset image in which all the filters should get removed and the report page should be default in the country information page.
Check out video
ruclips.net/video/2UWJislDChI/видео.htmlsi=1XsNbU5vZfHsXKFd
qustion for tableau
Assignment 2
---
From the Netflix Titles dataset, merge tables using Inner Joins and identify the actor/actress with the highest number of appearances in Sports Movies. Provide the name of the actor/actress and the corresponding movie titles they've starred in.
Question - for Power BI
Create the Finance Dashboard and add Navigation, Cards, Charts, Link to the Website and Slicer (Using Finance Dataset)
Hello sir Thank you so much for this video.
Could you please show one formula in a Tableau that is how to find out Return rate for superstore data
why does mine shows the same totals? Last year Sales = CALCULATE(SUM(JOB_HDR[ESTIMATE]),SAMEPERIODLASTYEAR(JOB_HDR[START DATE].[Date]))
How to show the same period last year's name as well in the bar chart ? Basically want to see in the tooltip.
Sir Growth % measure hum dusre tarekese bhi find out kar sakte he
first we have to find YOY Change ..........YOY Change = SUM(Superstore[Sales])-[Last Year Sales]
then for Growth% Divide YOY Change bye last year sales ...............Growth % = DIVIDE([YOY Change],[Last Year Sales])
And here it is..
Nice video sir
6. Import data from 2023 Worldwide Box Office - Box Office Mojo and add the past 3 years of data in the Power Query editor, create a master table of the past 3 years of data, and load only master data in the power bi query editor or power bi desktop?
7. Delete unwanted columns, replace, or remove the error value in the master table and format the data and represent the column quality.
will make video on this topic asap
ruclips.net/video/oWf9pHH_d_8/видео.htmlsi=JsHA2sFsBAE-2f8j
create a shared workspace and add the organization members to the workspace then publish the report. In powerbi..?
Add all the three tables from the model and create a table to show the detailed information for each day wise the sum of order quantity shipped quantity and delivered quantity. kindly use a card visual to show the difference between the total order quantity and the ship quantity the second difference between total order quantity and delivered quantity using quick measure.
I have already made video on this topic u can checkout in my channel
Show the Top 3 products with respect to sum of quantity under each segment (Total 9 products) in West region. Make this video sir
These formula works in DAX
Waiting for MySQL assignment Series...
It will be not just assignment series there will be teaching basic to advance sql
@@all_about_data_ Thank you for prompt reply you are doing amazing work just keep it up and eagerly waiting for MYSQL Learning series from you..
its Relay help full