A tabular data model is used for accessing your date intuitively especially if you want to organize large volumes of data. You will learn how Analysis Services work to be able to develop a tabular model.
You are provided in this [course_title] with lessons to import tables of data from different sources to maximize your access. This will help you enhance your model with business logic to ensure that you will succeed in the industry you are part of.
Assessment
This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.
Certification
Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.
Having an Official Edukite Certification is a great way to celebrate and share your success. You can:
- Add the certificate to your CV or resume and brighten up your career
- Show it to prove your success
Course Credit: Microsoft
Course Curriculum
Introducing Analysis Services | |||
Lesson Introduction | 00:01:00 | ||
Introducing Data Models | 00:05:00 | ||
Demo: Exploring a Tabular Model | 00:03:00 | ||
Introducing Analysis Services | 00:06:00 | ||
Goals of Analysis Services | 00:03:00 | ||
Developing and Managing Tabular Databases | 00:02:00 | ||
Reporting with Microsoft Reporting Tools | 00:02:00 | ||
Lesson Introduction | 00:01:00 | ||
Delivering Tabular Model Solutions | 00:02:00 | ||
Preparing Supporting Database Schemas | 00:01:00 | ||
Demo: Introducing the Finance Schema | 00:03:00 | ||
Creating Tabular Projects | 00:02:00 | ||
Demo: Creating a Tabular Project | 00:07:00 | ||
Review | 00:01:00 | ||
Lesson Introduction | 00:01:00 | ||
Importing Data | 00:07:00 | ||
Demo: Importing Data | 00:12:00 | ||
Creating Relationships | 00:06:00 | ||
Demo: Creating Relationships | 00:03:00 | ||
Review | 00:01:00 | ||
Lab 1 Introduction | 00:01:00 | ||
Lab 2 Introduction | 00:01:00 | ||
Designing Tabular Models | |||
Lesson Introduction | 00:01:00 | ||
Configuring Table and Column Properties | 00:10:00 | ||
Demo: Configuring Table and Column Properties | 00:07:00 | ||
Defining Date Tables | 00:02:00 | ||
Demo: Defining a Date Table | 00:03:00 | ||
Creating Hierarchies | 00:02:00 | ||
Demo: Creating Hierarchies | 00:04:00 | ||
Creating Perspectives | 00:01:00 | ||
Demo: Creating Perspectives | 00:02:00 | ||
Creating Translations | 00:02:00 | ||
Demo: Creating Translations | 00:03:00 | ||
Review | 00:01:00 | ||
Lesson Introduction | 00:01:00 | ||
Introducing DAX | 00:09:00 | ||
Creating Calculated Columns | 00:01:00 | ||
Demo: Creating Calculated Columns | 00:06:00 | ||
Creating Calculated Tables | 00:02:00 | ||
Creating Measures | 00:02:00 | ||
Demo: Creating Measures | 00:13:00 | ||
Creating KPIs | 00:02:00 | ||
Demo: Creating a KPI | 00:04:00 | ||
Review | 00:01:00 | ||
Lab 3 Introduction | 00:01:00 | ||
Managing Tabular Models | |||
Lesson Introduction | 00:01:00 | ||
Scripting Administrative Tasks | 00:01:00 | ||
Demo: Generating a Script | 00:01:00 | ||
Configuring Partitions | 00:02:00 | ||
Demo: Configuring Partitions | 00:03:00 | ||
Configuring Processing | 00:05:00 | ||
Demo: Configuring Processing | 00:07:00 | ||
Configuring Permissions | 00:03:00 | ||
Demo: Configuring Permissions | 00:06:00 | ||
Deploying Tabular Databases | 00:02:00 | ||
Demo: Deploying Tabular Databases | 00:03:00 | ||
Managing Tabular Databases | 00:03:00 | ||
Demo: Programmatically Working with SSAS | 00:03:00 | ||
Review | 00:26:00 | ||
Delivering Secure Data to PowerBI | 00:04:00 | ||
Describing DirectQuery Mode | 00:01:00 | ||
Use Cases for DirectQuery Mode | 00:01:00 | ||
Creating Models with DirectQuery Mode | 00:02:00 | ||
Demo: Working With DirectQuery Mode | 00:06:00 | ||
Review | 00:01:00 | ||
Lab 4 Introduction | 00:01:00 | ||
Making Architectural Decisions | |||
Lesson Introduction | 00:01:00 | ||
Introducing Azure Analysis Services | 00:01:00 | ||
Deploying Tabular Models to Azure | 00:03:00 | ||
Demo: Deploying to Azure Analysis Services | 00:05:00 | ||
Lesson Introduction | 00:01:00 | ||
Selecting the Right Model Type | 00:11:00 | ||
Comparing Supported SSAS Editions | 00:01:00 | ||
Review | 00:01:00 | ||
Lesson Introduction | 00:01:00 | ||
Registering SSAS with Azure Data Catalog | 00:11:00 | ||
Review | 00:03:00 | ||
Asessment | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.