University of North Carolina Wilmington
University of North Carolina Wilmington

Swain Center for Executive Education

 

Business Analytics Course - Using Excel

Power Query

September 21, 2018
8:30 am - 12:30 pm

UNCW, Wilmington, NC

Register Now

Register for Predictive Analytics, Power Query, and  PivotTables & Visualization and save $198!

Register for all

Download the course brochure

$399

Course fee includes:

  • Course slides and handouts
  • Parking
  • Certificate

$999 for  all three courses: Predictive Analytics, Power Query, and  PivotTables & Visualization

UNCW Faculty/Staff/Students/Alum receive a 10% discount. Choose the appropriate rate when registering for Swain programs online. If a UNCW department is funding your participation, use the Promo Code “SEAHAWK” to register online and initiate billing to your department with an IDI (internal Invoice). You can not pay with a UNCW Purchasing Card.

UNCW Swain Center is recognized by SHRM to offer SHRM-CP or SHRM-SCP Professional Development Credits (PDC). This program is valid for 4 PDCs toward SHRM-CP and SHRM-SCP recertification. For more information about certification or recertification, please visit SHRMcertification.org.

UNCW Campus

Randall Library 1022 or CI 1003 (TBD)

Parking Information

  • Importing and appending Excel data
  • Importing and appending text data
  • Merging data files
  • Merging queries
  • Importing data from web
  • Un-pivoting raw data files

Business have access to more data than ever before, yet one common frustration is the inability to combine and analyze data from diverse data types, sources, and formats. This data variety results in data separation that prevents business managers from using all available information when making decisions. Bringing isolated data together encourages information sharing for more efficient and well-informed business decisions.

Fortunately, there are spreadsheet software tools that can assist with merging various channels of data. This course will feature an in-depth exploration of Power Query. Power Query allows Excel users to add data from almost any source ( i.e., Excel, Access, SQL Server, Web, Text, etc.), transform and combine the data, and then export the output into Excel tables for analysis. Power Query is standard in Excel 2016 and is a free add-in program for users of Excel 2010 and Excel 2013.
  • Work faster and more efficiently in Excel
  • Append and merge data files and tables
  • Merge multiple data tables, files and folders
  • Combine spreadsheet and text data
  • Un-pivot raw data tables
  • Import data from the Web

This program is designed for:

  • are responsible for producing tables, charts, and reports in Excel
  • need to combine and analyze data from multiple sources
  • have basic Excel spreadsheet skills 

It is important to be proficient in data analytics to:

  • efficiently perform routine tasks to make data analysis faster and more efficient
  • extract meaningful insights from all available information
  • quickly update files, folders, and charts with new data
  • to avoid mistakes in transforming and combining data

Check out the 'Data Science' sector of Fast Company's Most Innovative Companies of 2016!

"I am thankful to have had the opportunity to take this class. The concepts I learned I will definitely be able to use."

"Analytics is unlike any other class I've taken thus far. It provided a challenge, but proved very interesting. I would definitely recommend this class."

"I enjoyed the learning opportunity and the quality of the teaching!"

Dr. Brian Kinard Brian R. Kinard, PhD, Associate Professor of Marketing, joined the Cameron School of Business in 2007 after receiving his Ph.D. in Marketing from Mississippi State University. Brian teaches undergraduate Marketing Analytics, Marketing Research, and Sports Marketing courses and actively engages in research related to consumer risk behavior. He also serves as a reviewer for several academic journals and professional organizations and has made numerous contributions to scholarly publications, including the International Journal of Research in Marketing, Journal of Advertising, Cornell Hospitality Quarterly, Journal of Consumer Affairs, and Journal of Services Marketing. He is the Associate Executive Director of the Atlantic Marketing Association and received the 2016 UNCW Chancellor's Award for Teaching Excellence.