Become An Expert In Microsoft Power Bi Desktop

Free Download Become An Expert In Microsoft Power Bi Desktop
Published 4/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 11.39 GB | Duration: 26h 3m
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
Homepage

https://www.udemy.com/course/become-an-expert-in-microsoft-power-bi-desktop/