Data analysis with Power BI: introduction

Course Dates: 01/11/23 - 06/12/23
Time: 19:00 - 21:00
Location: Online
Power BI is a Microsoft Product that is free to download and use, it allows to connect, transform, and visualize data.This can be done in Microsoft Power BI Desktop application or in Excel using Power Query and Power Pivot. The formulae language used in Power BI is called DAX: Data Analysis Expressions. Learning the basics of this language is crucial to be able to create dynamic reports. In this course, you will discover the world of Power Query and Power Pivots by learning the most basic but crucial functionalities of these environments including basic DAX functions.
This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
Book your place
In stock
Full fee £229.00 Senior fee £183.00 Concession £149.00

This course has now started

Course Code: CBI02

Started Wed, eve, 01 Nov - 06 Dec '23

Duration: 6 sessions (over 6 weeks)

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

What is the course about?

This is a practical course that introduces you to modelling & reporting with Power BI, using the Power BI application or in Excel. You will learn how to connect to multiple data sources and combine them into a data model that lets you build visuals and reports for business intelligence projects.
This course is not about building Visuals and Dashboards, but rather creating the functions and measures that would be used for visuals, whether that is in the form of charts or matrix reports.

If you have never used Power BI (first-time user),before you attend this course, you must attend the following online, free training provided by Microsoft:
Please note that Microsoft Power BI Desktop works on Windows OS but not supported/does not work on Apple/Mac for now.

Participants who will attend the full course will receive a City Lit certificate of attendance electronically for their CV or CPD records. The certificate will show your name, course title and dates of the course you have attended.

This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

What will we cover?

• Introduction to self-service Power BI, Power Query, Power Pivot
• Import data into Power BI using Power Query
• Manipulate queries using selected Power Query functions
• Introduction to DAX: Data Analysis Expressions
• Calculated Columns and Measures
• Categories of DAX functions
• Table functions and Calculate
• Basic Time intelligence
• KPIs & Conclusion.

What will I achieve?
By the end of this course you should be able to...

• Connect to data
• Transform and clean data and create a data model
• Create reports using power BI.

What level is the course and do I need any particular skills?

This course is for beginners. But you must have an advance level in Pivot Tables. If you have never used Power BI (first-time user), before you attend this course, you must attend the following online, free training provided by Microsoft:

How will I be taught, and will there be any work outside the class?

Power BI functionality and skills will be covered in class with practical examples. Students will need to practice what they learned after each class.

Are there any other costs? Is there anything I need to bring?

There are no other costs. You will need to have Microsoft Excel installed on your computer, preferably 2016 or later. You will have to download Power BI Desktop from Microsoft website on your computer (it s free). Please follow this link for system requirements:
Also, you will be shown in the beginning of the course how to activate Power BI Add-Ins in Excel.
Please note that Microsoft Power BI Desktop works on Windows OS but not supported/does not work on Apple/Mac for now.

When I've finished, what course can I do next?

Please click here to view our Microsoft 365 courses.

Disclaimer: Use of Third-Party Software
This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.

We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.