Microsoft Power Bi Desktop : The Practical 2023 Bootcamp!

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