Complete Microsoft Power BI 2021

Description

This comprehensive course on Complete Microsoft Power BI 2021 will deepen your understanding on this topic.

After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Power BI 2021 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast track your career ladder.

You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.

There is no experience or previous qualifications required for enrolment on this Complete Microsoft Power BI 2021. It is available to all students, of all academic backgrounds.

Our Complete Microsoft Power BI 2021 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.

Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-

And much more!

15 sections • 140 lectures • 14:25:00 total length

•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

•Creating our initial project file: 00:04:00

•Working with the attached project files: 00:04:00

•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 1 - Exercise Solution: 00:11:00

•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

•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

•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

•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

•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

•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

•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

•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

•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

•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

•Congratulations & next steps: 00:06:00

•The End: 00:01:00

•Resources - Complete Microsoft Power BI 2021: 00:00:00