Classroom
1 day625,-
excl. VAT
- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
With Power BI and AI you take your dashboards to a higher level. In one day you work with Q&A, Auto-Insights, Decomposition Tree, Smart Narrative and Copilot in Power BI. Practical, on your own dataset, with results you can apply immediately.
Description
Power BI is full of AI features that you may barely be using yet. The Q&A visual lets users ask questions in plain language, Key Influencers tells you which factors drive your metric, and Smart Narrative automatically writes a summary of your dashboard. You will learn how to configure these components so that they actually provide reliable answers.
In the morning you work with the existing AI visuals and the AI functions in Power Query, such as sentiment analysis, key phrases and language detection. You practise with synonyms and linguistic models for Q&A, with Auto-Insights to spot trends and with the Decomposition Tree for drill-down without a fixed hierarchy.
The afternoon session is devoted entirely to Copilot in Power BI. You will discover which licence you need, how to generate a report from a natural-language prompt and how to have DAX formulas written for you with an explanation included. We also discuss the data governance side: what Copilot does and does not see, and where the pitfalls lie.
You work practically in your own Power BI environment on a realistic dataset all day. Copilot in Power BI requires Premium capacity (F64 or higher) or a Fabric licence. We make these available during the course, so you do not need a Premium licence of your own to take part.
Topics
- Configuring the Q&A visual with synonyms, suggestions and linguistic models
- Auto-Insights: discovering hidden patterns and trends in your data
- Key Influencers visual: which factors have the strongest impact on your metric
- Decomposition Tree: drill down without a predefined hierarchy
- Smart Narrative: having your dashboard summarised automatically in text
- AI features in Power Query: sentiment analysis, key phrases and language detection
- Copilot in Power BI: licence requirements, possibilities and limitations
- Generating a report from a natural-language prompt
- Having Copilot write and explain DAX formulas
- Visualisation suggestions based on your question
- Data governance: what Copilot can and cannot see
- Building your own AI-powered dashboard on a realistic dataset
Result
Afterwards you will know how to use the AI features in Power BI to make your dashboards smarter and more interactive. You will recognise where AI saves you time and where you should remain critical of the output.
Specifically, by the end you will be able to:
- Configuring the Q&A visual with synonyms and linguistic models
- Using Auto-Insights and Key Influencers to extract insights from your data
- Building a Decomposition Tree for flexible drill-down
- Using Smart Narrative to have your dashboard explain itself automatically
- Applying AI functions in Power Query for text analysis and language detection
- Generating a report with Copilot from a natural language prompt
- Having Copilot write and explain DAX formulas
- Assessing the licensing requirements and governance aspects of Copilot in Power BI
- Setting up your own AI-powered dashboard on a realistic dataset
Target audience
This course is intended for Power BI users and developers who want to make their dashboards more interactive and intelligent with AI. You already work with Power BI Pro or Premium and now want to take a further step.
The course is intended for:
- Data analysts who want to get more insight from their data
- BI developers who want to integrate AI visuals and Copilot into their reports
- Business controllers who want to build smarter dashboards themselves
- Power BI developers who want to learn to work with natural-language prompts
- Report builders who want to make use of the latest AI capabilities in Power BI
Teaching method
You work practically in your own Power BI environment all day. After a short explanation you get straight to work yourself with a realistic dataset. In this way you build up a complete AI-powered dashboard step by step, from the first data import to a demonstrable solution.
You spend the morning on the existing AI functions such as Q&A, Auto-Insights, Key Influencers, Decomposition Tree and Smart Narrative. In the afternoon you dive into Copilot in Power BI: you learn how to generate reports with natural language prompts and have DAX formulas written for you. You can bring your own dataset or work with our sample.
The group consists of no more than 8 participants, so there is plenty of room for your questions and your own case. You can choose between classroom and online. You will take home a workbook with a step-by-step plan, a reference dashboard with all AI features and a prompt cheat sheet for Copilot.
Prior knowledge
You have basic Power BI skills and already work with dashboards. You understand the difference between Power Query, the data model and the report, and you have built a report yourself. Our Power BI Basics course or comparable practical experience is good preparation.
Comments
The Copilot module requires a Premium capacity (F64 or higher) or a Fabric licence. We make these available in our environment during the course, so you do not need a licence of your own.
In-company
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
Language
The training is given in Dutch as standard. The trainer has a good command of English. English-language course material can be used. With a minimum enrolment of 3 participants, the training can also be given entirely in English.
