September 4, 2020

Power BI Desktop Data Analysis Visualizations

How to use Power BI to perform data analysis and create data visualizations like dashboards quickly and easily. Watch the video below:

Power BI Desktop Data Analysis and Visualizations

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.

Get Data Using Power Bi Desktop

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.

Enrich Data with Visualizations in 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.

Design Reports Using Themes

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.

Mobile-Optimized reports for Viewers on the Go

Further Reading

Power BI Desktop

One thought on “Power BI Desktop Data Analysis Visualizations

  1. Hi Dinesh

    I am need code to copy all workbooks containing “*Template*2020.xlsm*” from folder and sub-folder “\\account\man\” to “C:\Sales Reports\”

    I cannot get it to work

    It would be appreciated if you could amend my code

    Sub sbCopyingAFile()
    ‘Declare Variables
    Dim FSO
    Dim sFile As String
    Dim sSFolder As String
    Dim sDFolder As String
    Dim SbFld As Object
    Dim FileObject As Object
    ‘This is Your File Name which you want to Copy
    sFile = “*Template*2020.xlsm*”
    ‘Change to match the source folder path
    sSFolder = “\\account\man\”
    ‘Change to match the destination folder path
    sDFolder = “C:\Sales Reports\”
    ‘Create Object
    Set FSO = CreateObject(“Scripting.FileSystemObject”)

    For Each SbFld In FSO.GetFolder(sSFolder).SubFolders ‘loop through subfolders
    For Each FileObject In FSO.GetFolder(SbFld).Files ‘loop through files in each subfolder
    If FileObject.Name Like sFile Then
    ‘Copying If the Same File is Not Located in the Destination Folder
    If Not FSO.FileExists(sDFolder & FileObject.Name) Then
    FSO.CopyFile (FileObject.Path), sDFolder & FileObject.Name, True
    MsgBox “Specified File Copied Successfully”, vbInformation, “Done!”
    MsgBox “Specified File Already Exists In The Destination Folder”, vbExclamation, “File Already Exists”
    End If
    End If
    Next FileObject
    Next SbFld
    End Sub

Comments are closed.