Dean Chereden
Dean Chereden
  • 73
  • 271 974
#1 report TIME-SAVING hack you are probably not using - Wireframe
Creating reports can be very time-consuming, but there are ways to help speed up the process, and one of those is WIREFRAMES.
Wireframes help not only plan out how the report will look but also what the report really needs, and be able to visually talk through the report with the stakeholder before a single metric is even created. Even better, the stakeholder can create wireframes so you don’t have to, saving you even more time.
#Wireframe #BIAnalyst #PowerBI
▶️ How to create a Power BI Dashboard from scratch
th-cam.com/video/7lGjFs514f4/w-d-xo.html
🔖c h a p t e r s 🔖
00:00 - Intro
00:30 - What is a Wireframe
01:03 - How Does Wireframing Save Time
03:08 - How Can I Create a Wireframe
💌 My email - dean@deanchereden.com
🌍 My website - www.deanchereden.com
🐦 Twitter - deanchereden
🎵 Ben Bada Boom - Frisky Feeling chll.to/e7cf01a6
🎶 Listen to Chillhop Music - th-cam.com/video/kpO-nyGEBJ4/w-d-xo.html
B-Roll used:
www.pexels.com/video/coworkers-having-a-meeting-in-the-meeting-room-8141545/
www.motionelements.com/stock-video-30513782-business-time-and-money-on-a-scale-balance-cartoon
pixabay.com/videos/work-office-people-working-87593/
pixabay.com/videos/growth-grow-success-chart-graph-108459/
pixabay.com/videos/meeting-planning-marketing-business-2340/
pixabay.com/videos/whiteboard-planning-strategy-1658/
www.pexels.com/video/person-using-a-laptop-7947512/
มุมมอง: 640

วีดีโอ

