Please ensure Javascript is enabled for purposes of website accessibility
Power BI Desktop: Data Analytics For Everyone

This course is designed for those interested to learn BI for data analytics. Read more.

4.8( 4 REVIEWS )
3807 STUDENTS
2h 39m
Students
3807
Course Skill Level
Beginner
Time Estimate
2h 39m

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

Who this course is for:

  • 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 you’ll learn: 

  • Learn to gather data
  • Transform data and model data
  • Explain the data and share valuable insights with your organisation

Requirements: 

  • No prior knowledge is required to take this course

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.

LEARN TO GATHER DATA, TRANSFORM DATA AND MODEL DATA BEFORE YOU CREATE VISUALIZATIONS TO EXPLAIN THE DATA AND SHARE VALUABLE INSIGHTS WITH YOUR ORGANISATION.

CONTENTS AND OVERVIEW

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 Analysts, 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.

Our Promise to You

By the end of this course, you will have learned BI for data analytics.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about BI for data analytics.

Course Curriculum

Section 1 - Power BI Desktop Introduction
Introduction 00:00:00
Download PowerBI Desktop 00:00:00
Lets Take A Tour Around The Desktop Application 00:00:00
How To Take This Course 00:00:00
Section 2 - Get And Query Data
Activity And Workbooks 00:00:00
Introduction To The Query Editor Section 00:00:00
Connect And Transform Data From An Excel Workbook 00:00:00
Connect And Transform Folders Of Data 00:00:00
Unpivot Data 00:00:00
Setting Up A Date (Calendar) Table Using Query 00:00:00
Connect To A .Txt File 00:00:00
Connect To Data On The Web 00:00:00
Activity 00:00:00
Section 3 - DAX
DAX Introduction 00:00:00
Relationships 00:00:00
Calculated Columns 00:00:00
Measures 00:00:00
The X-Functions 00:00:00
Related And Related Table Expressions 00:00:00
The Filter Expressions 00:00:00
Calculate Function 00:00:00
Other DAX Functions 00:00:00
More On DAX 00:00:00
More On Calculated Columns And Measures 00:00:00
Time Intelligence Functions 00:00:00
Downloadable Materials : DAX And Data Files 00:00:00
Section 4 - Visualizations
Introduction To Visulaizations 00:00:00
The Canvas And Your First Visualization 00:00:00
Line Charts And Hierarchy 00:00:00
Adding Slicers 00:00:00
Gauges, KPI’s And Cards 00:00:00
Scatter Charts 00:00:00
Conclusion 00:00:00

About This Course

Who this course is for:

  • 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 you’ll learn: 

  • Learn to gather data
  • Transform data and model data
  • Explain the data and share valuable insights with your organisation

Requirements: 

  • No prior knowledge is required to take this course

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.

LEARN TO GATHER DATA, TRANSFORM DATA AND MODEL DATA BEFORE YOU CREATE VISUALIZATIONS TO EXPLAIN THE DATA AND SHARE VALUABLE INSIGHTS WITH YOUR ORGANISATION.

CONTENTS AND OVERVIEW

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 Analysts, 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.

Our Promise to You

By the end of this course, you will have learned BI for data analytics.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about BI for data analytics.

Course Curriculum

Section 1 - Power BI Desktop Introduction
Introduction 00:00:00
Download PowerBI Desktop 00:00:00
Lets Take A Tour Around The Desktop Application 00:00:00
How To Take This Course 00:00:00
Section 2 - Get And Query Data
Activity And Workbooks 00:00:00
Introduction To The Query Editor Section 00:00:00
Connect And Transform Data From An Excel Workbook 00:00:00
Connect And Transform Folders Of Data 00:00:00
Unpivot Data 00:00:00
Setting Up A Date (Calendar) Table Using Query 00:00:00
Connect To A .Txt File 00:00:00
Connect To Data On The Web 00:00:00
Activity 00:00:00
Section 3 - DAX
DAX Introduction 00:00:00
Relationships 00:00:00
Calculated Columns 00:00:00
Measures 00:00:00
The X-Functions 00:00:00
Related And Related Table Expressions 00:00:00
The Filter Expressions 00:00:00
Calculate Function 00:00:00
Other DAX Functions 00:00:00
More On DAX 00:00:00
More On Calculated Columns And Measures 00:00:00
Time Intelligence Functions 00:00:00
Downloadable Materials : DAX And Data Files 00:00:00
Section 4 - Visualizations
Introduction To Visulaizations 00:00:00
The Canvas And Your First Visualization 00:00:00
Line Charts And Hierarchy 00:00:00
Adding Slicers 00:00:00
Gauges, KPI’s And Cards 00:00:00
Scatter Charts 00:00:00
Conclusion 00:00:00

Course Review

4.8

4.8
4 Ratings
  1. Anonymous

    Great course!

    5.0

    Very easy to follow. I would recommend this course.

  2. Anonymous

    Power BI Desktop: Data Analytics For Everyone

    4.0

    I felt as a beginning course for me that it was a good start. I have some basic information that I can start to use and then work on learning more over time.

  3. Anonymous

    Great course - Thanks

    5.0

    I bought this course a year ago as a part of a bundle.
    This week Jan 2021 I joined a job where this is a required skill.
    I completed it this weekend and now I am ready to face the task with my new skill.
    Great instructor I loved her English and her knowledge.
    JT from Costa Rica.

  4. Anonymous

    Excellent Overview

    5.0

    The instructor does not waste time getting too far into details and provides a very informative presentation that gives you a quick overview of what Power BI for Desktop can do. I found her instruction easy to follow and the speed of the presentation was perfect for those who can quickly grasp a concept and put it to use. I would recommend this course to anyone who wants a quick overview without going into too much detail.

Are you interested in higher education?