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])
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
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.
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.
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.
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
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.
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..
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])
PREVIOUS YEAR column is added but not showing another bar as previous year.
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.
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
your teaching skill are amazing sir
thank u
this was assignment in exelr class thank you
Bhai job lgi kya veha se course kr k
create a shared workspace and add the organization members to the workspace then publish the report. In powerbi..?
Question - for Power BI -
Create the Waterfall Chart to show Category-wise, Yearly Analysis using Superstore Dataset.
This helped me a lot. Thank you sir. well explained.
Thank you for solving this question
Question - for Power BI
Create Donut Chart to Show region wise Profit and Drill through the other page with West Region using Superstore Dataset
Thank you it helped me alot
Create the finance dashboard and add navigation cards charts link to the website and slicer
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?
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
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
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
Question - for Power BI
Create the Finance Dashboard and add Navigation, Cards, Charts, Link to the Website and Slicer (Using Finance Dataset)
Plz send me this video link
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
th-cam.com/video/2UWJislDChI/w-d-xo.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.
Nice video sir
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
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
th-cam.com/video/oWf9pHH_d_8/w-d-xo.htmlsi=JsHA2sFsBAE-2f8j
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
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..
These formula works in DAX
Show the Top 3 products with respect to sum of quantity under each segment (Total 9 products) in West region. Make this video sir
its Relay help full
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..