Loading...
Preparing content for you
Preparing content for you
Data is one of the most valuable resources for modern organisations. In this program, you will learn how to collect, clean, analyse, and visualise data using modern analytics tools enhanced with AI ca...
Duration
Instructor-Led
Lectures
5 Modules
Level
All Levels
Data is one of the most valuable resources for modern organisations. In this program, you will learn how to collect, clean, analyse, and visualise data using modern analytics tools enhanced with AI capabilities. Through practical exercises and projects, you will learn how to interpret data, create dashboards, and generate insights that support strategic business decisions.
No specific prerequisites. Just a passion to learn!
What data really is and how businesses generate data, Types of data and common data sources, What Big Data means and the 5Vs of Big Data, Types of data analytics and real-world use cases, Difference between Data Analysis vs Data Analytics, Career paths in Data Analytics and why the skill is in high demand, Introduction to Generative AI for data analytics:, LLMs, RAG, AI agents, Risks, limitations, and responsible use of AI in analytics, Prompt engineering basics for analytics workflows
Excel interface and environment, Cell referencing:, Relative, Absolute, Mixed, Structured referencing, AI-assisted data cleaning using Excel formulas, Core Excel functions for analysis:, Aggregates, IF, nested IF, Lookup functions, Pivot tables and Excel dashboards, Using AI to turn numbers into insights, Storytelling frameworks for business decisions
Why Power BI is used instead of Excel at scale, Power BI architecture and workflow, Connecting different data sources, Power Query Editor for data transformation, Introduction to DAX, Building dashboards with Copilot, Using AI to explain dashboards and insights, Business storytelling with dashboards