About this Course
In this course, we’ll focus on the fundamentals of data management, maintenance reporting and auto generating Python, DAX, and Tableau code with SQL using ChatGPT. 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; using ChatGPT and other AI tools, you'll learn to auto-generate Python, DAX, and Tableau Database Language with Sql Code
- 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
- Best practices using AI to improve your database design and improve your query performance