✅ Download the free course files to follow along ➡️[ Ссылка ]
In this Introduction to Power BI, we teach you 5 of the important Power BI Parts, namely Power Query, Data Modelling, DAX Expressions, Reporting Features, and Publishing to Power BI Service. Power BI is a very powerful business intelligence tool. If Excel isn’t cutting it for your data analysis and modeling, then you likely need to move up to Power BI.
With this 2-hour crash course, you will learn how to import CSV, Excel, and Text files in Power BI and how to transform the data using Power Query. We then look at creating Lookup Tables and Merging Queries. We also cover Data Modelling basics such as creating Relationships between tables and creating a dynamic Date Table using DAX, as well as other DAX Power BI Formulas.
The second half of this video defines Calculated Columns vs Measures and how to create a Key Measures Table. We also teach you how to build a Power BI Report, including adding Visualizations, adding Pages, Bookmarks, and Buttons, and Formatting. Finally, we show you how to pin Visualizations to a Dashboard before Publishing Reports to the Power BI Service.
We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master Power BI.
✅[ Ссылка ]
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Introduction to Power BI Desktop Part 1
0:01:51 - Agenda
0:03:59 - What is Power BI?
0:08:31 - Acquiring Power BI
0:15:16 - Importing CSV Files and Transforming Data
0:29:00 - Importing Excel Files and Text Files
0:32:21 - Creating Lookup Tables
0:40:21 - Merging Queries
0:46:42 - Data Modelling: Creating Relationship Between Tables
0:49:05 - Date Table Using DAX Expressions
0:59:32 - Introduction to Power BI Desktop Part 2
1:02:00 - Agenda
1:03:20 - Recap of Part 1
1:05:55 - Calculated Columns vs Measures
1:15:05 - Creating a Key Measures Table
1:19:07 - Adding Visualizations
1:28:17 - Adding Pages, Bookmarks, and Button
1:36:15 - Adding Filters
1:38:46 - Displaying and Formatting Overview Statistics
1:53:55 - Publishing Report to the Power BI Service
1:58:10 - Pinning Visualizations to a Dashboard
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ [ Ссылка ]
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ [ Ссылка ]
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
[ Ссылка ]
✅ Check out our free video playlist for data visualization 👉[ Ссылка ]
✅Power BI Tutorials for Beginners video playlist 👉 [ Ссылка ]
✅ Microsoft Excel Beginner's Training here 👉 [ Ссылка ]
✅ Data Analysis using Microsoft Tools here 👉 [ Ссылка ]
💬Stay in touch!
SimonSezIT.com: [ Ссылка ]
LinkedIn: [ Ссылка ]
FaceBook: [ Ссылка ]
🔔 Subscribe to our channel:
[ Ссылка ]
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
