Booking options
Price:
BuyContact Us£10.99
Course Images
Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7
By Studyhub UK
(3)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
18 hours 26 minutes
All levels
Description
Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK.
Learning Outcomes
Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface.
Develop proficiency in advanced data transformation techniques and data model creation.
Integrate Python with Power BI and harness the benefits of both for enhanced data analytics.
Master the art of 'Storytelling with Data' to deliver impactful presentations and reports.
Understand and implement Row-Level Security and harness Power BI Cloud services efficiently.
Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7?
Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Who is this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for?
Individuals keen on obtaining the Microsoft power bi certification UK.
Analysts and data professionals aspiring to enhance their data visualisation skills.
Business professionals wanting to leverage Power BI for insightful business decision-making.
Tech enthusiasts aiming to amalgamate programming (Python) with data analytics.
Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities.
Career path
Data Analyst: Average Salary £30,000 - £40,000 Annually
Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually
Power BI Developer: Average Salary £40,000 - £50,000 Annually
Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually
Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually
Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually
Prerequisites
This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
Certification
After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.
Endorsed Certificate of Achievement from the Quality Licence Scheme
Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10.
Endorsement
The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards.
Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.
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:07: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:09: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:06: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:08:00 | ||
Cross filter direction | 00:06:00 | ||
Activate & deactivate relationships | 00:06:00 | ||
Model summary | 00:03:00 | ||
Exercise 3 Create Model | 00:03: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:09: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 (BayesTextAnalyzer) 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 | ||
Changing the context with FILTER | 00:07: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 | ||
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 - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 | 00:00:00 | ||
Assignment | |||
Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 | 04:00:00 | ||
Order your QLS Endorsed Certificate | |||
Order your QLS Endorsed Certificate | 00:00:00 |
About The Provider
Studyhub UK
London, England
(3)Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated...
Reviews
There are no reviews for Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 yet.Why not be the first one to review this course?