Video Posts
Videos
We make lots of educational video content, come take a look!
+
Courses Offered
+
Training in person
1. million+
Asynchronous Learning
Adding data leveraging cross joins
Adding data leveraging cross joins Join Robin to master cross joins in SQL and Excel. Streamline your data merging for effective project management and analysis. Learn How To: Use Cross Joins The Data Skills Survival ...
Using Case statements for conditional logic in SQL queries
Using Case statements for conditional logic in SQL queries In this video, Robin continues to explore booking data, this time incorporating SQL queries and Case statements to classify data and highlight meaningful trends in her ...
Analyzing data using a matrix and conditional formats
Analyzing data using a matrix and conditional formats Have an Excel sheet with pivot tables full of data? Want to visualize those in Power BI in meaningful ways? Let Robin step you through the next ...
Using various pivot formats
Using various pivot formats to tell different stories for your presentations Every visual tells a story. Learn how to use Pivots to share different stories on the same data. Learn How To: Use Different Pivot ...
Perform basic analysis
Perform basic analysis on data sets No single data set is exactly the same. Learn how to do the basic analysis techniques to learn more about your data. Learn How To: Analyze Data Sets The ...
Using analysis commands
Using the analysis commands built into popular tools Most systems have some basic analysis built in to the software. Learn how to take your analysis up a step using these built-in tools. Learn How To: ...
Data Fundamentals Unpacked: Scary Data Words
October 20, 2023 - Robin, Gini, and Oz talked through some SCARY data words again this year- watch out for kurtosis! If you too have felt intimdated or overwhelmed by an unfamiliar data word, give ...
Basic dates analysis
Using basic dates analysis It's in the gap you can tell the story. This is a must watch video. This will show you how to gain some great data structure for data that needs to ...
Building paginated reports in Power BI
Building paginated reports in Power BI Learn how to quickly build basic paginated reports using PowerBI Report Builder. Learn How To Make Paginated Reports In Power BI The Data Skills Survival Kit Series If you're ...
DFU: People Analytics
***For best viewing experience log in to LinkedIn*** August 9, 2023 - We sure did miss having Gini on this episode, having Dr. Huang on was such a treat! The way she sees things is ...
Edit visual interactions
Edit visual interactions Learn how to create interactive dashboards with a few static items that never update. Learn How To Edit Interactions In Dashboards The Data Skills Survival Kit Series If you're a data analyst, ...
DFU: What languages should you learn for Data
***For best viewing experience log in to LinkedIn*** June 13, 2023 - Helen Wall returns for this fantastic talk about languages, coding, and data. The discussion covers problem solving, what is and is not programming, ...
DFU: Imposter Syndrome
***For best viewing experience log in to LinkedIn*** May 26, 2023 - On this episode of Data Fundamentals Unpacked we dig deep into imposter syndrome. We go over what it is, why it happens, and ...
Normalizing data to achieve a data design
Normalizing data to achieve a data design Normalizing data is typically the skill of a database designer, but when you are an analyst, you design data sets. No keys on how to break data to ...
DFU: Finding portfolio building work
***For best viewing experience log in to LinkedIn*** March 13, 2023 - A portfolio is a valuable way to demonstrate your skills to potential clients and employers- do you have one? Should you? The team ...
Working with full outer joins
Working with full outer joins Often times we find as data workers we are trying to determine what is on two data sets. We want to see everything that matches or doesn't match from two ...
Using anti joins to search for data
Using anti joins to search for data We know that data sets cannot be achieved efficiently without adjusting joins so we learn about left and right joins. Then as we produce these results sometimes we ...
Joining data with common data between two unrelated data sets
Joining data with common data between two unrelated data sets Joining data is part of the life of a data analyst. The problem is that most data sets that need to be joined exist in ...
Creating unique identifiers between two data sets
Creating unique identifiers between two data sets When a join is required, and the field doesn't exist, you must learn to create a field to create a unique identifier. This will allow you to enjoy ...
DFU: Data-Driven Decision Making
***For best viewing experience log in to LinkedIn*** November 22, 2022 - Today's episode is one with a controversial title- IS data-driven decision making actually bunk, or is data-driven decision making used as a scapegoat ...
Networking in Tech
We’re continuing our series with a lesson on networking. Watch this Meetup Live recording with Robin Hunt, co-founder of ThinkData Solutions and LinkedIn Learning course instructor, to learn how to shine among strangers (even if ...
DFU: When Data Gets Scary
***For best viewing experience log in to LinkedIn*** October 25, 2022 - Oz du Soleil is on the program for this episode! He's the perfect guest for an episode about SCARY data- what scares the ...
DFU: Plan Your Learning Path
***For best viewing experience log in to LinkedIn*** September 13, 2022 - On this episode of Data Fundamentals Unpacked we go over learning. Whether you're at the beginning of considering starting your path to being ...
DFU: Bias
***For best viewing experience log in to LinkedIn*** July 13, 2022 - We are excited to have expert Stacey A. Gordon join us for a discussion on bias, how we can learn more on the ...
DFU: Common Sense
***For best viewing experience log in to LinkedIn*** April 13, 2022 - Common sense is a fun topic. Do we need it in data, or is book sense enough? How do we get it, how ...
DFU: Data Ethics
***For best viewing experience log in to LinkedIn*** March 10, 2022 - Doug Rose joins us this week for a fascinating talk about ethics in data. What rules do we have, what rules should we ...
DFU: Math and Statistics
***For best viewing experience log in to LinkedIn*** February 24, 2022 - Today we figure out our relationships with math, our own barriers to getting comfortable with numbers, and times when we've had to wrestle ...
DFU: Seasonality
***For best viewing experience log in to LinkedIn*** December 2, 2021 - Seasonality is the topic at hand, and everyone brings great personal insights to what seasonality is, why it's important to consider, and how ...
The Importance of Defining the Skills of a Data Analyst
The Importance of Defining the Skills of a Data Analyst September 21, 2021 - What are the domains of the data analyst? Analysts have to understand databases and types of databases. They must know how ...
DFU: Tools Agnosticism
***For best viewing experience log in to LinkedIn*** September 16, 2021 - In this episode we took a look at how people use (and don't use!) tools and how data professionals adapt to changing situations. ...
The Relentless Analyst: Episode 3 Bikini Model
The Relentless Analyst: Episode 3 Bikini Model August 18, 2021 - In this episode, Robin Hunt of ThinkData Solutions, Inc. and Oz du Soleil of Excel on Fire discuss why it's crucial to have conversations ...
DFU: Big Data
***For best viewing experience log in to LinkedIn*** July 15, 2021 - Big Data is this episode's topic. It's a hot topic, but what's smoke and what's fire? Helen Wall joins the team as we ...
DFU: Uncertainty
***For best viewing experience log in to LinkedIn*** June 17, 2021 - On this episode of Data Fundamentals unpacked we have a wide-ranging talk on uncertainty in data and uncertainty in the wider world. We ...
DFU: Data Literacy
***For best viewing experience log in to LinkedIn*** May 18, 2021 - On this episode of Data Fundamentals unpacked we have a lively discussion of what data literacy means to different people in different contexts ...
The Relentless Analyst: Episode 2 Databases and or Spreadsheets
The Relentless Analyst: Episode 2 Databases and/or Spreadsheets April 15, 2021 - Oz and Robin team up again for episode 2 of the Relentless Analyst Podcast. This time they dive right into the topic of ...
The Relentless Analyst: Episode 1 Data Validation
The Relentless Analyst: Episode 1 Data Validation March 18, 2021 - Robin Hunt of ThinkData Solutions and Oz du Soleil, Microsoft Excel MVP, both live and breathe data! Listen in their conversation if you ever ...
Make The Percentage Symbol Show In Power BI Desktop
Make The Percentage Symbol Show In Power BI Desktop March 16, 2021 - It can be really frustrating when you want the % symbol to show on your dashboard for your values, and all you ...
Power Query – How to return to the Query Editor
Power Query - How to return to the Query Editor March 4, 2021 - We often want to see our data and continue to make changes, or discover we missed a step. This quick video ...
Power Query: Other Ways To Delete Columns
Power Query: Other Ways To Delete Columns March 4, 2021 - Delete columns in PowerQuery with ease. Our video tutorial shows varied methods to choose, remove, and change your mind. ThinkData's YouTube channel has lots ...
Power Query Change Column Names
Power Query: Change Column Names March 4, 2021 - It's incredibly easy to change column names in Power Query, and even if that's all you use it for, it's entirely worth it. If you have ...
Power Query Replacing Values – Lab In Action
Power Query Replacing Values - Lab In Action March 4, 2021 - This video shows you an interactive view of the Replacing Values lab in the Intro to Power Query course guide. It's a rough ...
Power Query – Review Steps and the Advanced Editor
Power Query - Review Steps and the Advanced Editor March 4, 2021 - It's easy to forget every single step in a process, but with Power Query's Applied Steps, you can effortlessly walk back through ...
Update Data with Power Query
Update Data with Power Query March 4, 2021 - The whole point is to save time right? Using Power Query does just that. You really begin to notice the improvement when you are done with ...
Counts from Column Profile
Counts from Column Profile December 5, 2020 - This video is me just showing how valuable the column profile option is inside of Power Query. This is a little type of analysis that we do ...
Setting up Microsoft Teams Nav Tiles
Setting up Microsoft Teams Nav Tiles July 30, 2020 - We know that setting up your screen based on preference is important. Learn a quick little trick on setting up Microsoft Teams just the way ...
Auto Calculate in Excel
Auto Calculate in Excel November 29, 2018 - In every version of Excel I have worked with (starting with Excel 97) I have used the auto calculate feature. It's a simple way to verify calculations. ...
Flag Email Messages in O365 Mail
Flag Email Messages in O365 Mail November 23, 2018 - Dealing with lots of email? You need tips and tricks. Learn how to flag messages and then quickly retrieve the messages you flagged. ThinkData's YouTube ...
On My Birthday
On My Birthday... November 20, 2018 - I am a data analyst and researcher... so of course i wanted to share some important stats about #childhood #cancer and ask you to support me as a ...
New Window in Excel
New Window in Excel October 26, 2018 - Have you ever opened a read-only copy so that you could view two sheets of the same workbook? It can be frustrating to no end because read-only ...
Customize the Quick Access Toolbar in Microsoft Office
Customize Quick Access Toolbar in Microsoft Office October 19, 2018 - Customizing your quick access toolbar is an area where I find all people can gain some instant productivity. Example, if its on another tab, ...
Minimize the Ribbon In Microsoft Office
Minimize the Ribbon in Microsoft Office October 19, 2018 - I have taught this tip in Excel classes since the advent of the Ribbon in Microsoft Office 2007. Screen space is a big deal when ...
Using Tab Leaders In Microsoft Word
Using Tab Leaders In Microsoft Word October 17, 2018 - Learn how to properly align and add dotted leaders to any document. Great for any document, agendas, programs etc. ThinkData's YouTube channel has lots of ...
Removing Duplicates, Build a SumIF, and Creating a Chart in Excel
Removing Duplicates, Build a SumIF, and Creating a Chart in Excel October 17, 2018 - In this video, we learn about removing duplicates, building a SUMIF, and creating a chart. Because it's full of shortcuts, you may also ...
How to Accept Skype Messages
How to Accept Skype Messages January 4, 2018 - Learn how to accept messages via Skype for Business. Robin's YouTube channel has lots of helpful videos- if you haven't checked it out before, click the ...
Follow Me On LinkedIn
Follow Me On LinkedIn January 18, 2018 - I don't write every day. I do try to be thoughtful in what I write. I hope you will follow me and read my articles on LinkedIn. ...
Random Tips, Tricks, and Shortcuts
Random Tips, Tricks, and Shortcuts January 16, 2018 - Like us, follow us, share us, join us, tweet us, subscribe to us - just be with us at ThinkData. We value your connection and believe ...
Navigate the Mail App in Office365
Navigate The Mail App In Office365 January 10, 2018 - Learn how to navigate Outlook web access via the browser in Office365. Used to the Desktop version of Outlook? Transition smoothly to the powerful browser-based ...
Setting Up Your Email Signature In Mail In Office365
Setting Up Your Email Signature In Mail In Office365 January 10, 2018 - Looking to set up an email signature in Office365? Learn how to set up your signature, turn on automatic replies, and change ...
Using Rules in Mail in Office365
Using Rules in Mail in Office365 January 4, 2018 - Using rules in Office365 can streamline your email. Our video offers a quick start to organization in Outlook, perfect whether you love rules or are ...
Dealing with lots of email in Office365
Dealing With Lots Of Email In Office365 January 4, 2018 - Handle lots of email in Office365 with ease. Learn these quick techniques for managing categories, flagging emails, and efficient searching and filtering. Robin's YouTube ...
Search Sort and Filter Email In Office365
Search, Sort, and Filter Email In Office365 January 4, 2018 - Learning to use webmail in Office365 can be a challenge when you are familiar with the tools of Desktop Outlook. This quick video shows ...
Share Your Screen in Skype
Share Your Screen in Skype January 4, 2018 - Learn to Share Your Screen in Skype with our informative video. It's easy, it's quick, and it's a really useful skill if you're using Skype. Robin's ...
Favorites and Others in Skype for Business
Favorites and Others in Skype for Business January 4, 2018 - Learn to work with favorites and more in Skype for Business. Robin's YouTube channel has lots of helpful videos- if you haven't checked it ...
Using Words to Set Dates in Outlook Meetings
Using Words to Set Dates in Outlook Meetings November 29, 2017 - Did you know that when you schedule an appointment in Outlook (for years you could do this) if it's next Wednesday or the ...
Increasing productivity in Excel
Increasing productivity in Excel July 5, 2017 - This video shows how to easily create dates in Excel and how to more efficiently select data. ThinkData's YouTube channel has lots of helpful videos- click the ...
What’s a fast way to select all data in a spreadsheet?
What's a fast way to select all data in a spreadsheet? July 5, 2017 - Now, not the whole sheet, but just the data in the sheet. This is one of the fastest ways to ...
How long does it take to autofill the same 30 days?
How long does it take to autofill the same 30 days? July 5, 2017 - Watch what a benefit this simple technique is- save yourself a few seconds here and there and watch them start ...
Whiteboard with Skype at your Desk with others
Whiteboard with Skype at your Desk with others June 2, 2016 - Let's talk about Skype for Business and start to expand our meeting capabilities. Robin's YouTube channel has lots of helpful videos- if you ...
Introduction to Outlook Groups
Introduction to Outlook Groups June 2, 2016 - Distribution groups on steroids anyone? Take a look at the Groups feature of Office365. Robin's YouTube channel has lots of helpful videos- if you haven't checked it ...
Create new shared Excel files in OneDrive
Create new shared Excel files in OneDrive June 2, 2016 - Learn about Excel Online and ease of sharing. No more dealing with the "Read Only Notify" messages because you can now edit in real ...
New Email for Office365
New Email for Office365 June 2, 2016 - For years we have interacted with email the same way. Take a look at the new way an email shows up when we click "new". Robin's YouTube ...
Using Sweep and Other Built in Rules in Office365
Using Sweep and Other Built in Rules in Office365 June 1, 2016 - This just shows a pretty wonderful set of built in rules from the browser based Mail of Office365. ThinkData's YouTube channel has ...
Set Up Your Office365 Tiles
Set Up Your Office365 Tiles June 1, 2016 - If you have been using Office365 you might be interested in adjusting your tiles from the app launcher. We love to be able to customize our ...
Who Made These? #KidsSeeGlass
Who Made These? #KidsSeeGlass February 27, 2014 - You see kids - I see inspiration. The child's smile is worth every dime. We are failing our children when they walk around uninspired. Please note that ...
Change the Calendar View Shortcut
Change the Calendar View Shortcut February 24, 2014 - This video introduces the CTRL and Scroll shortcut to change calendar views in Outlook. Robin's YouTube channel has lots of helpful videos- if you haven't checked ...
Working with Internet Explorer Tabs
Working with Internet Explorer Tabs May 27, 2012 - Discover how to manage Internet Explorer tabs with our video guide. Learn how to reorder tabs to your preference and even drag a tab to its ...
Remove a word from the custom dictionary
Remove a word from the custom dictionary January 15, 2010 - This video describes how to remove a word previously added to Word's cusom disctionary. This video is specifically about working in Microsoft Office Word ...
Excel 2007: Create A Basic Pivot and Drill Down
Excel 2007: Create A Basic Pivot and Drill Down May 14, 2010 - This is a quick demo of how to create a basic pivot table and how to easily drilldown into your data. While ...
Customize the Quick Access Toolbar
Customize the Quick Access Toolbar November 8, 2009 - Customize the Quick Access Toolbar in the Office 2007 Suite. You can easily make every command that you need or use show up on the top ...
What’s The Green Flag In Excel?
What's The Green Flag In Excel? October 18, 2009 - This talks about the green flag that shows up in the corner of a cell. People asks me this all the time and I think ...
Allow List Command In Excel
Allow List Command In Excel June 15, 2008 - This shows how to create a drop down box inside of cells in an Excel 2007 spreadsheet, with references on how to complete it also in ...
Want Us to Speak at Your Event?
Are you looking for a speaker for your next event who can discuss data? Want to find out why the ability to work with data is a necessary skill for all organizations in a modern digital age? We would love to talk to you!
Need Help With Your Data?
ThinkData creates customized training solutions for companies of all sizes, tailored to what your team needs most.