How to Get Started with Power BI

How to Power BI June 20, 2022
Video Thumbnail
How to Power BI Logo

How to Power BI

@HowtoPowerBI

About

I am Bas and I am here to teach everything I know about Power BI. My journey started a long, long time ago with VBA, Power Query and finally Power BI. Over the years I've build DataTraining.io, where I train and consult international organizations in Power BI and Tableau. Recently, I have decided to take everything I know and share it online, so that I can help more people :) Follow along to get an independent view on Power BI, Power Query and Power Apps. I always share my honest take on features, applications and limitations. 📊 TRAININGS 📊 --------------------------------- Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero For Custom Trainings and Consulting email directly [email protected] 😍 JOIN 😍 ---------------------------------- Subscribe: https://bit.ly/31MnQGO​ Website: https://www.datatraining.io Thanks for being a part of this channel 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​

Video Description

You want to get started with Power BI, but are not sure how? In this video I show you how to go from Excel to Power BI - step by step. In this complete walkthrough you learn about how to move from a normal pivot table in Excel to Power Pivot and use Power Query for data cleaning. You will see that once you know how they work in Excel, the transition to Power BI is quite straight forward. In Power BI you will learn all the things you need to know to get up and running. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download file here https://datatraining.io/powerbi-how-to -------------------------------- 📊 TRAININGS 📊 --------------------------------- Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Power BI Essentials https://datatraining.io/powerbilearningpath Business User Training https://datatraining.io/powerbi-business-users For Custom Trainings and Consulting email directly [email protected] --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 00:33 Why you want to work with tables 03:38 Creating a basic pivot table 04:41 Matching data into 1 table to use all of it in 1 pivot table 08:39 Linking tables using Power Pivot - Data Model 15:49 Fact table vs dimensions and adding a adding a date table / calendar 17:47 Using DAX: Data Analysis Expressions 19:59 Using Power Query for data cleaning 24:20 Loading data to Power Pivot 27:04 Creating the data model and doing checks in a pivot table 28:52 Run a refresh to import new data 29:57 Visualizing in excel - building an interactive report 35:35 Importing and cleaning data using Power Query in Power BI 39:58 Building a data model in Power BI 43:54 Creating visualizations and a report in Power BI 50:42 Using quick measures for calculations 52:23 Publishing to Power BI Service 53:42 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Join https://bit.ly/4b453bi Subscribe https://bit.ly/31MnQGO​ Insta https://www.instagram.com/howtopowerbi/ LinkedIn https://www.linkedin.com/in/basdohmen/ TikTok https://www.tiktok.com/@how.to.power.bi X https://twitter.com/HowToPowerBI fb https://www.facebook.com/groups/howtopowerbi Threads https://www.threads.net/@howtopowerbi Newsletter https://datatraining.io/newsletter --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://amzn.to/47F21Yc 📚 Power BI books MUST READ! https://amzn.to/3tUfFcj 💡 General books I recommend https://amzn.to/48YNo33 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://amzn.to/3HqfMQ2 * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Power BI Beginner's Kit

AI-recommended products based on this video

Loading...
be quiet! Dark Power Pro 13 1300W Power Supply | ATX 3.1 Compliant | 80 Plus Titanium | Digital Regulation for PCIe 5.0 and PCIe 6+2 Graphics Cards, | 2X 12VHPWR Cable Included | BN500

be quiet! Dark Power Pro 13 1300W Power Supply | ATX 3.1 Compliant | 80 Plus Titanium | Digital Regulation for PCIe 5.0 and PCIe 6+2 Graphics Cards, | 2X 12VHPWR Cable Included | BN500

(124)
$489.99
FREE delivery Wed, Oct 8
Loading...
Laptop Charger for Lenovo Thinkpad 135W AC Adapter Slim Tip, Thinkpad X1 Extreme P1 P15v T15p Gen 1 2 3 4 ideapad L340 3-15 ADL135NDC3A, Lenovo Thinkpad Pro Docking Station with 135W Power Adapter

Laptop Charger for Lenovo Thinkpad 135W AC Adapter Slim Tip, Thinkpad X1 Extreme P1 P15v T15p Gen 1 2 3 4 ideapad L340 3-15 ADL135NDC3A, Lenovo Thinkpad Pro Docking Station with 135W Power Adapter

(74)
$48.96$42.67
Prime$7.36 delivery Fri, Jun 20
Loading...
iPhone 15 16 Charger Fast Charging 10 ft USB C to USB C Cable Long,Apple 60W Type C Cord and USBC Wall Block Power Adapter Cube Brick for iPhone 16 Pro/16 Pro Max/16 Plus/15 Pro/15 Pro Max/15 Plus

iPhone 15 16 Charger Fast Charging 10 ft USB C to USB C Cable Long,Apple 60W Type C Cord and USBC Wall Block Power Adapter Cube Brick for iPhone 16 Pro/16 Pro Max/16 Plus/15 Pro/15 Pro Max/15 Plus

