BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//South Carolina Association of CPAs - ECPv6.16.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:South Carolina Association of CPAs
X-ORIGINAL-URL:https://sc.cpa
X-WR-CALDESC:Events for South Carolina Association of CPAs
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Detroit
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260525T060837
CREATED:20250605T211827Z
LAST-MODIFIED:20250606T050205Z
UID:10005478-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE435/26) Surgent's Leverage PowerBI.com to Create Data Analysis for Others
DESCRIPTION:Event Description\nUnlock the full potential of data analytics with this specialized course. This two-hour intensive course is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you’re a data analyst\, business intelligence professional\, or someone keen on mastering data visualization and report creation\, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com\, starting with a comprehensive tour of its interface and core concepts. You’ll gain experience in connecting to diverse data sources\, creating stunning visualizations\, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com\, allowing you to explore data with natural language queries. By mastering the art of sharing data sets\, reports\, and dashboards\, and creating comprehensive apps\, you’ll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course\, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate data sets\, reports\, and dashboards\, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape\, offering not just theoretical knowledge but real-world applications. Upon completion\, participants will not only have a thorough understanding of PowerBI.com but will also have the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skill set and make data-driven decisions with ease. \nDesigned For\nData analysts\, business intelligence professionals\, and anyone interested in learning how to use Microsoft Power BI to share data analysis \nObjectives\nIdentify the key components and functionalities of the PowerBI.com interface\, enabling efficient navigation and utilization for data analysis tasks    Recognize the capabilities of the Q&A feature in PowerBI.com so you can leverage it for generating quick insights from data using natural language queries    Select the appropriate data sharing and collaboration methods within PowerBI.com for your situation \nMajor Subjects\nAn in-depth walkthrough of the PowerBI.com environment\, focusing on user interface elements\, navigation\, and customization    Fundamental concepts of PowerBI.com\, including its architecture\, data handling capabilities\, and integration features    Techniques for connecting various data sources to PowerBI.com\, ensuring seamless data integration and synchronization    Creating impactful visualizations and assembling informative dashboards to present data compellingly    The interactive Q&A feature to derive insights through natural language queries    Best practices for sharing data sets\, reports\, and dashboards with different audiences so they can leverage your data analysis work    How to package reports and dashboards into apps for easy distribution and consumption \nInstructions\nNone
URL:https://sc.cpa/event/sste435-26-surgents-leverage-powerbi-com-to-create-data-analysis-for-others/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260525T060837
CREATED:20250605T213126Z
LAST-MODIFIED:20250606T044819Z
UID:10005489-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE431/26) Surgent's Clean\, Transform\, and Load Data in Power BI
DESCRIPTION:Event Description\nThis intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis\, the ability to effectively manage\, clean\, and transform this data is critical. This course delves into Microsoft Power Query\, a potent tool within Excel\, and Power BI Desktop\, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application\, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused\, the course encourages active learning through a series of practical exercises\, live demonstrations\, and illustrative case studies. This approach not only deepens the understanding of Power Query’s features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application\, it remains detailed in its instruction\, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data\, such as business analysts\, project managers\, and financial professionals\, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally\, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges\, ensuring that their data processes are efficient\, scalable\, and sustainable. This course is not just about mastering a tool; it’s about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course\, participants will be equipped to leverage Power Query in Excel or Power BI Desktop to its full potential\, turning data into a powerful driver for business success and innovation. \nDesigned For\nAccounting professionals\, financial analysts\, and anyone who regularly works with data and seeks to improve their skills in data management and analysis using Power Query \nObjectives\nIdentify the key features and functionalities of Microsoft Power Query    Distinguish between different data transformation techniques in Power Query\, including data cleaning\, merging\, and pivoting    Indicate the best practices for documenting each step in your data transformation process \nMajor Subjects\nIntroduction to Power Query in Power BI: the interface and basic functionalities    Removing duplicates\, handling null values\, and data type conversions    Advanced methods for manipulating data\, including pivoting\, merging\, and appending queries    Efficiently loading data into the Power BI data model    Setting up details for each step in the process so you can document what is happening and why \nInstructions\nDownload the handout and practice material prior to the course
URL:https://sc.cpa/event/sste431-26-surgents-clean-transform-and-load-data-in-power-bi/
CATEGORIES:Self-Study Video
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260630T120000
DTEND;TZID=America/Detroit:20260630T120000
DTSTAMP:20260525T060837
CREATED:20250605T213210Z
LAST-MODIFIED:20250606T044912Z
UID:10005498-1782820800-1782820800@sc.cpa
SUMMARY:(SSTE458/26) Surgent's Improve Design and Productivity with Excel Tables
DESCRIPTION:Event Description\nExcel tables are a fundamental feature that streamlines data organization\, analysis\, and visualization in Excel. Throughout this course\, you will discover how to transform raw data into elegant\, efficient\, and visually appealing tables. By harnessing the full potential of Excel tables\, you will be able to make better data-driven decisions and collaborate more effectively in various professional settings. Unlock the full potential of Excel tables to revolutionize the way you manage\, analyze\, and present data\, leading to improved efficiency and better decision-making in your personal and professional endeavors. \nDesigned For\nAny Excel user who wants to learn features within Excel to create better spreadsheets in a shorter amount of time \nObjectives\nUse Excel tables in most spreadsheets    Apply features of Excel tables to create more accurate spreadsheets    Identify ways to improve spreadsheet productivity by using Excel tables \nMajor Subjects\nWhat are Excel tables are and why are they important?    How to create Excel Tables from scratch    The art of sorting and filtering data within Excel tables to quickly identify patterns\, trends\, and outliers    How Excel tables use structured reference formulas to create accurate calculations    How Excel tables increase spreadsheet creation productivity \nInstructions\nNone
URL:https://sc.cpa/event/sste458-26-surgents-improve-design-and-productivity-with-excel-tables/
CATEGORIES:Self-Study Video
END:VEVENT
END:VCALENDAR