Training on demand
On Demand Training
Want to read what we think is interesting? Do you want to easily access videos and events that you can rewatch? This is the place for you. We also know that everyone has different learning styles, ideas, and plans that work best for them. There are a mix of free and paid options although we try to keep them to their own sections so that you can easily distinguish. We encourage you to explore the various topics and suggestions we’ve provided here and find what works for you.
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 ...
Protected: Auburn MBA Program
Function & Formula Writing in Excel Session recorded for the Auburn MBA program on 11/3/2023 presented by Taylor Abney of ThinkData Solutions, Inc. Data Visualization and Pivots Session recorded for the Auburn MBA program on ...
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 ...
THINKDATA SOLUTIONS, INC. DATA ANALYST APPRENTICESHIP REGISTERED WITH THE ALABAMA OFFICE OF APPRENTICESHIP
THINKDATA SOLUTIONS, INC. DATA ANALYST APPRENTICESHIP REGISTERED WITH THE ALABAMA OFFICE OF APPRENTICESHIP BIRMINGHAM, AL - ThinkData Solutions, Inc., an Alabama-based company and leading provider of customized solutions to data and technology related challenges, officially ...
THINKDATA SOLUTIONS, INC. DUO CO-AUTHOR THE OFFICIAL DATASYS+ STUDY GUIDE
"ThinkData CEO Robin E. Hunt and COO Daniel Bishop partnered with Todd Miranda to co-author The Official DataSys+ Study Guide. This guide has been designed from the ground up to help you learn and master ...
2023 Business Analysis Connection Day
Business Analysis Connection Day is the IIBA Birmingham Chapter's annual professional development conference. We will offer three tracks, each with three sessions. As this is a virtual event, attendees can switch between sessions at any ...
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 ...
View Details for 2023 National Cyber Summit
National Cyber Summit This national event offers innovative opportunities in education, collaboration, workforce development in security technology for industry leaders. Buy your tickets early, this busy event is in high demand!Robin Hunt taught ThinkData One ...
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, ...
Intermediate Power Query
Intermediate Power Query Are you tired of spending valuable time hopping from one spreadsheet to another in search of the data you need for your reports? It can be frustrating and inefficient, causing unnecessary delays ...
Getting Started with Power Query
Getting Started with Power Query Power Query is a game-changer in Excel. Whether you're currently using vlookups, concatenates, pivots, or frequently updating data, this course is an opportunity you don't want to miss.In addition to ...
Understanding and Building SQL Queries
Understanding and Building SQL Queries In this course, you don't need to grasp the entire universe of SQL to master writing great queries. We'll guide you on a journey towards understanding and confidently building queries. ...
Getting Started with Microsoft Power BI
Getting Started with Power BI Dashboards, Smashboards - if you're only surviving with basic pivots and charts accompanied by slicers, you're missing out on the amazing tools that Power BI has to offer. It's time ...
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, ...
Self-doubt is a terrible bedfellow.
Self-doubt is a terrible bedfellow. We unpacked a lot of feelings in this latest episode of Data Fundamentals Unpacked, or should I say I at least unpacked some of my own feelings. We were discussing ...
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 ...
You are building a mental muscle, and you need it to be strong.
You are building a mental muscle, and you need it to be strong. I just finished writing a letter to my nephew. He is in bootcamp. I think the words here will be valuable to ...
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 ...
ISACA Events
ISACA Events Robin Hunt has been honored to speak at ISACA conferences, including an annual event hosted by the Birmingham Alabama chapter. ISACA has been a prominent figure in the tech world for decades and ...
AFCEA Events
AFCEA Events Robin has been honored to be part of panel discussions at AFCEA events, including the TechNet Indo-Pacific Conference and the TechNet Augusta Conference. TechNet Augusta 2022 gave participants the opportunity to examine and ...
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 ...
ATD Events
ATD Events Robin has spoken at ATD events, both nationally and at the Birmingham chapter. ATD Birmingham is the Greater Birmingham chapter of the Association for Talent Development (ATD), which is a professional membership organization ...
ISSA Events
ISSA Events Data and security go hand-in-hand. Robin loves talking with ISSA organizations, including the Central Alabama chapter. The Central Alabama ISSA Chapter Meeting took place on January 5, 2023, at McLeod Software Corporation in ...
IIA Events
IIA Events Robin loves to teach the magic that is Power Query and other data techniques. She has worked with IIA organizations across the country, including IIA Southwest Virginia, IIA Birmingham, and IIA Mobile. The ...
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 ...
Dennis Taylor Month
Celebrate Dennis Taylor Month I met Dennis Taylor in San Francisco early in the year. Even though it was my first official meeting - I have known of him for years. To say I was ...
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 ...
Data Literacy At All Ages
In a data driven world, organizations need employees proficient in the in-demand skill of data literacy. Robin Hunt and Daniel Bishop built a company to educate people on data, as well as support organizations to ...
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 ...
What I know now…
What I know now... On November 1, 2021 about five months into writing Data+ I was reflecting on the fact that I was actually writing a book. This book and its content are going to ...
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 ...
Never underestimate the power of community
Never underestimate the power of community The word "community" has been a part of my vocabulary intentionally this year. I grew deeper relationships with Bill Shander and Gini von Courter this year. I would refer ...
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. ...
Defining a data analyst has traditionally been hard… until now
Defining a data analyst has traditionally been hard… until now One of my greatest challenges over the last several years is to create a practical definition of what a data analyst is. I believe the ...
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 ...
Unfocused and going nowhere fast
Unfocused and going nowhere fast Is this how you feel? Do you feel this way all the time, or just on certain days? Are you overall just disappointed where you are in your career? Or ...
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 ...
It’s not just a tool or a point in time – it’s everything all the time.
It's not just a tool or a point in time - it's everything all the time. Data Validation: It's not just a tool or a point in time - it's everything all the time. If ...
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 ...
Building engagement in virtual environments
Building engagement in virtual environments Building engagement in speaking events, where audience participation is welcomed, like training, has always been very important to me. However, building the same type of engagement is different with the ...
Birmingham demands data analysts
Birmingham demands data analysts-here's how Innovate Birmingham is filling the gap Whether it's sales figures, market research, logistics or more, every business is increasingly driven by data and analytics. However, that data is only valuable ...
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 ...
I can’t speak to the experience of others, only my own.
I can't speak to the experience of others, only my own. I can't speak to the experience of others, only my own. I have said in plenty of speaking engagements and conversations that my path ...
This is not somehow easier because software exists…
This is not somehow easier because software exists... Here are a few perspectives from someone who not only remote works but is converting a group of people from an in-office experience to a work-from-home experience. ...
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 ...
Excel – Know Your Cursors
Getting Started with Excel - Know Your Cursors I have been teaching Excel for close to two decades. I know one thing for sure - every time I teach these techniques people learn something new. ...
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 ...
Becoming Your Own Boss: 3 Things to Consider
Look Before You Leap: 3 Things to Consider Before Becoming Your Own Boss I started my formal training career in August 2000 in Birmingham, Alabama. Shortly after that, I was teaching the basics of HTML ...
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 ...
What do you get out of this?
What do you get out of this? About 5 years ago I had a highly respected entrepreneur ask me, "What do you get out of this?" He was referring to hosting events like today's event ...
Access 2016 Building Dashboards for Excel
Access 2016 Building Dashboards for Excel Using Excel, you can optimize reporting for Access databases. Learn how to build powerful dashboards to visualize your data, using tools such as slicers, timelines, charts, and PivotCharts. Instructor ...
Toolbox with no hammer?
Toolbox with no hammer? There are a few sections of this course that I just wish the whole world would watch. I think people don't consider Microsoft Access enough. People with Database in their job ...
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. ...
If you are successful people won’t believe you’re dealing with it
If you are successful people won't believe you're dealing with it You hear about failure and rising above it in entrepreneur blogs. It is, in fact, a 'fact of life'. What you hear less about ...
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 ...
Social media when you lose a loved one
How to handle social media when you lose a loved one I love social media, from the moment I realized what it could do for me to personally brand myself, I was a fan. At ...
Take a moment and read the names
Take a moment and read the names I don't imagine there will ever be a September 11th that I don't remember exactly what I felt that morning. Watching it unfold and not understanding what I ...
Some People Only Have Excel
Some People Only Have Excel Dear Learner, I deal with a lot of data so guess what? I deal with a lot of data cleanup. There are a million ways to remove stuff from your ...
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 ...
Build Data Skills
We love it when our content is provided by our partners at no cost to the learner. This means you can can get started with very little risk, and begin to determine where you should spend your time and efforts.
Career Essentials Certificates
Certification Prep
If you are currently pursuing data certifications you might want to consider certification prep materials. These materials all have various costs associated to them.
CompTIA DataSys+ (DS0-001) Exam Prep Bundle
What you’ll learn The Official CompTIA DataSys+ material has been developed by CompTIA for the CompTIA certification candidate. Rigorously evaluated by third party subject matter experts to validate adequate coverage of the DataSys+ exam objectives, ...
The Official CompTIA DataSys+ Student Guide (Exam DS0-001) eBook
What you’ll learn The Official CompTIA DataSys+ Study Guide (DS0-001) has been developed by CompTIA for the CompTIA certification candidate. Rigorously evaluated by third party subject matter experts to validate adequate coverage of the DataSys+ exam objectives, ...
CompTIA Data+ One Day Preview (11/08/2023)
Topics highlighted during course: Identify Basic Concepts of Data Schemas Understand Different Data Systems Understand Types and Characteristics of Data Compare and Contrast Different Data Structures, Formats, and Markup Languages Explain Data Integration and Collection ...
CompTIA Data+ Training
You could say we wrote the book on Data+ and that's true,we actually did write the book. We are proud of the content created for the Official Curriculum for the first certification of its kind. We have tons of options for you to explore. Read Announcement | Read About Exam
ThinkData Bootcamps and Apprenticeships
We have been building bootcamps for two decades. We know more than a few things about what makes a bootcamp successful. If you are seeking a bootcamp, we'd love to tell you about ours and see if it's a fit. We have options for almost every seeker, from self-pay options to scholarship opportunities.