Become An Expert In Microsoft Power Bi Desktop

2024's cutting-edge Power BI course tailored for Business Intelligence Analysts & Data Pros!

What you'll learn

Design professional-quality business intelligence reports from scratch

Transform raw data into interactive dashboards

Design and Implement tools utilized by data scientists & professional analysts

Showcase skills through full & comprehensive course projects

Harness potent artificial intelligence tools in reports

Learn from seasoned industry expert

Requirements

Microsoft Power BI Desktop (free download)

Designed for PC/Windows users, currently not available for mac users

Experience with Excel Power Query, Power Pivot & DAX is beneficial but not mandatory

Description

Master Power BI Desktop for data analysis through hands-on assignments and projects led by a top-rated instructor in Power BI.Are you a data professional or an aspiring analyst eager to indulge into the leading business intelligence platform? Look no further. This meticulously designed course is your gateway to mastery. With tens of hours of video tutorials, comprehensively covering every Power BI topic, this is the course you’ve been looking for.Embark on a journey guided by top-tier instructors from Sayyed Academy. Dive into hands-on projects and real-world assignments, polishing your skills along the way.COURSE PROJECT:Step into the shoes of a Business Intelligence Analyst at Adventure Works Cycles, a fictional manufacturing company. Your mission? Transform raw data into polished reports and dynamic dashboards, tracking KPIs, analyzing regional performance, identifying product trends, and pinpointing high-value customers.Fear not! We'll be with you every step of the way, offering clear explanations and expert tips to elevate you from novice to pro – guaranteed.This course covers all the stages of the business intelligence workflow, replicating real-world tasks encountered by data professionals.SECTION 1: Connecting & Shaping DataIn this phase, we will focus on constructing automated workflows to extract, transform, and load project data via Power Query. Explore various data connectors, storage modes, profiling tools, table transformations, and more: Data connectors Storage & import modes Query editing tools Table transformations Database connectivity Web data extraction QA & Profiling tools Text, numerical, date & time tools Rolling calendars Index & conditional columns Grouping & aggregating Pivoting & unpivoting Merging & appending queries Data source parameters Excel model importsSECTION 2: Building a Relational Data ModelIn this phase, we delve into data modeling best practices, covering cardinality, normalization, filter flow, and star schemas. We kick-start the Adventure Works data model from scratch: Database normalization Fact & dimension tables Primary & foreign keys Star & snowflake schemas Active & inactive relationships Relationship cardinality Filter context & flow Bi-directional filters Model layouts Data formats & categories HierarchiesSECTION 3: Enriching Data with DAX CalculationsIn this segment, we introduce data analysis expressions (DAX). Create calculated columns and measures, explore row and filter contexts, and wield powerful tools like filter functions, iterators, and time intelligence patterns: DAX vs. M Calculated columns & measures Implicit, explicit & quick measures Measure calculation steps DAX syntax & operators Math & stats functions Conditional & logical functions The SWITCH function Text functions Date & time functions The RELATED function CALCULATE, FILTER & ALL Iterator (X) functions Time intelligence functionsSECTION 4: Mastering Advanced DAXThis phase dives into advanced DAX functions, including implementing advanced aggregation, contextual calculations, time intelligence functions, and DAX variables: DAX shortcuts, code formatting, etc. Error handling DAX variables and uses DAX code testing and debugging DAX modifiers REMOVEFILTER & KEEPFILTER modifiers Advanced CALCULATE function uses Table and filter functions Calculated Virtual tables DISTINCT function VALUES function Table relationships & cardinality CONCATENATEX function Dynamic labels CALENDAR function Time intelligence functions PARALLELPERIOD & PREVIOUSQUARTER functions Additional time intelligence calculationsSECTION 5: Crafting Dynamic Data VisualizationsSection 5 focuses on breathing life into data with reports and dashboards. Review into data visualization best practices, chart creation, and interactivity enhancement: Data viz best practices Dashboard design framework Cards & KPIs Line charts, trend lines & forecasts On-object formatting Table & matrix visuals Conditional formatting Top N filtering Map visuals Drill up, drill down & drillthrough Report slicers & interactions Bookmarks & page navigation Numeric & fields parameters Custom tooltips Importing custom visuals Managing & viewing roles (RLS) Mobile layouts Publishing to Power BI ServiceUncover potent artificial intelligence tools like decomposition trees, key influencers, smart narratives, and natural language Q&A, coupled with performance optimization techniques for seamless report operation at scale. Discover the latest Power BI visuals, including the new card visual, button slicer, and more.Ready to embark on this transformative journey? Enroll today and unlock immediate, lifelong access to: Over 26 hours of premium video content A 270+ page Power BI eBook 28 practical assignments with solutions Downloadable course project files Expert Q&A support forum A risk-free 30-day money-back guaranteeIf you seek the ultimate course to cultivate job-ready Power BI skills, look no further.Keep learning with joy !