Execs will LOVE this.... Power BI in PowerPoint
มุมมอง 7924 หลายเดือนก่อน
Having to update PowerPoint slides each month with data can be very time-consuming, and even worse when you update it only for the meeting to be cancelled or moved, so it needs to be updated again and you end up wasting your time updating the first time. This is where importing Power BI directly into PowerPoint can save so much time, as you can recreate the slides in Power BI, publish them and ...
Ultimate Power BI Rolling Averages Guide
มุมมอง 2.4K5 หลายเดือนก่อน
When working with data it can be hard to see the trend when the period of time causes peaks and lows or compares how the last x days, weeks or months compare to the current day, week or month. This is when rolling averages can help as it can smooth the data to a selected period of time, like the last 7 days or 4 weeks, to understand and compare periods and trends. #PowerBI #DAX #PBICoreVisuals ...
Scrape the web for player market value using RStudio | worldfootballr
มุมมอง 1796 หลายเดือนก่อน
In this video, I show how to get player market value data using R, both past and present, for all football / soccer players, covering different seasons, and leagues and get their stats and last transfer value too. #rstat #dataanalyst #rstudio 📁 Rscript used in the video data.world/deanchereden/football/workspace/file?filename=Football Market Value - worldfootballr.R ▶️ How to install R and RStu...
This is a GAME CHANGER! Dynamic Switching Metrics in Visuals | Power BI
มุมมอง 3.2K7 หลายเดือนก่อน
I found this amazing trick to update any visual, and any formatting, including conditional formatting and reference labels, when selecting a metric from its core measure using field parameters, and a lot of SWITCH 😀 🚫 Problem I needed to create multiple KPI cards for a KPI Tree but each card had conditional formatting and various reference labels, so setting up just one was very time-consuming....
How to QUICKLY Shade Between 2 Lines in a Line Chart in Power BI
มุมมอง 2.7K8 หลายเดือนก่อน
It can be hard to see the difference between 2 trend lines, and if close together even harder if you want to know which is higher or lower. This is where shading between the lines can help and I’ll show how you can shade with lines, or fill the space, and also add dynamic colour change the lines or fill if higher or lower than each other. #PowerBI #DAX #PBICoreVisuals 📁 Dataset for Sales Data a...
How to EASILY create gauge charts with target lines using standard visuals in Power BI
มุมมอง 4.3K8 หลายเดือนก่อน
Sometimes you need to see how a metric is performing against a target but over a period of time, or categories, in a chart. This is easy to achieve in Power BI using error labels to create target lines in a standard column or bar chart, and you can find out how in this video. #PowerBI #DAX #PBICoreVisuals 📁 Dataset for Sales Data and file for original dim date table M code data.world/deanchered...
WOW with KPI Card Visuals using Reference Labels and Conditional Formatting | Power BI
มุมมอง 27K9 หลายเดือนก่อน
KPIs are key to monitoring business performance, but in most cases, they do not tell the whole story. This can now be overcome using reference labels and conditional formatting in the new card visual in Power BI and I show you how to maximise them in this video. #powerbi #dax #PBICoreVisuals 📁 Dataset for Sales Data and file for original dim date table M code data.world/deanchereden/superstore-...
Find out what football teams spent in ALL transfer windows using R
มุมมอง 12410 หลายเดือนก่อน
In this video, I show how to get transfer data for all football / soccer teams, covering different seasons, and create charts to show off your findings, using worldfootballr. #rstat #dataanalyst #rstudio 📁 Rscript used in the video data.world/deanchereden/football/workspace/file?filename=Football Transfers - worldfootballr.R ▶️ How to install R and RStudio th-cam.com/video/GsiTBOyd7ss/w-d-xo.ht...
Find Repeating Customers Using Cohort Analysis | Power BI
มุมมอง 2.2K10 หลายเดือนก่อน
When understanding customer data, one key area to look at is customer churn/retention to understand which customers/users are returning to purchase again, visit a website or app, or continue a subscription. Cohort analysis gives that insight and more, and I show you how to, using Power Query and a little bit of DAX in this video. #powerbi #dax #powerquery 📁 Dataset for Sales Data and file for o...
Toggle Button TRICK Using Bookmarks & Icons to Switch Visuals | Power BI
มุมมอง 6K11 หลายเดือนก่อน
Users of reports & dashboards generally prefer seeing the same data in different formats, like a table or a chart, & this can mean creating multiple pages to cover every user’s preferred visual.. But what if there was another way? Luckily there is by using bookmarks to switch between different visuals using either the built-in bookmark button or creating your buttons using any icon you wish, an...
EASILY create PIZZA PLOTS for football player stats using R & ggshakeR
มุมมอง 837ปีที่แล้ว
Pizza plots, percentile plots, are a great way to see football / soccer player stats against similar players in the same area, league and compare 2 players. Normally getting the data and setting up the visual can involve many lines of code but with worldfootballr for the data and ggshakeR for the pizza plots, you can easily create them in just a few lines of code and I show you how here. #rstat...
Dynamic LAST & PREVIOUS 12 Months in a Chart and Table | Power BI
มุมมอง 13Kปีที่แล้ว
One thing I’ve found, in my many years of creating reports in Excel and then Power BI, is when working with monthly reports for clients they were static, as of that month, looking back 12 months and the only way clients could see the previous month's last 12 months was to look at an old report. This is what led me to find a way to change that by creating moving last 12 months based on the month...
How to Conditional Format CALCULATION GROUP Columns in Power BI
มุมมอง 5Kปีที่แล้ว
Calculation groups are a great way to reduce the creation of multiple measures but when you apply conditional formatting, it is applied to all columns! So how do you apply to only the columns you need to conditional format? I’ll show you how & also show how to when using field parameters here: #powerbi #dax #calculationgroups ▶️ Link to how to create the field parameter table shown in this vide...
LEVEL UP your Power BI reporting with R
มุมมอง 2.2Kปีที่แล้ว
Power BI has come a long way over the last 7 years but there are still areas that it lacks in. Luckily most of these can be done using R directly in Power BI by either the R visual or running an R Script, and one of the best things about this is that in many cases you only need one or few lines of code to get the result you need, and I show you how to in this video. #rstat #powerbi #rstudio #da...
Answer Questions INSTANTLY with a Glossary Page & Info Pop-Ups in Power BI
มุมมอง 3.4Kปีที่แล้ว
Answer Questions INSTANTLY with a Glossary Page & Info Pop-Ups in Power BI
Save HOURS by Reusing Multiple Measures in Calculation Groups | Power BI
มุมมอง 3.7Kปีที่แล้ว
Save HOURS by Reusing Multiple Measures in Calculation Groups | Power BI
How to Create Custom Themes in Power BI
มุมมอง 4Kปีที่แล้ว
How to Create Custom Themes in Power BI
Create Dumbbell Plots with Callouts in RStudio
มุมมอง 395ปีที่แล้ว
Create Dumbbell Plots with Callouts in RStudio
How to get football data for FREE - worldfootballR
มุมมอง 6Kปีที่แล้ว
How to get football data for FREE - worldfootballR
Effortless Data Management: List Dates Between using Power Query | Power BI
มุมมอง 4.1Kปีที่แล้ว
Effortless Data Management: List Dates Between using Power Query | Power BI
How to CONVERT JSON string file to CSV in RStudio
มุมมอง 1.3Kปีที่แล้ว
How to CONVERT JSON string file to CSV in RStudio
The ULTIMATE Append Hacks in Power Query | Power BI
มุมมอง 2.4Kปีที่แล้ว
The ULTIMATE Append Hacks in Power Query | Power BI
🌍 How to WEB SCRAPE in RStudio 🌍
มุมมอง 4.8Kปีที่แล้ว
🌍 How to WEB SCRAPE in RStudio 🌍
How To Create An ANIMATED Bar Chart Race
มุมมอง 1.5Kปีที่แล้ว
How To Create An ANIMATED Bar Chart Race
Find 'BEST PERFORMING' products with a Pareto Chart (80/20 Rule) | Power BI
มุมมอง 12Kปีที่แล้ว
Find 'BEST PERFORMING' products with a Pareto Chart (80/20 Rule) | Power BI
🔽 Convert a string JSON file in just a FEW CLICKS 🖱️ using Power Query | Power BI
มุมมอง 1.6Kปีที่แล้ว
🔽 Convert a string JSON file in just a FEW CLICKS 🖱️ using Power Query | Power BI
Add IMAGES 🖼️ to Charts in RStudio
มุมมอง 1.2Kปีที่แล้ว
Add IMAGES 🖼️ to Charts in RStudio
How to Calculate Mean, Median & Mode in Power BI using DAX | Statistics: Central Tendency
มุมมอง 10Kปีที่แล้ว
How to Calculate Mean, Median & Mode in Power BI using DAX | Statistics: Central Tendency
Unlock Infinite API Data Requests - Leverage the Power of For Loop in RStudio
มุมมอง 783ปีที่แล้ว
Unlock Infinite API Data Requests - Leverage the Power of For Loop in RStudio

