Home : Book details : Book description

Description of  Power Query And Power Bi Combo Course

Published 1/2024 MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz Language: English | Size: 1.68 GB | Duration: 3h 15m Learn Excel Power Query, Power Pivot and Power BI Tools. Learn how to analyze millions of rows of data in Power Query What you'll learn Power Query: Learn to extract, transform, and load data from various sources. Power Pivot: Transform raw data into a data model for meaningful analysis. Power BI: Create interactive reports and dashboards for effective data visualization. Power Map: Craft stunning interactive sales maps to analyze geographical trends. Turn data into insights: Quickly transform vast amounts of data into actionable information. Build reports and dashboards: Design captivating visuals to communicate insights clearly. Analyze data with speed and accuracy: Make informed decisions based on reliable data analysis. Start from scratch: Build your skills from the ground up, no prior knowledge required. Learn the latest tools: Master the current versions of Excel Follow along with practice files: Apply your learning to real-world scenarios. Regular course updates: Stay ahead of the curve with continuous content refreshes. Requirements Willingness for learning Description Overview Section 1: Power Query Course Lecture 1 Installing and Exploring Power Query Lecture 2 Power Query Interface Lecture 3 Power Query Update With Pivot Tables Lecture 4 Format Dates and Values in Power Query Lecture 5 Parsing URLs in Excel Power Query Lecture 6 Split Text Fields in Excel Power Query Lecture 7 Group By in Excel Power Query Lecture 8 Unpivoting Columns Lecture 9 Pivoting Columns in Power Query Lecture 10 Split Columns into Other Columns Lecture 11 Filtering Rows Lecture 12 Sorting Data in Power Query Lecture 13 Transform and Add Columns Lecture 14 Combine Excel Data Files in Power Query Lecture 15 Perform Auto Clean Up in Power Query Lecture 16 Extract Data from Forms in Power Query Lecture 17 Extract Multiple Criteria in Excel Power Query Lecture 18 Extract Multiple Worksheets in Excel Power Query Lecture 19 Introduction to Joins Lecture 20 Merging Tables In Power Query Using Joins Lecture 21 Merge Tables in Power Query With Outer Joins Lecture 22 Right Anti Join In Power Query Lecture 23 Convert Reports to Pivot Table in Power Query Lecture 24 Modulo to Arrange Data Lecture 25 Get a List of ?File Names Through Power Query Lecture 26 Get Files Names Based on User Selection Section 2: Power BI Course Lecture 27 1. Introduction to the Course Final Lecture 29 Loading the Data in Power BI Lecture 30 Creating Visuals Part 1 Lecture 31 Creating Visuals Part 2 Lecture 32 Editing Power BI Interactions Lecture 33 Finalizing the Report Visuals Lecture 35 Additional Tips and Conclusion Everyone who wants to master Excel Dashboards,Business analysts,Data analysts,Students