STANDARD COMPETENCIES

 

 1 Demonstrate use of industry software to develop powerful visualizations

 2 Connect to various data sources through desktop data visualization software.

 3 Create basic calculations, including string manipulation, basic arithmetic calculations, custom aggregations and ratios,

        date math, logic statements and quick table calculations.

 4 Represent data using various visualization types.

 5 Join and blend data from various sources, as determined by intial request.

 6 Share your visualizations with others.

 7 Build dashboards and story points within data visualization software

 8 Identify key data elements required to build visualizations.

 9 Apply filters and parameters through data visualization software

 10 Enable drill-through functionality through actions in industry data visualization software

 

 

 TOPICAL OUTLINE

 

 I. Connect to data sources

 II. Data software interface and terminology to create powerful visualizations

 III. Basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios,

        date math, logic statements and quick table calculations

 IV. Representation of data using a variety of visualization types like the following:

      a. Cross Tabs

      b. Scatter Plots

      c. Geographic Maps

      d. Pie Charts and Bar Charts

      e. Motion Charts

      f. Small Multiples

      g. Heat Maps

      h. Density Charts

      i.   Tree Maps

 V. Trend lines, reference lines, and statistical techniques to describe data

      a. Implementing actions that will enable drill-through, drill-across, and table highlights.

      b. Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations

      c. Joining data, blending data, and updating data sources.

      d. Sharing visualizations with others.

      e. Combining your visualizations into interactive dashboards and story points