Brief Introduction
Take your data modelling skills to another level and learn how to use SQL, DAX with Power BI to drive changeDescription
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.
Requirements
- Requirements
- This course follows on from my earlier course 'Learn Microsoft Power BI'. I recommend students complete that course first as I won't be covering the material that was included in the earlier course.
- For the SQL part of the course I use SQL Server Express with SQL Server Management Studio. If you want to follow along you can install the freely available SQL Server Express (covered in the course).
- Power BI Desktop should be installed. This is covered in the earlier course.
Power BI A-Z: Hands-On Power BI Training For Data Science!
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn Microsoft Power BI for Data Science and Data Analytics. Build visualizations and BI reports with Power BI Desktop Connect Power BI to a Variety of Datasets...
LEARNING PATH: Microsoft Power BI Made Easy
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Change your data into actionable business insights The highlights of this Learning Path are: Get to discover and share new insights from your published reports and dashboards...
Excel Interactive Dashboards and Data Analysis
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn to create POWERFUL, INTERACTIVE dashboards in Excel in minutes with no coding We've focused on providing you with the fundamentals you need to work with Excel effectively! ...
Microsoft Power BI Certification: DA-100 Exam Prep
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Complete, hands-on guide to passing the DA-100 Power BI Exam and becoming a Microsoft Certified Data Analyst Associate See why Maven Analytics courses are among the TOP-RATED and BEST-SELLING courses on Udemy:...
