Microsoft Power BI Mastery: From Beginner to Intermediate
- Offered byUDEMY
Microsoft Power BI Mastery: From Beginner to Intermediate at UDEMY Overview
Duration | 11 hours |
Total fee | ₹499 |
Mode of learning | Online |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Faculty
- + 1 more item
Microsoft Power BI Mastery: From Beginner to Intermediate at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 6 downloadable resources and 6 articles
Microsoft Power BI Mastery: From Beginner to Intermediate at UDEMY Course details
- How to create stunning, interactive dashboards with Power BI
- How to share your analysis and dashboards using Power BI Online
- Importing Excel, Text, and CSV files into Power BI Desktop and combining files
- All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
- How to create amazing visuals, such as clustered column charts, maps, and trend graphs
- Using slicers and filters and applying design elements to your reports
- How to edit the interactions between your visualizations and filter at visualization, page, and report level
- How to import and transform data in Power Query
- How to enable/disable load and report refresh and resolving data import errors
- Data Modelling, relationship types, and troubleshooting relationship issues
- Measures vs Calculated Columns and creating additional and conditional columns
- How to use ROUNDUP and SUMX
- Creating Quick Measures and a Key Measures Table
- Using column, line, and map charts and gauge and card visualizations
- Creating a Shared Workspace in Power BI Service
- Creating reports and dashboards, pinning visualizations to the dashboard, and setting up scheduled refreshes
- **This course bundle includes downloadable course instructor files to follow along.** We've combined our Microsoft Power BI Beginner and Intermediate courses in this great value bundle. If you have reached your Excel limit and need to analyze and make sense of huge amounts of data, then Power BI can help take your existing data-crunching capabilities to new heights! Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience. The Power BI beginner course starts by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available. This intermediate training course is designed to be a continuation of the introductory Power BI course. We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success. The latter part of the course is an intensive exercise to give you practice creating reports and dashboards. What's included? Power BI for Beginner: What is Power BI and why you should be using it. To import CSV and Excel files into Power BI Desktop. How to use Merge Queries to fetch data from other queries. How to create relationships between the different tables of the data model. All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions. All about using the card visual to create summary information. How to use other visuals such as clustered column charts, maps, and trend graphs. How to use Slicers to filter your reports. How to use themes to format your reports quickly and consistently. How to edit the interactions between your visualizations and filter at visualization, page, and report level. Power BI Intermediate: Importing and transforming data in Power Query Importing Excel, text, and CSV files and combining files Enabling/disabling load and report refresh Resolving data import errors Data modeling, relationship types, and troubleshooting relationship issues Measures vs. calculated columns Creating a date table with DAXCreating additional and conditional columns Using the ROUNDUP and SUMX functions Creating quick measures and key measures tables The DAX - CALCULATE function Tables vs. matrix tables Formatting visualizations and applying conditional formatting Using column, line, and map charts Gauge and card visualizations Using slicers and filters and applying design elements Creating a shared workspace in Power BI service Building reports and dashboards Pinning visualizations to the dashboard Setting up scheduled refreshes This course bundle includes:10+ hours of video tutorials110+ individual video lectures Course and exercise files to help you follow along Certificate of completion Here's what our students are saying...5 Stars "Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand. Recommended. I will be looking for other courses by them." -Andrew5 Stars "Very detailed course, really enjoyed the Power BI course. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques." -Martin5 Stars "I would highly recommend. The course was informative and easy to follow." - Thomas5 Stars "I like everything! Everything is clear and understandable. Perfect courses!" -Jovita
Microsoft Power BI Mastery: From Beginner to Intermediate at UDEMY Curriculum
Introduction to Power BI Beginner Course
Welcome and Overview
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Demo Files (Section 2-4)
DOWNLOAD ME: Course Demo Files (Section 5-8)
DOWNLOAD ME: Course Exercise File
DOWNLOAD ME: Course Transcript
What is Power BI?
Install Power BI Desktop
A Tour of BI Desktop
Explore Commonly Used Power BI Options
Section Quiz
Beginner: Getting and Transforming Data
Import Files from a Folder into Power BI Desktop
Get Data from Excel and Text Files
Changing Query Source
Reference Queries to Create Additional Lookup Tables
Merge Queries in Power Query
Prevent Queries from Loading into Power BI Desktop
Practise Exercise
Section Quiz
Beginner: Data Modelling
Create Relationships Between Tables
Create a Dynamic List of Dates
Create Additional Date Columns for Analysis
Sort the Month and Weekday Names Correctly
Mark the Table as a Date Table
Hide Unnecessary Fields from Report View
Practise Exercise
Section Quiz
Beginner: Introduction to DAX Measures
Calculate the Total Revenue
Count the Total Rows of a Table
Use the CALCULATE Function
Calculate the Total Revenue Last Year
Difference Compared to Last Year
Practise Exercise
Section Quiz
Beginner: Adding Visualizations to your Report
Show Summary Information with Cards
Columns Charts to Compare Values
Map Visual to Plot Geographic Data
Slicers to Filter your Reports
KPI Card to Measure Performance Against a Goal
Line Graphs to Visualise Trend
Show Detail with the Matrix
Top N Lists with the Table Visualisation
Practise Exercise
Section Quiz
Beginner: Report Design
Adding Text Boxes and Shapes
Use Themes
Conditional Formatting
Practise Exercise
Section Quiz
Beginner: Editing Interactions and Filters
Edit the Interactions between your Visualisations
The Filter Pane to Filter at Any Level
Drill Through to More Detail
Practise Exercise
Section Quiz
Beginner: Power BI Service
Publish Your Report to the Power BI Service
Different Ways to Share your Power BI Report
Practise Exercise
Section Quiz
Beginner: Closing
Wrap Up
Introduction to Power BI Beyond the Basics Course
Course Introduction
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Instructor File
DOWNLOAD ME: Course Transcript
Setting Up for Success
Section Quiz
Intermediate: Importing and Transforming Data in Power Query
Importing Excel Data Files from a Folder
Combining Files and Removing Columns
Splitting and Merging Columns
Applying Data Types
Importing Text and CSV Files
Relationships and Lookup Tables
Duplicate vs Reference
Creating a Lookup Table
Creating Index Columns
Merging Queries
Enable/Disable Load and Report Refresh
Advanced Editor
Resolving Data Import Errors
Organizing Queries into Groups
Section Quiz
Intermediate: Data Modeling
Troubleshooting Relationship Issues
Relationship Types
Cross Filter Direction
Section Quiz
Intermediate: DAX - Essential Skills
Measures vs Calculated Columns
Creating a Date Table with DAX
Creating Additional Columns
Creating Conditional Columns
Marking Table as a Date Table
Using ROUNDUP to Extract Quarters
Creating Quick Measures
Creating a Key Measures Table
Aggregation Methods
Using SUMX
Section Quiz
Intermediate: DAX - CALCULATE Function
The CALCULATE Function
Changing Context with FILTER
Using ALL with CALCULATE
Section Quiz
Intermediate: Visualizations
Visualizations
Tables vs Matrix Tables
Formatting Visualizations - Part 1
Formatting Visualizations - Part 2
Conditional Formatting
Column and Line Charts
Card Visualizations
Map Charts
The Gauge Visualization
Slicers and Filter
Applying Design Elements
Section Quiz
Intermediate: The Power BI Service
Creating a Shared Workspace in Power BI Service
Inviting Others to a Shared Workspace
Reports vs Dashboards
Pinning Visualizations to the Dashboard
Setting up Scheduled Refreshes
Section Quiz
Intermediate: Orders Dashboard Example - Preparation
Orders Dashboard Example
Report Requirements
Importing Order Data
Section Quiz
Intermediate: Orders Dashboard Example - Transformation
Transforming Order Data in Power Query
Creating Lookup Tables
Merging Queries
Creating a Dates Table
Creating DAX Measures
Section Quiz
Intermediate: Orders Dashboard Example: Report
Adding a Report Title
Report Navigation with Buttons and Bookmarks
Card Visualizations and Filtering
Line Chart: Count of Male vs Female Customers
Stacked Column Chart: Total Revenue by Region
Treemap Chart: Count of Orders by Year/Month
Funnel Chart: Age Distribution
Matrix Table: Count of Customers by Type and Status
Adding Conditional Formatting
Section Quiz
Intermediate: Orders Dashboard Example: Dashboard
Publishing the Report to the Power BI Service
Pinning Media Tiles to Dashboard
Section Quiz
Intermediate: Course Close
Course Close
Microsoft Power BI Mastery: From Beginner to Intermediate at UDEMY Faculty details
Microsoft Power BI Mastery: From Beginner to Intermediate at UDEMY Entry Requirements
- A good knowledge of MS Excel is advised but not necessary Power BI Desktop installed on your machine is required to take the practice exercises
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?