Microsoft Power Bi Desktop – The Practical 2023 Bootcamp!

Free Download Microsoft Power Bi Desktop – The Practical 2023 Bootcamp!
Published 12/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.75 GB | Duration: 6h 19m
Learn Power BI from scratch with hands-on exercises for Data Cleaning, Data Modelling and Data Visualization!

What you’ll learn
Master Power BI Basics: Acquire a solid foundation in Power BI Desktop, including data connections, data transformation, and the creation of basic visualization
Advanced Data Transformation: Dive deep into Power Query for sophisticated data cleansing, shaping, and transformation, ensuring data is optimized for analysis.
Data Modelling: Understand the principles of effective data modeling, optimizing relationships and hierarchies to create a solid foundation for analysis.
Dynamic Visualizations: Learn to create dynamic and interactive visualizations, dashboards, and reports that effectively communicate insights to stakeholders.
Requirements
A PC running the Windows Operating System.
Description
Elevate Your Data Analysis Skills with the Ultimate Microsoft Power BI Desktop: The Practical 2023 Bootcamp! Unlock the full potential of Microsoft Power BI Desktop in our immersive and hands-on bootcamp designed for 2023! Master the art of transforming raw data into actionable insights with this comprehensive course that combines theory with real-world applications.Course Highlights:Business User-Friendly: Tailored for business professionals, this bootcamp emphasizes practical skills that resonate with executives, managers, and decision-makers.Cutting-Edge Content: Stay ahead in 2023 with the latest Power BI Desktop features and functionalities. From data preparation to advanced visualization techniques, we’ve got you covered.Hands-On Learning: Dive deep into practical exercises ensuring you not only understand the concepts but can apply them confidently in your professional environment.Data Modeling: Understand the art of designing robust data models, ensuring accuracy and efficiency in your analytics process.Strategic Data Visualization: Learn the art of creating compelling dashboards and reports that communicate insights effectively. Impress your stakeholders with visually stunning and data-driven presentations.Expert Guidance: Our experienced instructors bring a wealth of knowledge and industry insights to guide you through the complexities of Power BI Desktop. Get personalized feedback and support to enhance your learning journey.Career Advancement: Whether you’re a beginner or an experienced professional, this bootcamp is designed to elevate your career. Boost your resume with sought-after Power BI skills and open doors to exciting job opportunities.Lifetime Access: Access course materials, updates, and a vibrant community of learners even after completion. Stay connected with the latest trends in data analysis.Global Community Access: Connect with a diverse network of professionals worldwide, fostering collaboration, knowledge sharing, and potential career opportunities.Enroll now to embark on a 30-day journey from a Power BI novice to an advanced user, equipped with the skills demanded by today’s dynamic business landscape! Whether you’re a business analyst, data professional, or decision-maker, this bootcamp is your gateway to mastering the art and science of data-driven decision-making.
Overview
Section 1: Introduction
Lecture 1 Download the Course Datasets!
Section 2: Say Hello to Power BI Desktop
Lecture 2 Downloading Power BI Desktop
Lecture 3 What is ETL?
Lecture 4 ETL – Power BI
Lecture 5 The Power BI Lifecycle
Lecture 6 First Look at the Interface
Section 3: Connecting to and Preparing Data
Lecture 7 Introduction to Data Connectors
Lecture 8 Loading in a CSV file!
Lecture 9 The Power Query Interface
Lecture 10 Renaming Fields and Data Types
Lecture 11 EDA – Column Quality
Lecture 12 EDA – Column Profile and Distribution
Lecture 13 Dropping & Preserving Rows and Columns
Lecture 14 Split Columns
Lecture 15 Format Tool
Lecture 16 Merge Columns
Lecture 17 Transform vs. Add Column
Lecture 18 Extract Tool
Lecture 19 Conditional Columns
Lecture 20 Duplicating Columns and Adding Indexes
Lecture 21 Date Tool
Lecture 22 Numerical Tools
Lecture 23 Statistics and Count Rows
Lecture 24 Append Queries
Lecture 25 Group By
Lecture 26 Data Source Settings
Lecture 27 Imp. – Connecting to a Folder!
Lecture 28 Bringing it all together
Lecture 29 Enable/Disable Load
Section 4: Data Modeling
Lecture 30 What is Normalization?
Lecture 31 Primary Keys
Lecture 32 Foreign Keys
Lecture 33 Fact and Dimension Tables
Lecture 34 Star Schema
Lecture 35 Snowflake Schema
Lecture 36 What’s a Join?
Lecture 37 Merge Queries
Lecture 38 Cardinality
Lecture 39 Configuring our Data Model
Lecture 40 Configuring our Data Model – Contd.
Lecture 41 A simple enhancement to our data model
Section 5: Visualizing Data & Creating Dashboards
Lecture 42 Imp. settings
Lecture 43 Creating a Matrix
Lecture 44 Creating a Bar Chart
Lecture 45 Creating Stacked & Clustered Bar Charts
Lecture 46 Creating a Line Chart
Lecture 47 Creating Area Charts
Lecture 48 Trick : Formatting
Lecture 49 Line and Stacked Column Chart
Lecture 50 Adding Cards
Lecture 51 Adding more Cards
Lecture 52 Pie Chart
Lecture 53 Donut Chart
Lecture 54 Conditional Formatting a Matrix
Lecture 55 Funnel Chart
Lecture 56 Treemap
Lecture 57 Gauge Chart
Lecture 58 KPIs
Lecture 59 Filtering
Lecture 60 Slicers
Lecture 61 Map Visuals
Section 6: Conclusion
Lecture 62 Bonus Lecture
Decision-makers: Executives, managers, and decision-makers interested in gaining a strategic understanding of Microsoft Power BI to lead data-driven initiatives,Data Enthusiasts: Individuals eager to explore the world of data analysis and visualization, seeking practical skills to turn raw data into actionable insights.,Business Analysts: Professionals aiming to enhance their analytical capabilities, create compelling reports, and drive informed business decisions.,IT Professionals: IT experts looking to leverage Microsoft Power BI Desktop as a powerful tool for data analysis, reporting, and visualization within their orgs,Excel Power Users: Those familiar with Excel seeking to elevate their data manipulation and visualization skills, transitioning seamlessly to Power BI!,Career Changers: Individuals considering a career shift into the dynamic field of data analysis and Business Intelligence

Homepage

https://www.udemy.com/course/microsoft-power-bi-desktop/