Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Power BI Essentials
Rating: 4.6 out of 5(39 ratings)
80 students

Microsoft Power BI Essentials

Unlock the full potential of Power BI and transform your data into actionable insights for informed decision-making.
Created bySimon Sez IT
Last updated 3/2024
English
English [Auto],

What you'll learn

  • Transform raw data into meaningful insights using Power BI.
  • Create calculated measures to analyze data effectively.
  • Establish relationships and data models for optimized organization.
  • Design visually appealing data visualizations using various formatting techniques.
  • Utilize filters and slicers to focus on specific data subsets.
  • Publish Power BI reports from desktop to web for collaborative access.
  • Utilize the "Ask Questions" function for interactive data querying.
  • Share Power BI reports online through the Publish to Web feature.

Course content

8 sections • 24 lectures • 1h 33m total length

  • Course Welcome0:50

    Discover what Power BI is, what it can do, and how to get started; transform and shape data with Power Query, connect to Power BI, and create visuals.

  • WATCH ME: Essential Information for a Successful Training Experience2:03

    Watch this video for information to maximize your Power BI essentials training, including downloadable exercise files, how to unzip and open them, and how to adjust playback quality and speed.

  • DOWNLOAD ME: Course Files0:23
  • Intro to PowerBI3:12

    Explore Power BI to connect to diverse data sources, clean and model data, and publish interactive visualizations, dashboards, and reports for real-time collaboration and insights.

  • Transforming Data6:22

    Connect to data sources in Power BI, import an Excel file, transform data in Power Query Editor, rename columns, adjust data types, and load, close and apply into table view.

  • PowerBI Interface Overview2:47

    Explore the Power BI interface by switching between table view, report view, and model view; learn to import data, transform it, and build data models with visualizations across linked tables.

  • Adding More Data6:53

    bring in data from text and excel files, transform and merge columns with power query, and ready invoice and customer data for power bi analysis.

  • Transforming Again2:10

    Transforming again demonstrates changing a date column directly in Power BI using column tools, without going back to Power Query, noting potential data loss and the option to refresh.

  • Importing Web Data into PowerBI6:04

    Import web tables into Power BI, transform data with Power Query, set first row as headers, and load into Power BI to build a data model from web sources.

  • Section Quiz

Requirements

  • Basic knowledge of Microsoft Excel is helpful.
  • Power BI Desktop installed on your machine is required to take the practice exercises.

Description

**This course includes downloadable course demo files to work with and follow along.


Welcome to the Microsoft Power BI Essentials course. Throughout this course, you'll gain a comprehensive understanding of Power BI and its essential features, empowering you to analyze and visualize data for informed decision-making effectively.


You'll start by familiarizing yourself with Power BI's interface and learn how to transform and import data from various sources. As you progress, you'll delve into creating calculations such as measures and calculated columns to derive meaningful insights from your data.


Next, you'll explore data modeling techniques, including establishing relationships and data models to optimize data organization and analysis. You'll then learn to create visually appealing and informative data visualizations, including text boxes, date visualizations, and formatting.


As we go further, you'll discover how to filter and slice data to focus on specific insights, enhancing the clarity and relevance of your visualizations. You'll also master publishing your Power BI reports and dashboards from the desktop to the web, allowing seamless collaboration and accessibility.


Finally, you'll learn how to utilize the "Ask Questions" function to interactively query your data and publish your reports to the web for broader dissemination.


By the end of the course, you should possess the skills necessary to leverage Power BI effectively, enabling you to drive data-driven decisions and enhance your analytical capabilities in various professional settings.


In this course, you will learn how to:

  • Transform raw data into meaningful insights using Power BI.

  • Create calculated measures to analyze data effectively.

  • Establish relationships and data models for optimized organization.

  • Design visually appealing data visualizations using various formatting techniques.

  • Utilize filters and slicers to focus on specific data subsets.

  • Publish Power BI reports from desktop to web for collaborative access.

  • Utilize the "Ask Questions" function for interactive data querying.

  • Share Power BI reports online through the Publish to Web feature.


This course includes:

  1. 1+ hours of video tutorials

  2. 22 individual video lectures

  3. Course files to follow along

  4. Certificate of completion

Who this course is for:

  • Business analysts and data analysts
  • Users new to Power BI and and want to improve their skills.
  • Those who want to use Power BI for data visualization and analysis.

Report abuse