Power BI is fast becoming the go-to applications for businesses small and large to step-change their reporting needs. These tools are new, and different enough to regular Excel that most people benefit from some live training from an expert. This one day course focuses on teaching business/IT users the fundamental principles of data modelling using Power BI and Power Pivot and the DAX (Data Analysis Expressions) language.
This course is ideal if you already have a solid understanding and experience using Power BI report building, sharing and Power Query. It is recommended for most people that are relatively new to Power BI to attend the more comprehensive 2-day course “Power BI for the Business Analyst” instead of this one day data modelling course.
This one-day training course enables you to move from simply building reports using someone else’s data, to preparing your own data for enhanced use. In this course you will learn:
- Overview of the DAX language (Data Analysis Expressions).
- Common functions in the DAX language.
- How to write formulas that leverage multiple tables.
- The CALCULATE function – the most important function in DAX.
- Advanced concepts including table functions such as ALL, FILTER.
- Time Intelligence.
Download Course Brochure: Power BI For the Business Analyst Course Outline
Training Course Location
Training will most likely be held at Master Builder’s Association of Victoria https://goo.gl/maps/tZJXQeZSqgN2. The exact location will be confirmed with participants the week prior to the course and will depend on the number of participants attending.
Bulk discounts are available when you register and pay for 3 or more people at the same time.
- Register and pay for 3 people, get 10% discount on total amount.
- Register and pay for 6 people, get 20% discount on total amount.
Please Note: If you register on behalf of someone and/or register for more than one participant, please provide the names and email addresses of all the participants in the order notes.
Things you need to know
The training will commence at 9am and finish at 5pm. You will bring your own* laptop with Power BI Desktop installed – this will be confirmed in a logistics email the week prior to the course training date.
*If you do not have a laptop, please contact Matt – there is some loan equipment available if you are not able to bring a laptop with you.
Cancellations will be accepted 7 business days prior to the course start date. After that time no refunds will be issued. If you are unable to attend for any reason at short notice (i.e. with less than 7 days’ notice), you can send a proxy to attend the course in your place with prior agreement.
The training course may be rescheduled or cancelled if insufficient registrations are received up until 7 days prior to the course date. In this event a suitable arrangement will be made to either refund the course fee in full or reschedule to another session at the choice of the student. The objective is always to make you happy.
All participants will receive the certificate of completion at the end of the course.
Participants registered for the 2nd day of the training will receive a free copy of the book “Supercharge Power BI”. If instead you would prefer a copy of “Supercharge Excel”, please indicate this when you place your order. With these books you can continue your learning after the live training using the same familiar learning style covered in the course.