Data analysis with Power BI: introduction

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: https://docs.microsoft.com/en-us/power-bi/fundamentals/videos.
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.

You can choose to attend this course either live online or in person.
- 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: https://docs.microsoft.com/en-us/power-bi/fundamentals/videos.

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: https://www.microsoft.com/en-us/download/details.aspx?id=58494
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.