AI for Data Analysis: Excel, SQL, Python and Power BI

In this lesson, we will learn how to use AI in data analysis workflows. Excel formulas, SQL queries, Python pandas, Power BI DAX, KPI selection, dashboard planning, data cleaning and insight generation will be explained with practical examples. ## Lesson objective In this lesson, we will learn how to use AI in data analysis workflows. In the previous lesson, we looked at AI tools such as ChatGPT, Claude, Gemini and Microsoft Copilot. We explained which tools can be more suitable for writing, coding, document review, research, office workflow and data analysis.