Posts by pwsadmin
Using Append queries to combine spreadsheets
Using Append queries to combine spreadsheets You may discover that all your data is siloed into many different spreadsheets even though they contain the same structure. Learn how to create simple appends to create the one data sets you need. Learn How To Append Queries The Data Skills Survival Kit Series If you’re a data…
Read MoreUsing Union Queries to bring together data sets from other tables/views in SQL
Using Union Queries to bring together data sets from other tables/views in SQL Unions can be a valuable concept to understand when your data sets are in different tables or by different unique queries. Learn how to make them consistent to be used in Union queries. Learn How To Use Union Queries In SQL The…
Read MoreIntermediate 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 and potential errors. But what if there was a better way? What if you could update your data in one…
Read MoreGetting 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 mastering Power Query, our course provides you with essential skills to effectively manage data in Excel. You’ll learn how to…
Read MoreUnderstanding 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. Join us on this course as we break down the complexities of SQL into manageable steps, empowering you to write…
Read MoreGetting 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 to leave behind the hard way of doing things and embrace a new day of efficiency and productivity! Join us…
Read MoreMicrosoft Excel Data Worker Training
Microsoft Excel Data Worker If you use Excel to sort, filter, and analyze data for your company, our course will help. We provide best practices, valuable shortcuts, and essential skills for data workers.A popular topic covered is pivot tables, which are as important to data workers as hammers are to builders- they aren’t the only…
Read MoreBuild conditional functions to make data
Build conditional functions to make data The ability to create conditional formulas in Power BI is essential because it transforms raw data into meaningful, reliable information tailored for specific reporting needs. This capability is key to generating insights that drive informed decision-making and business success. Learn How To Build Conditional Functions The Data Skills Survival…
Read MoreDaniel Bishop Honored
Daniel Biship Honored40 under 40 Daniel Bishop, Cofounder and Lead Software Architect, has been added to the most current class of Top 40 Under 40. This is one of the more coveted honors locally for young professionals. Daniel began his technical journey years before founding ThinkData Solutions, Inc. We are not surprised to see him…
Read MoreJoining 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 different systems. This means there isn’t a direct relationship we can establish using a key from the data system. We…
Read More