Do you spend a lot of time working with excel building reports and dashboards?
Are you bored with the repetitive tasks? Are you fed up with copy and paste data from various sheets and deal with the same data issues again and again?
Then this course will help you to learn new feature with excel to automate all the steps to get an enterprise level dashboard.
This course will cover the aspects of self service Business Intelligence for excel analysts. In this course the students will be able to learn and practise the Power BI tools such as Power Query, Power Pivot, Power View. Also you will learn about DAX for efficient processing and reporting.
This course will be useful for Analysts, BI Developers, Dashboard Report Designers and super users.
Following topics are included in this course:
- Power BI Basics
- Loading Data
- M language
- Data Modelling
- Advanced Data Modelling
- DAX Basics
Basic knowledge in MS Excel.