- Видео 16
- Просмотров 6 345
Coffee Break Data
США
Добавлен 9 ноя 2020
I help service businesses convert leads into loyal clients. Know. Like. Trust.
I'm Renee, the creator behind Coffee Break Data, where my MS in Data Analytics fuels my drive to simplify the complex. Turning data into revenue, one insightful-and caffeinated-moment at a time.
I'm Renee, the creator behind Coffee Break Data, where my MS in Data Analytics fuels my drive to simplify the complex. Turning data into revenue, one insightful-and caffeinated-moment at a time.
SQL: Convert Float to Varchar WITHOUT Losing Data
Convert a Float to Varchar in SQL quickly. Data type nuances + a walk-through that will minimize your chance of accidentally losing data without realizing it or unnecessary errors to handle this conversion like a pro. 🔽🔽🔽🔽
✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn
📋 Choose Your Own Adventure
0:00 floats are approximate & need length of float for varchar
0:31 Brief scenario set-up
1:00 Is it a float? What's the precision?
1:18 CAST & FORMAT
2:35 FORMAT with Currency
3:42 Error when you don't get the length right
4:20 Can be used to update tables & such, too
👇 If this video was helpful, please like, share, and subscribe for more content on S...
✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn
📋 Choose Your Own Adventure
0:00 floats are approximate & need length of float for varchar
0:31 Brief scenario set-up
1:00 Is it a float? What's the precision?
1:18 CAST & FORMAT
2:35 FORMAT with Currency
3:42 Error when you don't get the length right
4:20 Can be used to update tables & such, too
👇 If this video was helpful, please like, share, and subscribe for more content on S...
Просмотров: 552
Видео
SQL: Handle Case When Null Issues FAST
Просмотров 198Год назад
'CASE WHEN Null' is a common issue in SQL. If you're getting unexpected results due to NULLs, this quick tutorial is for you.🔽🔽🔽🔽 ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn 📋 Choose Your Own Adventure 0:00 NULL does not equal zero 0:22 Brief dataset intro 1:00 CASE WHEN to categorize Utility Type and its pitfalls 1:28 Why this doesn't w...
How to Solve 'Data Sources with Logical Tables' Error | Tableau Troubleshooting
Просмотров 2 тыс.Год назад
Struggling with the frustrating "Data sources containing logical tables cannot be used" error in Tableau? You're not alone! Let's walk through the steps to fix this common issue, so you can get back to creating stunning visualizations. 🔽🔽🔽🔽 READ MORE: coffeebreakdata.com/tableau-relationships-blends-joins/ ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribep...
What to Do When Your Square Marks Overlap in Tableau
Просмотров 392Год назад
Struggling with overlapping square marks in your Tableau visualization? It's a common issue, but one that can be easily resolved. There is usually more than 1 way to solve a problem, and I share 2 here.🔽🔽🔽🔽 ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn 📋 Choose Your Own Adventure 00:00 Let's get you squared away (pun always intended)! 00:2...
How I'm Using ChatGPT as a Data Analyst
Просмотров 206Год назад
There is nothing as daunting as a blank page when you're starting a data analysis project - whether you're building a dashboard or working on a statistical analysis. I'll walk you through how I'm using AI via Chat GPT in my day-to-day as a data analyst without divulging any company information.🔽🔽🔽🔽 ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uI...
BUILD FASTER in Tableau Desktop // Shortcuts & Features You Should Know
Просмотров 79Год назад
Boost your Tableau Desktop efficiency & build rapidly with these 10 time-saving shortcuts and features so you can spend more time on insightful analysis and the creative aspects of your data-driven projects 🔽🔽🔽🔽 📺 Watch next: ruclips.net/video/OuSUn2HnyGQ/видео.html ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn
Time-Saving Secrets with Tableau Desktop
Просмотров 104Год назад
Looking to speed up your Tableau dashboard-building workflow? Keyboard shortcuts in Tableau can add up to big time-savings. I dish my fav shortcuts using Windows, but don't worry - Mac equivalents are shared, too! 🔽🔽🔽🔽 📺 Watch next: ruclips.net/video/SJgkw3nQhJ8/видео.html ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn
Do Your Metrics Align to Business Goals? DATA MISTAKES!
Просмотров 293 года назад
Do Your Metrics Align to Your Business Goals? // If every single report you have on deck doesn’t align to a business goal in some way, you’re making this mistake. Aligning each KPI to a goal is a key to good data and reporting strategy that helps you actually reach those objectives and minimize wasting precious TIME! The book 📚 I reference in the video is Measure What Matters by John Doerr and ...
How Many Custom Reports Does a Business Leader ACTUALLY Need?!
Просмотров 333 года назад
Feeling the management reports overload? Funny enough - this is a data and reporting mistake I've seen a time or 2 (or 3). So how many reports do you need? The reality is that you need enough reports to understand the health of and manage your business. It’s likely you’re swimming in reports that don’t actually do those things. They are just nice-to-have and someone is scared to let them go. I ...
Top Data Mistakes Too Many Businesses Make
Просмотров 533 года назад
Top Data Mistakes Too Many People Make // Data mistakes are costly. If you aren’t using accurate data the right way, at best you’re hurting your credibility. At worst, you’re costing you or your organization some serious money. This video dives into some common mistakes I see way too frequently across way too many organizations. Check out the playlist if you need more detail about any of these ...
You’re Failing with Data if You Aren’t Exploring It! Data Analysis Mistakes
Просмотров 1133 года назад
If you aren't exploring your data before using it to build models or just use it to make basic decisions, you're messing up. So much can be missed if you don't explore your data FIRST! Outliers, missing values, data quality issues, oh my! This video digs into why it matters and when to layer in more or less of this exploration. ✅ Looking to avoid data pitfalls like this? Check out this playlist...
Why Averaging an Average is Wrong
Просмотров 2,1 тыс.3 года назад
Averaging an average is sketchy math. Let's walk through the logic for why averaging an average is a common data mistake plus a walkthrough of a real-world example of how this makes for bad values to base decisions on. 🔽🔽🔽🔽 ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn
When to Use a Calculated Column vs a Measure in Power BI
Просмотров 1013 года назад
When to Use a Calculated Column vs a Measure in Power BI // It is not intuitive when you should break out a calculated column versus a measure in Power BI. After working with newbies for some time, most default to measures, but let’s walk through when you should use each option and why. Bookmark this handy dandy cheat sheet on when to use a calculated column versus a measure in Power BI at this...
All About Calculated Columns in Power BI
Просмотров 203 года назад
You have data loaded in Power BI, and you’re at a stage where you may need to add a calculated column. You’ll use DAX to get there, but let’s walk through details regarding when and how to use a calculated column for your data analysis.🔽🔽🔽🔽 ✉️ Sign up for the newsletter focused on simplifying data for maximum impact: subscribepage.io/uIAQSn If you aren’t sure if you need to add a measure or a c...
You are awesome! This is such a cool trick! Thank you for sharing!
thank you! you saved my life
I'm trying to categorize averages for similar tickets in our ticketing system.
NEEDE THIS. Thanks for the help!
That was great Thank you so much
The copyright of "Sequel" by the aviation company has been nullified. Hence, the OG can safely reclaim Sequel for SQL pronounciation.
You have just saved my butt with this !!!
I’m glad! That’s an annoying error!
ok so I watched this video and still don't understand why my numbers are not working. lol any chance you might be able to help?
THANK YOU. I NEEDED THIS
Just started a new BI role and the very first report I've been given to look at has averages of averages across TWO dimensions, time and category. It's going to be fun unpicking it.
subscribed. Side project where I'm trying to get average points, but players played different number of games
Love your videos! Thank you for taking time to create them and educate us.
I'm here trying to resolve Simpson's paradox for a rate efficiency calculation. I have two sets of data on unequal time time periods and I need to aggregate one of so I can join it to the other and then create additional aggregations.
Goals are very important for growth. I make goals all the time and work towards achieving them. I am new here and staying. Thanks for sharing
Goals for the win!! Glad to have you here, and let me know how I can support you!
that’s a great question: are you measuring what matters? data aside - this can be applicable to so many things in business.
Definitely won't be making these mistakes thanks to you! Loved your tips!
Glad to hear this! Pop in if you ever find yourself with data questions as I'm thrilled to help!
Business Intelligence must add up. Thank you.
🤝You've got that right, Felipe! Thanks for joining in!
Bad data can devastate in every area of business.
You are soooo right!
Great info in this video. Very true!
Thanks so much for watching!
Great video info...!
Thanks, Lucy!!
Have you had a data mistake that caused you some embarrassment?! I can’t be alone this!!
🤯 every bit of this is above & over my head, but that won’t stop me from showing up to cheer you on!
Thank you so much! I’ve revamped my content plan, so hopefully what’s coming next will be more relatable!
Ive always wondered about this! This is the exact information I needed! Thanks so much for sharing! :)