Enter your email to track your progress and stay up-to-date on new Power BI learning content.
By clicking Track progress, you are giving your consent to Microsoft to provide you updates about Power BI learning resources via email. You can unsubscribe at any time.
As you progress through Guided Learning, a green checkmark will appear next to your completed topics.
With an introduction complete, get ready to dive deep!
Welcome to the second section in this Guided Learning course for Power BI, called Getting Data. This section looks at the many data-centric features and tools of Power BI, focusing on Power BI Desktop. Many of these tools also apply to the Power BI service, so you're doing double duty with your learning in this section.
When you get data, sometimes it's not quite as well-formed, or clean, as you want it to be. So in this section you learn how to get data, how to clean it up (sometimes called cleaning or transforming data), and also learn some advanced tricks that can make your data-getting life easier.
As always in this course, your learning journey follows the same path as the flow of work in Power BI. As such, let's check out Power BI Desktop, where it often begins.
Power BI Desktop is a tool to connect to, clean, and visualize your data. With Power BI Desktop, you can connect to data and then model and visualize it in different ways. Most users who are working on Business Intelligence projects will spend the majority of their time using Power BI Desktop.
You can download Power BI Desktop from the web, or from the Power BI service. Just select the down arrow button in the upper right side of Power BI, then select Power BI Desktop.
Power BI Desktop installs as an application on your Windows computer.
So once you download it, you'll install Power BI Desktop and run it like other applications on Windows. The following image shows the Start Screen of Power BI Desktop, which appears when you start the application.
Power BI Desktop connects to a wide variety of data sources, from local on-premises databases to Excel worksheets to cloud services. It helps you clean and format your data to make it more usable, including splitting and renaming columns, changing data types, and working with dates. You can also create relationships between columns so that it's easier to model and analyze your data.