Tuesday 7 March 2017

Excel Power BI - Getting Data Part 4/10

Getting Data
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.
An Overview of Power BI Desktop
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.






No comments:

Post a Comment