Intro to Measures and Slicers

Check out Video #5 of Power BI Series and learn about DAX Measures and Slicers in Power BI Desktop.

This video covers:

  • How to create a Measure
  • Intro to Quick Measures and standard calculations
  • Intro to Slicers and Edit Interactions

If you are starting learning DAX I suggest:

  • Book:  Power Pivot and Power BI by Rob Collin & Avi Singh.  This was one of the first books I read about DAX.
  • Blog:  DAX Fridays  by Curbal.com . Ruth releases a video every Friday covering DAX functions (and more) and to date, the playlist counts with more than 80 videos.  Awesome work .

There are plenty of other sources (books, blogs, videos, etc), but these are my recommendations if you are new to DAX and Power BI and want to learn the basics.

Calculated Columns in Power BI Desktop

Check out Video #4 of Power BI Series and learn two easy ways how to create a calculated column in Power BI Desktop.

This video covers:

  • Create a Calculated Column in DAX
  • Create a Calculated Column in Power Query
  • Delete Calculated Columns differences and Errors

You can download the files here:
Link to GitHub

And access the online dashboard here

Load Multiple files and Append Query

In the 3rd video of the Power BI Series I show you how to load multiple files into Power BI using the Query Editor and to troubleshooting a Date type Error.

In this video we covered:

– How to load multiple excel files to Power BI
– How to use  Append Query to create a unique dataset
– Date error- Use locale
– Regional Settings

Keep tuned for the next video and learn How to Create Measures and Calculated Columns 

You can download the files here:

  1. Link to  GitHub
  2. Link to  OneDrive

And access the online dashboard here

Power BI Series – Refresh Data

In the 2nd Video of the Power BI Series I show you how to refresh the model with new data.

In this video we are covering:

    • Refresh the model with new data
    • Introduction to Power Query
    • Common Errors and how to troubleshoot it
    • Best Practice for file naming

Keep tuned for the next video and learn How to append multiple files using  the Power Query editor

You can download the files here:

  1. Link to GitHub: https://github.com/Bordalos/Power-BI/
  2. Link to OneDrive: https://1drv.ms/u/s!At1CSmc…

And access the online dashboard here

Power BI Series

Check out the 1st Video of the Power BI Series and learn how to build your first Power BI report in less than 15 minutes.

In this video we are covering:

  • Why should you move away from reports in Excel
  • How to install Power BI Desktop
  • How to connect to an excel dataset
  • Introduction to  Card, Multi-Row Card, Bing Map, Bar Chart, Line Chart, Matrix, Donut Chart visuals
  • Set Conditional Formatting Data Bars
  • Size, Align and Distribute visuals
  • Create a Top and Bottom N KPI
  • Edit Interactions for cross filters

Keep tuned for the next video and learn how to refresh the report with new data

You can download the files here:

  1. Link to GitHub: https://github.com/Bordalos/Power-BI/
  2. Link to OneDrive: https://1drv.ms/u/s!At1CSmc…

And access the online dashboard here

How to install Power BI

Installing Power BI Desktop is really simple and it’s FREE . Just go to https://powerbi.microsoft.com/en-us/get-started and download the latest version to your machine. Run the executable and boom 2. You are now empowered to create your own amazing reports.

The PBI desktop will be from now on your best companion and soon you won’t be using any other toll to do your analysis.

In more than 95% of the times you will already have a MS Office license in your Organization. Although if that’s not the case and you don’t have one licence you can sign up Office 365 for a 1 month trial.

Note: You will need to have a work or school email account to sign in into the Power BI Service or Power BI Mobile. More on that later. For now I suggest you start to discover the possibilities of the desktop version.

Sales KPI in one page

Sales KPI in one page

Here just an example of one page dashboard containing lots of information.
With Power BI it’s really quick and easy to create impressive presentations for that last-minute meeting with your client or boss. Yes, we all have been in that situation more often than we would like . Is exactly in that moments that PBI excels from the other BI and Analytics tools.

The agility you can build a report from the most untidy dataset, is not only going to save you lots of stress but also make you outstanding.

Check out the video series How to create a Power BI Report and Get the Power!

 

The First Time

It was love at the first sight! I tested the Power BI desktop for the first time back in 2016 and it completely blew my mind!
I've Got the Power
After been more than 10 year working in Finance and Accounting roles where Excel is the King , I knew PBI had come to change the game. In fact I had been for the last couple months get into Power Pivot and Power Query and at the time I thought those add-ins where already amazing. But is when you see those add ins combined with an astonishing visualizations graphs in the same suite that you can fully realize how powerful is this tool.

I’ve decided to create this blog to share with all of you that are new to this world how to use Power BI and leverage your works. There are endless reasons to get the Power, so stick around.