وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

SQL Server Analysis Services

سرفصل های دوره

SQL Server Analysis Services Tabular can help you analyze your data more effectively—even if you have a large volume of data to sort through—organizing and storing your data so that you can find trends by looking at data summaries. In this course, Ginger Grant provides high-level overview SQL Server Analysis Services Tabular, with real-world examples, to help you gain insights from your data and plan for the future. Ginger shows you how to install the required complex development environment outside of SQL Server Management studio and explains the benefits of creating a data model in Analysis Services. Advanced topics include how to extend the analysis using DAX, an in-depth look at the model components, and how the different relationships change the way the data is displayed.

Join Ginger in this course to learn how to organize and store your data in a way that makes it easier to find trends and draw conclusions—and move beyond spreadsheets!


01 - Introduction
  • 01 - Scalable data modeling with Analysis Services Tabular
  • 02 - Background skills

  • 02 - 1. Introducing Analysis Service Tabular
  • 01 - Analysis Services Tabular
  • 02 - Installing SQL Server and Analysis Services
  • 03 - Installing SQL Server Management Studio
  • 04 - Restoring data
  • 05 - Installing Visual Studio and testing with Excel

  • 03 - 2. Creating a Data Model
  • 01 - Introduction to data modeling in Analysis Services Tabular
  • 02 - Creating your first Analysis Services project
  • 03 - Create a data source to SQL Server
  • 04 - Adding other data sources
  • 05 - Challenge Create and test your model
  • 06 - Solution Create and test your model

  • 04 - 3. Creating Measures with DAX
  • 01 - Providing business insight with DAX measures
  • 02 - Creating tables in DAX
  • 03 - Developing calculated measures
  • 04 - Using the CALCULATE function
  • 05 - Challenge Calculate measures
  • 06 - Solution Calculate measures

  • 05 - 4. Time Intelligence Calculations
  • 01 - Incorporating time intelligence
  • 02 - All about the date table
  • 03 - Examining three popular DAX time intelligence functions SAMEPERIODLASTYEAR, PARALLELPERIOD, and TOTALYTD
  • 04 - Writing DATESBETWEEN measures
  • 05 - Challenge Time intelligence measures
  • 06 - Solution Time intelligence measures

  • 06 - 5. Advanced Modeling
  • 01 - Examining different modeling relationships
  • 02 - Active and inactive relationships
  • 03 - Resolving issues with inactive relationships with USERELATIONSHIP
  • 04 - Challenge USERELATIONSHIP measures
  • 05 - Solution USERELATIONSHIP measures

  • 07 - 6. Row-Level Security
  • 01 - Restricting data for different users
  • 02 - Modifications to the model to support row-level security
  • 03 - Implementing roles in your model to restrict data
  • 04 - Challenge Implement model security
  • 05 - Solution Implement model security

  • 08 - 7. Deploying the Model
  • 01 - Review of deployment steps
  • 02 - Troubleshooting potential deployment issues
  • 03 - Review of how to test the model in SQL Server Management Studio

  • 09 - Conclusion
  • 01 - Learn more about Analysis Services
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 16937
    حجم: 320 مگابایت
    مدت زمان: 143 دقیقه
    تاریخ انتشار: ۸ مرداد ۱۴۰۲
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید