English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 103 Lessons (16h 55m) | 3.03 GB
This Power BI Bootcamp will take you from absolute beginner in Power BI to being able to get hired as a confident and effective Business Intelligence Analyst. You’ll learn the full Power BI suite of tools, the M programming language, and the DAX formula language, all while analyzing real-world datasets and building enterprise-level projects.
We guarantee you that this is the best and most up-to-date Power BI Bootcamp or course that you can find. You’ll not only learn Power BI basics and fundamentals that most courses cover. You’ll also learn advanced topics, tools, and tricks to turn you into a top 10% Business Intelligence Analyst!
WHAT YOU’LL LEARN
- Become a top 10% Business Intelligence Analyst to enhance your skill set and career opportunities
- Analyze real-world datasets on fun subjects including Bigfoot and UFO sightings
- Build both guided and independent Power BI projects so that you can put your Power BI skills into practice and deeply understand the material
- Learn Power Query’s built-in graphical tools to fetch data from a variety of external sources, clean and transform it, and load it into Power BI
- Master the art and science of Power BI Data Modeling
- Leverage the M programming language to apply and edit advanced transformations that go beyond the functionality built into the Power Query interface
- How to create and customize Power BI’s most useful visualizations
- How to determine which visualizations are most appropriate for a given data analysis problem
- Construct a Data Model consisting of multiple distinct datasets, by identifying and establishing appropriate relationships between these datasets
- Create sophisticated metrics (KPIs) with the Power BI DAX programming language
- Make DAX code more readable and maintainable using whitespace, comments, and variables, plus using measure tables to organize your measures
- Learn why Power BI is the premier analysis & visualization tool
Table of Contents
1 Power BI Bootcamp Zero to Mastery
2 Introducing Power BI
3 Navigating the Power BI Interface
4 Installing and Configuring Power BI
5 ETL with Power BI
6 Fetching Data from Databases
7 Introducing Power Query
8 Applying Basic Transformations
9 Editing Transformations
10 Introducing the UFO Sightings Project
11 Solution UFO Sightings Project – Part I
12 Numeric Transformations
13 Date Transformations
14 Text Transformations
15 Conditional Transformations
16 Solution UFO Sightings Project – Part 2
17 Introducing Matrix Visualizations
18 Adding Layers to Matrix Visualizations
19 Navigating Matrix Visualizations
20 Formatting Visualizations
21 Data Bars
22 Conditional Formatting Rules
23 Solution UFO Sightings Project – Part 3
24 Introducing Measures
25 Creating Your First Measure
26 Customizing Measures
27 Solution UFO Sightings Project – Part 4
28 Column Charts
29 Column Chart Variations
30 Bar Charts
31 Line and Area Charts
32 Combo Charts
33 Visualizing Proportionality
34 Solution UFO Sightings Project – Part 5
35 Customizing Chart Interactions
36 Customizing Chart Formatting
37 Map Charts
38 Building Dashboards
39 Formatting the Report Environment.
40 Solution UFO Sightings Project – Part 6
41 Filtering Individual Visualizations
42 Filtering Multiple Visualizations
43 Slicers
44 Date Slicers
45 Solution UFO Sightings Project – Part 7
46 Previewing Data
47 Configuring Refresh Options
48 Merging Datasets
49 Appending Datasets
50 Aggregate Calculations
51 Introducing Oodles of Noodles (Meal Kit Delivery Service Project)
52 Solution Meal Kit Delivery Service Project – Part 1
53 Introducing the M Language
54 M Behind the Scenes
55 Creating Custom Columns with M
56 Creating Custom Filters with M
57 Using M Functions (Build a Calendar Table)
58 Solution Meal Kit Delivery Service Project – Part 2
59 Introducing the Model View
60 Understanding Relationships
61 Relationships in Power BI – Part 1
62 Relationships in Power BI – Part 2
63 Using Related Data in Visuals
64 Exploring Filter Context
65 Calendar Tables
66 Data Modeling Pitfalls
67 Multiple Data Tables
68 Two-Way Relationships
69 Solution Meal Kit Delivery Service Project – Part 3
70 Exercise Imposter Syndrome
71 Calculated Columns with DAX
72 The IF Function
73 SWITCH 101
74 SWITCH 201
75 The RELATED Function
76 Using DAX Functions in Measures
77 The CALCULATE Function
78 Going Deeper with CALCULATE
79 The ALL Function
80 Introducing Time Intelligence Functions
81 The ISBLANK Function
82 The DATEADD Function
83 The DATESINPERIOD Function
84 Formatting and Commenting Code
85 Variables
86 The X Functions
87 The RANKX Function
88 The TOPN Function
89 Creating a Measure Table
90 Data Modeling and Analysis Best Practices
91 Card Visuals
92 Single-Value Cards
93 KPI Cards
94 Gauge Charts
95 Analyzing Time Series Data
96 Changing Measures Dynamically
97 What-If Parameters
98 Bookmarks
99 Drillthrough
100 Mobile View
101 Solution 1 Meal Kit Subscription Service Project – Part 8
102 Solution 2 Meal Kit Subscription Service Project – Part 8
103 Thank You!
Resolve the captcha to access the links!