Make Strategic Business Decisions : Data Analytics

4 Days | Price: $799

Data Analytics is designed to alleviate the trepidation of analysis and focus on key identifiers for understanding methods of analysis and how to use exploration and visualization tools. Our clients tell us that the biggest challenges they face with data analysis are their need to overcome how to select the data for analysis, how to determine what data to select, and how to integrate the data pieces to provide a story that will provide metrics to build programs and services, provide information for organizational improvements, and drive future opportunities. Even with training in a particular tool, it is difficult to provide proper analysis by checking pre-determined metrics on a list. For the non-statistician, it is important to go beyond the tool and truly understand what analysis is important. This course, using Microsoft Excel, is designed to alleviate the trepidation of analysis and focus on key identifiers for understanding methods of analysis and how to use the exploration and visualization tools available in standard business productivity tools. NOTE: This class is four ½-day sessions.
1 – Working with Lists and Tables
  • Creating manual range names
  • Working with lists
  • Converting lists to tables
  • Working with tables
  • Changing the table area
  • Adding new rows or columns to the table
  • Toggling total row
  • Using table selection shortcuts
  • Using unique/duplicate records
  • Sorting list/table rows
  • Filtering a table
  • Outlining data
  • Validating data
  • Using subtotals
2 – Understanding Tools for Data Exploration
  • Creating charts
  • Modifying and formatting charts
  • Using advanced chart features
  • Creating Sparklines
  • Creating PivotTables
  • Understanding PivotTable benefits
  • Filtering data using row and column filters
  • Filtering data using report filters
  • Filtering data using slicers
3 – Using the Analysis Tool Pack
  • Understanding Confidence Intervals
  • Creating descriptive statistics
  • Adding Single Factor ANOVA
  • Creating a correlation
  • Working with Histogram
  • Creating moving averages
  • Using Regressions
4 – Using Visuals in Excel
  • Using conditional formatting
  • Inspecting with Trendlines
  • Observing exponential growth
  • Looking at data with Pareto Charts
 

Upcoming Classes

StartsRegister