Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
AI for Business Intelligence | Data Development with AI
Rating: 3.9 out of 5(11 ratings)
68 students

AI for Business Intelligence | Data Development with AI

Data Development solutions with AI | AI tools to enhance Data development and Data Productivity
Created byTyrone Dugmore
Last updated 3/2025
English
English [Auto],

What you'll learn

  • Define how AI tools help Data professionals
  • AI Prompt Engineering for Data, SQL and PowerBI
  • Business Intelligence Lifecycle and Boosting your productivity with AI
  • Using AI for Data Engineering
  • Using AI for Data Querying
  • Using AI for Reporting and Dashboards
  • Using AI to create diagrams

Course content

1 section • 19 lectures • 2h 16m total length

  • Introduction1:52

    Transform your data into strategic assets by applying ai-driven business intelligence and data development practices, including generating complex sql queries, defining requirements, and building testable data solutions.

  • Why This Course1:43

    Leverage AI in the business intelligence lifecycle to shape requirements, define data points, and build warehousing, visualization, and workflows with SQL Server, Visual Studio Code, Copilot, Power BI, and Mermaid.

  • Data and Business bridging the gap11:41

    Bridge data and business with AI for data development, prompt engineering, Copilot and Gemini code assist, and use cases for SQL and data warehouses to deliver insights.

  • Business Intelligence and Data Lifecycle6:42

    Define the business problem and requirements analysis, determine core measurements and data points, build data warehouses and visualizations, and apply generative ai for faster coding, synthetic data, and documentation.

  • What is AI Code assist for Data professionals12:17
  • Tooling for Data and Analytics3:10

    Explore essential tooling for data and analytics, including SQL Server, Visual Studio Code, Gemini, Copilot, Mermaid, Power BI, GitHub, and AI-assisted coding to build data warehouses and visualizations.

  • AI Prompt engineering Foundations6:34

    Explore prompt engineering foundations, using natural language to design prompts for AI tools like code assistants and SQL developers, with personas, goals, context, few-shot and zero-shot ideas, and output formats.

  • Github Co-Pilot Activation for VS Code4:39

    Sign up for GitHub, install and activate Copilot in Visual Studio Code, upgrade to Pro, and test code completions and Copilot chat with a SQL example.

  • Gemini Code Assist Activation for VS Code3:41

    Activate Gemini code assist for VS Code and install both Gemini code assist and GitHub Copilot to enable AI-assisted development for business intelligence and data intelligence practices.

  • Use Cases for AI in Data Development & Requirements12:40

    Explore AI-driven use cases in data development and requirements gathering within a CRM scenario and the AdventureWorks database, including Gemini prompts and KPI-driven reporting.

  • Use Cases for AI in Data Development - Explain Code using AI10:40

    Discover how to use AI tools like Gemini code assist and GitHub Copilot to explain and document SQL code and ETL processes for analysts and data developers.

  • Use Cases for AI in Data Development - SQL Code with AI15:00
  • Use Cases for AI in Data Development - SQL Code Part 27:18

    Learn to build kpi measures and aggregates from a stored procedure using the all customer sales table, generating total sales revenue and average transaction value by product.

  • Use Cases for AI in Data Development - SQL Code Part 33:39

    Explore data warehousing concepts with Kimball and Inmon models, and learn to draft SQL prompts for a Kimball data warehouse, including daily updated fact sales and product dimension procedures.

  • Use Cases for AI in Data Development - Testing SQL with AI8:13

    discover how ai tools test sql code and data quality, generating robust test scripts for code checks, data validations (nulls, duplicates, totals), and business sign-off templates for data readiness.

  • Use Cases for AI in Data Development - Insights and Analysis with AI6:06

    Explore how AI generates recommendations, queries, and code from your data, delivering summaries and business context. Learn to operationalize insights, targeting high value customers with VIP programs and actionable steps.

  • Use Cases for AI - Reporting, Dashboards and Visualisations with AI11:34

    Leverage AI and Copilot with Power BI to enhance dashboards, build KPI cards and visuals, and craft executive narratives for data-driven reporting.

  • Use Cases for AI in Data Development - Diagrams for Data with AI7:57

    Explore how AI tools like mermaid, copilot, and Gemini code assist create ER diagrams, UML, mind maps, and Gantt charts to visualize data development and the BI life cycle.

  • Conclusion1:07

    Explore how Gemini and GitHub Copilot support day-to-day business intelligence tasks, including reporting and data insights, while complementing your skills to make money, save money, and serve customers better.

Requirements

  • Basic Database and Reporting knowledge required, you can learn as you go along!

Description

This comprehensive training pack equips data professionals with the skills to leverage AI for enhanced business intelligence and data development solutions.

Learn how to bridge the gap between data and business needs, understand the data lifecycle within a BI context, and master AI-powered code assistance tools like GitHub Copilot and Google Gemini Code Assist.

Increase your efficiency, improve code quality, and deliver data-driven insights faster with the power of AI. Includes hands-on exercises and real-world examples.

This course covers:

  • Data and Business bridging the gap

  • Business Intelligence and Data Lifecycle

  • What is AI Code assist for Data professionals

  • Tooling for Data and Analytics

  • Prompt engineering Foundations

  • Co-Pilot & Gemini Code Assist usage

  • Use Cases for AI in Data Development

    • Requirements

    • Explain

    • Document

    • Build

    • Test

    • Insights and Analysis

    • Diagramming your Solutions

What you will learn :

  • Prompt engineering foundations

  • Responsible AI practices

  • Practical use cases for AI in data development (including requirements gathering, code generation, testing, analysis, and visualization),

  • Integration with tools like SQL Server, Visual Studio Code, and Power BI.

Through real-world examples and practical exercises, you'll discover how to:

  • Accelerate code completion and reduce debugging time.

  • Generate synthetic data for robust testing and development.

  • Automate documentation and improve code understanding.

  • Translate code between languages (e.g., SAS to SQL, Python).

  • Extract valuable insights and formulate business recommendations.

  • Develop data warehouse solutions using the Kimball methodology.

  • Create impactful Power BI dashboards and reports.

  • Design clear and informative diagrams for solution documentation.


Who this course is for:

  • Beginner to Intermediate Data Analysts, Data engineers and Data professionals. Data curious people will benefit from the content.

Report abuse