If you’re looking to upgrade your business analytics tool but feel uneasy about learning a complicated new data platform, Power BI by Microsoft may be just the thing for you. 

What I like about Power BI:

  • Easy-to-use reporting tool that allows you to perform analytics functions and create insightful reports
  • Good performance with accurate measures 
  • Faster than Excel
  • More capacity to view vast amounts of data
  • Ability to compress large files of data and only use 50 Mb while doing it
  • Ability to upload data from a variety of sources to visualize data trends, create themes, metrics and dimensions, edit queries and upload to the cloud
  • Uploading to the cloud creates an easy sharing of dashboards 

In this article, I’ll show you how to import data, conduct queries and edits, and create visualizations.

Importing Data

Importing your data is as simple as clicking  “Get Data” and selecting your source. You have the option to import data from Excel, Txt/CSV, Odata, the web, and a few others. 

Want to pull data from the internet? It’s not as complicated as you might think. Select “Other” and then the “Web” option. After you select “Get Data” and “Web”, copy and paste the website link into the window that will appear.

From there you will have the option to load or edit the data. Editing the data is always the easiest and recommended option.

Queries

Editing queries means you can filter through your data and delete any columns you may not need or fix any import errors. To delete columns, select which columns you would like to remove and hit the “Remove Columns” tab.

You may edit your numbers if you want to convert your them into currency, decimals or date. Do this under “Edit Queries.” 

When you finish editing your data, close and apply these changes to your dashboard.

With your data prepared, you can now begin creating relationships, DAX formulas, and visualizations.

DAX Formulas

DAX Formulas are similar to excel formulas. You can multiply, divide and calculate from within your columns. Simply right-click on one of the column names under your fields tab and select “new measure”. In the toolbar that will appear you can name and create formulas that you desire. A calculator icon will appear in the fields toolbar where your measure has been created. If you are not familiar with DAX I highly recommend taking an online course on DAX language to familiarize yourself!

After you create your formulas you can click and drag these measures into your dashboard. There are a variety of dashboards ranging from bar charts, line charts, slicers, hierarchy slicers, tables, calendars, maps and many more. This enables you to create any kind of visualization that meets your needs.

Visualizations

Click and drag data fields into your metrics and dimensions tabs by values under the visualizations. Here you can mix and match measures to formulate your visualizations. Take it two steps further and add drill-downs and filters to your data after you select your metrics and dimensions. See the example of creating a table below: 

PowerBI gives you the capabilities to present up-to-date and easy-to-read dashboards that you can personalize for any client or stakeholder. It’s a fast and effective tool that will save you some serious headaches and efficiently manage your data in the process.

Message Sent

Thank you for registering.

Cardinal Path hosted a live session to connect with you and answer all your questions on Google Analytics.
Get all the expertise and none of the consultancy fees in this not-to-be-missed, rapid-fire virtual event.

Thank you for submitting the form.

Thank you for submitting the form.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you.

Click here to download access the tool.

Message Sent

Thank you for registering.

Message Sent

Thank you.

Message Sent

Thank you.

Message Sent

Thank you

Message Sent

Thank you

Message Sent

Thank you.

Message Sent

Thank you

Message Sent

Thank you.

Message Sent

Success!
Your message was received.

Thank you.

Thank you for registering.

Cardinal Path is continuing with its series of free training. Next we are conducting training on Google Data Studio. Check it out here.

Message Sent

Thank you for registering.

Thank you for your submission.

Your request has been submitted and a rep will reach out to you shortly.

Message Sent

Thank you for your interest.

Thank you for registering.

You should receive a confirmation email from GoToWebinar with your unique webinar login information. If you do not receive this email or have trouble logging in to the event, please email asmaa.mourad@cardinalpath.com.

Thank you for subscribing!

You're now looped into the world's largest GMP resource hub!

Thank you for your submission.

Thank you for your submission.

Thank you for your submission.

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for your submission.

Thank you for your submission.

Message Sent

Thank you for registering.

Thank you for registering.​

Paid media spend by Government websites increased a whopping 139% YoY in 2020.

2020 Online Behavior Live Dashboard

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

2020 Online Behavior Live Dashboard

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Success! Thank you
for reaching out.