Power BI Masterclass - beginners to advanced

BY
Udemy

To acquire a comprehensive understanding of Microsoft Power BI faster for beginners to start their career in power BI.

Mode

Online

Fees

₹ 599 3999

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Microsoft Power BI is a powerful self-service business analytics/business intelligence tool that is simple to implement. Power BI is also an excellent data science tool. Numerous data scientists use it to visualize and present their findings. Power BI Masterclass - beginners to advanced certification is designed by Dan We - who works in the Business Intelligence field and is presented by Udemy.

Power BI Masterclass - beginners to an advanced online course is a comprehensive programme that includes 13 hours of learning resources and 14 articles + resources for participants who want to learn how to develop in power BI with lifetime access.

Power BI Masterclass - beginners to advanced online training includes all of the fundamentals of PBI, applicants will gradually master more advanced concepts, translating chaotic data into the proper format and producing Power BI reports and dashboards and Microsoft Power BI enables the applicants to create advanced Dax analyses that are highly effective.

The highlights

  • Certificate of completion
  • Self-paced course
  • 13 hours of pre-recorded video content
  • 14 articles + resources
  • Learning resources

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 599  ₹3,999
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Data science knowledge Business analytics knowledge

After completing the Power BI Masterclass - beginners to advanced online certification course aspirants will acquire a solid understanding of the concepts involved, how to begin a career in data analytics, quickly develop amazing reports with Power BI design patterns, and aspirants can transform complex data into the proper format and provide important insights to improve strategic decision-making and create competitive advantages. In Microsoft Power BI. In the Power, BI Masterclass certification participants can write advanced Dax calculations and design Power BI Reports, which include Power BI Dashboards (Reports).

The syllabus

The Power BI Masterclass - Updated

  • The Power BI Masterclass 2022 lets get started
  • About this Update
  • Before you start
  • Download the latest course files here to follow along
  • If necessary enable the new format pane preview feature
  • A complete tour through the Power BI Interface
  • Our first Power BI Report lets get started
  • Finishing our first report
  • Power BI the more advanced way exploring the dataset
  • Preparing the dataset using Power Query Editor
  • How to create a proper Datestable in Power BI
  • Datatransformation and cleaning Lets explore the Power Query Editor
  • Data enrichment with web data extraction
  • Datamodel setup Modelview and Relationships
  • Introduction to calculated columns and measures in Power BI
  • The measures table trick
  • Creating DAX measures in Power BI practise round
  • Flexibility of DAX Measures why they are so great
  • Dates and Drilldown functionality in Power BI
  • Additional info to the Auto datetime feature in Power BI
  • Timeintelligence DAX Calculations in Power BI getting started
  • Timeintelligence DAX Calculations in Power BI more flexibility
  • Timeintelligence DAX Calculations Cumulative Sum or Running Totals
  • DAX Measure Cleanup and Formatting best practise
  • The final Power BI Report creation
  • Advanced Training 2 New dataset setup
  • Practising DAX measures and Bulk Formatting Tricks
  • DAX Timeintelligence different Functions allow different Insights
  • Ranking and dynamic Ranking in Power BI
  • Power BI DAX Expressions Cumulative Sales for the prior year
  • Introduction to Scenario Analysis in Power BI
  • Rolling 30 day Sales DAX Expression
  • DAX Table functions in Power BI lets get into it
  • Advanced DAX Top 10 Customers
  • Customer Insights How many customers by weekday
  • DAX or No DAX that is the question
  • Advanced DAX Customer Classification
  • Introducing Variables while calculating Weekday Sales
  • Lets create our final report
  • Addon Buttons and Page Navigation in Power BI
  • NEW - A free resource for bonus videos tips and tricks
  • Congratulations and Motivation

This is the slightly "older part" of section 1. Will be removed in the future

  • Power BI Masterclass - beginners to advanced Introduction
  • Download latest course files
  • A first tour through the Power BI Interface
  • Power BI the easy way - lets get started
  • Power BI the easy way lets finish our first report in Power BI Desktop
  • Power BI the advanced way - lets dive into our dataset
  • The Power BI Query Editor - Datapreparation in action
  • Import the new and advanced date table into our model
  • Walk through Transformation steps in Powerquery Editor
  • Data enrichment importing web data into Power BI
  • Exploring the Model View and setting up Relationships
  • First Calculations in Power BI Calculated Columns and Measures
  • The Measures Table Trick - Structuring our report
  • Power BI DAX - Practise creating further Measures
  • The Beauty of Flexibility - Power BI Slicing and Dicing
  • Date drill down functionalities in Power BI
  • Autodatetime in Power BI - What you need to know about Date hierarchies
  • Advanced Dax - Intro to Timeintelligence DAX Measures
  • Advanced Dax - Flexibility in Timeintelligence DAX Functions
  • Advanced Dax - Cumulative or Running Total Sales Calculation in DAX
  • Power BI Lets create our final report
  • Welcome to Part 2 Setting up our new model structure
  • Power BI DAX - creating our base measures
  • Advanced TimeIntelligence in DAX - Parallelperiod and potential use cases
  • Advanced DAX - Dynamic Sales Rankings
  • Advanced DAX - Running Total Sales and prior year sales
  • Power BI - visualizing insights from our data
  • Scenario Analysis in Power BI
  • Advanced DAX - Running Total X Day Sales
  • DAX - An Introduction to table functions
  • Advanced DAX What are the Top 10 Clients
  • Advanced DAX - How many Customers per Weekday
  • Power BI DAX or no DAX - that is the question
  • Advanced DAX - Customer Classification in Power BI
  • Advanced DAX - Variables and Sales per Weekday and Weekends
  • Create our final Report in Power BI

How to use CALCULATE in Power BI Desktop

  • About this section
  • Download latest course files for this section
  • Introduction to the CALCULATE function starting from scratch
  • Filter Contexts Row Context and Context Transition in Power BI explained
  • Combine Calculate with ALL and VALUES
  • Excourse dynamic selection with CALCULATE
  • How to apply multiple criteria filter with CALCULATE in Power BI
  • How to use multiple Filtercriteria with CALCULATE in Power BI OR
  • CALCULATE with multiple criteria from different columns in Power BI
  • Salesclassification using CALCULATE
  • Cleaning up and quickly set up the new model
  •  Applying ALL and ALLSELECTED with CALCULATE in Power BI
  • CALCULATe with the Keepfilters modifier
  • Modify model relationships with CALCULATE
  • Using Context Transition with CALCULATE to evaluate the maximum sales on a da
  • Visual understanding of the expanded table concept
  • CALCULATE modifiers remove all filters except one
  • Using CALCULATE with Timeintelligence Expressions

Bonus section

  • Download resources for the bonus videos here
  • Bonus 1 How to improve your Reports even further with custom visuals a few examp
  • Bonus 2 How to publish and share your power bi Report
  • Bonus 3 How to create your own Datestable with DAX explore available Options
  • Bonus 4 Power BI Interview question SUM vs SUMX Difference
  • Bonus 5 Best and Worst Customer Identification and dynamic Sales Thresholds with
  • Power BI Masterclass 2 Expand Excellence Preview What we will learn
  • Power BI Bonus Tip Cascading slicers without bidirectional relationships
  • You want to become a Power BI Expert? Here are more learning resources

Instructors

Mr Dan We
Coach
Freelancer

Other Masters

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books