15 days of Power BI Complete Microsoft Power BI Bootcamp

Just 15 days to master Power BI Desktop + Power BI Service (Cloud) + Power BI Mobile in a project-based, practical way.
15 days of Power BI Complete Microsoft Power BI Bootcamp
File Size :
6.58 GB
Total length :
16h 47m

Category

Instructor

Nikolai Schuler

Language

Last update

Last updated 11/2022

Ratings

4.6/5

15 days of Power BI Complete Microsoft Power BI Bootcamp

What you’ll learn

Learn Power BI from scratch
Build Reports
Use DAX
Create Visualizations
Clean Data with PowerQuery
Connect to data sources

15 days of Power BI Complete Microsoft Power BI Bootcamp

Requirements

Windows PC. You can’t natively install Power BI on Mac or Linux.
The course is designed to take people from beginner to pro in just 15 days. We start from the basics and have a step-by-step guided approach stretched over 15 days

Description

Learn data visualization through Microsoft Power BI and create opportunities for you or key decision-makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.    You’ll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.    Use Microsoft Power BI to Analyze and Visualize Data So You Can Respond Accordingly    Connect Power BI to a Variety of Datasets    Drill Down and Up in Your Visualization and Calculate Data    Visualize Data in the Form of Various Charts, Plots, and Maps    Convert Raw Data Into Compelling Data Visualizations Using Microsoft Power BI    Each section provides exercises that will challenge you so you can learn by immediately applying what you’re learning.    Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.    Contents and Overview    This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.    To be able to find trends in your data and make accurate forecasts, you’ll learn how to work with hierarchies and time series.    Also, to make data easier to digest, you’ll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.    In order to begin visualizing data, you’ll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.    You’ll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.    Finally, you’ll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brick charts, and more.    By the time you complete this course, you’ll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.    You’ll be fully prepared to collect, examine, and present data for any purpose, whether you’re working with scientific data or you want to make forecasts about buying trends to increase profits.

Overview

Section 1: Day 1 – Beginner – Understanding the Basics

Lecture 1 Motivation & About this course

Lecture 2 Tips to get the most out of the course

Lecture 3 Goals Day 1

Lecture 4 Understanding Power BI

Lecture 5 Download & Install

Lecture 6 Quick note on the next lecture

Lecture 7 Get excited – Challenge!

Lecture 8 The 3 Views in Power BI

Lecture 9 Important: Initial Settings

Lecture 10 Our project & getting data

Lecture 11 Query Editor – Basic data cleaning

Lecture 12 Working with the attached project files

Lecture 13 Edit rows & columns

Lecture 14 Data Types

Lecture 15 Replacing values

Lecture 16 Summary of today

Section 2: Day 2 – Beginner – Data Prep & Data Model Fundamentals

Lecture 17 Goals Day 2

Lecture 18 Exctracting values

Lecture 19 Split columns

Lecture 20 Text operations

Lecture 21 Numerical operations

Lecture 22 Creating relationships (data model)

Lecture 23 Practice: Data Cleaning & Relationship

Lecture 24 Solution: Data Cleaning & Relationship

Lecture 25 Solution: Data Cleaning & Relationship

Lecture 26 Stacked column chart

Lecture 27 The Format tab

Lecture 28 Pie Chart – Guidelines

Lecture 29 Pie chart

Section 3: Day 3 – Intermediate – Data Prep & Visualization

Lecture 30 Goals Day 3

Lecture 31 Append Queries

Lecture 32 Merge & Group

Lecture 33 Dates & Hierarchies

Lecture 34 Line Chart

Lecture 35 Files from folder

Lecture 36 Fact-Dimension model

Lecture 37 Edit relationships & cardinality

Lecture 38 Activate & deactivate relationships

Lecture 39 Manage & autodetect relationships

Section 4: Day 4 – Intermediate – Data Transformations

Lecture 40 Goals Day 4

Lecture 41 Tables

Lecture 42 Customizing tables

Lecture 43 Conditional formatting

Lecture 44 Merging Queries

Lecture 45 Unpivot & Pivot

Lecture 46 Many-to-Many Relationship

Lecture 47 Filter Visual

Lecture 48 Edit page

Section 5: Day 5 – Intermediate – Interactive Visualizations

Lecture 49 Goals Day 5

Lecture 50 Filters Pane

Lecture 51 TopN Filter

Lecture 52 Sync Slicers

Lecture 53 Treemap Visuals

Lecture 54 Edit interactions

Lecture 55 Drillthroughs

Lecture 56 Keep filters with drillthroughs

Lecture 57 Tooltips

Lecture 58 Custom column

Lecture 59 Enable & Disable Load

Lecture 60 References vs. Duplicates

Lecture 61 Columns from example

Section 6: Day 6 – Advanced – Visualization

Lecture 62 Goals Day 6

Lecture 63 Visual Header & Sorting

Lecture 64 Conditional column

Lecture 65 Maps

Lecture 66 Filled Maps

