Course Offerings

Develop essential data analysis skills that are in high demand by local businesses! With this bundled course, participants will build data literacy and learn how to use business tools, including SQL, Microsoft Excel, Microsoft Power BI, and Tableau for data analysis and visualization. Students will learn how to read, write, and communicate data; understand data sources and constructs and use various analysis methods to inspect, cleanse, and transform data to discover insights, suggest conclusions, and support business decision-making. Upon completion, participants will be prepared to take the Microsoft Excel core certification exam.

Course Objectives

Microsoft Excel Fundamentals:
• Manage worksheets and workbooks
• Manage data cells and ranges
• Manage tables and table data
• Perform operations by using formulas and functions
• Manage charts
• Prepare for the certification exam

Excel Data Analysis:
• Demonstrate basic usage of Excel data analysis techniques
• Explore external databases, PivotTables, and Pivot Charts
• Import and export data using external sources
• Cleanse data
• Analyze data using PivotTables And PivotCharts

SQL:
• Create normalized databases
• Explore how to insert data into tables efficiently
• Use various techniques to retrieve data from multiple tables

Power BI:
• Create effective storytelling reports by implementing simple-to-intermediate Power BI features
• Develop powerful analytical models to extract key insights for changing business needs
• Build, publish, and share impressive dashboards for your organization

Tableau:
• Develop data visualizations to explain complex data with clarity
• Explore Data Model capabilities
• Connect to various data sources
• Leverage Tableau Prep Builder's capabilities for data cleaning and structuring
• Create and use calculations to solve problems and enrich the analytics
• Enable smart decisions with data clustering, distribution, and forecasting
• Share data stories to build a culture of trust and action

Communicating with Data:
• Know the fundamental data skills required to work with data
• Use data visualization to influence change in your organization
• Apply data techniques to effectively work with data end to end
• Communicate data points clearly and persuasively
• Review why different stakeholders have divergent needs and views

Outline of instruction

Microsoft Excel Fundamentals:
1. Manage Worksheets and Workbooks
2. Manage Data Cells and Ranges
3. Manage Tables and Table Data
4. Perform Operations by Using Formulas and Functions
5. Manage Charts
6. Prepare for The Excel Core Certification Exam

Excel Data Analysis:
1. Learning Basic Data-Analysis Techniques
2. Working with Data-Analysis Tools
3. Introducing Excel Tables
4. Data from External Sources
5. Cleaning Data
6. Analyzing Table Data with Functions
7. Creating and Using PivotTables
8. Performing PivotTable Calculations
9. Building PivotCharts
10. Exam Certification Preparation

SQL:
1. SQL Basics
2. Manipulating Data
3. Normalization
4. The SELECT Statement
5. Shaping Data with the WHERE Clause
6. JOINS
7. Subqueries, Cases, and Views
8. SQL Programming
9. Security
10. Aggregate Functions

Power BI:
1. Introduction to Business Intelligence and Power BI
2. Up and Running with Power BI Desktop
3. Connecting and Shaping Data
4. Creating Data Models and Calculations
5. Unlocking Insights
6. Creating the Final Report
7. Publishing and Sharing
8. Using Reports in the Service
9. Understanding Dashboards, Apps, and Security
10. Data Gateways and Refreshing Datasets

Tableau:
1. Taking Off with Tableau
2. Connecting to Data in Tableau
3. Moving Beyond Basic Visualizations
4. Calculations and Parameters
5. Leveraging Level of Detail Calculations
6. Diving Deep with Table Calculations
7. Making Visualizations That Look Great and Work Well
8. Telling a Data Story with Dashboards
9. Visual Analytics - Trends, Clustering, Distributions, and Forecasting

Communicating with Data:
1. Communication
2. Data
3. Visualizing Data
4. Visualizing Data Differently
5. Visual Elements
6. Methods of Communicating with Data
7. Implementation Strategies for Your Workplace
8. Tailoring Your Work to Specific Departments

Contact Hours

120

CEUs

1

Industry Standard, State or National Certification

Microsoft

CE or CU Articulation

No

Prerequisites

Prior to registering for this course, students should have digital literacy, including basic computer skills.

Text and Supplies Needed

N/A

Clinical Site/Special Facilities

None

Requirements for Successful Completion

80% attendance"Actively participate in class, including discussions and independent and group activities. ","Complete assigned labs and projects."

Accreditation/Special Approval Requirements

N/A

Intended Audience

Individuals who want to expand their knowledge and skills for employment-readiness or those who want to successfully prepare for the relevant industry certification exam(s).

Specific Industry or Business Support Needs

Data Analyst, Business Analyst, Business Intelligence Analyst, Management Analyst, Systems Analyst

Wake County Need for Industry Positions

According to Burning Glass Technologies, Wake County has a high demand for data analysis skills.

Industry or Job Titles Related to training Outcomes for Employment

Data Analyst

Business Analyst

Business Intelligence Analyst

Management Analyst

Systems Analyst

Related Courses

Course Contact Information

Andrea Dethmers
9195325736
[email protected]