kingers Posted April 18 Report Share Posted April 18 Become An Expert In Microsoft Power Bi Desktop Published 4/2024 MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz Language: English | Size: 11.39 GB[/center] | 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 intelligencehttps://voltupload.com/a1szrmpsvw31/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z01https://voltupload.com/uutyt3susuwv/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z02https://voltupload.com/zrad2hd7yoix/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z03https://voltupload.com/qvmtt1ti6fho/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z04https://voltupload.com/e68a36a3a5ni/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z05https://voltupload.com/olsh3cckwb3d/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z06https://voltupload.com/6igmwxhfwzl3/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z07https://voltupload.com/aar4db5l1tti/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z08https://voltupload.com/ztccwxybf769/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z09https://voltupload.com/3jp47g3kygri/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z10https://voltupload.com/jid7akb6upk0/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z11https://voltupload.com/ba8bokcghq09/Become_An_Expert_In_Microsoft_Power_BI_Desktop.ziphttps://rapidgator.net/file/1e54053b34f6dc6d6c7c595de2f60ab7/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z01https://rapidgator.net/file/9c379d4bf8053a2afdbcb30670dff66e/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z02https://rapidgator.net/file/65e14508c4088e9028664bd9d24b2233/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z03https://rapidgator.net/file/05bf63d042252947dbbd87c026875f36/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z04https://rapidgator.net/file/ea631085581a4fbcc18e78f03c199630/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z05https://rapidgator.net/file/14dca9e102bb2027ffd09be771703200/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z06https://rapidgator.net/file/fe84d2916a2d821791d26f46632d460e/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z07https://rapidgator.net/file/2fdbebab4913bc7486360b228a492953/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z08https://rapidgator.net/file/901dd2b1de9cc7a92e421f6c2c700a92/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z09https://rapidgator.net/file/82939236025d373d00caff4fc5cb171d/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z10https://rapidgator.net/file/23cc06930e46085be26a9ae260f9f83b/Become_An_Expert_In_Microsoft_Power_BI_Desktop.z11https://rapidgator.net/file/a0b0d27ebd8f9c68adf1105a65686eb5/Become_An_Expert_In_Microsoft_Power_BI_Desktop.zipFree search engine download: Become An Expert In Microsoft Power BI Desktop Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now