Power BI Desktop - Data Analytics for Everyone

Learn how to Get, Sort, Transform, Model and Visualize data from any source with Microsoft Power BI application

Power BI

Power BI Desktop is a combination of Excels Power Features (Power Pivot, Power Query and Power View) all in a standalone package. Using Power BI, you can find, get, transform, analyse and Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. Combined with BI Service, these data queries reports and dashboard can be shared and viewed on the go.

This self-service business intelligence systems brings data analytics to the ordinary company.


Power BI brings the world of data analytics to the ordinary business, by connecting to data from multiple sources and transforming or modelling that data, you can view and share insights to your business like never before. Being a self-service system, means you don’t need the help of and IT department to transform or model the data.



Section 1 of this course is an Introduction section where you will learn how to install PowerBI and you will be given a guided tour.

In section 2 of this course we will look at getting data from multiple sources, both internal and external. Connecting to different types of files of data, Folders or data and online data. Setting up data queries and transforming the data into a format that can be used.

In section 3 of this course we will look at Data modelling, setting up relationships, creating calculated columns and measures using DAX, using calculated tables and creating hierarchy. In addition to this we will also look at some time intelligence functions.

In section 4 of this course we will look at Data visualization. We will go through the use of different charts, trend lines, slicer’s maps and other visualizations

Who Should Attend?

This course is suited to those with an interest in Excel, Data Analyst's, Data Mining, BI and Reporting This course is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.

• This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.

• This course is for you if you are looking to learn Power BI Self Service functions.

• This course is not for you if you are new to Excel.

What’s included?

Instruction by an expert

12 months access 24/7

Certificate of completion

How long will it take ?

Completion Time  5 hours

Intended Audience: Accountants, Auditors, Those involved in reporting, Data enthusiastic, Mangers, Those involved in Business Intelligence

Download PowerBI Desktop
How to take this course
Lets take a tour around the desktop application
Activity and Workbooks
Introduction to the Query Editor Section
Connect and transform data from an Excel Workbook
Connect and transform folders of Data
Unpivot Data
Setting up a date (Calendar) table using query
Connect to a .TXT file
Connect to data on the Web
DAX introduction
Calculated columns
The X-functions
Related and Related Table Expressions
The Filter Expressions
Calculate Function
Other DAX Functions
More on DAX
More on Calculated Columns and Measures
Time Intelligence Functions
Introduction to Visulaisations
The Canvas and your first visualization
Line Charts and Hirearchy
Adding Slicers
Gauges, KPI's and Cards
Scatter Charts

What's included

  • 29 Video Lessons
  • 11 Text Lessons

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle


My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.