BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20250611T150000Z
DTEND:20250611T160000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:SCORE Free Webinar - Organizing Data for Analysis
DESCRIPTION:How many times have you laboriously gathered data only to discover that no matter what you do you can't use it to produce the analysis you need? Often the problem is that the information is not structured in a way that can produce the desired result. This webinar will explain how to set things up so you can get from where you are to where you want to be.\n\nThis live\, one-hour session will explain and demonstrate:\n\n\n Key data analysis concepts\, including field\, record\, table and relationship\;\n How to identify the data structure you need\, and why there is no one-size-fits-all solution\;\n How to decide what adjustments\, if any\, you need to make to an existing data structure\;\n Tools and techniques for automating some of the adjustments\, including combining and splitting fields\, and converting horizontal to vertical record structures\;\n What is required to join tables so you can connect data from several sources\; and\n How to test your data to make sure it works.\n\n\nThe demonstrations will be done on Excel\, but the principles are applicable to\n\ndatabases\, SQL\, and other tools that can be used to parse and analyze data.\n\nThis session will be good preparation for a July program on Excel's Power Query\n\nfeature (date TBD).\n\nThere will be plenty of time for questions\, so come prepared.
X-ALT-DESC;FMTTYPE=text/html:How many times have you laboriously gathered data only to discover that no matter what you do you can&rsquo\;t use it to produce the analysis you need? Often the problem is that the information is not structured in a way that can produce the desired result. This webinar will explain how to set things up so you can get from where you are to where you want to be.
\n\nThis live\, one-hour session will explain and demonstrate:
\n\n\n - Key data analysis concepts\, including field\, record\, table and relationship\;
\n - How to identify the data structure you need\, and why there is no one-size-fits-all solution\;
\n - How to decide what adjustments\, if any\, you need to make to an existing data structure\;
\n - Tools and techniques for automating some of the adjustments\, including combining and splitting fields\, and converting horizontal to vertical record structures\;
\n - What is required to join tables so you can connect data from several sources\; and
\n - How to test your data to make sure it works.
\n
\n\nThe demonstrations will be done on Excel\, but the principles are applicable to
\n\ndatabases\, SQL\, and other tools that can be used to parse and analyze data.
\n\nThis session will be good preparation for a July program on Excel&rsquo\;s Power Query
\n\nfeature (date TBD).
\n\nThere will be plenty of time for questions\, so come prepared.
\n
LOCATION:
UID:e.628.7963
SEQUENCE:3
DTSTAMP:20260531T064847Z
URL:https://business.qhma.com/events/details/score-free-webinar-organizing-data-for-analysis-7963
END:VEVENT
END:VCALENDAR