Data Science Tutorials
Data Science Tutorials
  • Видео 1 100
  • Просмотров 7 559 224
Power BI Line Chart Cumulative | Cumulative Sum on Line Chart | DAX for Cumulative Sum
Power BI tutorial to show how you can create a cumulative sum and then display it on the line chart to show the progress of KPI like sales or profit etc. I have first shown how you can build a cumulative sum using the calculate, sum, allselected and max function and then how this can be used on power bi line chart to show the trending line chart.
Cumulative line chart is helpful to know where the trend is intact or stagnant or slowing down.
Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com
In this training I cover 10 advance dashboards with lot of dax and visualization configuration for stan...
Просмотров: 49

Видео

How to Add Horizontal Line in the Power BI Line Chart to Highlight important Events
Просмотров 1172 часа назад
Power BI Tutorial to show how you can add a horizontal line on a specific date in a line chart which helps highlight an event on the chart. Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com In this training I cover 10 advance dashboards with lot of dax and visualization configuration for standar...
Improving Power BI Dashboard Project for New Business Requirements | Adding Advance Functionalities
Просмотров 62428 дней назад
Power BI dashboard enhancement with new business requirements where we'll see that how we can add advance functionalities in power bi dashboard when we implement the business feedback by solving complex scenarios related to ranking, top n rows etc. which helps taking the power bi dashboard to next level and providing more functionality to end users. Here we have looked at complex situations rel...
Power BI Dashboard Project for Zomato Restaurant Business | Build Step by Step KPI Dashboard
Просмотров 1,9 тыс.Месяц назад
Power BI Tutorial for beginners on how to create a dashboard within power bi for business to visualize business related KPIs and visualizations. I am covering a lot of key dashboard design and development techniques in this tutorial so hope you'll enjoy creating this dashboard. Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email ...
Interactive Tableau KPI Dashboard Project for Zomato Data Analysis
Просмотров 234Месяц назад
Learn how to create interactive KPI dashboard in tableau by using the Zomato restaurant data. In this dashboard we are using the scenario that a person wants to open a new restaurant and has the existing data of restaurants of the city, then what are the KPIs, Charts and Metrics s/he can design in the tableau and finally create a good Dashboard Layout for the end users. Connect with me on Linke...
Tableau Interview Question - How to add new file to existing data
Просмотров 70Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - What is the default join in tableau
Просмотров 41Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - How to join all the files that are present in the folder
Просмотров 44Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - How to change date field from calendar year to fiscal year
Просмотров 44Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - Difference between Calculated Field and Parameter
Просмотров 47Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Power BI & Tableau Demo Class with Interview Question Prep | 1 Year Course
Просмотров 155Месяц назад
As I am starting a 1 year course in tableau and power bi to not only teach these two BI tools but also prepare you for interview. With this class, you'll not only get the advance level skill set in these two BI tools, but also investing time in preparing the tricky interview questions. Want to prepare yourself? contact - abhishek.agarrwal@gmail.com
Tableau Interview Question - Count of customers who have ordered at least 3 times
Просмотров 44Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - How to find customers who have ordered only once
Просмотров 40Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - How to Find Frequent vs Infrequent Purchase
Просмотров 42Месяц назад
Tableau interview questions series where objective is that you practice the questions like it has come in interview and find out the answers. In interview they ask simple question in such a way that you start thinking about how exactly this can be done and with this series you can learn how to interpret the question by tableau functionality. In the second question, I am asking the question that...
Tableau Interview Question - How to Find Highest city sales is above average or not
Просмотров 119Месяц назад
Tableau Interview Question - How to Find Highest city sales is above average or not
Tableau Interview Question - After how many quarters customer is making a repeat purchase
Просмотров 48Месяц назад
Tableau Interview Question - After how many quarters customer is making a repeat purchase
Tableau Interview Question - How to calculate the average state sales from highest city sales
Просмотров 39Месяц назад
Tableau Interview Question - How to calculate the average state sales from highest city sales
Tableau Interview Question - How to find difference from selected category
Просмотров 55Месяц назад
Tableau Interview Question - How to find difference from selected category
Tableau Interview Question - How to Calculate Customer Acquisition Trend Metric
Просмотров 59Месяц назад
Tableau Interview Question - How to Calculate Customer Acquisition Trend Metric
Tableau Interview Question - Which cities are contributing to highest sales in the state
Просмотров 44Месяц назад
Tableau Interview Question - Which cities are contributing to highest sales in the state
Tableau Interview Question - What are the Highly profitable, profitable and unprofitable days
Просмотров 39Месяц назад
Tableau Interview Question - What are the Highly profitable, profitable and unprofitable days
Tableau Interview Question - Have our customers made orders all around the year
Просмотров 54Месяц назад
Tableau Interview Question - Have our customers made orders all around the year
Tableau Interview Question - Contribution of Revenue from previous year customers into current year
Просмотров 64Месяц назад
Tableau Interview Question - Contribution of Revenue from previous year customers into current year
Tableau Interview Question - What is the Customer Order Frequency or Repeated Orders
Просмотров 117Месяц назад
Tableau Interview Question - What is the Customer Order Frequency or Repeated Orders
5 Tableau Interview Question - How to Compare Quarterly Sales Trend for Various Years
Просмотров 54Месяц назад
5 Tableau Interview Question - How to Compare Quarterly Sales Trend for Various Years
4 Tableau Interview Questions - How to get the latest order date that is constant for all Dimensions
Просмотров 70Месяц назад
4 Tableau Interview Questions - How to get the latest order date that is constant for all Dimensions
3 Tableau Interview Question - Customer biggest order count in any year
Просмотров 522 месяца назад
3 Tableau Interview Question - Customer biggest order count in any year
2 Tableau Interview question - How to get the first purchase date of customer
Просмотров 1052 месяца назад
2 Tableau Interview question - How to get the first purchase date of customer
1 Tableau Interview Question - How to create a measure that is not impacted by Filters
Просмотров 1532 месяца назад
1 Tableau Interview Question - How to create a measure that is not impacted by Filters
Tableau Exclude LoD Tutorial with Use case and Exercises
Просмотров 1102 месяца назад
Tableau Exclude LoD Tutorial with Use case and Exercises