Overview

Section 1: Introduction and Course Structure

Lecture 1 Read Me

Lecture 2 Introduction to Course

Lecture 3 Course Design

Lecture 4 Download Resources

Lecture 5 Course Project

Lecture 6 Setting Expectations

Section 2: Power BI Introduction

Lecture 7 Introduction

Lecture 8 What is Power BI

Lecture 9 Power BI Download and Installation

Lecture 10 Power BI Settings

Lecture 11 Work Flow & Interface

Lecture 12 Resources and Monthly Updates

Section 3: Connecting & Preparing Data

Lecture 13 Introduction Connecting & Preparing Data

Lecture 14 Power BI Data Sources & Connectors

Lecture 15 New Power Query Editor Tools

Lecture 16 Table transformation

Lecture 17 Assignment - Table Transformation

Lecture 18 Solution - Table Transformation

Lecture 19 Expert Tip - Data Storage & Connection Modes

Lecture 20 Connecting to SQL Server Datasource

Lecture 21 Connecting to a Web Page

Lecture 22 QA & Column Profiling Tools

Lecture 23 Numeric Tools

Lecture 24 Assignment Numeric Tools

Lecture 25 Solution - Assignment Numeric Tool

Lecture 26 Text Tools

Lecture 27 Assignment Text Tools

Lecture 28 Solution Assignment - Text Tools

Lecture 29 Date & Time Calendar Table

Lecture 30 Changing Locale to Format Date

Lecture 31 Expert Tip - Rolling Calendar

Lecture 32 Assignment Date Table

Lecture 33 Solution - Date Table

Lecture 34 Index & Conditional Columns

Lecture 35 Guidelines to Work With Calculated Columns

Lecture 36 Grouping & Aggregation

Lecture 37 Pivot & Un-Pivot Columns

Lecture 38 Merging Queries

Lecture 39 Appending Queries

Lecture 40 Expert Tip - Adding Files From Folder

Lecture 41 Data Source Setting

Lecture 42 Expert Tip - Parameterised Data Source

Lecture 43 Refreshing Queries & Organizing

Lecture 44 Expert Tip - Import Excel Model in Power BI

Lecture 45 Best Practices - Data Connection & Preparation

Section 4: Data Model

Lecture 46 Data Modeling Introduction

Lecture 47 Data Modeling 101

Lecture 48 Normalization

Lecture 49 Fact & Dimension Tables

Lecture 50 Primary & Foreign Keys

Lecture 51 Understanding Table Relationships

Lecture 52 Creating Table Relationships

Lecture 53 Managing Table Relationships

Lecture 54 Star & Snowflake Schemas

Lecture 55 Assignment - Table Relationships

Lecture 56 Solution - Assignment Table Relationships

Lecture 57 Expert Tip - Active In-Active Relationship

Lecture 58 Cardinality

Lecture 59 Connecting to Multiple Data Tables

Lecture 60 Filter Context & Flow - Waterfall Model

Lecture 61 Bi-directional Filters & Risks

Lecture 62 Hiding Fields From Report View

Lecture 63 Expert Tip - Custom Model Layout

Lecture 64 Assignment - Hiding Fields

Lecture 65 Solution - Assignment - Hiding Fields Filter Flow

Lecture 66 Categorizing & Formatting Data

Lecture 67 The Data Hierarchies

