Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7

Home
Course
IT & Software
Quality Licence Scheme
Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7

Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7

Level: Level 7
Modules: 142 Modules
Duration: 18 hours, 26 minutes
Students: 561

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