Mô tả

In this course, get ready to kick off your business intelligence career with a variety of focused content built to equip you with the skills you will need to break into a rewarding and competitive BI industry. Yes, it's yet another Intro to Power BI course—but this class will also focus on enhancing your burgeoning Power BI skills with a variety of other areas that are sure to elevate your dashboarding & reporting acumen beyond simple data charts and tables.

Power Pivoting combines in-depth Power BI tutorials with business intelligence career discussion videos, demonstrations of impactful design and data storytelling techniques, intermediate-level tips and tricks for wowing your business users, almost a dozen hands-on DAX demonstrations, and a full-length Power BI walkthrough that will take you all the way from importing your data to building a tool that's ready to publish.

If you are considering getting your hands dirty with data and transitioning from a non-data career into one where transforming data, calculating metrics, and telling complex data stories through simple visualizations are just another day in the office, this is the course for you. The road to a successful BI career transition can be a long and difficult one; this class will walk you through everything you need to know from a Power BI perspective alongside an instructor who went through that transition himself and never looked back.

Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

15 sections

Instructor & Topic Introduction

1 lectures
Instructor & Topic Introduction
32:45

BI 101: Introduction to Business Intelligence

4 lectures
Part 1: Introduction to Business Intelligence
46:52
Part 2: What Does a BI Professional Actually Do?
25:25
Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 1)
17:58
Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 2)
25:26

BI 101: The Business Intelligence Career Toolkit

2 lectures
The Business Intelligence Career Toolkit
42:56
Career Topic: What Makes a Great BI Resume?
37:04

BI 101: Introduction To Microsoft Power BI

3 lectures
Introduction to Microsoft Power BI
38:20
Walkthrough of a Microsoft Power BI Report Example
14:59
Career Topic: Let's Talk About Business Intelligence Careers
34:21

Data Modeling 101: Transforming Data with the Power Query Editor

3 lectures
Transforming Data with the Power Query Editor
28:45
Tutorial: Applying Power Query Editor Transformations to a Dataset
35:40
Tutorial: Building a Date Table with the Power Query Editor
29:37

Data Modeling 101: Data Modeling Concepts

3 lectures
Data Modeling Concepts with the Power Query Editor
29:04
Tutorial: Modeling an HR Dataset into a Star Schema
45:12
Career Topic: What Makes a Great Power BI Portfolio?
25:24

Front-End BI Design 101: Data Visualization 101

9 lectures
Choosing the Right Data Visual
36:36
Tutorial: Bar Charts
19:01
Tutorial: Line Charts
17:26
Tutorial: Area Charts
08:23
Tutorial: Donut Charts & Cards
13:24
Tutorial: Maps
14:41
Tutorial: Tables & Matrices
23:42
Tutorial: Scatter Plots
13:11
Bonus Tutorial: Slicers
16:11

Front-End BI Design 101: The Art of Designing BI Tools

3 lectures
Design Techniques for Power BI
37:48
Introduction to Data Storytelling
22:04
Tutorial: Applying Gestalt Techniques
43:13

Front-End BI Design 101: Data Visualization 102

3 lectures
Applying Design Techniques to Data Visualization in Power BI
32:32
Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 1)
39:53
Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 2)
43:03

Front-End BI Design 101: Building Power BI Tools for Interactivity

6 lectures
Building Power BI Tools for Interactivity
26:59
Tutorial: Deploying Buttons in Power BI
18:00
Tutorial: Introduction to Power BI Bookmarks
35:19
Clarification: Navigating Bookmark Settings
05:45
Tutorial: Unlocking the Magic of Hovering with Tooltip Report Pages
20:14
Tutorial: Get Drilling with Drill-Through Pages
20:23

Intermediate Topics: Data Analysis Expression (DAX)

11 lectures
The One About DAX
26:53
Tutorial: Basic Measures
21:05
Tutorial: Filter Functions
21:38
Tutorial: Logical Functions
17:13
Tutorial: Calculated Columns
13:18
Tutorial: Text Functions
28:11
Tutorial: Date Functions
13:10
Tutorial: Time-Series Analysis Part 1
20:28
Tutorial: Time-Series Analysis Part 2
31:30
Tutorial: Advanced Aggregations
17:24
Tutorial: Quick Measures
18:04

Intermediate Topics: Smart Visuals and Intermediate Design Techniques

10 lectures
Introduction
09:08
Smart Visuals: Key Influencers
13:18
Smart Visuals: Decomposition Tree
10:37
Smart Visuals: Q&A Visual
15:25
Smart Visuals: Smart Narrative
10:52
Design Technique: Building a Slicer Panel
21:11
Design Technique: Understanding Disconnected Slicers
12:34
Design Technique: Field Parameters
11:28
Design Technique: BYOB (Build Your Own Buttons)
07:03
Design Technique: Building a Data Sandbox for Your Users
11:52

Applying Power BI: Publishing Reports to the Power BI Service

3 lectures
Publishing to the Power BI Service
38:11
Tutorial: Walkthrough of the Power BI Service
30:50
Career Topic: Preparing for the BI Interview
34:54

Applying Power BI: Full-Length Tutorial (Toy Company Sales Dataset)

11 lectures
Toy Company Sales Data Overview
04:19
Designing Our Layout
09:34
Importing Our Color Theme
05:12
Modeling the Toy Company Sales Datasets
12:12
Handling Background Images
03:12
Building Our DAX Measure Tables
06:11
Writing our DAX Sales Performance Measures
23:01
Formatting Our Sales Performance Page
23:10
Building a Product Performance Page
21:49
Building a Store Performance Page
29:07
Projecting Sales Performance Against an Annual Target
44:27

Course Summary & Next Steps

2 lectures
Course Summary & Wrap-Up
38:50
Continuing Your Journey: The Microsoft Power Platform & Azure Synapse Analytics
30:32

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.