Powerbi Express: Unleashing Microsoft Powerbi In 6 Hours

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

Requirements

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.

Description

PowerBI Course Topics:PowerBI TechnologyPowerBI ArchitectureDownload & Install PowerBI DesktopPower Query:Importing Data From Many SourcesUse First Row as HeadersRemove RowsKeep RowsAdd Custom ColumnsAppend QueriesRename ColumnsSplit ColumnsMerge ColumnsMerge QueriesQueries SettingsRemove ColumnsTransform the Columns using DatePivot & Unpivot ColumnsGroup By Data Based on Multiple ColumnsDisable LoadIntroduction to Power BI Visuals:Overview of the importance of data visualizationSignificance of Power BI Visuals in data storytellingCreating Clustered Column Charts:Understanding the basics of Clustered Column ChartsFormatting options for enhanced visualizationCategorizing Data in Visuals:Techniques for effectively categorizing and grouping dataUtilizing categories for improved insightsDrilling Up & Down in Visuals:Exploring drill-up and drill-down functionalitiesEnhancing data exploration through hierarchical viewsFormatting Clustered Column Charts:In-depth look at formatting options for Clustered Column ChartsCustomizing visuals for a polished and professional appearanceLineChart Visualization:Creating LineCharts for trend analysisSorting based on another column for dynamic visualsApplying filters and multipliers for refined insightsPie Chart Visualizations:Utilizing Pie Charts for proportional data representationCustomization options for Pie ChartsStacked & 100 Percent Stacked Visualizations:Understanding the nuances of Stacked and 100 Percent Stacked visualsCreating Column and Bar Charts with stacked variationsArea Chart and Stacked Area Chart:Exploring the application of Area ChartsCreating Stacked Area Charts for cumulative representationCombo Charts:Integrating Line & Clustered Column ChartsIntegrating Line & Stacked Column Charts for richer insightsTable, Slicer, Conditional Formatting & Cascading Dropdown:Creating tables for detailed data representationImplementing slicers for interactive filteringLeveraging conditional formatting for emphasisCascading dropdowns for refined data selectionMatrix Visual and TreeMap Visual:Understanding the versatility of Matrix VisualsUtilizing TreeMap for hierarchical and nested data representationCard and Multi-Row Card:Creating Card visuals for key metricsImplementing Multi-Row Cards for expanded information displayGauge Chart and Key Performance Indicator Visual:Visualizing performance metrics with Gauge ChartsUtilizing Key Performance Indicator (KPI) Visuals for strategic insightsFunnel Chart:Creating Funnel Charts for visualizing sales or process dataCustomizing Funnel Charts for specific requirementsEmpowering Data Storytelling with Advanced Reports and Dashboards:Understanding Data Flow in Relationships:Importance in Analytical ArchitectureNavigating Interconnected PathwaysRole in the ProjectBuilding Dashboards:Dataset IntegrationTextBox, Images, and Background Color EssentialsEnhancing Dashboards with Advanced Elements:Custom Visuals IntegrationLeveraging DAX Measures and ScoreCardsVisual Storytelling: Adding and Formatting Visuals:Strategic Placement of Visual ElementsOptimal Formatting for Impactful PresentationExploring Forecast Options and Visual Elements:Predictive Power of ForecastingCrafting Insights with Donut Charts and RectanglesImplementing Dynamic Measures with DAX:SELECTEDVALUE FunctionSWITCH Function for Dynamic DashboardCrafting Dynamic Dashboards:Integrating Dynamic MeasuresUser-Driven Interaction and PersonalizationUtilizing Report Page as Tooltip:Immersive Tooltip ExperiencesEnhancing User EngagementMastering Reporting using Bookmarks and Q&A:Strategic Use of BookmarksHarnessing Q&A for Natural Language InteractionAnalysis with Filter Levels:Tailoring Granularity for Comprehensive ReportingAdapting to Changing Analytical NeedsPower BI Service:Publish Report to Power BI Service:Initiating the Transition from Desktop to ServiceEnsuring Seamless Collaboration with Online PlatformData Gateway Facilitating Scheduled Data Refresh in Power BI Service:Understanding the Role of Data GatewayEnabling Scheduled Data Refresh for Timely InsightsReport Refresh using CSV File without Schedule:Flexible Data Refresh OptionsUtilizing CSV Files for On-Demand Data UpdatesThree main Power BI service licenses:Unpacking Licensing TiersSelecting the Right License for Your OrganizationClarification on Dashboards:Defining Dashboards in Power BIClarifying their Role in the Reporting EcosystemMany ways to create Dashboards inside Power BI Service:Diverse Approaches to Dashboard CreationTailoring Dashboards to Suit Data Storytelling NeedsDisplay Report and Dashboard in Full Screen Mode:Maximizing Visibility for Enhanced PresentationCreating Impactful Full-Screen DisplaysSubscribe, Share and Download Report:Facilitating Information DisseminationEnabling User Engagement through Sharing and DownloadingQuick Insights:Harnessing Automated Insights for Rapid AnalysisUncovering Actionable Information SwiftlyFeatured Q&A Questions:Utilizing Q&A Features to Extract InformationIncorporating User-Generated QueriesWorkSpace and App Difference and their Security Options:Understanding Workspaces and AppsExploring Security Options for Controlled AccessRow Level Security:Implementing Granular Data Security MeasuresEnsuring Restricted Access at Row LevelCreating Mobile Layout Report and Testing Reports in Mobile App:Adapting Reports for Mobile ConsumptionTesting BookMark and Report Page ToolTip in Power BI Service:Validating Interactive Elements in Power BI ServiceEnsuring Seamless User Experience with Bookmarks and ToolTips

