Learn to develop a complete real-world solution using Dataverse and Power Apps while we develop a tool that will help a non-profit in Guatemala make a difference in the lives of children. You’ll learn how to engineer a real-world project in Dataverse, building a canvas and model-driven app from the ground up. If you’re a beginner, this video is for you!
Overview
COURSE DIFFICULTY
COURSE DURATION
4h 30m
Skills Learned
After completing this online training course, students will be able to:
Create and analyze data with PivotTables
Build formulas and functions for data analysis
Build data models with Power Pivot
Develop analytical models with SQL Server Analysis Services
Database Administrators, Excel Power Users, Business Analysts, Data Analysts
None
01. Introduction to SSAS Tabular - What you need to get started
02. Introduction to SSAS Tabular for Developers
03. Introduction to Tabular (Overview)
04. Introduction to Tabular (Choosing Tabular vs Multidimensional)
05. Introduction to Tabular (Upgrading Power Pivot to Tabular)
06. Importing Data into Tabular
07. Creating the Data Model
08. Creating Calculated Columns with DAX (Introduction to DAX)
09. Creating Calculated Columns with DAX (Your First Calculations)
10. Creating Calculated Columns with DAX (Navigation Functions)
11. Creating Calculated Measures with DAX (Basics)
12. Creating Calculated Measures with DAX (Calculate Function)
13. Incorporating Time Intelligence
14. Building Reports in Excel
15. Managing Tabular Models (Perspectives)
16. Managing Tabular Models (Partitions)
17. Managing Tabular Models (Deployment)
18. Securing Tabular Data Models
19. Advanced Data Analysis (KPIs)
20. Advanced Data Analysis (Role Playing Dimensions)
21. Advanced Data Analysis (Many to Many)
22. Advanced Data Analysis (Parent-Child)
23. Performance Tuning
24. Planning and Implementing a Solution
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create and analyze data with PivotTables
Build formulas and functions for data analysis
Build data models with Power Pivot
Develop analytical models with SQL Server Analysis Services
WHO SHOULD ATTEND
Database Administrators, Excel Power Users, Business Analysts, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Introduction to SSAS Tabular - What you need to get started
02. Introduction to SSAS Tabular for Developers
03. Introduction to Tabular (Overview)
04. Introduction to Tabular (Choosing Tabular vs Multidimensional)
05. Introduction to Tabular (Upgrading Power Pivot to Tabular)
06. Importing Data into Tabular
07. Creating the Data Model
08. Creating Calculated Columns with DAX (Introduction to DAX)
09. Creating Calculated Columns with DAX (Your First Calculations)
10. Creating Calculated Columns with DAX (Navigation Functions)
11. Creating Calculated Measures with DAX (Basics)
12. Creating Calculated Measures with DAX (Calculate Function)
13. Incorporating Time Intelligence
14. Building Reports in Excel
15. Managing Tabular Models (Perspectives)
16. Managing Tabular Models (Partitions)
17. Managing Tabular Models (Deployment)
18. Securing Tabular Data Models
19. Advanced Data Analysis (KPIs)
20. Advanced Data Analysis (Role Playing Dimensions)
21. Advanced Data Analysis (Many to Many)
22. Advanced Data Analysis (Parent-Child)
23. Performance Tuning
24. Planning and Implementing a Solution