Lecture 68 Assignment Date Hierarchy

Lecture 69 Solution - Assignment Date Hierarchy

Lecture 70 Best Practices - Desiging a Data Model

Section 5: Using DAX in Power BI

Lecture 71 Introduction to Using DAX in Power BI

Lecture 72 DAX

Lecture 73 M-code vs DAX Code

Lecture 74 Calculated Columns

Lecture 75 DAX Measures

Lecture 76 Implicit & Explicit Measures

Lecture 77 Quick Measures

Lecture 78 Comparing Calculated Columns & Measures

Lecture 79 Expert Tip - Measures Tables

Lecture 80 The Filter Context

Lecture 81 Calculation Steps for a Measure

Lecture 82 DAX Syntax and Operators

Lecture 83 Frequently Used Functions

Lecture 84 Maths & Statistics Functions

Lecture 85 Maths Counting Functions

Lecture 86 Assignment New Measures

Lecture 87 Solution - Assignment New Measures

Lecture 88 Expert Tip - Organising Measures

Lecture 89 Logical Functions in DAX

Lecture 90 Switch Logical Function

Lecture 91 Assignment - Logical Functions

Lecture 92 Solution - Assignment Logical Functions

Lecture 93 Text Functions in DAX

Lecture 94 Assignment - Text Functions

Lecture 95 Solution - Assignment Text Functions

Lecture 96 DAX Functions for Date & Time

Lecture 97 Assignment - Date Functions

Lecture 98 Solution - Assignment Date functions

Lecture 99 The DAX Function RELATED

Lecture 100 The DAX Function CALCULATE

Lecture 101 The Peculiar Case of Unmtached Totals

Lecture 102 Assignment - CALCULATE Function

Lecture 103 Solution - Assignment CALCULATE Function

Lecture 104 The ALL Function of DAX

Lecture 105 Assignment - CALCULATE & ALL

Lecture 106 Solution - Assignment Calculate & All

Lecture 107 The FILTER Function of DAX

Lecture 108 The Iterator Functions of DAX

Lecture 109 Assignment - Iterator Functions

Lecture 110 Solution - Assignment Iterator Functions

Lecture 111 Time Intelligence Functions in DAX

Lecture 112 Assignment – Time Intelligence

Lecture 113 Solution – Assignment Time Intelligence

Lecture 114 Best Practices - Using DAX

Section 6: Advanced DAX for Measures

Lecture 115 Introduction to Advanced DAX

Lecture 116 DAX Shortcuts

Lecture 117 Formatting DAX Code

Lecture 118 Comments in DAX Code

Lecture 119 Error Handling in DAX

Lecture 120 DAX Variables and Uses

Lecture 121 Evaluation Order for Variables

Lecture 122 Expert Tip - Debug & Test DAX

Lecture 123 Modifiers for CALCULATE Function

Lecture 124 Modifier - REMOVEFILTERS

Lecture 125 Modifier - KEEPFILTERS

Lecture 126 Assignment - Modifiers

Lecture 127 Solution - Assignment Modifiers

Lecture 128 Expert Tip - Advanced CALCULATE Uses

Lecture 129 Table & Filter Functions

Lecture 130 Calculated Virtual Tables

Lecture 131 The DISTINCT Function

Lecture 132 Versatile VALUES Function

Lecture 133 Table Relationships

Lecture 134 Iterator Cardinality

Lecture 135 CONCATENATEX Function

Lecture 136 Expert Tip - Dynamic Labels

Lecture 137 Requirements of a Date Table

Lecture 138 Calendar Function

Lecture 139 Expert Tip - Reusable Date Table

Lecture 140 Time Intelligence Functions

Lecture 141 PARALLELPERIOD Function

Lecture 142 PREVIOUSQUARTER Function

Lecture 143 SAMEPERIODLASTYEAR Function

Lecture 144 Additional Time Intelligence Calculations

Lecture 145 Best Practices - Advanced DAX

Section 7: Visualizing Data

Lecture 146 Introduction Visualizing Data on Dashboards

Lecture 147 Key Questions Before You Design

Lecture 148 Analytics Dashboard