(101)
$16.14
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
for iPhone 16/15 Pro Max Charger, 20W Fast Charging USB C Charger Block Wall Power Adapter + 6FT USB-C Cable for iPhone 16 Pro Max Plus 16e, iPhone 15 Pro Max, iPad Pro 12.9/11/13 inch, Air 4/5

for iPhone 16/15 Pro Max Charger, 20W Fast Charging USB C Charger Block Wall Power Adapter + 6FT USB-C Cable for iPhone 16 Pro Max Plus 16e, iPhone 15 Pro Max, iPad Pro 12.9/11/13 inch, Air 4/5

(3,858)
$19.99
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
Mac Book air Charger,Replacement for Mac Book Air AC 45W Power T-Tip Shape Connector Power Adapter,Charger for Mac Book Air 11 inch and 13 inch(Applicable to 2012-2017)

Mac Book air Charger,Replacement for Mac Book Air AC 45W Power T-Tip Shape Connector Power Adapter,Charger for Mac Book Air 11 inch and 13 inch(Applicable to 2012-2017)

(88)
$22.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
Mac Book Air Charger Replacement for Mac Air AC 45W Power T-tip Shape Connector Power Adapter for 11 inch and 13 inch (Between 2012-2017)

Mac Book Air Charger Replacement for Mac Air AC 45W Power T-tip Shape Connector Power Adapter for 11 inch and 13 inch (Between 2012-2017)

(207)
$19.78
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
Replacement for Mac Book Air Charger 6FT, 45W Mac Air AC Power T-Tip Shape Connector Adapter for Mac Book Air 11 inch & 13 inch Between 2012-2017

Replacement for Mac Book Air Charger 6FT, 45W Mac Air AC Power T-Tip Shape Connector Adapter for Mac Book Air 11 inch & 13 inch Between 2012-2017

(421)
$26.99
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
WEIDIAN Fanless Mini PC Industrial Win 11 Pro N100, 8GB RAM 128GB SSD, 2xCOM RS232, 2xGigabit LAN, 2xDisplays HD VGA Small Desktop PC Computer for Industrial Business Office Auto Power On

WEIDIAN Fanless Mini PC Industrial Win 11 Pro N100, 8GB RAM 128GB SSD, 2xCOM RS232, 2xGigabit LAN, 2xDisplays HD VGA Small Desktop PC Computer for Industrial Business Office Auto Power On

(115)
$396.27
FREE delivery Jun 23 - Jul 8
Loading...
Ksipze led Lights Strip for Bedroom 100FT,Smart Music Sync RGB Color Changing with App and Remote Control, Power Supply Led Strip Lights Lumiere LED for Room Home Party Decoration
Best Seller

Ksipze led Lights Strip for Bedroom 100FT,Smart Music Sync RGB Color Changing with App and Remote Control, Power Supply Led Strip Lights Lumiere LED for Room Home Party Decoration

(4,149)
$17.99
FREE delivery Sun, Oct 19 on your first order
3K+ bought in past month
Loading...
Talons of Power: A Graphic Novel (Wings of Fire Graphic Novel #9)

Talons of Power: A Graphic Novel (Wings of Fire Graphic Novel #9)

(550)
$14.98
FREE delivery Sat, Jan 31 on your first order
Loading...
GinTai DC in Power Jack Charging Port Socket Plug Connector Replacement for Lenovo IdeaPad Gaming 3-15IMH05 81Y4 3-15ARH05 3-151HU6 3-15ACH6 Series/Legion 5 15IMH05 82AU00BTUS Laptop

GinTai DC in Power Jack Charging Port Socket Plug Connector Replacement for Lenovo IdeaPad Gaming 3-15IMH05 81Y4 3-15ARH05 3-151HU6 3-15ACH6 Series/Legion 5 15IMH05 82AU00BTUS Laptop

(1)
$13.99
FREE delivery Sat, Jun 21 on your first order
Loading...
JINTAI Replacement for Lenovo ideapad Yoga Slim 7-15IMH05 82AB Slim 7-15IMH05 82AE Yoga Creator 7-15IMH05 82DS 5C10S30099 DD0LS5AD021 DC in Power Jack Charger Charging Port Cable Conntor Harness

JINTAI Replacement for Lenovo ideapad Yoga Slim 7-15IMH05 82AB Slim 7-15IMH05 82AE Yoga Creator 7-15IMH05 82DS 5C10S30099 DD0LS5AD021 DC in Power Jack Charger Charging Port Cable Conntor Harness

(0)
$68.46
FREE delivery Jun 25 - 30
Loading...
Power Supply for Xbox One [Latest Version] Replacement Power Brick Power Box for Xbox one Adapter AC Power Cord Cable 100-240V Auto Voltage
Best Seller

Power Supply for Xbox One [Latest Version] Replacement Power Brick Power Box for Xbox one Adapter AC Power Cord Cable 100-240V Auto Voltage

(25,212)
$37.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month