All Courses for £49
Overview
By enroling in Microsoft Power BI Masterclass 2021, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic.
The Microsoft Power BI Masterclass 2021 course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Microsoft Power BI Masterclass 2021 course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Microsoft Power BI Masterclass 2021 Program.
So enrol in our Microsoft Power BI Masterclass 2021 course right away if you’re keen to envision yourself in a rewarding career.
Description
Enroling in this Microsoft Power BI Masterclass 2021 course can improve your Microsoft Power BI Masterclass 2021 perspective, regardless of your skill levels in the Microsoft Power BI Masterclass 2021 topics you want to master. If you’re already a Microsoft Power BI Masterclass 2021 expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Microsoft Power BI Masterclass 2021 insights that will help you make the most of your time. This Microsoft Power BI Masterclass 2021 course will act as a guide for you if you’ve ever wished to excel at Microsoft Power BI Masterclass 2021.
Why Choose Us?
- This course is accredited by the CPD Quality Standards.
- Lifetime access to the whole collection of the learning materials.
- Online test with immediate results.
- Enroling in the course has no additional cost.
- You can study and complete the course at your own pace.
- Study for the course using any internet-connected device, such as a computer, tablet, or mobile device.
Certificate of Achievement
Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99.
Who Is This Course For?
This Microsoft Power BI Masterclass 2021 course is a great place to start if you’re looking to start a new career in Microsoft Power BI Masterclass 2021 field. This training is for anyone interested in gaining in-demand Microsoft Power BI Masterclass 2021 proficiency to help launch a career or their business aptitude.
Requirements
The Microsoft Power BI Masterclass 2021 course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Microsoft Power BI Masterclass 2021, without any fuss.
Career Path
This Microsoft Power BI Masterclass 2021 training will assist you develop your Microsoft Power BI Masterclass 2021 ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a Microsoft Power BI Masterclass 2021 professional story and personalise your path to a new career. Furthermore, developing this Microsoft Power BI Masterclass 2021 skillset can lead to numerous opportunities for high-paying jobs in a variety of fields.
Order Your Certificate
To order CPD Quality Standard Certificate, we kindly invite you to visit the following link:
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 | ||
| Order Your Certificate | |||
| Order Your Certificate | 00:00:00 | ||
Related Courses
