Phu Xuan University Library
|
PXU E-LIB
Sign in
Data Analysis Certificate Program

External

Data Analysis Certificate Program

Calbright prepares data analysts to be versatile and capable of contributing to any industry. Therefore, readers will find a broad range of topics presented in this text, including spreadsheets, Structured Query Language (SQL), databases, data visualization, public speaking, research, and statistics. This resource is written for anyone seeking to become a well-rounded data professional and wants an introduction to the specializations that exist within varied data analyst roles.

Business
Author
Alex Mata
Publisher
Calbright College
Source
LibreTexts
License
CC BY-SA
Language
EN
Category
Business Administration
Read online Download PDF (open licence)
Contents· 155 sections
  1. 01: Welcome to Data Analysis
  2. 02: Introduction to Working in Microsoft Excel
  3. 2.01: Using Excel Cells
  4. 2.02: Using Excel Data
  5. 2.03: Using Excel Functions
  6. 2.04: Using Excel Charts
  7. 2.05: Using Conditional Formatting in Excel
  8. 03: Working in Google Sheets
  9. 3.01: Creating a New Spreadsheet
  10. 3.02: Using Google Sheets
  11. 3.03: Add-Ons
  12. 04: SQL Structured Query Language
  13. 4.01: Create Database
  14. 4.02: Constraints
  15. 4.03: User Defined Types and Altering Tables
  16. 4.04: Key Terms and Exercises
  17. 05: SQL Data Manipulation Language
  18. 5.01: Using SELECT Statement
  19. 5.02: INSERT Statement
  20. 5.03: UPDATE and DELETE Statements
  21. 5.04: Built-In Functions
  22. 5.05: Joining Tables
  23. 5.06: Key Terms and Exercises
  24. 06: The Relational Data Model
  25. 6.01: Fundamental Concepts in the Relational Data Model
  26. 6.02: Key Terms
  27. 07: The Entity Relationship Data Model
  28. 7.01: Entity Entity Set and Entity Type
  29. 7.02: Types of Attributes
  30. 7.03: Keys
  31. 7.04: Nulls
  32. 7.05: Relationships
  33. 7.06: Key Terms and Exercises
  34. 08: Visual Media
  35. 8.01: Tables Charts and Infographics
  36. 8.02: Matching Graphics and Objectives
  37. 8.03: Placement Style and Coloring
  38. 8.04: Captions and Titles
  39. 8.05: Introduction to Contemporary Visual Aids
  40. 8.06: Video as a Visual Aid
  41. 8.07: Designing a Video for Your Needs
  42. 8.08: Products and Resources for Creating Videos
  43. 8.09: Introduction to Accessible Visual Aids
  44. 8.10: Accessibility Matters
  45. 8.11: Why It Matters- Visual Media
  46. 8.12: Introduction to Using Visuals
  47. 8.13: Visuals in a Report
  48. 8.14: Increasing Impact with Media
  49. 8.15: Revising and Enhancing Visual Media for Impact
  50. 8.16: Evaluating the Effectiveness of your Message
  51. 8.17: Putting It Together- Visual Media
  52. 8.18: Discussion- Visual Media
  53. 8.19: Assignment- Visual Media
  54. 8.20: Introduction to Media and Your Message
  55. 8.21: Using Visual Media Resources
  56. 8.22: Visual Design Principles
  57. 8.23: Introduction to Images
  58. 8.24: Images Overview
  59. 8.25: Using Images for Impact
  60. 8.26: Using Images Legally
  61. 8.27: Introduction to Charts Diagrams and Graphic Organizers
  62. 09: Research and Statistics
  63. 9.01: Introduction
  64. 9.02: Measures of Center
  65. 9.03: Measures of Variation
  66. 9.04: Theres More to Research Methods than Statistics
  67. 9.05: A brief Introduction to Research Design
  68. 9.06: Introduction to Psychological Measurement
  69. 9.07: Scales of measurement
  70. 9.08: Assessing the Reliability of a Measurement
  71. 9.09: The role of variables predictors and outcomes
  72. 9.10: Experimental and non-experimental research
  73. 9.11: Assessing the validity of a study
  74. 9.12: Confounds Artifacts and other Threats to Validity
  75. 9.13: Videos
  76. 9.14: References
  77. 10: Data Validation
  78. 10.01: Importance of Statistics and Experimental Measurements
  79. 11: Describing Data
  80. 11.01: This is what too many numbers looks like
  81. 11.02: Look at the data
  82. 11.03: Important Ideas - Distribution Central Tendency and Variance
  83. 11.04: Measures of Central Tendency (Sameness)
  84. 11.05: Measures of Variation (Differentness)
  85. 11.06: Using Descriptive Statistics with data
  86. 11.07: Rolling your own descriptive statistics
  87. 11.08: Remember to look at your data
  88. 11.09: Videos
  89. 11.10: References
  90. 12: Correlation
  91. 12.01: If something caused something else to change what would that look like
  92. 12.02: Pearsons r
  93. 12.03: Turning the numbers into a measure of co-variance
  94. 12.04: Examples with Data
  95. 12.05: Regression A mini intro
  96. 12.06: Interpreting Correlations
  97. 12.07: Summary
  98. 12.08: References
  99. 13: Probability Sampling and Estimation
  100. 13.01: Prelude to Probability Sampling and Estimation
  101. 13.02: How are Probability and Statistics Different
  102. 13.03: What Does Probability Mean
  103. 13.04: Basic Probability Theory
  104. 13.05: The Binomial Distribution
  105. 13.06: The normal distribution
  106. 13.07: Other useful distributions
  107. 13.08: Summary of Probability
  108. 13.09: Samples populations and sampling
  109. 13.10: The Law of Large Numbers
  110. 13.11: Sampling distributions and the central limit theorem
  111. 13.12: The Central Limit Theorem
  112. 13.13: z-scores
  113. 13.14: Estimating population parameters
  114. 13.15: Estimating a confidence interval
  115. 13.16: Summary
  116. 13.17: Videos
  117. 13.18: References
  118. 14: Public Speaking
  119. 14.01: How You Speak
  120. 14.02: Introduction to Audience Engagement
  121. 14.03: Audience Attention and Rapport
  122. 14.04: Audience Participation
  123. 14.05: Introduction to Speech Tips and Techniques
  124. 14.06: Overcoming Fears and Anxiety
  125. 14.07: Pro Tips
  126. 14.08: Putting It Together- Public Speaking
  127. 14.09: Discussion- Public Speaking
  128. 14.10: Why It Matters- Public Speaking
  129. 14.11: Introduction to Effective Public Speaking
  130. 14.12: What is Public Speaking
  131. 14.13: Benefits of Public Speaking
  132. 14.14: Audience Expectations
  133. 14.15: Developing an Effective Speech
  134. 14.16: Introduction to Delivery Techniques
  135. 14.17: Starting Your Speech
  136. 14.18: Body Language and Gestures
  137. 15: Developing and Delivering Business Presentations
  138. 15.01: Text Boxes and Themes
  139. 15.02: Images Videos and Arranging Objects
  140. 15.03: Introduction to Making a Presentation for a Meeting
  141. 15.04: Parts of a Good Presentation
  142. 15.05: Whats my Presentation About
  143. 15.06: Bad Presentations
  144. 15.07: Making a Presentation for a Meeting
  145. 15.08: Putting It Together- Developing and Delivering Business Presentations
  146. 15.09: Assignment- Developing and Delivering Business Presentations
  147. 15.10: Why It Matters- Developing and Delivering Business Presentations
  148. 15.11: Introduction to Visual Aids
  149. 15.12: Presentation Tools and Visual Aids
  150. 15.13: Introduction to Using Microsoft PowerPoint
  151. 15.14: New Presentations
  152. 15.15: Editing and Enhancing a PowerPoint Presentation
  153. 15.16: Visuals- Images Videos and Objects
  154. 15.17: Introduction to Using Google Slides
  155. 15.18: Creating and Organizing Presentations