Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Hands-On SQL Server 2019 Analysis Services

You're reading from  Hands-On SQL Server 2019 Analysis Services

Product type Book
Published in Oct 2020
Publisher Packt
ISBN-13 9781800204768
Pages 474 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Steve Hughes Steve Hughes
Profile icon Steve Hughes
LinkedIn
Steve Hughes is a senior director of data and analytics at 3Cloud. In this role, he focuses on growing the teams' skills and capabilities to deliver data projects with Azure. In his 20 years of experience in technology, much of the time was spent on creating business intelligence (BI) solutions and helping customers implement BI and cloud solutions. He is passionate about helping customers understand that data is valuable and profitable. Steve has recently been diagnosed with ALS but continues to work and share with others what he has learned. Steve is also the founder of Data on Wheels where he blogs with one of his daughters on topics such as data, analytics, and work enablement
Read more
See other products by Steve Hughes
Toc

Table of Contents (19) Chapters close

Preface 1. Section 1: Choosing Your Model
2. Chapter 1: Analysis Services in SQL Server 2019 3. Chapter 2: Choosing the SQL Server 2019 Analytic Model for Your BI Needs 4. Section 2: Building and Deploying a Multidimensional Model
5. Chapter 3: Preparing Your Data for Multidimensional Models 6. Chapter 4: Building a Multidimensional Cube in SSAS 2019 7. Chapter 5: Adding Measures and Calculations with MDX 8. Section 3: Building and Deploying Tabular Models
9. Chapter 6: Preparing Your Data for Tabular Models 10. Chapter 7: Building a Tabular Model in SSAS 2019 11. Chapter 8: Adding Measures and Calculations with DAX 12. Section 4: Exposing Insights while Visualizing Data from Your Models
13. Chapter 9: Exploring and Visualizing Your Data with Excel 14. Chapter 10: Creating Interactive Reports and Enhancing Your Models in Power BI 15. Section 5: Security, Administration, and Managing Your Models
16. Chapter 11: Securing Your SSAS Models 17. Chapter 12: Common Administration and Maintenance Tasks 18. Other Books You May Enjoy

Deploying your Power BI report to a Power BI workspace

A Power BI report can be deployed to the Power BI service online or to Power BI Report Server, which runs in SQL Server Reporting Services (SSRS). In this section, we will look at deploying the report to the service, which is the most common and recommended approach.

Power BI Report Server

Power BI Report Server is the on-premises deployment option for Power BI reports. However, it requires specific licensing with SSRS or Power BI Premium. This option allows customers who still have concerns about the cloud an option to deploy locally. Be aware that a different Power BI Desktop application is required because Power BI Report Server does not keep pace with its online peer. Some of the functionality we have demonstrated in this chapter may not be compatible depending on your current version of Report Server. We will not be discussing this option due to these restrictions.

We have been working in Power BI Desktop, which...

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 6 of 7
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $15.99/month. Cancel anytime

Authors (1)

