DATA MODELLING (2/2 Credits)

Learning Outcomes:

• Describe core data modeling concepts in structuring and preparing data for analysis
• Apply quantitative techniques, including mathematical data operations and statistical methods, and analytical components, to enhance data analysis
• Design dashboards to visualize meaningful insights by developing and communicating analytical components

Topics:

1. Data Cleaning and Preparation
2. Named Ranges and Tables
3. Logical, Lookup, and Conditional Functions
4. Analysis with Data Tables
5. Get and Transform Data using Power Query
6. Power Pivot and the Data Model
7. Conditional and Number Formatting
8. Mastering Charts
9. Creating Interactive Dashboards
10. Principles of Data Visualization
11. Project Submission and Material Review
12. Data Modeling – Overview and Importance
13. Data Structuring for Data Models
14. Preparing Data for the Data Model
15. Data Modeling with Power Pivot
16. Creating DAX Calculations from The Data Model
17. Creating Cube Functions from The Data Model
18. Communicating Insights from Your Data Model Using Dashboards
19. Making The dashboard interactive
20. Visualization Elements for Your Dashboard
21. Choosing the Right Design Themes
22. Publication and Deployment
23. Foundations of Regression Analysis
24. Interpreting Regression