Course Description
Course Overview
Data Analytics for Business & Research Institutions is a comprehensive course designed to equip learners with the skills needed to harness the power of data in making informed decisions. Taught by industry experts, this course covers a wide range of data analytics techniques, from basic data processing to advanced statistical analysis and predictive modeling, tailored specifically for business environments and research institutions.
Delivered online, this course offers the flexibility to learn at your own pace, making it suitable for both beginners and professionals looking to enhance their data analytics capabilities. The curriculum is rich with practical exercises, case studies, and real-world projects, allowing students to apply their knowledge in analyzing complex datasets, identifying trends, and making data-driven decisions.
Students receive ongoing mentorship from experienced data analysts throughout the course, ensuring they fully grasp the concepts and tools necessary to excel in data analytics. This mentorship helps learners transition from theory to practice, enabling them to effectively apply data analytics in their organizations, whether for business optimization or academic research, and become proficient in turning data into actionable insights.
Course Outline
Module One: Microsoft Excel
- Overview of MS Excel
- Getting Started with MS Excel
- Data Entry in MS Excel
- Relative & Absolute Referencing in MS Excel
- Moving Data Across Sheets
- Basic Shortcuts in MS Excel
- Autofill in MS Excel
- Displaying formula in MS Excel status bar
- Conditional Formatting in MS Excel
- Table Styles
- Cell Styles
- Inserting Smart Art
- Goal Seek
- Scenarios
- Data Table & Sensitivity Analysis
- Forecasting in MS Excel
- Tracing Precedents & Dependents
- Comments in MS Excel
- Inserting Charts in MS Excel
- Pivot Table
- Text to Column & Concatenation
- Flashfill in MS Excel
- Checking & Removing Duplicates
- Data Consolidation
- Tables in MS Excel
- Grouping Data in MS Excel
- SUMIF,SUMIFS,COUNTIF,COUNTIFS
- Data Validation & Dropdown List
- VLOOKUP & HLOOKUP
- IFERROR
- MS Excel IF
- Named Ranges
- Understanding MS Excel Errors
- MS Excel Form
- marking a Workbook as Final
- Protecting MS Excel Workbook
- Module Conclusion & Reflections
- MS Excel Quiz & Assignments
Module Two: Microsoft Power Business Intelligence (Power BI)
- Overview of Power BI
- Loading Data to Power BI
- Components of Power BI
- Charts & Visualizations
- Data Interactions in Power BI
- Data Models & Relationships
- Data Cleanup
- Data Analysis Expressions (DAX)
- Formatting Power BI Visuals
- Conditional Formatting
- Inserting Titles & Pictures
- Trends & Forecasting in PBI
- Building Dashboards in PBI
- Module Conclusion & Reflections
- MS Power BI Quiz & Assignments
Module Three: MYSQL
- Overview of SQL & Database
- Introduction to Data
- Introduction to Primary Keys
- Introduction to Foreign Keys
- Getting Started with MYSQL
- Creating Database & Tables
- SQL Syntax
- SQL Insert Into
- SQL Select From
- SQL Conditions
- SQL Order By
- SQL Null Values
- SQL Update
- SQL Delete
- SQL Select Top
- SQL Min & Max Values
- SQL Sum
- SQL Count
- SQL Like
- SQL IN
- SQL Between
- SQL Aliases
- SQL Joins
- SQL Group By
- SQL Exists
- Date Part
- SQL Having
- SQL Data Import
- SQL Data Export
- Module Reflections & Conclusion
- SQL Quiz & Assignments
Module Four: Statistical Package for Social Sciences
- Overview of SPSS
- Installation of SPSS Software
- Getting Started with SPSS
- Descriptive Statistics in SPSS
- Knowledge Transformation, Hypothesis & Decision Rule in SPSS
- Linear Regression in SPSS
- Correlations in SPSS
- One Way ANOVA in SPSS
- ANCOVA in SPSS
- Independent T-Test in SPSS
- Paired T-test in SPSS
- Chi-Square in SPSS
- Forecasting in SPSS
- Quality Control in SPSS
- Test for Reliability
- Module Conclusion & Reflections
- SPSS Quiz & Assignments
0 reviews for "Data Analytics for Business & Research Institutions"
