Master fundamental skills of Power BI Desktop and build refined dashboards with case study. Free Microsoft 365 license.
What you'll learn
- End to end professional dashboard development with Power BI Desktop
- Data processing
- Data loading with different scenarios
- Data transformation with Power Query Editor
- Data model creation
- Build visualisations from desktop app and from Power BI marketplace
- Theme customisation
- Dashboard buttons with web URL and actions
- Bookmark
- Dashboard export
- Real life case study
- Microsoft 365 free license application
- Power BI best practices
Requirements
- Practice whilst following course videos
- Computer with Windows operating system for the most of the course
Description
This course features the latest Power BI Desktop (version: 2.84.981.0, released on 28 Aug 2020) so rest assured that you are going to learn about the most up-to-date features of Power BI Desktop.
You'll immediately get your return on investment from budget point of view as I'll teach you step by step how to apply for a Microsoft free license which gives you access to not only Power BI Pro features but also other wide range of Microsoft solutions.
Instead of purely lecturing all the functionalities of Power BI like other courses, I'm combining lectures with practices (case study) so you'll have first-hand learning and applying experience.
At the end of the course, you'll be able to build on your own beautifully-designed, professional-looking and report-ready dashboards if you follow the steps in my course. You'll be able to leverage what you've learned in your real-life business or personal contexts.
Throughout my course, you'll be able to learn and apply:
Load data
- Load data with different formats
- Load data in one file one sheet
- Load data in one file multiple sheets
- Load data in multiple files and multiple sheets
- Cleanse and standardise source data in power query editor
- Add additional data fields
- Change data types
- Format data
- build one single data model with multiple tables
- build separate data models
- Build different chart types from built-in charts
- Access and use customised charts from Power BI marketplace
- DAX
- Format
- Filters
- Analytics function
- Canvas layout design
- Cover page creation
- Buttons with linked functions and URLs
- Bookmarks
- Customise theme
- Dashboard export
- Top tips
Cheers,
Bing
Who this course is for:
- Anyone who has 0 to intermediate level knowledge about Power BI
- Advanced Power BI users who'd like to practice with real life case study and to learn best practice of building professional looking dashboard