• Post category:StudyBullet-8
  • Reading time:12 mins read


Hands-on Guide to Mastering Power BI Desktop and Power BI Service

What you will 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.

Description

More than +70,000 satisfied students worldwide have enrolled in this course, writing thousands of 5-star reviews.

“I recommend this course for anybody starting with Power BI. It touches all aspects of the desktop and online tool for visual development. If multiple data source examples are included then it would be very complete (like data gateway, data flow, etc.). Given the scope of the course, I still considered this one of the best available. I am able to follow at 2x speed and complete the course.”

Vidya L

“If you want to know all about PowerBi, then this course for you. Concepts are explained in detail & simple as well, which makes us understand the concepts clearly. I strongly recommend this course for beginners, go for it !!!. Happy learning !!! Special Thanks to Navya Mam, for making this course and boosting my career skills.”

Sundaram Subramanian

“The instructor has done a very good job by explaining all the features of Power BI in a much simpler way which anyone with any experience can understand easily. I am really happy and have all the required knowledge to implement for the real-time project.”

Shani Jaiswal

“I think covering the entire (in true sense end to end) tool with an example makes a first-time viewer like me a good hold and develops an encouragement for its use. Nicely covered and an informative tutorial!”

Shreyas Shringi

“This is an excellent course to learn Power BI, its components, and various functionalities. All the modules are very clearly explained with examples.”

Chiranjeevi Rao Boddu

“What a great course! The instructor was so detailed, showing us how to perform various functions from manual to automated. The case studies were very real and I can vouch for that as a data scientist with a business background. It is obvious that the lesson planning was done meticulously and if I could rate this 6 stars, I would.”

Len Kwok

One of the BEST resources to learn power Bi that I found in Udemy. thanks a lot and keep it up…”
Naag Sadineni


Get Instant Notification of New Courses on our Telegram channel.


Goes in-depth for even a person who just starts with PowerBI can follow. There are some issues with date formatting in few data sets (different sheets had different date formats), which I solved using the tips provided on date formatting in the 14 and 15 points. All in all very helpful for a person who is starting with PowerBI.”

Yasintha Jayaratne

“Excellent course, excellent teacher. I appreciate following this course because the teacher knows and explains well the concepts.”

Abdoul TraorΓ©

And many thousands more…

Course 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

You get lifetime access and a 30 day, 100% money-back guarantee!

English
language

Content

Business Intelligence (BI) Concepts & introduction

Introduction to Business Intelligence
The relation between Business Intelligence and Data Warehouse
Power BI overview & Installation
Introduction Power BI desktop

Connecting Power BI with Different Data sources

Connecting with Data
Connect to Excel in Power BI Desktop
Connect to CSV files in Power BI Desktop
Connect to SQL Server in Power BI Desktop
Connect to a Web page from Power BI Desktop
Enter data directly into Power BI Desktop

Power Query for Data Transformation

Introduction to power query
Query Editor
Text Transformations
Number Column Calculations
Data Type
Date and Time Calculations
Append Queries_Merge Queries
Data source settings and Refresh setings
Data formatting
Hierarchy Creation in PowerBI

Power BI Data Modeling – Relationship View & PowerPivot

Data Modeling Introduction
Primary key vs Foreign Key
Relationship build, Edit, Delete
Snowflake Scheme
Active vs In Active relationship
Relationship Primary key with multiple foreign keys from different data

Data Analysis Expression (DAX)

Data Analysis Expression (DAX)
Creating Calculated Columns, Creating Measures
DAX Date and Time Functions
DAX Text Functions
DAX Logical Functions
Related Function
Implicit Vs Explicit Measures
Statistical Functions
DAX Filter Functions
DAX X-factor Functions
DAX Time Intelligence Functions
DAX Rank Functions
New Table and Quick Measure

Reports & Visualization types in Power BI

Reports and Visualization types in Power BI
Page Settings
Getting started with color formatting and axis properties
Customize Visualization and X-axis and Y-axis properties
Filters in Power BI
Slicers in Power BI
Table and Matrix
Conditional formatting on visuals
Card and Multi-row card
Treemap
Combo Chart
Line chart, Area chart, and Stacked area chart
Gauge chart
KPI
Drill through
Map and Filled map
Pie chart and Doughnut charts
Ribbon charts
Waterfall Chart
Funnel chart
Import Data model to Power BI desktop
Phone layout
Bookmark

PowerBi Publishing- Reports

Comparing Power BI desktop and Power BI Service
Sign in to Power BI
Power BI Service walkthrough
Publishing a report from Power BI desktop to Power BI Service
Create a Dashboard in Power BI Service
Power BI Service Workspace UI
Edit a Report in Power BI Service
Power BI Report – Reading View
Power BI Report – Usage Metrics
Analyze in Excel
Power BI Report – Quick insights
Dashboard walkthrough
Add Tile in Dashbaord
Q and A
Dataset Settings
Get More Visuals
Row-level security with Power BI