الاستماع والقراءة

خطوة إلى عالم لا حدود له من القصص

  • اقرأ واستمع إلى ما تريده
  • أكثر من مليون عنوان
  • العناوين الحصرية + أصول القصة
  • 7 الشهر يورو في EGP89 يوم تجربة مجانية، ثم
  • من السهل الإلغاء في أي وقت
جرب مجانا
Cover for Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

لغات
الإنجليزية
الصيغة
تصنيف

الإدارة والأعمال

Expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions

About This Book

• Build and deploy Tabular Model projects from relational data sources

• Leverage DAX and create high-performing calculated fields and measures

• Create ad-hoc reports based on a Tabular Model solution

• Useful tips to monitor and optimize your tabular solutions

Who This Book Is For

This book is for SQL BI professionals and Architects who want to exploit the full power of the new Tabular models in Analysis Services. Some knowledge of previous versions of Analysis services would be helpful but is not essential.

What You Will Learn • Learn all about Tabular services mode and how it speeds up development

• Build solutions using sample datasets

• Explore built-in actions and transitions in SSAS 2016

• Implement row-column, and role-based security in a Tabular Data model

• Realize the benefits of in-memory and DirectQuery deployment modes

• Get up to date with the new features added to SQL Server 2016 Analysis Services

• Optimize Data Models and Relationships Usage

In Detail

SQL Server Analysis Service (SSAS) has been widely used across multiple businesses to build smart online analytical reporting solutions. It includes two different types of modeling for analysis services: Tabular and Multi Dimensional. This book covers Tabular modeling, which uses tables and relationships with a fast in-memory engine to provide state of the art compression algorithms and query performance.

The book begins by quickly taking you through the concepts required to model tabular data and set up the necessary tools and services. As you learn to create tabular models using tools such as Excel and Power View, you'll be shown various strategies to deploy your model on the server and choose a query mode (In-memory or DirectQuery) that best suits your reporting needs.

You'll also learn how to implement key and newly introduced DAX functions to create calculated columns and measures for your model data. Last but not least, you'll be shown techniques that will help you administer and secure your BI implementation along with some widely used tips and tricks to optimize your reporting solution.

By the end of this book, you'll have gained hands-on experience with the powerful new features that have been added to Tabular models in SSAS 2016 and you'll be able to improve user satisfaction with faster reports and analytical queries.

Style and approach

This book takes a practical, recipe-based approach where each recipe lists the steps to address or implement a solution. You will be provided with several approaches to creating a business intelligence semantic model using analysis services.

© 2017 Packt Publishing (كتاب إلكتروني): 9781786461506

تاريخ النشر

كتاب إلكتروني: ٣٠ يناير ٢٠١٧

