Microsoft Power BI
Microsoft Power BI
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - ENDS SOON
OR
Or
Take All
courses for
£49 
1 Year Access 
Level 7
35 Students -
3 weeks, 4 days
Get access to 5000+ courses including this for
Overview
Get the very most out of the corporate world’s premier business analytics service by taking this comprehensive Microsoft Power BI course. Part of the Power Platform, the application is intuitive enough to provide impressive interactive visualisations and high-end intelligence capabilities and yet is simple enough for you to quickly create reports and dashboards.
This Microsoft Power BI tutorial provides the best available tuition and guidance, allowing you to gain the full potential of this invaluable service. Again installation guidance, you will learn how to fully prepare projects, perform expert data transformation, create complex data models, present proficient data visualisation, and provide a narrative for your statistics. You will also be shown how to use Python, DAX, Json, REST API, MySQL, and much more for effective combinations with Power BI.
This specialised training delivers the core skills and knowledge needed to stand out from others using this service. Reporting and presenting will become a breeze, and you will be a Power BI expert.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £129.00. Please note that overseas students may be charged an additional £10 for postage.
CPD Certificate of Achievement from One Education
Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.
Endorsement
This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an endorsed lesson. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.
Why Study This Course
It doesn’t matter if you are an aspiring expert or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an acknowledged certificate attesting to your knowledge.
The Microsoft Power BI is fully available to anyone, and no previous lessons are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
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: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: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 – Microsoft Power BI Masterclass 2021 | 00:00:00 | ||
| Assignment | |||
| Assignment – Microsoft Power BI | 3 weeks, 3 days | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
