Microsoft Power BI Intermediate
Take your data modelling skills to another level and learn how to use SQL, DAX with Power BI to drive change
This course follows on from my earlier course 'Learn Microsoft Power BI'. The skills you learn on this course will give you the tools to manipulate data at different levels in order to create the insight you want. You'll be able to create insight with calculations and develop highly formatted dashboards suitable for publication.
Acquire the Skills to be a Data Ninja
Learn how to:
- Write SQL to query databases
- Clean dirty data to get it ready for modelling
- Create data models that unlock insights from multiple data tables
- Enrich the model with DAX calculations
Communicate insights by
- Creating executive level dashboards
Power BI is a new tool that empowers you to be a master of data rather than a servant of it.
Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards.
The prerequisites I have are
- Students must be data literate.
- Excel users will have no problem learning Power BI.
- I'm assuming you've completed my earlier course 'Learn Microsoft Power BI'.
SQL or BI developers probably won't get a lot from this course apart from DAX Calculations and Dashboard skills.
The type of terminology used on this course includes, Tables, Rows, Fields, Joins, Relationships, Models, Calculations, Filtering, Visualizations.
The course is taught using screencasts, slides.
The files I use on the course are available for you to download. As long as you install SQL server with the sample databases you'll be able to follow along.
It can take between 2.5 and 3 hours to take this course.
There are over 2.5 hours of screencasts.
The course is structured using key learning points, allowing you to build upon skills as you progress through the course. At the end of the course you'll have the skills to manipulate data to suit the requirements for complex dashboards.
The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data.
Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button.