Course
AI For Data Analytics and BI
45 hours 46 minutes
Credits: 3 Credits
Description
In this course, learners will develop practical skills at the intersection of artificial intelligence, prompt engineering, and data analytics – progressing from foundational AI concepts through to advanced Power BI implementation and AI-assisted data visualisation. Learners will explore generative AI, GPT models, machine learning, deep learning, and neural networks, and develop structured prompt engineering skills for both general and data-specific applications. They will apply AI capabilities within Power BI including machine learning model training, AI-powered visuals, smart narratives, and Copilot integration. Learners will also build and refine data visualisations using D3.js and generative AI, and develop comprehensive Power BI skills covering data loading, modelling, advanced visualisations, Power Query, the Power BI Service, dashboards, paginated reports, and mobile app usage.
What Students Will Learn
- Generative AI, Prompting and Ethics Awareness (Beginner)
- An Introduction to Generative AI
- An Introduction to GPT Models
- Artificial Intelligence and Machine Learning
- Deep Learning and Neural Networks
- Getting Started with Prompt Engineering
- Exploring Prompt Engineering Techniques
- Case Studies in Prompt Engineering
- Considerations for Using AI Responsibly
- AI in Power BI Competency (Intermediate Level)
- Leveraging AI Insights & Text Analytics in Power BI
- Training Machine Learning Models in Power BI
- AI-powered Visuals in Power BI
- Smart Narratives, Q&A Visuals, & Copilot in Power BI
- Prompt Engineering for Data: Leveraging Prompts When Working with Data
- Prompt Engineering for Data: Basic Data Manipulation Using Generative AI
- Prompt Engineering for Data: Leveraging Prompts for Filtering & Grouping Data
- Prompt Engineering for Data: Combining & Visualizing Data Using Generative AI
- Prompt Engineering for Data Science Literacy (Beginner Level)
- Build a D3.js Visualization with Generative AI
- Data Visualization Lab: Visualize the Central Park Squirrel Census with D3.js and Generative AI Part 1
- Troubleshoot and Refine Generative AI Data Visualization
- Data Visualization Lab: Visualize the Central Park Squirrel Census with D3.js and Generative AI Part 2
- Data Loading & Visualization in Power BI: Getting Started
- Data Loading & Visualization in Power BI: Loading Data from Databases
- Data Loading & Visualization in Power BI: Loading Data from Cloud Storage
- Data Loading & Visualization in Power BI: Data Modeling
- Data Loading & Visualization in Power BI: Advanced Visualizations
- Final Exam: From Data Loading to Stunning Visualization
- Getting Started with Power Query in Power BI
- Performing Joins Using Merge Queries in Power BI
- Getting Started with the Power BI Service
- Working with Scorecards, Dashboards, & Paginated Reports in Power BI
- Using the Power BI Mobile App
- Final Exam: Mastering Power BI Service and Power Query
- Data Analytics & Visualization All-in-One For Dummies
- Big Data and Analytics: The Key Concepts and Practical Applications of Big Data Analytics
Overall Learning Outcomes
- Explain core generative AI concepts including GPT models, machine learning, deep learning, and neural networks
- Apply prompt engineering techniques and patterns to design effective prompts for general and data-specific tasks
- Evaluate the ethical considerations and responsible use principles associated with generative AI
- Leverage AI features in Power BI including AI insights, text analytics, machine learning model training, and AI-powered visuals
- Use smart narratives, Q&A visuals, and Copilot in Power BI to enhance data storytelling and exploration
- Build and refine interactive data visualisations using D3.js with generative AI assistance
- Load and transform data in Power BI from databases and cloud storage using Power Query and merge operations
- Design and implement data models and advanced visualisations in Power BI
- Publish, share, and manage content using the Power BI Service including scorecards, dashboards, and paginated reports
- Access and interact with Power BI content using the Power BI mobile app