(Online Delivery) Data Analysis Fundamentals
Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes). Please note - this is NOT a class that focuses on Microsoft Excel, Power BI, or any other software. Microsoft Excel will likely be used in class to illustrate core concepts, but the class is not designed to help students use software.
Description
Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).
Please note - this is NOT a class that focuses on Microsoft Excel, Power BI, or any other software. Microsoft Excel will likely be used in class to illustrate core concepts in a hands-on format, but the class is not designed to help students use software. This class is intended as a precursor to further training on Microsoft Excel, Power BI, or any other tool being used for data analysis.
Lesson 1: Understanding Types and Characteristics of Data
- Understand Types of Data
- Break Down the Field Data Types
Lesson 2: Describing Key Analysis Techniques
- Get Started with Analysis
- Recognize Types of Analysis
Lesson 3: Using the Appropriate Type of Visualization
- Learn Use Basic Visuals
- Build Advanced Visuals
- Build Maps with Geographical Data
- Use Visuals to Tell a Story
Lesson 4: Expressing Business Requirements in a Report Format
- Consider Audience Needs When Developing a Report
- Describe Data Source Considerations For Reporting
- Describe Considerations for Delivering Reports and Dashboards
- Develop Reports or Dashboards
- Understand Ways to Sort and Filter Data
Lesson 5: Designing Components for Reports and Dashboards
- Design Elements for Reports and Dashboards
- Utilize Standard Elements
- Creating a Narrative and Other Written Elements
- Understand Deployment Considerations