get app

    PL-300 certification Analyzing Data with MS Power BI

    BY
    Udemy

    Learn the skills required for the Microsoft PL-300 certification with the free Power BI Desktop application. Power Query, DAX, M, more.

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 649 4099

    Quick Facts

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

    Course overview

    Data analysts are responsible for setting up and creating scalable data models, cleaning and transforming data, and allowing advanced analytic capabilities that give meaningful business value via easily understandable data visualizations. Additionally, data analysts work with key stakeholders across industries to give pertinent insights based on stated business needs. Philip Burton, a computing consultant specializing in the implementation of computer systems and data analysis, designed the certification PL-300 certification Analyzing Data with MS Power BI which Udemy offers.

    PL-300 certification Analyzing Data with MS Power BI online training provides 28 hours of video, and 28 downloadable aids along with articles the complete, unrestricted, and permanent package, including mobile and TV access makes learning convenient and accessible which includes a course completion certificate also. PL-300 certification Analyzing Data with MS Power BI online course focuses on creating visualizations of data, getting and transforming data, refining the model, and developing the Power BI service which needs to collect and analyze large data sets to spot trends, patterns, and insights.

    The highlights

    • 28 hours of pre-recorded video content
    • 28 downloadable materials 
    • 36 articles
    • Lifetime access
    • Access on mobile and TV
    • Training 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
    ₹ 649  ₹4,099
    certificate availability

    Yes

    certificate providing authority

    Udemy

    What you will learn

    Knowledge of data visualization Animation skills

    After completing the PL-300 certification Analyzing Data with MS Power BI  online certification course, applicants will gain an insight into being capable of formatting numbers and dates, as well as adding labels, tooltips, and animation. Model development and refinement, including the addition of calculated columns and measurements. Learn the essential DAX functions that let you write your own formulas, as well as how to generate analyses such as line charts, stacked bar charts, or geographic studies utilizing maps.

    The syllabus

    Introduction

    • Introduction
    • Welcome to Udemy
    • The Udemy Interface
    • Do you want auto-translated subtitles in more languages?
    • What is the PL-300 exam?
    • What are we going to learn?
    • Installing Power BI Desktop
    • Resources
    • Saved Power BI files

    Level 1: Creating and formatting a table visualization

    • Welcome to Part 1:
      • 1a. Visualizations
      • 1b. Importing from Excel, and Creating our first visualization
    • Viewing data
    • Focus mode and Different visualizations
    • Why do I need a Work email address? And how can I get one, if I don't have it?
    • 10b. Saving visualization to the Desktop and to the Power BI service
    • Practice Activity Number 1
    • Practice Activity Number 1 - The Solution

    Level 2: Formatting our first visualization

    • Formatting font and font size
    • Formatting colors
    • Stylistic options
    • Position visuals
    • Align visuals
    • Format Painter
    • Configuring summarization, both default and in a specific visualization
    • Changing number and date formatting
    • Practice Activity Number 2
    • Practice Activity Number 2 - The Solution

    Level 3: Creating different visualizations: Matrices and bar charts

    • Matrix
    • Drill down data, see data and records, and export data
    • Stacked bar charts and 8j. switch theme for reports
    • Bar Chart formatting
    • Configure interactions between visual (Edit interactions)
    • Clustered and 100% Stacked bar charts
    • Line and area charts, including 8b. Configure duplicate pages
    • Combo charts (Line and column charts)
    • Practice Activity Number 3
    • Practice Activity Number 3 - The Solution

    Level 4: Adding more control to your visualizations

    • Adding Text boxes, Images and Shapes
    • Visual level, page level and report level filters - basic filters
    • Advanced Filtering
    • Filter Top N Items
    • Slicer
    • Slicer Warning
    • Sort visuals
    • Configure small multiples
    • Use Bookmarks for reports
    • Drillthrough
    • Buttons and Actions
    • Enable Natural Language Queries (Ask A Question)
    • Tooltip Pages
    • Practice Activity Number 4
    • Practice Activity Number 4 - The Solution

    Level 5: Other visualizations

    • Ribbon charts
    • Waterfall charts
    • Scatter, bubble and dot charts
    • Pie charts and donut charts
    • Treemaps
    • Funnel charts
    • Adding Marketplace visualizations (Import a Custom Visual)
    • Practice Activity Number 5
    • Practice Activity Number 5 - The Solution

    Level 6: Mapping

    • Maps
    • Formatting maps
    • 8g. Adding Data Categories
    • Filled Maps, Conditional Formatting, and color blindness
    • Creating hierarchies
    • ArcGIS Maps for Power BI
    • Practice Activity Number 6
    • Practice Activity Number 6 - The Solution

    Level 7: Measure performance by using KPIs, gauges and cards

    • Gauges
    • Cards and Multi-row cards
    • More conditional formatting
    • KPIs
    • Practice Activity Number 7
    • Practice Activity Number 7 - The Solution

    Part 1 Level 8: Other Visualization Items for the DA-100 exam

    • Define quick measures
    • Export report data
    • Create reference lines by using Analytics pane
    • Design and configure for accessibility
    • Identify outliers
    • Use Anomaly Detection
    • Add a Smart Narrative visual
    • Use groupings and binnings
    • Use the Key Influencers to explore dimensional variances
    • Use the decomposition tree visual to break down a measure
    • R and Python Visualizations
    • Use or create a PBIDS file
    • Creating a paginated report
    • Exploring Power BI Report Builder
    • End of Part 1

    Part 2 Get and Transform Data: Level 1 - Home Part 1

    • Welcome to Part 2: Get and Transform Data
    • Introduction - let's Get some more Data
    • Exploring the Power Query Editor interface
    • Introducing the M language
    • Let's start look at the Home tab
    • Home menu - Manage Columns
    • Home menu - Reduce Rows and Use First Row as Headers
    • Practice Activity Number 8
    • Practice Activity Number 8 - The Solution

    Part 2 Level 1 - Get Data - Home

    • Sort and Filter
    • Split Column
    • Other Transform activities
    • Practice Activity Number 9
    • Practice Activity Number 9 - The Solution

    Part 2 Level 2 - Getting Multiple files

    • Merge Queries and Expand Table
    • Merge Queries with Group By, and different types of Joins
    • Appending two queries together
    • Appending three or more queries together + resolving a problem with data types
    • Combine Files (getting information from a folder)
    • Practice Activity Number 10
    • Practice Activity Number 10 - The Solution

    Part 2 Level 3 - Transform Menu

    • Transform - Table and Any Column
    • Pivot Column
    • Unpivot
    • Practice Activity Number 11
    • Practice Activity 11 - The Solution
    • Unpivot in conjunction with other Transform features
    • Practice Activity Number 12
    • Practice Activity 12 - The Solution

    Part 2 Level 4 - Transform - Text and Numbers

    • Transform/Add Column - Text - Format
    • Transform/Add Column - Text - Merge Columns
    • Transform/Add Column - Text - Extract
    • Transform/Add Column - Text - Parse
    • Transform/Add Column - Number Column - Statistics and Standard
    • Transform/Add Column - Other Number Column functions
    • Practice Activity Number 13
    • Practice Activity Number 13 - The Solution

    Part 2 Level 5 - Transform - Dates and Time

    • Creating a list of dates
    • Transform/Add Column - Date
    • Transform/Add Column - Dates in other cultures/languages
    • Transform/Add Column - Time
    • Transform/Add column - Duration
    • Practice Activity Number 14
    • Practice Activity Number 14 - The Solution

    Part 2 Level 6 - Add Columns, View and Help Menus

    • Column from examples
    • Conditional Column
    • Resolving Errors from Conditional Columns
    • Index Column and Duplicate Column
    • Custom Column - If Then Else
    • Converting text from a different locale to a number
    • Practice Activity Number 15
    • Practice Activity Number 15 - The Solution

    Part 2 Level 7 - View and Help menus and advanced functionality

    • Other M Functions
    • View and Help menus, including Column Properties
    • Profile the data
    • Advanced Editor
    • Functions and Parameters
    • Date Time Zone date type and Functions
    • Worked Practice Activity Number 16 - Dividing Annual data into Months

    Part 2 Level 8 - Get other types of data

    • Introduction to SQL Server
    • Importing database data into Power BI, and Query Folding
    • Select a storage mode
    • Expanding multiple tables in SQL Server
    • Importing data from SQL Server Analysis Services (SSAS)
    • Setting up Azure SQL Database
    • Using Azure SQL Database in Power BI
    • Automatic page refresh
    • Using Big Data
    • Use the Microsoft Dataverse

    Part 2 Level 9 - Other Get and Transform Topics for the DA-100 exam

    • Resolve problems
    • Configure data loading
    • Identify query performance issues, including Query Diagnostics
    • Apply AI Insights
    • End of Part 2

    Part 3 Level 1: Creating a Data Model

    • Welcome to Part 3 - Modeling and DAX functions
    • Small changes to the menus
    • Get multiple data sets, and connecting them together
    • The problems with direction of relationships between data sets
    • Practice Activity Number 17
    • Practice Activity Number 17 - The Solution

    Part 3 Level 2 - An introduction to DAX functions, including Logical functions

    • DAX functions - A useful Resource
    • Calculated columns - an introduction
    • Basic operators
    • IF, BLANK and ISBLANK
    • AND, OR and NOT
    • SWITCH
    • Other functions
    • Practice Activity Number 18
    • Practice Activity Number 18 - The Solution

    Part 3 Level 3 - Statistical functions

    • Measures - an introduction, with standard aggregations including Countblank
    • Aggregation of calculations
    • Other statistical functions
    • Practice Activity Number 19
    • Practice Activity Number 19 - The Solution

    Part 3 Level 4 - Mathematical functions

    • Introduction to mathematical functions
    • Rounding functions
    • Division functions - MOD and QUOTIENT
    • SIGN (and use with SWITCH) and ABS
    • Exponential functions
    • Other functions
    • Practice Activity Number 20
    • Practice Activity Number 20 - The Solution

    Part 3 Level 5 - Text functions

    • Text searching
    • Text extraction and substitution
    • Text conversion
    • Other functions
    • Practice Activity Number 21
    • Practice Activity Number 21 - The Solution

    Part 3 Level 6 - Information Functions

    • ISERROR and LOOKUPVALUE
    • Other functions
    • Practice Activity Number 22
    • Practice Activity Number 22 - The Solution

    Part 3 Level 7 - Filter and Value Functions

    • RELATED - Flatten out a parent-child hierarchy
    • RELATEDTABLE and COUNTROWS
    • Context
    • ALL
    • FILTER
    • CALCULATE
    • ALLEXCEPT
    • ALLSELECTED
    • Other functions
    • Practice Activity Number 23
    • Practice Activity Number 23 - The Solution

    Part 3 Level 8 - Time Intelligence Functions

    • Date and Time Functions
    • FIRSTDATE, LASTDATE
    • Start of... and End of...
    • Previous... and Next...
    • DATESINPERIOD
    • DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
    • Opening Balance and Closing Balance
    • Semi-additive Measures
    • SAMEPERIODLASTYEAR and PARALLELPERIOD
    • Other Time Intelligence Functions
    • Practice Activity Number 24
    • Practice Activity Number 24 - The Solution

    Part 3 Level 9 - Other Modeling and DAX Topics for the DA-100 exam

    • Create calculated tables
    • Create a common date table
    • Define role-playing dimensions
    • Resolve many-to-many relationships - Joint Bank Accounts
    • Resolve many-to-many relationships - Different types of granularity
    • Improve cardinality levels through summarization and by changing data types
    • Identify poorly performing measures, relationships, and visuals
    • End of Part 3

    Part 4 Section 1 - An Introduction to the Power BI Service

    • Welcome to Part 4: The Power BI Service
    • Introducing The Power BI Service
    • Logging into Power BI Service and a quick look around
    • Power BI Terminology
    • Datasets and Reports in the Power BI Service
    • Get Data - Other People's Data
    • Get Data - Your Data
    • The Navigation Pane, including Add a Quick Insights result to a report

    Part 4 Section 2 - Power BI Pro and adding users

    • Signing up for Power BI Pro
    • Adding new users
    • Creating a new report
    • Sharing my new report

    Part 4 Section 3 - Row and Object Level Security

    • Adding role-based Row Level Security
    • Adding Dynamic Row Level Security
    • Testing Dynamic Row Level Security in the Power BI Service
    • Implement Object-Level Security

    Part 4 Section 4 - Dashboards

    • Differences between dashboards and reports
    • Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options
    • Dashboards: Options
    • Configure Subscriptions
    • Pin a Live Report Page to a Dashboard
    • Use the Q&A Feature
    • Add a Dashboard Theme
    • Apply or Change Sensitivity Labels
    • Configure Data Alerts

    Part 4 Section 5 - Manage datasets

    • Analyze in Excel
    • Promote or Certify (Endorse) a Dataset
    • Manually Refreshing data in the Power BI Service
    • Data Gateways; Providing Access to Datasets
    • Configure a Dataset Scheduled Refresh
    • Configure Incremental Refresh Settings - Step 1
    • Configure Incremental Refresh Settings - Step 2

    Part 4 Section 6 - Create and manage workspaces

    • Create and Configure a Workspace
    • Assign Workspace Roles
    • Providing Access to Datasets
    • Configure and Update a Workspace App
    • Promote or certify Power BI report or app
    • Publish, Import or Update Assets in a Workspace - Publish securely
    • Publish reports on the web, so the public can see
    • Create and manage workspaces

    Part 4 Section 7 - Other Power BI Service Topics

    • Drillthrough from another report
    • Export Data
    • Create a PivotTable from a Power BI dataset in Excel
    • Recommend a Development Lifecycle Strategy
    • Identify downstream dataset dependencies
    • Personalize visuals
    • Use or create a dataflow
    • Dataflow Scheduled Refresh and Endorsement
    • Connect to a dataset using the XMLA endpoint
    • Configure large dataset format
    • Dashboard Data Classifications
    • That's almost it for the Power BI Service
    • End of Part 4

    Well done

    • Congratulations for finishing the course!
    • Bonus Lecture

    Instructors

    Mr Phillip Burton

    Mr Phillip Burton
    Instructor
    Udemy

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Data Science Courses Cyber Security Courses Programming Courses Digital Marketing Courses Law Courses Leadership Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses NPTEL Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    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