About this Course
In this course, we’ll focus on the fundamentals of data management, maintenance and reporting. You’ll learn how to manage and improve data access and transaction performance and how to maintain your data using proven security, backup and distribution strategies. We’ll also cover how to monitor your data and metadata using dashboards and KPI reporting.
WHAT YOU’LL LEARN
- Best practices and tools for performance monitoring and performance tuning (indexing, column stores, distribution)
- Backup and restore scenarios
- Tips for using the on-premises Power BI Report Server and Power BI cloud services
- Security strategies
- How to create administrative reports and dashboards