Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)
OFF
IT & SoftwareSQL Server Analysis Services (SSAS)

Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)

4.7
(812 students)
6h 30m

>_ What You'll Learn

  • Extract data from multiple tables.
  • Create connections between the tables.
  • Develop the model using DAX functions.
  • Create analyses in Excel.

>_ Requirements

  • You don't need to know or do anything before starting this course.
  • I'll show you have to download the Developer Edition of SQL Server 2022 for FREE. Previous versions cost $100.
  • You need to have a Windows computer, or use a Mac computer which can dual-boot into Windows or using Parallel Desktop with Windows. (However, it will not work under Windows ARM - for example, a Mac M1 or M3.)

/ Course Details & Curriculum

This course covers the Tabular model in SQL Server Analytical Services.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

We'll install SQL Server Developer onto your computer, which previously used to cost $100, together with the SSAS extension.

We'll then create our first analysis using SQL Server in just a matter of minutes.

After this introduction, we'll go into some detail into how to create your analyses in Excel, including advanced Pivot Table options that most people don't even know about, but which are very useful. This includes slicers, timelines, and non-Visual Totals.

Then we'll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too. We'll create calculated columns, which are replicated in each row, and measures, which are summary calculations. We'll have a look at logical, aggregations, statistical, mathematical, text, information, filter and value, and time intelligence functions.

Finally, I'll show you how you can do similar things in Microsoft Excel.

By the end of this course, you will be able to create reliable analyses in Visual Studio, deploy them into SQL Server Analytical Services, drilled down the results quickly in Excel, and you'll be able to help others with their data analysis.

Author and Instructor

P

Phillip Burton, I Do Data Limited

Expert at Udemy

With years of hands-on experience in IT & Software, Phillip Burton, I Do Data Limited has dedicated thousands of hours to teaching and mentorship. This course is the culmination of industry best practices and a proven curriculum that has helped thousands of students transition into professional roles.

Community Feedback

M

Michael Chen

Verified Enrollment

"This Microsoft SQL Server Analysis Services - SSAS (Tabular DAX) course was exactly what I needed. The instructor explains complex IT & Software concepts clearly. Highly recommended!"

S

Sarah Johnson

Verified Enrollment

"I've taken many Udemy courses on advanced data analysis & Excel automation, but this one stands out. The practical examples helped me land a job."

D

David Smith

Verified Enrollment

"Great value for money. The section on SQL Server Analysis Services (SSAS) was particularly helpful."

E

Emily Davis

Verified Enrollment

"Excellent structure and pacing. I went from zero to hero in IT & Software thanks to this course. Lifetime access is a huge plus."

Common Questions

Is the "Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)" course truly discounted?
Yes. By utilizing our verified 90% coupon, you can enroll in "Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)" at a massive discount. This grants you lifetime access to all course materials and updates.
Do I qualify for a certificate upon completion?
Yes. When you enroll with a 90% coupon provided by CoursesWyn, you follow the same path as a paid student and are eligible for the official completion certificate from Udemy.
What happens if the coupon code expires?
Udemy coupons have strict enrollment limits and time windows. If this code expires, we recommend bookmarking this page and checking back daily, as we refresh our deals constantly to find the latest active discounts.
$99.99Save 90%
$9.99

Verified Discount Code

CLAIM DISCOUNT 🚀
Lifetime Access
🏆Official Certificate
📱Access on Mobile/TV
🔄Latest Updated Course

Claim Your Discount Code

XXXXXXXX
CLICK TO SHOW
$99.99
$9.9990%
GET DEAL