Power BI Essentials: Power BI Training and Exam Prep
Power BI Essentials: Power BI Training and Exam Prep, available at $89.99, has an average rating of 4.63, with 364 lectures, 17 quizzes, based on 3068 reviews, and has 19611 subscribers.
You will learn about How to use Power BI Desktop to import and model data and create reports. How to use the Power BI service for the creation of dashboards, collaboration and sharing of content. This course is ideal for individuals who are This course is suitable for anyone who needs to become familiar with Microsoft's Power BI product, whether for work, study or career. It is particularly useful for This course is suitable for anyone who needs to become familiar with Microsoft's Power BI product, whether for work, study or career.
Enroll now: Power BI Essentials: Power BI Training and Exam Prep
Summary
Title: Power BI Essentials: Power BI Training and Exam Prep
Price: $89.99
Average Rating: 4.63
Number of Lectures: 364
Number of Quizzes: 17
Number of Published Lectures: 362
Number of Published Quizzes: 17
Number of Curriculum Items: 381
Number of Published Curriculum Objects: 379
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- How to use Power BI Desktop to import and model data and create reports.
- How to use the Power BI service for the creation of dashboards, collaboration and sharing of content.
Who Should Attend
- This course is suitable for anyone who needs to become familiar with Microsoft's Power BI product, whether for work, study or career.
Target Audiences
- This course is suitable for anyone who needs to become familiar with Microsoft's Power BI product, whether for work, study or career.
The comprehensive introduction to Microsoft Power BI, fully updated for 2021 and covering many of the topics required for the exam DA-100.
Master Power BI Desktop, the Power BI service & Power BI mobile. This user-friendly course is designed to familiarize you with Microsoft Power BI’s business intelligence capabilities in the most logical order.
The course consists of 30 sections, arranged into seven groups that reflect the way in which Microsoft Power BI works and the order in which operations are carried out: Getting Started, Connecting to Data, Data Wrangling, Data Modelling, DAX formulas, Visualization, and Publishing & Sharing.
Each of the 30 sections in this course starts with an overview and ends with a section summary which recaps the key topics covered and reminds you where these techniques fit into the overall Microsoft Power BI cycle.
So, take your time and work your way slowly but surely through the course material; and when you’re done, you should find that you know Micrososft Power BI pretty well.
INTERACTIVE PDF
The course also includes a fully interactive PDF file containing hundreds of backlinks to the exact point in the video where that topic was discussed.
EXAM DA-100 COVERAGE AND MAPPING
Although this course is aimed at beginners, it covers a lot of the topics required for the Microsoft DA-100 exam. At the end of each section, we’ll highlight which topics have been covered, so you can start checking them off your list.
CUSTOMIZABLE COURSE DURATION
If you are too busy to complete the whole course straightaway, no problem. We have shortened versions of the course created for people just like you.
There are three of these shortened courses.
The Executive Overview course (6 hours)is designed for users who want to get up to speed on Power BI as quickly as possible, without going into too much detail.
The Report Developer course (6 hours)will suit anyone who will be focusing on creating Power BI reports based on datasets created by their IT department or by other colleagues.
And the Dataset Developer course (9 hours) is for people in the opposite camp, those who will be responsible for developing datasets from which their colleagues can build reports.
GETTING STARTED
The first group of sections is, naturally enough, Getting Started. This is where you’ll get up and running and download all of the resources you’ll need; and where you’ll get an overview of the Power BI product, Microsoft Power BI tenants and Power BI licenses.
CONNECTING TO DATA
Then we dive straight into using Power BI and the first business intelligence skill you need to master: connecting to data sources.
In these five sections, you’ll learn how to bring data into Power BI from Text Files, CSVs and Excel Files; as well as how to connect to a Folder of Data, either on your own file system or in a SharePoint library, and automatically combine all the files inside the folder into a single table.
You’ll also learn how to Connect to data on websites and how to scrape data from the web page itself.
And, naturally, you’ll get plenty of practice in connecting to Power BI’s most frequent data partner: SQL Server. You’ll learn how to work in import, DirectQuery and composite modes and how to retrieve data from both views and database tables, as well as by executing SQL statements.
DATA WRANGLING
Once you’re comfortable with getting data into Power BI, we’ll move on to the next stage in the Power BI cycle: Data Wrangling.
It’s very rare that the data you connect to is already optimized for reporting; so our four sections on data cleansing and transformation will fully familiarize you with using Power Query, the utility built into Power BI whose user-friendly interface allows you to carry out powerful and sophisticated transformation with just a few mouse clicks, as well as how to edit the underlying M language code generated by the interface.
DATA MODELLING
After mastering the first two steps in your Power BI journey, connecting to data and data cleansing, you’ll be ready to move on to the next stage: data modelling.
In this group of sections, you’ll learn how to combine the various tables that you need into a single entity called a data model.
DAX FORMULAS
Having created a data model, our next group of sections focuses on using the DAX language to add insights and enhancements.
We’ll look at the three types of calculation which you can create using the DAX language:
Calculated columns
Calculated tables
And measures
And we’ll get to grips with the most important function in the DAX language: the CALCULATE function.
And we’ll end the section by looking at DAX time intelligence functions which enable you to compare calculations based on different time periods, to provide such insights as year-on-year growth and year to date sales.
VISUALIZATION
Once we have built our data model, we’ll move on to the next phase in the Power BI development cycle: visualization and report creation.
We’ll start with what I like to call the big-picture visuals, those which give your audience with key metrics at a glance. As you’ll see in this section Power BI has three big picture visuals: the card, the KPI visual and the gauge.
And, of course, we’ll talk about many other visuals and visualization techniques as we work through these sections.
We’ll even look at using DAX measures to enhance the user experience by making titles change dynamically as users interact with them.
PUBLISHING AND SHARING
OK, so now we have a report, in our last group of sections, we will look at how we can make our content available to our intended audience.
First, we’ll look at publishing from Power BI Desktop into the Power BI service.
Then, you’ll learn how to create dashboards in the Power BI service and the different ways of adding content to them.
You’ll learn how to create app workspaces and how to grant access to fellow report developers, so that your team can collaborate on the creation of content; and how the different strategies for sharing that content throughout the entire organisation.
And, in our section on Power BI mobile, you’ll learn how to create reports and dashboards which are optimised for mobile viewing.
************************************************************************************
AS A BONUS FOR COMPLETING THIS COURSE, YOU’LL ALSO GET ACCESS TO THE ULTIMATE POWER BI EXAM DA-100 PREP COURSE.
The Ultimate Power BI Exam DA-100 Prep Course is the course that’s tailor-made for your DA-100 exam preparation. And there has never been a better time to prepare!
Microsoft is currently providing a discounted certification exam to anyone whose livelihood has disrupted due to the COVID-19 crisis. If this includes you, then you can take the exam online for just $15, until 31st December 2021.
Passing the DA-100 exam could be just the ticket for landing your next job in BI or analytics. It helps you stand out from the crowd and this course is all you need to be confident of passing.
Here’s how!
If you download the exam skills outline , you’ll see that the exam consists of about 110 topics arranged into 14 sections which fall into 5 different categories.
This course is mapped precisely to those 110 topics, so you always know exactly what you’re, learning, why you’re learning it and which topic it relates to.
This means that don’t have to follow the course sequentially.
You can jump straight to those topics which are of particular interest, or which you have difficulty grasping.
There are three components to the course.
First, we have the videos. There’s an individual video for each of the 110 topics and you will constantly be aware which topic each video relates to.
Secondly, at the end of each section, we have an in-depth online, text-based revision, over a thousand pages in total.
You’ll find this feature particularly useful if you find that reading helps you to remember or if English is not your first language.
And, thirdly, we have exam questions, over 100 questions in total.
These questions have been carefully designed to be similar to exam questions and when you get a question right or wrong, you’ll be given tips as to why this could not be the right answer, as well as a link to the video in which the subject matter in that question was covered.
So, as you can see the course includes a lot of reinforcement learning.
And this means this course doesn’t just qualify you to pass the exam DA-100 exam. If anything, it over-qualifies you!
So, sign up for the course now and sail through the DA-100 exam with no problems.
Course Curriculum
Chapter 1: Section 1: Welcome
Lecture 1: 1.0: Welcome to the Course
Lecture 2: 1.1: Download the Course Files
Lecture 3: 1.2: Downloading the Interactive PDF
Lecture 4: Shortened Course Versions (for Busy People)
Lecture 5: Executive Overview Course (6 Hours)
Lecture 6: Report Developer Course (6 Hours)
Lecture 7: Dataset Developer Course (9 Hours)
Chapter 2: 2. Getting Started
Lecture 1: 2.0: Welcome to Section 2
Lecture 2: 2.1: Installing SQL Server
Lecture 3: 2.2: Installing the Sample Databases
Lecture 4: 2.3: What is Power BI
Lecture 5: 2.4: The Power BI Tenant
Lecture 6: 2.5: Power BI Licensing
Lecture 7: Share your Thoughts
Lecture 8: 2.6: Summary of Section 2
Chapter 3: Section 3: Connecting to Text Files
Lecture 1: 3.0: Welcome to Section 3
Lecture 2: 3.1: Connecting to Delimited Text Files
Lecture 3: 3.2: Using UTF-8 Encoding
Lecture 4: 3.3: Connecting to Files in SharePoint
Lecture 5: 3.4: Quick Practice
Lecture 6: 3.5: Summary of Section 3
Chapter 4: Section 4. Connecting to Excel data
Lecture 1: 4.0: Welcome to Section 4
Lecture 2: 4.1: Excel Data Objects
Lecture 3: 4.2: Hidden Sheets
Lecture 4: 4.3: Blank Columns
Lecture 5: 4.4: Password
Lecture 6: 4.5: Total Row
Lecture 7: 4.6: Quick Practice
Lecture 8: 4.7: Summary of Section 4
Chapter 5: Section 5. Connecting to a Folder of Data
Lecture 1: 5.0: Welcome to Section 5
Lecture 2: 5.1: Connecting to a Folder of Data
Lecture 3: 5.2: Using a Sample File
Lecture 4: 5.3: Quick Practice
Lecture 5: 5.4: Connecting to SharePoint folders
Lecture 6: 5.5: Accessing SharePoint sub-folders
Lecture 7: 5.6: Summary of Section 5
Chapter 6: Section 6. Connecting to Web Data
Lecture 1: 6.0: Welcome to Section 6
Lecture 2: 6.1: Connecting to a Web URL
Lecture 3: 6.2: Connecting to web page data
Lecture 4: 6.3: Quick Practice
Lecture 5: 6.4: Summary of Section 6
Chapter 7: Section 7. Connecting to SQL Server
Lecture 1: 7.0: Welcome to Section 7
Lecture 2: 7.1: Overview of Connecting to SQL Server
Lecture 3: 7.2: Importing SQL Server Views
Lecture 4: 7.3: Using SQL Statements
Lecture 5: 7.4: DirectQuery Mode
Lecture 6: 7.5: Composite Models
Lecture 7: 7.6: Storage Mode
Lecture 8: 7.7: Summary of Section 7
Chapter 8: Section 8. Splitting and Combining
Lecture 1: 8.0: Welcome to Section 8
Lecture 2: 8.1: Removing Spaces by Splitting
Lecture 3: 8.2: Splitting by Character Transition
Lecture 4: 8.3: Combining Columns
Lecture 5: 8.4: Summary of Section 8
Chapter 9: Section 9. Extracting text
Lecture 1: 9.0: Welcome to Section 9
Lecture 2: 9.1: Extracting character ranges
Lecture 3: 9.2: Text Between Delimiters
Lecture 4: 9.3: Text Before Delimiter
Lecture 5: 9.4: Summary of Section 9
Chapter 10: Section 10. Transforming report data
Lecture 1: 10.0: Welcome to Section 10
Lecture 2: 10.1: Removing Unwanted Rows
Lecture 3: 10.2: Fill Down
Lecture 4: 10.3: Unpivot Columns
Lecture 5: 10.4: Quick Practice
Lecture 6: 10.5: Summary of Section 10
Chapter 11: Section 11. Combining tables
Lecture 1: 11.0: Welcome to Section 11
Lecture 2: 11.1: Append Queries
Lecture 3: 11.2: Merge Queries
Lecture 4: 11.3: Merge Queries Left Anti
Lecture 5: 11.4: Summary of Section 11
Chapter 12: Section 12. Data Modelling Fundamentals
Lecture 1: 12.0: Welcome to Section 12
Lecture 2: 12.1: Data Tables
Lecture 3: 12.2: Calculated Tables
Lecture 4: 12.3: Data Columns
Lecture 5: 12.4: Calculated Columns
Lecture 6: 12.5: Relationships
Lecture 7: 12.6: Measures
Lecture 8: 12.7: Hierarchies
Lecture 9: 12.8: Rows of Data
Lecture 10: 12.9: Summary of Section 12
Chapter 13: Section 13. Creating Fact and Dim Tables
Lecture 1: 13.0 Welcome to Section 13
Lecture 2: 13.1: Creating a Schema for Power BI
Lecture 3: 13.2: Creating Views for Power BI
Lecture 4: 13.3: Creating a Power BI Login
Lecture 5: 13.4: Connecting to Views
Lecture 6: 13.5: Using Relationship Columns
Lecture 7: 13.6: Using Merge Queries
Instructors
-
Grant Gamble
Developer, trainer and author
Rating Distribution
- 1 stars: 30 votes
- 2 stars: 40 votes
- 3 stars: 328 votes
- 4 stars: 1236 votes
- 5 stars: 1434 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple