Power BI Express: Unleashing Microsoft PowerBI in 6 Hours

Focused View

Vikas Munjal

6:09:03

180 View

1. Introduction

1. PowerBI Technology.mp4

05:52

2. PowerBI Architecture.mp4

07:30

3. Table of Contents.mp4

05:04

2. Power Query

1. Download & Install PowerBI Desktop.mp4

01:52

2. Power Query.html

3.1 PowerBiDataSources.zip

3. Please download the Data Resource used in the Course.html

4. Power Query 1.mp4

12:06

5. Power Query 2.mp4

08:28

3. PowerBi Visuals

1. Alternative Way if you dont know or have SQL Server.mp4

04:56

2. How to Restore Database using SSMS for performing Practicals.mp4

03:19

3.1 Method1 Adw.zip

3.2 Method2 adw.zip

3. Please download Database for Practice.html

4. Clustered Column Chart, Categorizing Data, DrillUp & Down.mp4

09:56

5. Formatting Clustered Column Chart Part 1.mp4

12:48

6. Formatting Clustered Column Chart Part 2.mp4

06:11

7. LineChart, Sorting based on another coulmn, Filters & Multipliers.mp4

07:28

8. Pie Chart.mp4

06:32

9. Stacked & 100 Percent Stacked Column and Bar Chart.mp4

10:23

10. Area Chart.mp4

06:26

11. Stacked Area Chart.mp4

07:43

12. Combo Charts - Line & Clustered AND Line & Stacked Column Chart.mp4

05:55

13. Important Note on DAX Formula.html

14. Table, Slicer, Conditional Formatting & Cascading Dropdown.mp4

13:57

15. Matrix Visual.mp4

11:24

16. TreeMap Visual.mp4

04:56

17. Card and Multi-Row Card.mp4

06:32

18. Gauge Chart.mp4

09:00

19. Key Performance Indicator Visual.mp4

12:10

20. Funnel Chart.mp4

08:00

4. Advanced Reports and Dashboards

1. Data Flow in Relationship.mp4

09:45

2. Data Flow in Relationship Continues.mp4

08:07

3. An alternative way to build Semantic Model using Excel WorkBook Data.mp4

09:38

4. Dashboard - Dataset, TextBox , Images and Background Colour.mp4

10:23

5. Dashboard - Adding Custom Visuals , DAX Measures and ScoreCards.mp4

10:22

6. Dashboard - Adding Visual & Format it.mp4

06:06

7. Dashboard - Forecast Option, Adding Donut Chart & Rectangles.mp4

09:45

8. Dynamic Measures - DAX Calculation using SELECTEDVALUE & SWITCH.mp4

15:20

9. Dynamic Dashboard.mp4

09:31

10. Reporting using BookMark and Q&A.mp4

10:05

11. Filter Levels in Reporting.mp4

01:48

12. Report Page as ToolTip.mp4

07:35

5. Publish Report to PowerBI Service

1. Publish Report to PowerBI Service.mp4

04:31

2. Data Gateway Facilitating Scheduled Data Refresh in PowerBI Service.mp4

09:36

3. Report Refresh using CSV File without Schedule.mp4

05:59

4. Three main Power BI service licenses.mp4

03:07

5. Clarification on Dashboards.mp4

05:53

6. Many ways to create Dashboards inside PowerBI Service.mp4

07:06

7. Display Report and Dashboard in Full Screen Mode.mp4

02:04

8. Subscribe, Share and Download Report.mp4

04:56

9. Quick Insights.mp4

04:02

10. Featured Q&A Questions.mp4

02:11

11. WorkSpace and App Difference and their Security Options.mp4

10:51

12. Row Level Security.mp4

05:43

13. Creating Mobile Layout Report and Testing Reports in Mobile App.mp4

04:34

14. Testing BookMark and Report Page ToolTip in PowerBI Service.mp4

01:37

Description

Efficient and Rapid Learning for Data Visualization and Business Intelligence

What You'll Learn?

Understanding the underlying technology and architecture of PowerBI.
Efficient Data Preparation Techniques
Effective Visualization Skills
Advanced Reporting and Dashboard Building
Seamless Power BI Service Integration

Who is this for?

It is designed specifically for beginners or who wants to quickly revise the PowerBI Technology

This course is designed for individuals seeking to enhance their knowledge and skills in PowerBI.

This course provides valuable insights and practical techniques tailored to your learning needs.

It is ideal for Students,Professionals,Entrepreneurs,Freelancers,Hobbyists and Enthusiasts

What You Need to Know?

No prior knowledge or programming language skills are required to enroll in this course.

The only requirement is Microsoft Excel should be installed to your machine.

No need even to install SQL Server.

More details

