Prezentacja danych w PowerBI:
Power BI LearnIt Tutorial 2020
Part 1 and Part 2 – Basic
Start 0:00 Introduction 0:03 Downloading Software 1:18 What is Power BI? 6:34 Course Trajectory 7:56
Part 1. Introduction to Part 1 11:00 What is a Query or Power Query? 12:28 Querying Data 14:49 Query Excel Files 16:17 Normalizing Concepts 20:54 Appending Queries 25:00 Querying Web Pages 30:29 Merging Queries (Part 1) 34:33 Merging Queries (Part 2) 36:34 Normalizing Data 42:27 Lab – Querying Data and Analyzing Results 57:36 Limitations of Excel’s Pivot Tables 58:30
Part 2. Introduction to Power BI Desktop 1:08:18 Querying 1:12:29 Creating Basic Visuals 1:19:36 Customizing Basic Visuals 1:24:44 Map Visuals 1:29:24 Card Visuals 1:32:38 Shapes and Text Boxes 1:36:29 Slicers 1:39:23 Gauge Visuals 1:41:11 Lab – Creating Reports 1:44:25 Lab – Walkthrough (Part 1) 1:45:53 Lab – Walkthrough (Part 2) 1:56:30 Conclusion 2:07:06
19.11.2022
Part 3 – Advanced
Advanced. Start 0:00 Introduction 00:03 Opening Power Pivot 11:09 Importing from Access 15:06 Save and Save Often 20:55 Importing from Excel 21:50 Creating Power Pivot Tables 26:26 Creating Relationships 33:36 Calculated Columns 37:52 Basic Measures 47:03 DAX & Derived Measures 54:55 CALCULATE 1:03:07 Lab – Creating Measures 1:11:59 Importing Excel Data Model into Power BI 1:13:33 Measures in Power BI 1:17:19 Visualizing Measures 1:22:33 Creating Calendar Tables 1:27:38 Save and Save Often 1:42:10 Sorting by Column 1:42:31 Drilling Down 1:46:12 Lab – Creating Analysis Reports 1:49:51 Publishing to Power BI Online 1:50:39 Creating Dashboards 1:53:07 Sharing Dashboards 2:01:26 Q&A 2:05:43 Conclusion 2:07:25
Part 4 – Master
Master. Start 0:00 Introduction 0:03 Querying SharePoint Lists 1:17 Unpivot Columns 5:01 Copying and Pasting M Script 13:22 M Language Basics 19:20 Creating a Calendar Table with List.Dates 22:22 Adding Metadata with M Functions 27:36 Reusing Calendar M Script in Excel 29:01 Custom Query Functions 31:54 DATESYTD 37:13 DATESYTD and DATESMTD 45:15 DATEADD 47:23 DATESBETWEEN 53:45 Complicated Relationships 58:17 Granularity Discrepancies 1:02:54 Inactive Relationships 1:07:54 Many to Many 1:13:07 Introduction 1:23:40 Filter Context Flows Downstream 1:25:14 Order of Operations 1:30:56 ALL to Clear Structural Filters 1:35:41 ALL – Choosing the Right Table 1:42:32 FILTER 1:49:05 Disconnected Tables 1:56:45 Lab Results 2:07:18 Disconnected Visuals 2:08:23 Row Level Security 2:12:22 Custom Visuals 2:16:49 Republish Dashboard 2:22:49 Excel Objects in Power BI Online 2:25:35 Designing for Mobile 2:28:38 Using the Power BI Mobile App 2:29:45 Alerts 2:32:01 Conclusion 2:34:23
Start 0:00 Introduction 0:03 Data Analytics 5:44 Licensing Options 8:03 Products and Services 10:09 Accessing Course Exercise Files 12:46 Reviewing Exercise File Data 13:01 Getting Data from Multiple Sources 14:17 Getting Data from Excel 16:14 Saving 18:21 Touring Report View 20:55 Touring Data View 25:49 Touring Model View 28:04 Starting New Instances of Power BI Desktop 30:28 Splash Screen 32:28 Getting Data from Access Database 35:32 Selecting Related Tables 40:05 Viewing Table Relationships and Settings 42:42 Accessing a Web URL 47:11 Getting Data from the Web 49:13 Web Authentication and Loading Tables 51:41 Exploring Web Data Inconsistencies 54:59 Optimizing Performance with Excel Files 57:06 Optimizing Performance with Power Pivot Data Model 59:25 Connecting to Underlying PivotTable Data 1:01:04 Importing from Power Pivot Data Model 1:03:15 Resolving Data Load Error 1:06:45 Resolving Data Path Error 1:09:51 Resolving Refresh Error 1:13:18 Exploring Power View Visualization Error 1:16:01 Implications of Locally Stored vs Cloud Based Excel Files 1:19:24 Locally Stored Excel Files 1:19:53 Refreshing In-Desktop and In-Service 1:22:02 Cloud-Based Excel Files 1:24:48 Publishing Cloud-Based Files to the Service and Refreshing 1:30:44 Conclusion 1:35:31
Start 0:00 Introduction 0:03 Data Shaping – Renaming Tables 0:42 Data Shaping – Promoting the First Row 2:21 Data Shaping – Duplicating Column Replace Values 4:41 Data Shaping – Removing Columns 7:29 Data Shaping – Filtering, Sorting, and Applying Changes 9:36 Introduction to Enhancing Data Structure 13:52 Enhancing Data Structure – Join Types Merge Queries 16:25 Data Profiling Recap 21:16 Introduction to Designing a Data Model 26:03 Working with Tables 27:09 Fact vs Dimension 33:04 Breaking Down Tables 34:30 Creating Hierarchy 41:10 Relationships aka Cardinality 43:26 Creating Relationships 45:20 Reviewing the Model Interface 51:26 Creating RLS Roles in Desktop 55:10 Assigning Users to RLS Roles in Service 59:34 Conclusion 1:01:59
Start 0:00 Introduction 0:03 Creating Calculated Tables 2:08 Creating Calculated Columns – DATEDIFF 6:03 Creating Calculated Columns – RANKX Highest 9:32 Creating Calculated Columns – RANKX Lowest 12:54 Creating Calculated Columns – RANKX Dense 18:50 Creating Quick Measures 20:40 Creating Measures 26:54 Creating Date Tables 31:38 Time Intelligence Functions 41:59 Key Performance Indicators 46:13 Additional Key Performance Indicators 49:59 DAX Recap 53:44 Introduction to Optimizing Model Performance 54:41 Publishing Dataset to Service 57:16 Using DirectQuery on Power BI Dataset 59:48 DirectQuery vs Import File Size Comparison 1:01:46 Importance of Variables 1:05:09 Building a Measure to Use in a Measure 1:07:11 Building a Measure with Variables and Comments 1:09:06 Adding Measures to Multi-Row Card 1:16:59 Other Optimization Techniques 1:19:53 Conclusion 1:21:23
Start 0:00 Introduction 0:03 Creating Reports with Pie Charts 2:09 Adding Tooltips to Reports 4:00 Formatting Reports with Pie Charts 6:25 Filtering and Sorting Reports 10:34 Sync Slicers 18:16 Creating Drill Through Pages 25:18 Creating Source Reports with Slicers 28:27 Using Drill Through 32:40 Formatting Drill Through Pages 35:52 Formatting Two Objects at Once 40:53 Conditional Formatting 42:45 Bookmarks 47:47 Accessibility Features 51:13 Accessibility – Alt Text-Data Table-Focus View 53:00 Accessibility – Tab Order 58:07 Accessibility – Colorblind Friendly Theme 1:00:08 Adding the Histogram Visualization 1:01:17 Creating Histograms 1:03:55 Copy Visual 1:11:16 Reports Recap 1:13:58 Introduction to Creating Dashboards 1:14:32 Creating Dashboards – Editing Published Reports and Pinning to a New Dashboard 1:16:57 Introduction to Real-Time Dashboards 1:24:33 Creating Forms for Pushing Data 1:27:18 Creating Push Datasets 1:33:01 Creating Reports for Real-Time Dashboards 1:37:38 Creating Dashboards for Streaming Data 1:41:58 Accessing Power Automate 1:44:15 Creating a Flow to Push Form Data into Dataset 1:46:14 Respond to Survey 1:52:51 Viewing Real-Time Dashboards 1:53:48 Enhancing Dashboards with Custom Themes 1:56:59 Enhancing Dashboards with Videos 2:00:08 Configuring Dashboard Tile Alerts 2:02:31 Using Q and A and Quick Insights and Add to Dashboard 2:05:16 More Dashboard Features 2:11:48 Conclusion 2:17:48
Start 0:00 Introduction 0:03 Loading Sample Data and Making Workspace Premium 2:49 Downloading Report Builder and Creating Paginated Reports 7:29 Sorting Reports in Design View 14:03 Adding Report Headers and Making Them Repeat Across Pages 17:26 Making Column Headers Repeat Across Pages and Publishing Reports 21:48 Reviewing Paginated Reports – Print Preview and Export Options 27:48 Paginated Reports Recap 33:37 Introduction to Performing Advanced Analytics 34:29 Accessing a Sample Desktop File from the Service 35:42 Advanced Analytics – Grouping 39:22 Advanced Analytics – Binning 42:52 Advanced Analytics – Drill Down and Up 47:16 Advanced Analytics – Analyze Feature 56:13 Data Insights Through AI Visuals 59:57 Creating Animated Scatter Charts 1:06:06 Using Visuals to Forecast Values 1:09:22 Creating Custom Analytics Visuals 1:16:57 Conclusion 1:23:02
Start 0:00 Introduction 0:03 Sharing Dashboards 0:51 Revoking Sharing Privileges 2:32 Sharing Reports 4:06 Copying Reports to Other Workspaces and Workspace Roles 6:58 Creating and Publishing Apps 10:48 Managing Workspaces Recap 17:41 Introduction to Managing Datasets 18:21 Creating Parameters 19:46 Editing Parameters in the Service and Refreshing Datasets and Visuals 20:23 Refresh Options 25:44 Managing Datasets Recap 30:03 Conclusion 33:35
Convert pictures, GIFs and videos to DAX measures Microsoft certified custom visuals for Power BI, such as the HTML Tex Styler, are not allowed to access the internet, which makes it impossible to display elements such as pictures, videos or GIFs, which are hosted on a website. With the converter below, you can simply upload … Continue reading