Комментарии

  • @ShreyasSinha
    @ShreyasSinha 2 дня назад

    Was hoping you would explain last 10 15 days on a slicer

  • @panfriedbacon
    @panfriedbacon 2 дня назад

    How Do we get around renaming Desktop Version of PBI and Workspace, but maintaining access to users? E. G. If Desktop name = Report_1.1 And I want to rename Workspace to Report_Final But I need to maintain User Access same as Reprot_1.1

  • @user-gq6cg3ls7f
    @user-gq6cg3ls7f 4 дня назад

    Thank you for the video. I couldn't find the dataset.

  • @user-dd9lj4hu4x
    @user-dd9lj4hu4x 5 дней назад

    great explanation.. thank you

  • @MalayKumar98
    @MalayKumar98 7 дней назад

    1. You spent 2 minutes explaining yourself as if this is your first video and yiur audience is too stupid to know what this business is about. 2. You spent too much time giving boring part explaining what is release year or and what is duration. Please understand, this is a data analysis video...ppl who will come to your video obviously have certain knowledge.

  • @ManjeeraK
    @ManjeeraK 7 дней назад

    Very useful video. Have a question. Is it possible to sort the breakdown field. I created a waterfall chart where year on axis quarter is the breakdown field and total revenue is the metric. I wanted to see the quarter also in ascending order along with the year.

  • @SivaKrishna-kj2gp
    @SivaKrishna-kj2gp 7 дней назад

    Hi, Thank you for your videos. Is there a video on how to create a trend chart for user engagement. I have user_id and event_date in a table and need to plot a chart which should show percentages of engagement(active user) for each month over the years.

  • @brijeshthakrar2106
    @brijeshthakrar2106 9 дней назад

    Hey!, It helped me understand concept but I had a doubt, let's say ID "12345" was in all 3 but when you used distinct function in which row it was counted ? In Furniture or in Office supply or in Tech ? Cause in the data that I'm working it will make a huge difference I want to know more about it if you could reply

  • @kanikasuneja7777
    @kanikasuneja7777 10 дней назад

    Would have been great if you had also put detailed project videos of these. Just looking at it, not helping much

    • @RVideoTutorials
      @RVideoTutorials 10 дней назад

      Video is to give details what kind of advance dashboard I am covering in my training.

  • @Jawidfaqiry
    @Jawidfaqiry 12 дней назад

    can you put the link to download the powerbi desktop

    • @RVideoTutorials
      @RVideoTutorials 10 дней назад

      www.microsoft.com/en-us/power-platform/products/power-bi/downloads

    • @Jawidfaqiry
      @Jawidfaqiry 9 дней назад

      @@RVideoTutorials many thanks for the all the support i got it.

  • @videholidays
    @videholidays 13 дней назад

    If I share .pbix file to the other user. Will this additional chart type work seamlessly? Or it needs any configuration on that other laptop?

    • @RVideoTutorials
      @RVideoTutorials 10 дней назад

      they need to have power bi desktop installed to use or interact with file.

  • @hiovanycubillosgomez5901
    @hiovanycubillosgomez5901 14 дней назад

    awesome videos

  • @anilsuvvada7302
    @anilsuvvada7302 14 дней назад

    Clean n clear👌

  • @mosama22
    @mosama22 15 дней назад

    Thank you for the beautiful video 🙂 But FYI: Starting in 0.20.0, the .ix indexer is deprecated, in favor of the more strict .iloc and .loc indexers.

  • @HarshitSrivastav-of4cd
    @HarshitSrivastav-of4cd 15 дней назад

    sir can you share your contact information for work enquiry

    • @RVideoTutorials
      @RVideoTutorials 15 дней назад

      you can reach out : abhishek.agarrwal@gmail.com

  • @shanx4590
    @shanx4590 18 дней назад

    Actually there is no data heirarchy feild in the data set provided?

  • @WisamMSaeed
    @WisamMSaeed 18 дней назад

    where is the csv file of this dashboard please ? I could not find it

    • @RVideoTutorials
      @RVideoTutorials 15 дней назад

      within the given folder you can find datasets google sheet. There you'll find this and other datasets as well.

  • @janiththilanka-hp4bo
    @janiththilanka-hp4bo 18 дней назад

    i cant find ,this video use to data set can you give the direct link

  • @koushikchoudhury2179
    @koushikchoudhury2179 19 дней назад

    Dear , you are ultimate. A true SME.Good show.Keep it up.Excellent dear

  • @theabhishekshaww
    @theabhishekshaww 19 дней назад

    Hi I need a help for my project... Can you please help me? How should I contact you?

    • @theabhishekshaww
      @theabhishekshaww 19 дней назад

      Actually I work in an MNC company and I am stuck in a situation if can you please help me on real time project😊?

  • @TheJaebeomPark
    @TheJaebeomPark 19 дней назад

    amazing

  • @vijeandran
    @vijeandran 20 дней назад

    superb video 😍

  • @gihan121
    @gihan121 21 день назад

    3 mins to get to the point

  • @JuanHernandez-pf6yg
    @JuanHernandez-pf6yg 22 дня назад

    Useful. Thank you.

  • @SriramNikhil-ss8ey
    @SriramNikhil-ss8ey 22 дня назад

    sir pleaes give the data sheet please , please sir ..

  • @SriramNikhil-ss8ey
    @SriramNikhil-ss8ey 22 дня назад

    Hi Sir, Really Impressed your way of teaching. your videos are most helpful to restart my carrier. Sir one request sir pls if you can provide me the "Requirement Document & Excel data" to go through and it will add lika a project to my skills.

    • @RVideoTutorials
      @RVideoTutorials 13 дней назад

      excel data link is given in description and I have explained in video how you can get it. Also requirement is something I have shown it in the video itself.

  • @dhakafady774
    @dhakafady774 23 дня назад

    TO CALCULATE I DID THIS DAX BUT THE RESULT CAME (BLANK) , WHY? SIR PLEASE CORRECT MY DAX PLEASE SIR YoYGrossSales = VAR CurrentYear =TOTALYTD(SUM(Sheet1[Gross Sales]), Sheet1[Date]) RETURN DIVIDE( CALCULATE([TOT G SALE], 'Sheet1'[Year] = CurrentYear) - CALCULATE([TOT G SALE], 'Sheet1'[Year] = CurrentYear - 1), CALCULATE([TOT G SALE], 'Sheet1'[Year] = CurrentYear - 1

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @dhakafady774
    @dhakafady774 23 дня назад

    sir pleaes give the data sheet please , please sir .

  • @QingxiaoWang
    @QingxiaoWang 24 дня назад

    There's no dataset at all. Nobody can practice it.

  • @weirsteven
    @weirsteven 24 дня назад

    Thanks so much for this tutorial. Currently learning DAX after a few months getting reacquainted with SQL. It really made this "click".

  • @venatiusndifor961
    @venatiusndifor961 26 дней назад

    Hello please i need help, I did some work on power bi desktop published the work to workspace on powerbi.com then due to some technical issues i lost the file (i can only access older verson of which i have done more 6 days review on the present file and published). Now my worry is, how do i get the most recent verson from powerbi.com (workspace) back to the desktop?? please i need help.

  • @LucasSzybalski
    @LucasSzybalski 26 дней назад

    Is there a way to do this on AGG( , I see in video you have sum. Unchecking "aggregate" is grayed out.