Data analysis with Power BI
Time: 18:00 - 21:15
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) and your monthly take home pay is less than £343. 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.
Course Code: CBI02
Duration: 4 sessions (over 4 weeks)
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.
This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
We will contact you with joining instructions before your course starts.
What will we cover?
1. Introduction to self-service Power BI, Power Query, Power Pivot
2. Import data into Power BI using Power Query
3. Manipulate queries using selected Power Query functions
4. Introduction to DAX: Data Analysis Expressions
5. Calculated Columns and Measures
6. Categories of DAX functions
7. Table functions and Calculate
8. Basic Time intelligence
9. 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). Also, you will be shown in the beginning of the course how to activate Power BI Add-Ins in Excel.
When I've finished, what course can I do next?
You might also be interested in data analytics with Python: introduction, introduction to Python, Access.