Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analysis in Power BI with ChatGPT and Microsoft Copilot
Rating: 4.4 out of 5(3,190 ratings)
10,938 students

Data Analysis in Power BI with ChatGPT and Microsoft Copilot

Leverage the power of artificial intelligence for Power BI and maximize your data query and report-building skills
Created by365 Careers, Dimitar Shutev
Last updated 9/2024
English
German [Auto],English [Auto],

What you'll learn

  • Build a Power BI report from scratch
  • Facilitate ChatGPT prompts for data analysis
  • Filter using DAX expressions
  • Create data visualizations in Power BI using ChatGPT
  • Format your dashboard effectively using AI
  • Utilize the Power of Microsoft Copilot to write better DAX expressions
  • Compare ChatGPT vs Copilot for Business Intelligence

Course content

1 section • 23 lectures • 1h 26m total length

  • Introduction to the Course2:06

    Explore data analysis in Power BI with ChatGPT by building a complete report from scratch in under an hour, using DAX, data questions, and visual formatting for accessible insights.

  • Download Power BI2:18

    Install Power BI with guided setup, selecting 64-bit or 32-bit and optionally the Microsoft Store, then verify it runs. Download the 'Student Turnover Report' base file for the course.

  • Describing Data2:08

    Describe the purchases table to ChatGPT in Power BI and ask about revenue versus refunds by month, churn rate, and month-over-month impact.

  • Querying ChatGPT2:41

    Select the purchases table and create a calculated DAX column to separate refunds by the refund date, with ChatGPT translating the logic into usable code.

  • Building Your First Chart4:19

    Build a Power BI chart showing monthly net revenue and refunds using a purchase date axis, with ChatGPT-provided DAX formulas, and optimize the axis for chronological clarity.

  • Slicing Your Data2:59

    Learn how to slice data in power bi with slicers that filter by date range, keep filters in one place, and resize visuals for clear storytelling.

  • Formatting Your Chart2:45

    Collaborate with ChatGPT to generate matte color palettes and test hex codes for a revenue versus refunds chart in Power BI, then apply formatting and set the title.

  • Converting IDs into Dimensions4:29

    Convert id numbers into dimensions in Power BI by creating a subscription type column from the subscriptions table and mapping ids to annual, monthly, and lifetime using a calculated column.

  • Fixing Slicers2:15

    Map 0, 2, and 3 to lifetime, annual, and monthly with a switch-based DAX, then set cross filter direction to both so the students, purchases, and subscriptions tables respond to slicer.

  • Working with Canvas Size3:03

    optimize a Power BI report by adding data labels to a bar chart, renaming the y axis to price, and resizing the canvas to 1000 by 1280.

  • Churn Calculations5:34

    Learn to compute churn rate in power bi with chatgpt, designing churn count, total subscriptions, and churn rate measures from a subscriptions table, while handling state and date column limitations.

  • Formatting Your Second Chart5:15

    Format the churn rate as a percentage in Power BI, use DAX with ChatGPT guidance, and display a monthly line chart while configuring bidirectional cross-filtering across purchases, subscriptions, and students.

  • Formatting a Dashboard3:16

    Enhance a Power BI dashboard by styling the second chart with a dashed red line and labels; add a subscription type and country dropdown slicer, and set a report title.

  • Smart Narrative2:53

    Add a Smart Narrative visual to automatically describe your Power BI data. Adjust the canvas height, style the Key Findings block, and center chart titles before saving.

  • Microsoft Copilot Intro1:36

    Explore Microsoft Copilot, a freemium generative AI chatbot that integrates with Power BI, understands data models, writes DAX, and compares its prompts and performance with ChatGPT.

  • Analyzing Data using Microsoft Copilot4:05

    Explore how Microsoft Copilot aids data analysis in Power BI and guides DAX calculations. Develop net revenue and refunds measures and set up KPI visualizations for a clear dashboard.

  • Styling Card Visuals using Microsoft Copilot5:31

    Boost Power BI dashboards by styling card visuals with Copilot, applying navy background, white numbers, and currency formatting to three measures—net revenue, refunds, and total revenue—aligned in a single row.

  • Styling Card Visuals using Microsoft Copilot Part Two3:16

    Style card visuals in Power BI with Copilot by adjusting container sizes, displaying total revenue and refunds in dollars, selecting standout colors, and aligning cards vertically for KPIs.

  • Create a Calendar Table using Microsoft Copilot5:13

    Create a calendar table in Power BI using Copilot, relate it to purchases, and fix blanks by stripping time from purchase dates with a calculated column.

  • Building Charts using Microsoft Copilot3:35

    build charts in power bi with copilot by comparing net revenue and refunds, establishing a date table relationship, and using stacked column charts for year and month views.

  • SWITCH function using Microsoft Copilot4:30

    Convert subscription type IDs to text using DAX switch function, with Copilot, enabling tile slicers and cross-filtered visuals in Power BI.

  • Calculate Churn Rate using Microsoft Copilot8:47

    Calculate churn rate in Power BI by building an active subscription column, creating total subscriptions and churn subscriptions measures, and analyzing monthly churn through a date table and cross-filtered data.

  • Dashboard Formatting with Microsoft Copilot4:13

    Format dashboards in Power BI by styling churn rate red, centering title, and adding a translucent background; rename the page and summarize with a narrative visual when Copilot is unavailable.

Requirements

  • Access to Power BI

Description

ChatGPT or Microsoft Copilot? Take this short deep dive into the world of AI assistants where we take you through real-life data scenarios. Using the power of AI we are going to solve data analyst challenges by asking natural language questions.

ChatGPT took the world by storm when it was first introduced and is quickly transforming the work landscape. This high-powered AI tool has immense business value and can be used by professionals in any industry with or without vast experience in the domain.

The Data Analysis in Power BI with ChatGPT course is designed to teach you how to leverage artificial intelligence in Power BI to analyze, query, and visualize data—even if you’re a complete BI beginner. Pairing ChatGPT with Power BI enhances user experience by making data analytics more accessible to beginners and non-technical professionals. This significantly reduces the learning curve associated with data analysis and business intelligence tools.

You receive personalized recommendations based on your experience and the data you’re working with, and actionable insights tailored to your needs.

Moreover, ChatGPT suggests relevant data visualizations for your dashboard or reports. ChatGPT offers many benefits for creating reports in Power BI. Such automation streamlines the workflow and enables much quicker task implementation as the AI model adapts its suggestions to your specific use case.

Effective data analysis with ChatGPT and integration in Power BI allows for more efficient decision-making and swift responses to market changes—giving you and your company a competitive edge.


Who this course is for:

  • Power BI beginners
  • Power BI advanced users
  • People interested in a career in business intelligence
  • Business organisations transitioning from other BI tools into Power BI

Report abuse