Lecture 149 The Dashboard Layout

Lecture 150 Adding Pages & Objects to Report View

Lecture 151 Format & Selection Panes

Lecture 152 Cards & Multi-Row Cards

Lecture 153 Assignment - KPI Cards

Lecture 154 Solution - Assignment KPI Cards

Lecture 155 On-Object Formatting

Lecture 156 Adding Line Charts

Lecture 157 Expert Tip - Trend Lines & Forecasts

Lecture 158 Assignment - Line Chart

Lecture 159 Solution - Assignment Line Chart

Lecture 160 KPI Cards

Lecture 161 Doughnut & Bar Charts

Lecture 162 The Filter Options Pane

Lecture 163 Assignment - Doughnut Chart & Filters

Lecture 164 Solution - Assignment Doughnut Chart & Filters

Lecture 165 Tables & Matrix Visuals

Lecture 166 Conditional Formatting

Lecture 167 Top N Filter

Lecture 168 Assignment - Tables

Lecture 169 Solution - Assignment Tables

Lecture 170 Expert Tip - Top N Text Cards

Lecture 171 Assignment - Top N Cards

Lecture 172 Solution - Assignment Top N Cards

Lecture 173 New Card Visual

Lecture 174 Advanced Formatting - New Card Visual

Lecture 175 More Advanced Formatting - New Card Visual

Lecture 176 Assignment - New Card Visual

Lecture 177 Solution - Assignment New Card Visual

Lecture 178 Expert Tip - Sparkline Chart in Card

Lecture 179 Map Visual

Lecture 180 Slicers

Lecture 181 Assignment - Slicer

Lecture 182 Solution - Assignment Slicer

Lecture 183 New Button Slicer

Lecture 184 The DAX Function HASONEVALUE

Lecture 185 Radial Gauge Charts

Lecture 186 Expert Tip - Advanced Formatting Gauge Charts

Lecture 187 Area Charts

Lecture 188 Drill Up & Down

Lecture 189 Assignment - Drill Up & Down

Lecture 190 Solution - Assignment Drill Up & Down

Lecture 191 Cross-Report Drillthrough

Lecture 192 Editing Report Interactions

Lecture 193 Assignment - Report Interactions

Lecture 194 Solution - Assignment Report Interactions

Lecture 195 Power BI Bookmarks

Lecture 196 Assignment - Bookmarks

Lecture 197 Solution - Assignment Bookmarks

Lecture 198 Expert Tip - Custom Navigation Buttons

Lecture 199 Expert Tip - Slicer Panel

Lecture 200 Report Parameters

Lecture 201 Fields Parameters

Lecture 202 Assignment - Field Parameters

Lecture 203 Solution - Assignment Field Parameters

Lecture 204 Expert Tip - Custom Tooltips

Lecture 205 Assignment - Custom Tooltip

Lecture 206 Solution - Assignment Custom Tooltip

Lecture 207 Using Custom Visuals

Lecture 208 Using Roles in Power BI

Lecture 209 Mobile Layouts

Lecture 210 Preview - Publishing to Power BI Service

Lecture 211 Best Practices - Data Visualizations

Section 8: Artificial Intelligence in Power BI

Lecture 212 Introduction to AI in Power BI

Lecture 213 Anomaly Detection

Lecture 214 Smart Narrative Summaries

Lecture 215 Q&A Visuals

Lecture 216 Decomposition Tree

Lecture 217 Key Influencers

Section 9: Optimization Tools in Power BI

Lecture 218 Introduction to Optimization in BI

Lecture 219 Optimize Menu Ribbon

Lecture 220 Pausing Visuals

Lecture 221 Optimization Presets

Lecture 222 Applying AIl slicer button

Lecture 223 Performance Analyzer

Lecture 224 External Tools

Section 10: Power BI Updates & New Features

Lecture 225 About This Section

Those seeking a hands-on, project-based introduction to Power BI Desktop,Data analysts and Excel users aspiring to enhance their skills,Individuals aiming to master the top business intelligence tool,Students craving an engaging, interactive learning experience,Anyone eyeing a career in data analysis or business intelligence