About this Course
In this course, we’ll focus on the fundamentals of data management, maintenance and reporting. The course will begin with an introduction of modern data visualization tools like Power BI, Tableau and Jupyter Notebook. 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
- Introduction to modern data visualization tools like Power BI, Tableau and Jupyter Notebook
- Best practices and tools for performance monitoring and performance tuning (indexing, column stores, distribution)
- How to consume data from GitHub, move into Azure SQL Server, Azure Data Factory, and integrate into data visualization tools
- Backup and restore scenarios and security strategies
- Tips for using the on-premises Power BI Report Server and Power BI cloud services
- How to create administrative reports and dashboards
- Introduction to modern visualization languages like DAX and Python