Lecture 67 Forecasts

Lecture 68 Drillthrough with Button

Lecture 69 Bookmarks

Lecture 70 Challenge: Top Products

Lecture 71 Cards

Lecture 72 Multi-Row Cards

Section 7: Day 7 – Advanced – Templates, R scripts, Tooltips

Lecture 73 Goals Day 7

Lecture 74 Tooltips Page

Lecture 75 Working with templates

Lecture 76 Visualizing using R scripts

Lecture 77 R script for the next lecture

Lecture 78 Libraries & Get data using R

Lecture 79 Working with R to transform data

Lecture 80 Working with parameters

Section 8: Day 8 – Pro – Parameters & Functions

Lecture 81 Goals Day 8

Lecture 82 Parameters with lists & queries

Lecture 83 Get data from a web page

Lecture 84 Use parameters with web page

Lecture 85 Challenge (Solution)

Lecture 86 Invoking a custom function

Section 9: Day 9 – DAX – The Essentials

Lecture 87 Goals Day 9

Lecture 88 Understanding Calculated Columns

Lecture 89 Understanding Measures

Lecture 90 AVERAGE

Lecture 91 COUNT, DISTINCTCOUNT, COUNTROWS

Lecture 92 SUMX

Lecture 93 AVERAGEX & ROUND

Lecture 94 RELATED & Data Model

Lecture 95 CALCULATE

Lecture 96 Filter problems

Lecture 97 FILTER

Lecture 98 Logical operators

Lecture 99 Formatting & Commenting

Lecture 100 DAX Challenges

Lecture 101 Solutions

Section 10: Day 10 – DAX – Advanced

Lecture 102 Goals Day 10

Lecture 103 ALL

Lecture 104 ALL on columns

Lecture 105 ALLEXCEPT

Lecture 106 ALLSELECTED

Lecture 107 DATEADD

Lecture 108 Year-to-Date & Month-to-Date

Lecture 109 ROUNDING functions

Lecture 110 FORMAT

Lecture 111 Complete Date Table with features

Lecture 112 DAX Challenges

Lecture 113 DAX Solutions

Section 11: Day 11 – Publishing Reports & Power BI Service (Intermediate)

Lecture 114 Goals Day 11

Lecture 115 How to go on from here?

Lecture 116 Power BI Pro vs Free vs Premium

Lecture 117 Sign up for free

Lecture 118 Alternative method without work mail

Lecture 119 Quick Interface Tour

Lecture 120 My workspace

Lecture 121 Publishing reports

Lecture 122 Editing reports

Lecture 123 Updating reports with Power BI Desktop

Lecture 124 Creating & Exploring Workspaces

Section 12: Day 12- Scheduling, Data Gateway & Mobile App (Advanced)

Lecture 125 Goals Day 12

Lecture 126 Installing & using a Data Gateway

Lecture 127 Scheduled refresh

Lecture 128 Creating apps

Lecture 129 Creating Dashboards

Lecture 130 Get Quick Insights

Lecture 131 Using Mobile App

Lecture 132 Creating Mobile Layout

Section 13: Day 13 – Row-Level & Page-Level Security (Pro)

Lecture 133 Goals for Day 13

Lecture 134 Basic Row-Level Security

Lecture 135 Row-Level Security in the cloud

Lecture 136 Data Model & Row-Level Security

Lecture 137 Dynamic RLS

Lecture 138 Many-to-Many RLS

Lecture 139 Page-Level Security

Section 14: Day 14 – Python, Machine Learning & SQL (Pro)

Lecture 140 Goals for Day 14

Lecture 141 Plan of action

Lecture 142 Setting up Python for Power BI

Lecture 143 Transforming data using Python

Lecture 144 Python script I used in the next lecture

Lecture 145 Creating visualizations using Python

Lecture 146 Python script II used in the next lecture

Lecture 147 Violin plots, pair plots & ridge plots using Python

Lecture 148 Python script III used in the next lecture

Lecture 149 Machine learning (BayesTextAnalyzer) using Python

Lecture 150 Performance & Troubleshooting

Lecture 151 Loading data from web in JSON

Lecture 152 Setting up a MySQL database

Lecture 153 Loading data from SQL database

Section 15: Day 15 – M language Fundamentals (Pro)

Lecture 154 Goals for Day 15

Lecture 155 What is the M language?

Lecture 156 Basics about the advanced editor

Lecture 157 Values & Lists

Lecture 158 Table functions & transforming columns

Lecture 159 Quick Challenge 1

Lecture 160 Each & Table.AddColumns

Lecture 161 Quick Challenge 2

Lecture 162 More functions & Next steps

Section 16: Congratulations

Lecture 163 You made it!

Lecture 164 Bonus lecture

Anyone that has never used Power BI before and is looking for a hands-on approach to learn it,Anyone working with data and get professional working with Power BI,Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant

Course Information:

Udemy | English | 16h 47m | 6.58 GB
Created by: Nikolai Schuler

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top