Get Lifetime Access to This Course & 1900+ Others for Only £149. Subscribe Now
Course Overview
Learn how to make a genuine difference in your life by taking our popular Microsoft Power BI. Our commitment to online learning and our technical experience has been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Microsoft Power BI to a whole new level and quickly reap the rewards of your study in the field you have chosen.
We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.
Please note that Microsoft Power BI provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.
Learning Outcomes
- Instant access to verified and reliable information
- Participation in inventive and interactive training exercises
- Quick assessment and guidance for all subjects
- CPD accreditation for proof of acquired skills and knowledge
- Freedom to study in any location and at a pace that suits you
- Expert support from dedicated tutors committed to online learning
Your Path to Success
By completing the training in Microsoft Power BI, you will be able to significantly demonstrate your acquired abilities and knowledge of Microsoft Power BI. This can give you an advantage in career progression, job applications, and personal mastery in this area.
Is This Course Right for You?
This course is designed to provide an introduction to Microsoft Power BI and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.
Assessment Process
Once you have completed all the modules in the Microsoft Power BI course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.
Show off Your New Skills with a Certification of Completion
The learners have to successfully complete the assessment of this Microsoft Power BI course to achieve the CPD & IAO accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.
Course Curriculum
| Section 01: Introduction | |||
| Welcome! | 00:01:00 | ||
| What is Power BI? | 00:03:00 | ||
| Download & Installing Power BI Desktop | 00:04:00 | ||
| Getting to know the interface | 00:03:00 | ||
| Mini Project: Transform Data | 00:06:00 | ||
| Mini Project: Visualize Data | 00:05:00 | ||
| Mini Project: Creating a Data Model | 00:07:00 | ||
| Course Outline: What will you learn in this course? | 00:05:00 | ||
| How to learn best with this course? | 00:03:00 | ||
| Section 02: Preparing our Project | |||
| Creating our initial project file | 00:04:00 | ||
| Working with the attached project files | 00:04:00 | ||
| Section 03: Data Transformation - The Query Editor | |||
| Exploring the Query Editor | 00:06:00 | ||
| Connecting to our data source | 00:07:00 | ||
| Editing rows | 00:08:00 | ||
| Changing data types | 00:08:00 | ||
| Replacing values | 00:03:00 | ||
| Close & Apply | 00:03:00 | ||
| Connecting to a csv file | 00:03:00 | ||
| Connecting to a web page | 00:05:00 | ||
| Extracting characters | 00:06:00 | ||
| Splitting & merging columns | 00:09:00 | ||
| Creating conditional columns | 00:06:00 | ||
| Creating columns from examples | 00:09:00 | ||
| Merging Queries | 00:17:00 | ||
| Pivoting & Unpivoting | 00:06:00 | ||
| Appending Queries | 00:08:00 | ||
| Practice & Solution: Population table | 00:15:00 | ||
| The Fact-Dimension-Model | 00:09:00 | ||
| Practice: Load the dimension table | 00:04:00 | ||
| Organizing our queries in groups | 00:03:00 | ||
| Entering data manually | 00:05:00 | ||
| Creating an index column | 00:03:00 | ||
| Workflow & more transformations | 00:05:00 | ||
| Module summary | 00:05:00 | ||
| Exercise 1 – Instruction | 00:02:00 | ||
| Exercise Solution | 00:11:00 | ||
| Section 04: Data Transformation - Advanced | |||
| Advanced Editor – Best practices | 00:05:00 | ||
| Performance: References vs. Duplicating | 00:10:00 | ||
| Performance: Enable / Disable Load & Report Refresh | 00:05:00 | ||
| Group by | 00:05:00 | ||
| Mathematical Operations | 00:05:00 | ||
| Run R Script | 00:15:00 | ||
| Using Parameters to Dynamically Transform Data | 00:07:00 | ||
| M formula language: Basics | 00:07:00 | ||
| M formula language: Values, Lists & Tables | 00:14:00 | ||
| M formula language: Functions | 00:13:00 | ||
| M formula language: More functions & Steps | 00:05:00 | ||
| Exercise 2 – Instructions | 00:01:00 | ||
| Exercise 2 – solution | 00:05:00 | ||
| Section 05: Creating a Data Model | |||
| Understanding the relationship | 00:05:00 | ||
| Create & Edit Relationships | 00:06:00 | ||
| One-to-Many & One-to-One Relationship | 00:06:00 | ||
| Many-to-Many (m:n) Relationship | 00:06:00 | ||
| Cross Filter Direction | 00:06:00 | ||
| Activate & Deactivate Relationships | 00:06:00 | ||
| Model Summary | 00:03:00 | ||
| Exercise 3 Create Model | 00:02:00 | ||
| Exercise 3 Solution | 00:02:00 | ||
| Section 06: Data Visualization | |||
| Our first visual | 00:08:00 | ||
| The format tab | 00:12:00 | ||
| Understanding tables | 00:10:00 | ||
| Conditional formatting | 00:09:00 | ||
| The Pie Chart | 00:06:00 | ||
| All about the filter visual | 00:13:00 | ||
| The filter pane for developers | 00:11:00 | ||
| Cross filtering & edit interactions | 00:04:00 | ||
| Syncing Slicers Across Pages | 00:07:00 | ||
| Creating drill downs | 00:08:00 | ||
| Creating Drill Throughs | 00:07:00 | ||
| The Tree Map Visual | 00:07:00 | ||
| The Decomposition Tree | 00:05:00 | ||
| Understanding The Matrix Visual | 00:05:00 | ||
| Editing pages | 00:07:00 | ||
| Buttons & Actions | 00:09:00 | ||
| Bookmarks to Customize Your Report | 00:10:00 | ||
| Analytics and Forecasts with line charts | 00:10:00 | ||
| Working with custom visuals | 00:07:00 | ||
| Get data using R Script & R Script visual | 00:08:00 | ||
| Asking Questions – Q&A visual | 00:04:00 | ||
| Wrap up – Data Visualization | 00:08:00 | ||
| Section 07: Power BI & Python | |||
| Python in Power BI – Plan of attack | 00:03:00 | ||
| Setting up Python for Power BI | 00:03:00 | ||
| Transforming data using Python | 00:11:00 | ||
| Creating visualizations using Python | 00:08:00 | ||
| Violin Plots, Pair Plots & Ridge Plots Using Python | 00:15:00 | ||
| Machine learning (Bayes Text Analyzer) using Python | 00:00:00 | ||
| Performance & Troubleshooting | 00:03:00 | ||
| Section 08: Storytelling with Data | |||
| Introduction | 00:01:00 | ||
| Show Empathy & Identify the Requirement | 00:03:00 | ||
| Finding the Most Suitable KPI’s | 00:02:00 | ||
| Choose an Effective Visualization | 00:04:00 | ||
| Make Use of Natural Reading Pattern | 00:03:00 | ||
| Tell a Story Using Visual Cues | 00:05:00 | ||
| Avoid Chaos & Group Information | 00:02:00 | ||
| Warp Up – Storytelling with Data | 00:02:00 | ||
| Section 09: DAX - The Essentials | |||
| Introduction | 00:03:00 | ||
| The Project Data | 00:04:00 | ||
| Measures vs. Calculated Columns | 00:15:00 | ||
| Automatically creating a date table in DAX | 00:08:00 | ||
| CALENDAR | 00:05:00 | ||
| Creating a Complete Date Table with Features | 00:04:00 | ||
| Creating Key Measure Table | 00:03:00 | ||
| Aggregation functions | 00:06:00 | ||
| The different versions of COUNT | 00:14:00 | ||
| SUMX – Row based calculations | 00:09:00 | ||
| Section 10: DAX - The CALCULATE function | |||
| CALCULATE – The basics | 00:11:00 | ||
| ALL | 00:08:00 | ||
| ALL SELECTED | 00:03:00 | ||
| ALL EXCEPT | 00:07:00 | ||
| Section 11: Power BI Service - Power BI Cloud | |||
| How to go on now? | 00:03:00 | ||
| Power BI Pro vs Premium & Signing up | 00:04:00 | ||
| Exploring the interface | 00:04:00 | ||
| Discovering your workspace | 00:03:00 | ||
| Connecting Power BI Desktop & Cloud | 00:04:00 | ||
| Understanding Datasets & Reports | 00:03:00 | ||
| Working on Reports | 00:04:00 | ||
| Updating reports from Power BI Desktop | 00:04:00 | ||
| Creating and Working with Workspaces | 00:07:00 | ||
| Installing & Using a Data Gateway | 00:13:00 | ||
| Get Quick Insights | 00:03:00 | ||
| Creating Dashboards | 00:04:00 | ||
| Sharing our results through Apps | 00:10:00 | ||
| Power BI Mobile App | 00:05:00 | ||
| Power BI Mobile App | 00:05:00 | ||
| Creating the layout for the Mobile App | 00:04:00 | ||
| Wrap up – Power BI Cloud | 00:07:00 | ||
| Section 12: Row-Level Security | |||
| Introduction | 00:03:00 | ||
| Creating a Row-Level Security | 00:05:00 | ||
| Row-Level Security in the Cloud | 00:04:00 | ||
| Row-Level Security & Data Model | 00:05:00 | ||
| Dynamic Row-Level Security | 00:07:00 | ||
| Dynamic Many-to-Many RLS | 00:04:00 | ||
| Hierarchical Row-Level Security | 00:13:00 | ||
| Section 13: More data sources | |||
| JSON & REST API | 00:10:00 | ||
| Setting up a local MySQL Database | 00:14:00 | ||
| Connecting to a MySQL database in Power BI | 00:05:00 | ||
| Connecting to a SQL database (PostgreSQL) | 00:05:00 | ||
| Section 14: Next steps to improve & stay up to date | |||
| Congratulations & Next Steps | 00:06:00 | ||
| The End | 00:01:00 | ||
| Resources | |||
| Resources – Microsoft Power BI Masterclass 2021 | 00:00:00 | ||
| Assignment | |||
| Assignment – Microsoft Power BI | 00:00:00 | ||
COURSE REVIEWS
- 1 year
- Intermediate
- Number of Units141
- Number of Quizzes0
- 14 hours, 19 minutes Gift this course
COPYRIGHT © 2023 - ACADEMY FOR HEALTH & FITNESS TRADING AS MAYFAIR COLLEGE LTD (Company number 12389626). ALL RIGHTS RESERVED.