Overview

Section 1: Introduction

Lecture 1 PowerBI Technology

Lecture 2 PowerBI Architecture

Lecture 3 Table of Contents

Section 2: Power Query

Lecture 4 Download & Install PowerBI Desktop

Lecture 5 Power Query

Lecture 6 Please download the Data Resource used in the Course

Lecture 7 Power Query 1

Lecture 8 Power Query 2

Section 3: PowerBi Visuals

Lecture 9 Alternative Way if you don't know or have SQL Server

Lecture 10 How to Restore Database using SSMS for performing Practicals

Lecture 11 Please download Database for Practice

Lecture 12 Clustered Column Chart, Categorizing Data, DrillUp & Down

Lecture 13 Formatting Clustered Column Chart Part 1

Lecture 14 Formatting Clustered Column Chart Part 2

Lecture 15 LineChart, Sorting based on another coulmn, Filters & Multipliers

Lecture 16 Pie Chart

Lecture 17 Stacked & 100 Percent Stacked Column and Bar Chart

Lecture 18 Area Chart

Lecture 19 Stacked Area Chart

Lecture 20 Combo Charts - Line & Clustered AND Line & Stacked Column Chart

Lecture 21 Important Note on DAX Formula

Lecture 22 Table, Slicer, Conditional Formatting & Cascading Dropdown

Lecture 23 Matrix Visual

Lecture 24 TreeMap Visual

Lecture 25 Card and Multi-Row Card

Lecture 26 Gauge Chart

Lecture 27 Key Performance Indicator Visual

Lecture 28 Funnel Chart

Section 4: Advanced Reports and Dashboards

Lecture 29 Data Flow in Relationship

Lecture 30 Data Flow in Relationship Continues

Lecture 31 An alternative way to build Semantic Model using Excel WorkBook Data

Lecture 32 Dashboard - Dataset, TextBox , Images and Background Colour

Lecture 33 Dashboard - Adding Custom Visuals , DAX Measures and ScoreCards

Lecture 34 Dashboard - Adding Visual & Format it

Lecture 35 Dashboard - Forecast Option, Adding Donut Chart & Rectangles

Lecture 36 Dynamic Measures - DAX Calculation using SELECTEDVALUE & SWITCH

Lecture 37 Dynamic Dashboard

Lecture 38 Reporting using BookMark and Q&A

Lecture 39 Filter Levels in Reporting

Lecture 40 Report Page as ToolTip

Section 5: Publish Report to PowerBI Service

Lecture 41 Publish Report to PowerBI Service

Lecture 42 Data Gateway Facilitating Scheduled Data Refresh in PowerBI Service

Lecture 43 Report Refresh using CSV File without Schedule

Lecture 44 Three main Power BI service licenses

Lecture 45 Clarification on Dashboards

Lecture 46 Many ways to create Dashboards inside PowerBI Service

Lecture 47 Display Report and Dashboard in Full Screen Mode

Lecture 48 Subscribe, Share and Download Report

Lecture 49 Quick Insights

Lecture 50 Featured Q&A Questions

Lecture 51 WorkSpace and App Difference and their Security Options

Lecture 52 Row Level Security

Lecture 53 Creating Mobile Layout Report and Testing Reports in Mobile App

Lecture 54 Testing BookMark and Report Page ToolTip in PowerBI Service

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