In this lesson, you will learn how to manage credentials on your data sources. You can also set privacy levels or turn off the privacy levels. You will understand different privacy levels and when to use what.
In this lesson, you will learn how to share queries across different workbooks.
In this lesson, you will learn some tricks about keeping your queries understandable and reusable.
In this lesson, you will learn some tricks to manage changing columns. You will learn how to handle two scenarios -(1) Additional columns not required in the data model appear in the data and (2) A column in the data model goes missing in the data.
In this lesson, you will learn the concept of Query Folding that enables you to push back complex data processing to the SQL Server, without having to write any SQL code. The Native Query code is produced at every query step.
Excelerator BI | © 2023 | Sitemap