Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 7.5 hours on-demand video
  • 3 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
IT & Software Other IT & Software Microsoft Power BI

Master in Microsoft Power BI Desktop and Service

Hands-on Guide to Mastering Power BI Desktop and Power BI Service
Rating: 4.4 out of 54.4 (1,150 ratings)
66,347 students
Created by Learnsector LLP, Navya Kannan
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Understand Power BI concepts like Microsoft Power BI desktop layouts, BI reports, dashboards, and Power BI DAX commands and functions.
  • Create compelling reports and visualizations, derive real-time insights, and deploy it on demand.
  • Create, share, collaborate, and benefit from business information with purpose-built dashboards.
  • Form relationships in your data model and learn data visualization best practices.

Requirements

  • Microsoft Power BI Desktop installed on your computer (which is free).
  • Knowledge of Excel Power Query is an added advantage.

Description

This Microsoft Power BI course will help you to become a Power BI expert. It will enhance your skills by offering you comprehensive knowledge on Power BI Desktop, Power BI Online, and the required hands-on experience for solving real-time industry-based Power BI projects.

As we progress through this course, you’ll learn to unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

In this course, you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services.

  • You will learn how to connect Power BI to different data sources.

  • You will be able to transform your data using Power Query and create data models.

  • You will also level-up your data analysis skills using DAX and create calculated columns and measures.

  • With the help of Reports and Visualization in Power BI, you will be able to present your data in an efficient and interactive way.

  • And lastly, you will learn how to publish your reports and dashboards to the Power BI online service.

Why Learn Power BI?

Power BI is a business intelligence tool by Microsoft that provides analytics services. It provides interactive dashboards and visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on anyone else as Power BI's artificial intelligence is there to help you out. Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modeling capabilities along with data preparation, data discovery, and interactive dashboards.


Why should you take up this Power BI course?

  • Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in the next 2 years – Gartner.

  • 70% of leading companies say that analytics is integral to how they make decisions – IBM Survey

  • A Senior Business Intelligence Analyst can earn $89,000 in the United States – Payscale


Who this course is for:

  • Individuals looking for jobs as Business Analysts, Business Development Manager.
  • Suitable for business intelligence (BI) and reporting professionals, data analysts.
  • Statisticians aiming to implement their statistics skill to derive business insights.
  • Marketing, Finance, Sales, and other domain Professionals who need extensive business intelligence.

Course content

7 sections • 82 lectures • 7h 16m total length

  • Preview05:00
  • Preview04:10
  • Power BI Overview & Installation
    02:25
  • Introduction Power BI Desktop
    08:52
  • Knowledge Check
    2 questions

  • Preview04:33
  • Connect to Excel in Power BI Desktop
    03:42
  • Connect to CSV files in Power BI Desktop
    01:33
  • Connect to SQL Server in Power BI Desktop
    01:28
  • Connect to a Web page from Power BI Desktop
    03:11
  • Enter data directly into Power BI Desktop
    03:24

  • Preview02:11
  • Query Editor
    11:04
  • Downloadable resources for Hands-on Excercise
    00:04
  • Data formatting Troubleshoot- Option 2
    00:29
  • Data formatting Troubleshoot - Option 1 (recommended)
    00:30
  • Text Transformations
    13:59
  • Number Column Calculations
    04:23
  • Data Type
    04:01
  • Date and Time Calculations
    11:24
  • Append Queries and Merge Queries
    16:24
  • Data Source Settings and Refresh Setings
    04:28
  • Power Query Data Formatting
    08:26
  • Hierarchy Creation in PowerBI
    04:00

  • Preview03:29
  • Primary key vs Foreign Key
    02:54
  • Relationship build, Edit, Delete
    08:54
  • Snowflake Scheme
    04:33
  • Active vs In Active relationship
    04:09
  • Relationship Primary key with multiple foreign keys from different data
    09:50

  • Preview03:06
  • Creating Calculated Columns, Creating Measures
    08:50
  • DAX Date and Time Functions
    10:51
  • DAX Text Functions
    06:13
  • DAX Logical Functions
    13:21
  • DAX Related Function
    09:05
  • DAX Implicit Vs Explicit Measures
    03:12
  • DAX Statistical Functions
    01:43
  • DAX Filter Functions
    07:40
  • DAX X-factor Functions
    05:26
  • DAX Time Intelligence Functions
    10:50
  • DAX Rank Functions
    05:09
  • New Table and Quick Measure
    05:07

  • Preview01:32
  • Page Settings
    05:27
  • Getting started with color formatting and axis properties
    07:34
  • Customize Visualization and X-axis and Y-axis properties
    08:13
  • Filters in Power BI
    05:15
  • Slicers in Power BI
    06:03
  • Table and Matrix
    04:25
  • Conditional formatting on visuals
    04:57
  • Card and Multi-row card
    12:49
  • Treemap
    02:49
  • Combo Chart
    03:22
  • Line chart, Area chart, and Stacked area chart
    02:56
  • Gauge chart
    07:19
  • KPI
    05:19
  • Drill through
    04:08
  • Map and Filled map
    06:11
  • Pie chart and Doughnut charts
    03:13
  • Ribbon charts
    04:28
  • Waterfall Chart
    03:42
  • Funnel chart
    02:52
  • Import Data model to Power BI desktop
    02:11
  • Phone layout
    02:02
  • Bookmark
    07:52

  • Preview03:10
  • Sign in to Power BI
    03:02
  • Power BI Service walkthrough
    05:59
  • Publishing a report from Power BI desktop to Power BI Service
    07:24
  • Create a Dashboard in Power BI Service
    05:21
  • Power BI Service Workspace UI
    04:18
  • Edit a Report in Power BI Service
    04:39
  • Power BI Report - Reading View
    14:31
  • Power BI Report - Usage Metrics
    03:11
  • Analyze in Excel
    04:07
  • Power BI Report - Quick insights
    02:58
  • Dashboard walkthrough
    02:31
  • Add Tile in Dashbaord
    03:06
  • Q and A
    04:15
  • Dataset Settings
    01:44
  • Get More Visuals
    03:09
  • Row-level security with Power BI
    04:11

Instructors

Learnsector LLP
Learn to Win
Learnsector LLP
  • 4.3 Instructor Rating
  • 4,549 Reviews
  • 211,713 Students
  • 6 Courses

Learnsector, your one-stop solution for all your training needs. We're dedicated to giving you the best in class training in the space of Programming, Cyber Security, Cloud, Machine Learning, Analytics and Project Management.

Our exclusive training helps you to acquire relevant skill set mandatory to grab thriving opportunities.We train you intensively to implement your technical skills in real-world scenario.We help you stay up-to-date with latest technologies and requirements of IT organizations across the world.

Navya Kannan
Software Asset Management Specialist
Navya Kannan
  • 4.4 Instructor Rating
  • 2,603 Reviews
  • 213,329 Students
  • 3 Courses

Started career as IT Service Desk executive for over 2 years. Later moved on to work as Software Asset Management (SAM) Specialist. My role involved taking care of Software compliance across the company. After continuing in this role for closer to 3 years, I started working as a Risk Consultant with the Big 4s. My role was to conduct software publisher specific audits to check an organisation's compliance status. This activity required extensive reporting, mainly with the help of Microsoft Excel and other tools. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.