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, Jupyter Notebook, as well as to the DAX and SQL languages
- Best practices and tools for performance monitoring and performance tuning (indexing, column stores, distribution)
- How to consume API data from GitHub and integrate with Azure services (SQL Server, Data Factory, Synapse Analytics) and data visualization tools
- Strategies for using on-premise Power BI Report Server and Power BI cloud services