ความคิดเห็น

  • @peterrollon8529
    @peterrollon8529 4 วันที่ผ่านมา

    thank you for making this video sir, it helps me a lot

  • @ibrahim82649
    @ibrahim82649 9 วันที่ผ่านมา

    This is amazing

  • @gaurav_717
    @gaurav_717 17 วันที่ผ่านมา

    thank you sir

  • @gospelmoto2833
    @gospelmoto2833 18 วันที่ผ่านมา

    Helpful and practically doable! New sub here.

  • @arshumafaz
    @arshumafaz 20 วันที่ผ่านมา

    I am not getting the dataset from the supplied link. It is showing Oops! We can't find that page. Please help with new link

    • @DeanChereden
      @DeanChereden 20 วันที่ผ่านมา

      You need to be logged into data.world to view the datasets

  • @andrewrynd3823
    @andrewrynd3823 22 วันที่ผ่านมา

    the script link doesn't work anymore. Is is stored in a different place?

    • @DeanChereden
      @DeanChereden 20 วันที่ผ่านมา

      Are you logged into data.world? You'll get an error / oops message if not

  • @christianbauermeister6266
    @christianbauermeister6266 28 วันที่ผ่านมา

    great video , thanks.

  • @Dematsa
    @Dematsa หลายเดือนก่อน

    Sweet thanks!

  • @tonyboateng-minta2308
    @tonyboateng-minta2308 หลายเดือนก่อน

    Amazing

  • @richardh99999
    @richardh99999 หลายเดือนก่อน

    Link to calendar table file is broken. Do you have a new link please?

    • @richardh99999
      @richardh99999 หลายเดือนก่อน

      I ended up building my own following your instructions 🙂

  • @shreedevirao5246
    @shreedevirao5246 หลายเดือนก่อน

    How can I use Toggle switch without using Ctrl?

    • @DeanChereden
      @DeanChereden หลายเดือนก่อน

      It's the only way in desktop. If the report was published to the Power BI service it would work with just a click. I think it's a Microsoft thing because all their products like word and PowerPoint require pressing ctrl when clicking on hyperlinks too, unless they are viewed in the web.

  • @richardh99999
    @richardh99999 หลายเดือนก่อน

    Love the enthusiam you share here for how powerful One Power Bi Report can be, all in one place ! I wish you could take our data and build the same kind of report for us !

  • @liveurlife3166
    @liveurlife3166 หลายเดือนก่อน

    This was crucial for my basics in DAX

  • @busouting
    @busouting 2 หลายเดือนก่อน

    Thank you

  • @edithchansigaud3550
    @edithchansigaud3550 2 หลายเดือนก่อน

    VERY VERY GOOD VIDEO!!!! SUBSCRIBING!

  • @bramgroenhof
    @bramgroenhof 2 หลายเดือนก่อน

    Thanks for the video! Is it also possible to use a different variable than date to 'drive' the data? "Round 1", "Round 2", "Final" for example. is there a way to tell R to it in that other (through maybe a factor?)

  • @ankuraggarwal349
    @ankuraggarwal349 2 หลายเดือนก่อน

    Very well explained, Thanks!

  • @Solpaneler
    @Solpaneler 2 หลายเดือนก่อน

    Very interesting and informative video! I'm new to R, I installed the worldfootballR package, when I try certain functions like for example fotmob_get_match_team_stats() seen at @48:26 R sais "could not find function". Would appriciate if someone could tell me what I'm doing wrong 😄 Nevermind, just saw this: "Note that fotmob data is no longer provided since the release of v0.6.4 due to a change in their terms of service."

  • @laladave3089
    @laladave3089 2 หลายเดือนก่อน

    I am experiencing an issue with the 'Running Total Sales' and '% Total Sales Cumulative' measures, as I am receiving the error message: 'Visual has exceeded the available resources.' I would greatly appreciate your assistance. Thank you.

  • @ukchrism
    @ukchrism 2 หลายเดือนก่อน

    One of the best Power BI channels on here.... come on TH-cam!!!

  • @MrPostfattism
    @MrPostfattism 2 หลายเดือนก่อน

    How do you get the "valid, empty, error" at the top of your columns in power query? I have not found an easy way to check my dimensions to my fact tables and this seems like an elegant solution.

    • @DeanChereden
      @DeanChereden หลายเดือนก่อน

      It's part of the view options when in Power Query. You'll want to check the boxes under View called Column Quality and Column Distribution. Also ensure you look at all data and not the top 1000 rows. I can check if you look at the bar at the bottom of the transform data view and see if it says ' Column profiling based on top 1000 rows'. If it is, click on the wording and select the option that covers the entire data set.

  • @panduislami7832
    @panduislami7832 2 หลายเดือนก่อน

    thank you, Dean. It's really easy to understand and really easy to do.

  • @phamanhthu1596
    @phamanhthu1596 2 หลายเดือนก่อน

    Can you please help me to debug :( My calculation group have: Current, Previous week, WoW Previous week = CALCULATE( SELECTEDMEASURE(), DATEADD(tb_dim_date[date], -7, DAY) ) ------------------------- WoW = SELECTEDMEASURE() - CALCULATE( SELECTEDMEASURE(), 'Summary Metric'[Time Intelligence] = "Previous week" ) but when I apply Measure Switching Conditional Formating same as yours, it does not work. because the WoW cannot display in the SELECTEDVALUE, i got error "Couldn't load the data for this visual" - cannot convert value 'WoW' of type Text to type Numeric/Date. Much appreciate!!

  • @experience_kingsley
    @experience_kingsley 2 หลายเดือนก่อน

    Thank you! This was really good. I will be watching more of your tutorials.

  • @BlakeC341
    @BlakeC341 2 หลายเดือนก่อน

    Underrated channel.

  • @panduislami7832
    @panduislami7832 2 หลายเดือนก่อน

    Thank you, Dean. This tutorial really easy to do.

  • @kanibala-z7c
    @kanibala-z7c 2 หลายเดือนก่อน

    Hey,here i see you have only 700 rows what if you have 1 Lakh rows how do we pull that in power bi

    • @AK-ij9il
      @AK-ij9il 2 หลายเดือนก่อน

      I'm struggling the same, you got any solution?

  • @scottwilliams6741
    @scottwilliams6741 3 หลายเดือนก่อน

    This is a super helpful video. I have been trying to figure out how to set up previous year's value with a Selected Measure. Thanks so much for this great video, Dean!

  • @theimmoralcookie
    @theimmoralcookie 3 หลายเดือนก่อน

    Spent all day looking for mode. Thx.

  • @AlemayehuMullatu
    @AlemayehuMullatu 3 หลายเดือนก่อน

    Thank you very much for sharing with us this great video.

  • @sudarshanvp2660
    @sudarshanvp2660 3 หลายเดือนก่อน

    Thank you Dean for explaining this in the simplest way possible

  • @iiiiii-w8h
    @iiiiii-w8h 3 หลายเดือนก่อน

    don't you end up with some regions shaded both green and red?

  • @euemeupaiful
    @euemeupaiful 3 หลายเดือนก่อน

    you are a beast💥💥

  • @zique711
    @zique711 3 หลายเดือนก่อน

    This was a great video thanks for making it. It helped me to better understand basic stats in R.

  • @adambenkiki6304
    @adambenkiki6304 3 หลายเดือนก่อน

    does not work. all i get are blanks

  • @data-made-simple
    @data-made-simple 3 หลายเดือนก่อน

    Thank you Dean - clever trick to get formatting working with both field parameters and calculation groups!

  • @mikomori9623
    @mikomori9623 3 หลายเดือนก่อน

    Great video, thanks, love the card’s visuals

  • @dizzyboy92
    @dizzyboy92 4 หลายเดือนก่อน

    Thanks for the information!

  • @Nalaka-Wanniarachchi
    @Nalaka-Wanniarachchi 4 หลายเดือนก่อน

    Nice an clean explanation.This could further enhanced by using calculation groups.

  • @movietalkstudio3030
    @movietalkstudio3030 4 หลายเดือนก่อน

    It's amazing

  • @sachi28100
    @sachi28100 4 หลายเดือนก่อน

    it was bit fast for a beginners, but helpful thank you

  • @juanignacioXI
    @juanignacioXI 4 หลายเดือนก่อน

    Awesome Dean, this is what i was looking for!

    • @DeanChereden
      @DeanChereden 4 หลายเดือนก่อน

      Glad it helped 🙂

  • @markNXCH
    @markNXCH 4 หลายเดือนก่อน

    Nice Video! But.. Zooming in is very annoying..

  • @XITIJTHOOL
    @XITIJTHOOL 4 หลายเดือนก่อน

    nice one

  • @WaqasKhan-sp3sn
    @WaqasKhan-sp3sn 4 หลายเดือนก่อน

    excellent tutorial

  • @alexjenkins8026
    @alexjenkins8026 4 หลายเดือนก่อน

    so, design it in a way from day 1 that you expect it to change? lol :(

  • @robertthompson0
    @robertthompson0 4 หลายเดือนก่อน

    This is nice. I wonder if instead of using UNICHAR to return the up and down arrows you could write it into the VAR targetpercent using custom formatting like you can for a measure in format on the ribbon in measure tools. I know this works to return up and down arrows based on positive and negative values although you can't currently write colours into the formatting like you can in excel. So it would change from - VAR targetpercent = FORMAT(DIVIDE(targetdiffamount, target,0),"0.0%") to VAR targetpercent = FORMAT(DIVIDE(targetdiffamount, target,0),"▲ "0.0%;"▼ "0.0%; I might test it and see. It just means that you do not have to create 2 additional variables and call them in the returned result. You could just return the targetpercent.

  • @608er
    @608er 4 หลายเดือนก่อน

    Great stuff

  • @WaqasKhan-sp3sn
    @WaqasKhan-sp3sn 4 หลายเดือนก่อน

    Best tutorial

  • @WaqasKhan-sp3sn
    @WaqasKhan-sp3sn 4 หลายเดือนก่อน

    HI Dean. can u share PBIX file of this kpi report. thanks