![Sweatpants BI](/img/default-banner.jpg)
- 100
- 137 383
Sweatpants BI
United States
Приєднався 26 вер 2011
Tips, tricks, walkthroughs, and tutorials primarily focused on Microsoft Power BI, Data Visualization, and Data Storytelling. Content is intended for anyone who spends most of their day building amazing business intelligence tools, captivating data visuals, and incredible designs, whether they spend 99% of their time doing that in sweatpants at home (like Sean) or dressed like an actual grown-up at the office.
Note: I will rarely read the comments on anything I post here. It's not that I don't appreciate your support and feedback; it's mostly just a lack of time between managing my busy day job, multiple Power BI classes that I teach, and making time for family. If you desperately need to reach me or if you're seeking the .pbix file for something I built, LinkedIn is the best way to reach me and I'll do my best to get back to you quickly.
Note: I will rarely read the comments on anything I post here. It's not that I don't appreciate your support and feedback; it's mostly just a lack of time between managing my busy day job, multiple Power BI classes that I teach, and making time for family. If you desperately need to reach me or if you're seeking the .pbix file for something I built, LinkedIn is the best way to reach me and I'll do my best to get back to you quickly.
BI Book Club: Chatter by Ethan Kross
In this month's BI Book Club, we're going to focus less on data visualization and analytics and more on mental health. Working in data can be stressful: Complex requirements, tight deadlines, and unique data challenges! And don't even get me started on the stress of job-hunting. This book is a fantastic resource for people who are struggling with self-doubt or who recognize that sometimes the negative, pessimistic voice within our minds isn't productive. One book doesn't have all the answers of course but Chatter has tons of useful examples, tools, and science to help you understand what contributes to our sense of self, the internal monologue within us, why it goes off the rails, and how to regain control when negative emotions take the wheel!
Переглядів: 80
Відео
BI Book Club: Effective Data Storytelling by Brent Dykes
Переглядів 335Місяць тому
In this month's BI Book Club, I'm going to be talking about Effective Data Storytelling by Brent Dykes. If you've read any of the other books I've discussed on this channel, you've heard of data storytelling and probably understand it conceptually but most books don't dig too deep into this fun and nuanced topic. Not this book. In Effective Data Storytelling, the emphasis is less on the little ...
Full Power BI Report Walkthrough: Housing Market Insights - Part 6: Interactive User Features
Переглядів 4092 місяці тому
In the final part of this full-length Power BI Report walkthrough, we'll continue developing our report focused on insights from the Austin, Texas Housing Market by walking through some interactive features that will make your users excited to click around and play with your report to discover more! Dataset & Resources: drive.google.com/drive/folders/1KmeeAmz6NDAqW5z-AqckaCKiW3D51nHb?usp=drive_...
Full Power BI Report Walkthrough: Housing Market Insights - Part 5: Report Design, Continued
Переглядів 3152 місяці тому
In Part 5 of this full-length Power BI Report walkthrough, we'll continue developing our report focused on insights from the Austin, Texas Housing Market by discussing more techniques that will help us make a tool that looks incredible! Dataset & Resources: drive.google.com/drive/folders/1KmeeAmz6NDAqW5z-AqckaCKiW3D51nHb?usp=drive_link
Full Power BI Report Walkthrough: Housing Market Insights - Part 4: Report Design
Переглядів 3222 місяці тому
In Part 4 of this full-length Power BI Report walkthrough, we'll continue developing our report focused on insights from the Austin, Texas Housing Market by discussing a variety of techniques that will help us make a tool that looks incredible! Dataset & Resources: drive.google.com/drive/folders/1KmeeAmz6NDAqW5z-AqckaCKiW3D51nHb?usp=drive_link
Full Power BI Report Walkthrough: Housing Market Insights - Part 3: Visualizing the Data, Continued
Переглядів 4272 місяці тому
In Part 3 of this full-length Power BI Report walkthrough, we'll continue developing our report focused on insights from the Austin, Texas Housing Market by developing multiple views of data visuals that will help us dive deeper into different aspects of the dataset! Dataset & Resources: drive.google.com/drive/folders/1KmeeAmz6NDAqW5z-AqckaCKiW3D51nHb?usp=drive_link
Full Power BI Report Walkthrough: Housing Market Insights - Part 2: Visualizing the Data
Переглядів 5833 місяці тому
In Part 2 of this full-length Power BI Report walkthrough, we'll continue developing our report focused on insights from the Austin, Texas Housing Market by developing multiple views of data visuals that will help us dive deeper into different aspects of the dataset! Dataset & Resources: drive.google.com/drive/folders/1KmeeAmz6NDAqW5z-AqckaCKiW3D51nHb?usp=drive_link
Full Power BI Report Walkthrough: Housing Market Insights - Part 1: Data Modeling
Переглядів 1 тис.3 місяці тому
In Part 1 of this full-length Power BI Report walkthrough, we'll explore and model our dataset, which is a Zillow-like compilation of thousands of properties at different price points, sizes, amenities, etc. around Austin, Texas! Dataset & Resources: drive.google.com/drive/folders/1KmeeAmz6NDAqW5z-AqckaCKiW3D51nHb?usp=drive_link
Dashboard Redemption: May 2024
Переглядів 2643 місяці тому
In this month's Dashboard Redemption, we're going to show some love to another sales report that could benefit from a better layout, smaller slicers, and a streamlined color palette. And we're also going to see if we can make a purple theme work (we can.) and spend a little time talking about color theory.
10 Business Intelligence Resume Mistakes
Переглядів 1683 місяці тому
I've been reviewing a lot of BI resumes recently and I realized that, most of the time, I'm giving candidates the same advice & feedback. So, in this video let's walk through some of the most common, annoying, understandable, and fixable mistakes that I see in business intelligence resumes.
How to Build a BUMP CHART in Power BI Using the Native Line Chart
Переглядів 4804 місяці тому
In this quick tutorial, I'll demonstrate how to build a perhaps lesser known version of a line chart known as the bump chart, which is useful for visually representing rank changes over time. We'll also dig into the recently released RANK window function in DAX!
Dashboard Redemption: April 2024
Переглядів 3514 місяці тому
In this month's Dashboard Redemption, we'll walk through a sales analysis dashboard full of poor color choices and design clutter, then talk about how to find the real narrative and reconfigure the report into something much more effective. By the way, if you have dashboards that you would be interested in having redeemed, feel free to hit me up on LinkedIn with the .pbix file. Would love to ke...
How to Build an Area Chart STREAM GRAPH in Power BI
Переглядів 5074 місяці тому
In this video, I'll run through a solution for manipulating the native area chart visual in Power BI to create a stream graph, complete with all the DAX expressions and detailed explanations of how to build it.
BI Book Club: Better Data Visualizations by Jonathan Schwabish
Переглядів 4554 місяці тому
In this month's BI Book Club recommendation, let's talk about another brilliant book on data visualization: The appropriately named Better Data Visualizations. This book is a wonderful crash course in design & communication techniques to help you build more effective data visuals and also a fantastic reference guide for the litany of compelling data visuals out there, many of which can be used ...
We Need to Talk About Treemap Visuals.
Переглядів 3155 місяців тому
The treemap visual is one of the most often misused visuals in all of Power BI, especially for new developers and data viz professionals who don't know better. In this video, let's talk about how so many Power BI learners get it wrong and what needs to happen instead.
8 Big Power BI Mistakes I See Every Day
Переглядів 3805 місяців тому
8 Big Power BI Mistakes I See Every Day
BI Book Club: Storytelling with Data by Cole Nussbaumer Knaflic
Переглядів 4525 місяців тому
BI Book Club: Storytelling with Data by Cole Nussbaumer Knaflic
Scatter Chart Hack: How to Build a Waffle Chart Using Native Power BI Visuals
Переглядів 7596 місяців тому
Scatter Chart Hack: How to Build a Waffle Chart Using Native Power BI Visuals
The 10 Most Frustrating Things About Working in Business Intelligence
Переглядів 1726 місяців тому
The 10 Most Frustrating Things About Working in Business Intelligence
Let's Talk About Color Management in Power BI
Переглядів 4296 місяців тому
Let's Talk About Color Management in Power BI
Adding Narrative Elements to Time-Series Visuals in Power BI
Переглядів 5906 місяців тому
Adding Narrative Elements to Time-Series Visuals in Power BI
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 10 - Smart Narrative Visuals FTW
Переглядів 3227 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 10 - Smart Narrative Visuals FTW
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 9 - Integrating Design & Data Viz
Переглядів 2197 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 9 - Integrating Design & Data Viz
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 8 - Finishing Our Layout
Переглядів 2097 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 8 - Finishing Our Layout
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 7 - Designing a Layout
Переглядів 2307 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 7 - Designing a Layout
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 6 - Rough Run-Rate Forecast
Переглядів 2797 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 6 - Rough Run-Rate Forecast
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 5 - Working with Time Trends
Переглядів 3257 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 5 - Working with Time Trends
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 4 - Summary Measures & Visuals
Переглядів 4227 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 4 - Summary Measures & Visuals
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 3 - DAX to the Rescue!
Переглядів 4227 місяців тому
Kraken Koffee Infographic - Step-by-Step Guided Walkthrough: Part 3 - DAX to the Rescue!
Hi Thanks for sharing . that was really helpful . how can i have date table?
Hi! Just finished the dashboard. I followed along from start to finish. By far the best Power BI dashboard tutorial I have ever experienced. Amazing... from start to finish you really covered the essentials in a fantastic way. Big thank you from Sweden
Thank you so much!
Thank you so much for this information!
You are adding so much value ❤
Wher is the link to your Udemy courses? I have heard you talk about it several times but can't see a link to it
I also have a black cat! She hates being picked up though and will squirm if you try so we don't. 😂 Oh, and thanks for the book review, Sean. Sounds like a worthwhile read if it has a unique focus. :D
Wow, i have been using Power Bi for a while and it's the first time i encounter Parameter option, this is amazing thanks a lot
Thanks a lot for your videos, such valuable knowledge you are sharing for free
This is nothing but awesome , I wish you will upload Pbx file as well
Love the idea of BI book reviews. Congrats on the new job & kitty.
This is exactly what i needed, thanks for the resource🙏
Please how can I get part 1 2 and 3
Nice Insightful
if the slicer is from 2013 to 2019, will it not be average retention rate for those years in the card visual ?
how do we do the monthly retention or quarterly retention rates
Hi! Can we calculate the retention rate for other dimensions without bringing in the time period column?
can we get retention rate without the period of component? For example: Retention Rate by Age or Age Group ?
Where can I find the dataset
Hi sean, I was really eager to know how did you managed latitude and longitude in Maven slop challenge?
May I have a dataset from the video? Thank you!
Amazing Dashboard Designing. Sir I am your Student from Udemy. Sir i followed your Dashboards as it is and really enjoyed. thank you for the wonderful lectures on Udemy. You are really a Gem Sir. I am in this field for one Year. Still upgrading myself and searching for BI analyst entry level job. I learnt SQL, SQL Server Database, SSIS, Power BI, Basic Python, Machine Learning Models. Sir If you have any suggestion for me plz give me.
what is the difference with your videos and udemy one?
the slicer panel on off only works on summary page .
struggling finish this one god help me
Congratulations Sean! Love from India ♥
you are the best Reporting and Visualization export i have come across. This is really a great support to the community from your side. That all the so much valuable information is available via your channel. Thanks for educating us and keep doing such great work. I would request if you can make a project on Power BI with SQL server where data gets refreshed may be monthly or twice a month and the report get updated. May be not free but you may share it with any sort of paid features. etc.
I've always understood that having your layout be a canvas image instead of rending all the individual elements in Power BI itself was an awesome, easy way to get load times down but this takes layout design to the next level. Very cool, Sean. Thanks for posting this.
Can you share the Udemy course link?
update, just rewatched it carefully, its a new *customised colomn* if anyone make same mistake as me. Hey Sean, the 'IF" statement got me stuck at the 'Kraken_koffee_fact[hour]' IS NOT AGGREGATED colomn. Even the switch function as well... can you explain how you did that ?
Thanks for this tutorial
hello is this course same as udemy one? the udemy interface always stuck and youtube is smoother for me.... if its the same i prefer do it from youtube
Thank you sir!!
waiting for next part :), Its superb and Thanks for sharing such great insights
Huge congratulations!!!
Thanks a lot for the tutorial, clean explanation and awesome project! I am going to finish all your projects <3
You are one of the most underrated Power BI experts out there. I love your tutorials! Thanks for sharing!
Amazing stuff 👌One of the best tutorials I have ever seen on data modeling. Looking forward to the next part
Congratulations
thanks a lot, guys regarding the data he already shared it in the description of the first video in the playlist.
this is so creative, well done!
I took your Udemy class ( 5 out of 5) and you need to make some more.
Superuseful tutorial 👌 Is it possible to build the better report from scratch with added files so I can follow along?
you are doing great job♥
can you provide the dataset
Very helpful. Thanks.
Hey Sean, great tutorials. I have a suggestion for a future video. A Jitter plot and a measure that selectively colours certain data points based on a condition and driven by a slicer
Hi Sean, this playlist has been extremely helpful for me to add something beautiful in my portfolio. Thanks for all the detailed videos. In this particular video, I was just wondering why did we create the measure - Average Daily Sales = AVERAGEX(VALUES('Forecast Date Table'[Date]),[Total Sales]) and then used that inside of Average Daily Sales 2 = CALCULATE([Average Daily Sales],ALLSELECTED('Forecast Date Table'[Date])) Instead could we just directly create Average Daily Sales = AVERAGEX(ALLSELECTED('Forecast Date Table'[Date]),[Total Sales]) which is exactly the same as Average Daily Sales 2, that is being used further to get the forecast value. Please correct me if I am missing out on anything here. Thanks.
Great
Great stuff as usual, Sean. Would it be possible to upload the demo pbix's from your tutorials?