How to use Power BI to perform data analysis and create data visualizations like dashboards quickly and easily. Watch the video below:
What is Power BI Desktop?
Power BI Desktop is a free application for PCs that lets us gather, transform, and visualize our data. Today we’ll learn how to find and collect data from different sources and how to clean, edit or transform it.
Power BI Desktop and the Power BI Service work together. We can create our reports and dashboards in Power BI Desktop, and then publish them to the Power BI Service for others to use or collaborate.
Connect to hundreds of data sources , wherever it is
We can access data from hundreds of supported on-premises and cloud-based sources, such as Excel, MySQL, MS Access, Salesforce, Azure SQL DB, and SharePoint. We can update the data with a ‘refresh’, We can develop a broad range of scenarios that provide actionable insights for our work or business.
Preparing and modelling our data:
Power BI saves time by making data preparation and data modeling easier with Power Query and modeling tools. Most Excel users are familiar with the Power Query Tool. We can easily use, clean, integrate and enrich data with visualizations using Power BI.
Power BI can provide advanced analytics with the familiarity of MS Office: We can dig deeper into our data using features like quick measures, merging, appending, grouping, forecasting and clustering and get actionable insights for our business. Advanced users can use the power of the DAX (Data Analysis Expressions) formula language to get full control over the data model.
We can deepen our data insights with AI-driven augmented analytics:
Power BI provides new AI capabilities which require no coding.
We can create stunning reports with interactive data visualizations with Power BI. We can design our report with theming, formatting, and layout tools.
We can author for everyone, anywhere using Power BI in combination with Power BI Services:
We can share our visual analytics with the people who need it. We can also create mobile-optimized reports for viewers to use on the go. As shown in the video above, we can publish from Power BI Desktop to the cloud. We can embed reports created in Power BI Desktop into existing apps or websites quickly and easily.