Description
PowerBI Course Topics:
PowerBI Technology
PowerBI Architecture
Download & Install PowerBI Desktop
Power Query:
Importing Data From Many Sources
Use First Row as Headers
Remove Rows
Keep Rows
Add Custom Columns
Append Queries
Rename Columns
Split Columns
Merge Columns
Merge Queries
Queries Settings
Remove Columns
Transform the Columns using Date
Pivot & Unpivot Columns
Group By Data Based on Multiple Columns
Disable Load
Introduction to Power BI Visuals:
Creating Clustered Column Charts:
Understanding the basics of Clustered Column Charts
Formatting options for enhanced visualization
Categorizing Data in Visuals:
Techniques for effectively categorizing and grouping data
Utilizing categories for improved insights
Drilling Up & Down in Visuals:
Exploring drill-up and drill-down functionalities
Enhancing data exploration through hierarchical views
Formatting Clustered Column Charts:
In-depth look at formatting options for Clustered Column Charts
Customizing visuals for a polished and professional appearance
LineChart Visualization:
Creating LineCharts for trend analysis
Sorting based on another column for dynamic visuals
Applying filters and multipliers for refined insights
Pie Chart Visualizations:
Utilizing Pie Charts for proportional data representation
Customization options for Pie Charts
Stacked & 100 Percent Stacked Visualizations:
Understanding the nuances of Stacked and 100 Percent Stacked visuals
Creating Column and Bar Charts with stacked variations
Area Chart and Stacked Area Chart:
Exploring the application of Area Charts
Creating Stacked Area Charts for cumulative representation
Combo Charts:
Integrating Line & Clustered Column Charts
Integrating Line & Stacked Column Charts for richer insights
Table, Slicer, Conditional Formatting & Cascading Dropdown:
Creating tables for detailed data representation
Implementing slicers for interactive filtering
Leveraging conditional formatting for emphasis
Cascading dropdowns for refined data selection
Matrix Visual and TreeMap Visual:
Understanding the versatility of Matrix Visuals
Utilizing TreeMap for hierarchical and nested data representation
Card and Multi-Row Card:
Creating Card visuals for key metrics
Implementing Multi-Row Cards for expanded information display
Gauge Chart and Key Performance Indicator Visual:
Visualizing performance metrics with Gauge Charts
Utilizing Key Performance Indicator (KPI) Visuals for strategic insights
Funnel Chart:
Creating Funnel Charts for visualizing sales or process data

Advanced Reports and Dashboards:

Understanding Data Flow in Relationships:
Importance in Analytical Architecture
Navigating Interconnected Pathways
Role in the Project
Building Dashboards:
Dataset Integration
TextBox, Images, and Background Color Essentials
Enhancing Dashboards with Advanced Elements:
Custom Visuals Integration
Leveraging DAX Measures and ScoreCards
Adding and Formatting Visuals:
Positioning Visual Components for Enhanced Engagement
Consistency in Design Elements
Exploring Forecast Options and Visual Elements:
Predictive Power of Forecasting
Crafting Insights with Donut Charts and Rectangles
Implementing Dynamic Measures with DAX:
SELECTEDVALUE Function
SWITCH Function for Dynamic Dashboard
Crafting Dynamic Dashboards:
Integrating Dynamic Measures
User-Driven Interaction and Personalization
Utilizing Report Page as Tooltip:
Immersive Tooltip Experiences
Enhancing User Engagement
Reporting using Bookmarks and Q&A:
Use of Bookmarks
Harnessing Q&A for Natural Language Interaction
Analysis with Filter Levels:
Tailoring Granularity for Comprehensive Reporting
Power BI Service:
Publish Report to Power BI Service:
Initiating the Transition from Desktop to Service
Ensuring Seamless Collaboration with Online Platform
Data Gateway Facilitating Scheduled Data Refresh in Power BI Service:
Understanding the Role of Data Gateway
Enabling Scheduled Data Refresh for Timely Insights
Report Refresh using CSV File without Schedule:
Flexible Data Refresh Options
Utilizing CSV Files for On-Demand Data Updates
Three main Power BI service licenses:
Unpacking Licensing Tiers
Selecting the Right License for Your Organization
Clarification on Dashboards:
Defining Dashboards in Power BI
Clarifying their Role in the Reporting Ecosystem
Many ways to create Dashboards inside Power BI Service:
Diverse Approaches to Dashboard Creation
Tailoring Dashboards to Suit Data Storytelling Needs
Display Report and Dashboard in Full Screen Mode:
Maximizing Visibility for Enhanced Presentation
Creating Impactful Full-Screen Displays
Subscribe, Share and Download Report:
Facilitating Information Dissemination
Enabling User Engagement through Sharing and Downloading
Quick Insights:
Harnessing Automated Insights for Rapid Analysis
Uncovering Actionable Information Swiftly
Featured Q&A Questions:
Utilizing Q&A Features to Extract Information
Incorporating User-Generated Queries
WorkSpace and App Difference and their Security Options:
Understanding Workspaces and Apps
Exploring Security Options for Controlled Access
Row Level Security:
Implementing Granular Data Security Measures
Ensuring Restricted Access at Row Level
Creating Mobile Layout Report and Testing Reports in Mobile App:
Adapting Reports for Mobile Consumption

Testing BookMark and Report Page ToolTip in Power BI Service:
Validating Interactive Elements in Power BI Service
Ensuring Seamless User Experience with Bookmarks and ToolTips

Who this course is for:
It is designed specifically for beginners or who wants to quickly revise the PowerBI Technology
This course is designed for individuals seeking to enhance their knowledge and skills in PowerBI.
This course provides valuable insights and practical techniques tailored to your learning needs.
It is ideal for Students,Professionals,Entrepreneurs,Freelancers,Hobbyists and Enthusiasts

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Vikas Munjal

Instructor's Courses

Having more than 15 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India.My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understand , remember and learn all the things in pictures , diagrams or images . This is the science of learning.My Microsoft Certifications are:Microsoft Certified Solution Expert Data PlatformMicrosoft Certified Solution Expert Business IntelligenceMicrosoft Certified Solution Expert Data Management and AnalyticsMicrosoft Certified Solution Associate SQL Server 2012/2014Microsoft Certified Professional

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.