Left arrow icon
Profile icon Steve Hughes
LinkedIn
Steve Hughes is a senior director of data and analytics at 3Cloud. In this role, he focuses on growing the teams' skills and capabilities to deliver data projects with Azure. In his 20 years of experience in technology, much of the time was spent on creating business intelligence (BI) solutions and helping customers implement BI and cloud solutions. He is passionate about helping customers understand that data is valuable and profitable. Steve has recently been diagnosed with ALS but continues to work and share with others what he has learned. Steve is also the founder of Data on Wheels where he blogs with one of his daughters on topics such as data, analytics, and work enablement
Read more
See other products by Steve Hughes
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook
Read more
Read more
Jan 2017 12 hours 24 minutes
Hands-On Business Intelligence with DAX
Hands-On Business Intelligence with DAX
Read more
This book follows a step-by-step explanation of essential concepts, practical examples, and self-assessment questions. You will begin by learning the basics of DAX, along with important concepts such as evaluation contexts and data modeling, before moving on to more advanced topics such as query optimization.
Read more
Jan 2020 13 hours 24 minutes
SQL Server 2017 Integration Services Cookbook
SQL Server 2017 Integration Services Cookbook
Read more
SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of this book, you’ll gain complete hands-on experience of SSIS 2017’s new features, and design and development improvements including SCD, Profiling, Tuning, and Customizations.
Read more
Jun 2017 18 hours 36 minutes
Expert Data Modeling with Power BI
Expert Data Modeling with Power BI
Read more
This book shows you how to effectively use Power BI, covering everything from Fact tables and Dimension tables to different data modeling techniques. With the help of real-world scenarios, you'll be able to identify when, why, and how to prepare data to support an efficient Star Schema to satisfy business requirements.
Read more
Jun 2021 20 hours 24 minutes
Microsoft Power BI Cookbook
Microsoft Power BI Cookbook
Read more
Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services.
Read more
Sep 2021 21 hours 52 minutes
Microsoft Power BI Cookbook
Microsoft Power BI Cookbook
Read more
Power BI is a business intelligence and analytics services by Microsoft designed to provide visual and interactive insights into data. With the help of technical examples, this book will help you explore Power BI tools and features and demonstrate the use of end-to-end solutions that integrate them to get more out of Power BI.
Read more
Sep 2017 26 hours 44 minutes
Learn Power Query
Learn Power Query
Read more
This book will effectively guide you through Power Query, starting with the shortcomings of other tools with regard to data analysis and management. You’ll then delve into the Power Query interface, understand how to connect, combine, and refine data with query tools, and finally create dashboards and multi-dimensional reports in Power Query.
Read more
Jul 2020 14 hours 16 minutes
Mastering Microsoft Power BI
Mastering Microsoft Power BI
Read more
This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various data sources, you will learn to perform effective visual analytics. By the end of this book, you will be able to gain unique, hidden insights into your data using Microsoft Power BI.
Read more
Mar 2018 21 hours 16 minutes
ETL with Azure Cookbook
ETL with Azure Cookbook
Read more
This book will take you through hand-on recipes for extracting, transforming, and loading data using big data tools and Azure services such as Data Factory and Azure Databricks. You will learn how to interact effectively with Azure services, along with covering automation with BIML and data profiling in Azure.
Read more
Sep 2020 14 hours 52 minutes
Introducing Microsoft SQL Server 2019
Introducing Microsoft SQL Server 2019
Read more
Introducing Microsoft SQL Server 2019 takes you through what’s new in SQL Server 2019 and why it matters. After reading this book, you’ll be well placed to explore exactly how you can make MIcrosoft SQL Server 2019 work best for you.
Read more
Apr 2020 16 hours 16 minutes
Microsoft Power BI Quick Start Guide
Microsoft Power BI Quick Start Guide
Read more
Microsoft Power BI Quick Start Guide, Second Edition gets you up to speed with Power BI quickly, enabling you to derive actionable insights from your data using the data visualization capabilities of Microsoft Power BI within a short span of time.
Read more
Oct 2020 9 hours 52 minutes
Microsoft Power BI Quick Start Guide
Microsoft Power BI Quick Start Guide
Read more
Microsoft Power BI is a cloud-based service that helps you easily visualize and share insights from your organization's data. This book will get you started with Business Intelligence using the Power BI tool, covering essential concepts like installation, building basic dashboards and visualizations to make your data come to life.
Read more
Jul 2018 6 hours 44 minutes
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Et al.
Et al.
Read more
Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.
Read more
Aug 2023 7 hours 40 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Mastering Tableau 2023
Mastering Tableau 2023
Read more
This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.
Read more
Aug 2023 22 hours 48 minutes
Building AI Applications with ChatGPT APIs
Building AI Applications with ChatGPT APIs
Read more
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Read more
Sep 2023 8 hours 36 minutes
Building AI Applications with ChatGPT APIs
Building AI Applications with ChatGPT APIs
Read more
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Read more
Sep 2023 8 hours 36 minutes
Data Engineering with AWS
Data Engineering with AWS
Read more
Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.
Read more
Oct 2023 21 hours 12 minutes
Modern Data Architecture on AWS
Modern Data Architecture on AWS
Read more
Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.
Read more
Aug 2023 14 hours 0 minutes
Practical Guide to Applied Conformal Prediction in Python
Practical Guide to Applied Conformal Prediction in Python
Read more
Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.
Read more
Dec 2023 8 hours 0 minutes
TinyML Cookbook
TinyML Cookbook
Read more
With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.
Read more
Nov 2023 22 hours 8 minutes
Right arrow icon