كتب مشابهة لـ Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

  1. كيف تمسك بزمام القوة - 48 قاعدة
    كيف تمسك بزمام القوة - 48 قاعدةروبرت غرين
    4.4
  2. The Psychology of Money: The transformative multimillion-copy personal finance bestseller
    The Psychology of Money: The transformative multimillion-copy personal finance bestsellerMorgan Housel
    4.5
  3. Never Split the Difference: Negotiating As If Your Life Depended On It
    Never Split the Difference: Negotiating As If Your Life Depended On ItChris Voss, Tahl Raz
    4.6
  4. Good to Great: Why Some Companies Make the Leap...And Other's Don't
    Good to Great: Why Some Companies Make the Leap...And Other's Don'tJim Collins
    4.3
  5. The 7 Habits of Highly Effective People
    The 7 Habits of Highly Effective PeopleStephen R. Covey
    4.3
  6. كيف تجذب المال إليك
    كيف تجذب المال إليكجوزيف ميرفي
    4
  7. How to Win Friends and Influence People in the Digital Age
    How to Win Friends and Influence People in the Digital AgeDale Carnegie & Associates
    4.1
  8. Getting to Yes: How to Negotiate Agreement Without Giving In
    Getting to Yes: How to Negotiate Agreement Without Giving InRoger Fisher, William Ury
    4.1
  9. حواديت تسويقية - الجزء الأول
    حواديت تسويقية - الجزء الأولد. مصطفى نوارج
    4.6
  10. قاعدة الحذاء .. ومهارات الحديث والاقناع
    قاعدة الحذاء .. ومهارات الحديث والاقناعد. مصطفى نوارج
    4.3
  11. SPIN Selling
    SPIN SellingNeil Rackham
    4.3
  12. كتاب التفاوض - وفن التعامل مع الاخرين
    كتاب التفاوض - وفن التعامل مع الاخريند. مصطفى نوارج
    4.3
  13. أسرار التسويق - 49 سرًا ناجحًا لتنمية المبيعات
    أسرار التسويق - 49 سرًا ناجحًا لتنمية المبيعاترون فينكلستين
    4.1
  14. ابدأ ب لماذا
    ابدأ ب لماذاسيمون سينك
    4.5
  15. Deep Work: Rules for Focused Success in a Distracted World
    Deep Work: Rules for Focused Success in a Distracted WorldCal Newport
    3.9
  16. How to Talk to Anybody, Anytime, Anywhere: 3 Steps to Make Instant Connections
    How to Talk to Anybody, Anytime, Anywhere: 3 Steps to Make Instant ConnectionsChris Widener
    3.8
  17. ملخص كتاب كيف تبيع أيّ شي لأي إنسان؟
    ملخص كتاب كيف تبيع أيّ شي لأي إنسان؟جو جيرارد
    3.7
  18. ضربة البداية: أساسيات ريادة الأعمال
    ضربة البداية: أساسيات ريادة الأعمالمحمد محرم, محمد أبو النجا
    2.3
  19. ملخص كتاب المستثمر الذكي
    ملخص كتاب المستثمر الذكيبنيامين غراهام
    4.4
  20. ضربة البداية: أساسيات ريادة الأعمال
    ضربة البداية: أساسيات ريادة الأعمالمحمد محرم, محمد ابو النجا
    5
  21. The Mom Test: How to Talk to Customers & Learn if Your Business is a Good Idea When Everyone is Lying to You
    The Mom Test: How to Talk to Customers & Learn if Your Business is a Good Idea When Everyone is Lying to YouRob Fitzpatrick
    4.5
  22. أغنى رجل في بابل
    أغنى رجل في بابلجورج إس. كلاسون
    4.2
  23. The Charisma Myth: How Anyone Can Master the Art and Science of Personal Magnetism (Intl Ed)
    The Charisma Myth: How Anyone Can Master the Art and Science of Personal Magnetism (Intl Ed)Olivia Cabane
    4.2
  24. The Goal: A Process of Ongoing Improvement – 30th Aniversary Edition: A Process of Ongoing Improvement - 30th Aniversary Edition
    The Goal: A Process of Ongoing Improvement – 30th Aniversary Edition: A Process of Ongoing Improvement - 30th Aniversary EditionJeff Cox, Eliyahu M. Goldratt
    4.6
  25. MONEY Master the Game: 7 Simple Steps to Financial Freedom
    MONEY Master the Game: 7 Simple Steps to Financial FreedomTony Robbins
    4.4

ما مميزات اشتراك Storytel؟

  • أكثر من مليون كتاب

  • وضع الأطفال (بيئة آمنة للأطفال)

  • تنزيل الكتب للوصول إليها دون الاتصال بالإنترنت

  • الإلغاء في أي وقت

لوقت محدود فقط

شهري

قصص لكل المناسبات.

89 EGP /شهر

وفر 50%
  • حساب واحد

  • حساب بلا حدود

  • إلغاء في أي وقت

جرب الآن

سنوي

قصص لكل المناسبات.

708 EGP /سنة

وفر 33%
  • حساب واحد

  • حساب بلا حدود

  • إلغاء في أي وقت

جرب الآن

6 أشهر

قصص لكل المناسبات.

474 EGP /كل 6 أشهر

وفر 12%
  • حساب واحد

  • حساب بلا حدود

  • إلغاء في أي وقت

جرب الآن