Data analysis with Power BI

Course Dates: 02/11/21 - 23/11/21
Time: 18:00 - 21:15
Location: Online
Tutors: 
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 is FREE if a) you live in London and your job is at risk of redundancy or b) you are either on Jobseekers' Allowance (JSA) or Employment & Support Allowance(ESA) or c) you receive other state benefits (including Universal Credit). For more information click here
This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
Download
Book your place
In stock
SKU
178945
Full fee £199.00 Senior fee £159.00 Concession £100.00

Course Code: CBI02

Tue, eve, 02 Nov - 23 Nov '21

Duration: 4 sessions (over 4 weeks)

Or call to enrol:020 7831 7831

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

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: 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.

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: 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?

Excel for financial modelling, Excel expert or advanced or Access.

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.