• No products in the cart.

SCOPE OF POWER BI

Learn data visualization through Power BI and create opportunities for you or key decision makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.

You’ll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.

  • Connect Power BI to a Variety of Datasets
  • Analyze, Blend, Join, and Calculate Data
  • Visualize Data in the Form of Various Charts, Plots, and Maps

WHO SHOULD TAKE THIS COURSE

  • You should take this course if want to learn Power BI completely from scratch
  • You should take this course if you know some Power BI skills but want to get better
  • You should take this course if you are good with Power BI and want to take your skills to the next level and truly leverage the full potential of Power BI

Course Curriculum

Introductio to Power BI
Understanding the Power BI Tools 00:00:00
Installing Power BI Desktop and Connecting to Data 00:00:00
Working in the Query Editor 00:00:00
Initial Project 3/3: Working in the Data Model and Creating a Visualization 00:00:00
Course Outline 00:00:00
An Overview of the Workflow in Power BI Desktop 00:00:00
Introducing the Different Views of the Data Model 00:00:00
Taking a Closer Look at the Query Editor Interface 00:00:00
Before we Dive Deeper: Recommended Settings 00:00:00
An Introduction to the Query Editor
Just to be sure: What is the Query Editor? 00:00:00
Connecting Power BI Desktop to our Data Sources 00:00:00
Editing Rows 00:00:00
Understanding Append Queries 00:00:00
Editing Columns 00:00:00
Replacing Values 00:00:00
Formatting Data 00:00:00
Pivoting and Unpivoting Columns 00:00:00
Splitting Columns 00:00:00
Creating a New Group for our Queries 00:00:00
What we Achieved until Now and How to Continue 00:00:00
Introducing the Star Schema 00:00:00
Duplicating and Referencing Queries 00:00:00
Creating the DIM Region Table 00:00:00
Entering Data Manually 00:00:00
Merging Queries 00:00:00
Finishing the DIM Region Table 00:00:00
Introducing the DIM AgeGroup Table 00:00:00
Creating an Index Column 00:00:00
Duplicating Columns and Extracting Information 00:00:00
Creating Conditional Columns 00:00:00
” Creating the FACT Population Table” 00:00:00
Performing Basic Mathematical Operations 00:00:00
Improving Performance and Loading Data into the Data Model 00:00:00
Module Summary 00:00:00
QUIZ 00:00:00
Working on our Data Model: Data & Relationship View
Module Introduction 00:00:00
Query Editor vs. Data Model 00:00:00
Introducing and Understanding Relationships 00:00:00
Editing Relationships 00:00:00
Understanding Cardinality 00:00:00
Cross Filter Selection and Many-To-Many Relationships 00:00:00
Active Properties 00:00:00
Understanding the differences between the M-Language and DAX 00:00:00
M vs. DAX applied: Calculated Columns 00:00:00
M vs. DAX: Conclusion 00:00:00
DAX – Basic information 00:00:00
DAX and Calculated Columns 00:00:00
Calculated Columns vs. Measures 00:00:00
Introducing DAX-Measures 00:00:00
DAX-Measures Continued 00:00:00
Categorizing Data 00:00:00
Module Summary 00:00:00
QUIZ 00:00:00
Working in the Report View to Visualize our Results
Module Introduction 00:00:00
Understanding the Interface of the Report View 00:00:00
Creating our First Visualizations 00:00:00
Editing Interactions and Adding Tooltips 00:00:00
Adding Color Saturation 00:00:00
Understanding Hierarchies and Adding Drill-Down 00:00:00
Formatting Charts and Sorting 00:00:00
Introducing Slicers 00:00:00
Adding Treemaps and Tables 00:00:00
Applying different Filter Types 00:00:00
Creating (Multi-Row) Cards 00:00:00
Understanding Combined Visualizations and Waterfalls 00:00:00
Module Summary 00:00:00
QUIZ 00:00:00
Power BI Service & Power BI Mobile - How to Continue?
Module Introduction 00:00:00
Continuing our Work and why we need Power BI Service 00:00:00
Comparing Power BI Free, Pro and Premium 00:00:00
Logging in to Power BI Service 00:00:00
Understanding the Interface 00:00:00
Importing our Data from Power BI Desktop to Power BI Service 00:00:00
Understanding the Dataset Menu 00:00:00
Working on Reports 00:00:00
Introducing Dashboards 00:00:00
Exploring our Workspace 00:00:00
Understanding Gateways 00:00:00
Comparing Personal and On-Premise Gateway and Installing a Gateway 00:00:00
Working alone or Collaborating with Colleagues 00:00:00
Collaborating in App Workspaces 00:00:00
Sharing the Results 00:00:00
Publishing the App 00:00:00
Content Packs from Online Services 00:00:00
Power BI Mobile: Installing and Understanding the Mobile App 00:00:00
One Last Thing: Excluding Datasets from Sharing 00:00:00
Module Summary 00:00:00
QUIZ 00:00:00
Other Data Sources
” Module Introduction” 00:00:00
Importing JSON Data 00:00:00
Importing Data from REST APIs 00:00:00
Preparation: Setting up a MySQL Server 00:00:00
Importing Data from a MySQL Server (and other SQL Servers) 00:00:00
Wrap Up 00:00:00
Creating Custom Visuals (Power BI for Developers)
Developer Prerequisites 00:00:00
Module Introduction 00:00:00
How do Custom Visuals Work? 00:00:00
Using Data Driven Documents (D3) 00:00:00
Creating and Using a Visual 00:00:00
Installing an IDE (Code Editor) 00:00:00
Understanding the visuals.ts File 00:00:00
Understanding the Project Structure 00:00:00
Installing d3.js (Data Driven Documents) 00:00:00
Adding a First Shape 00:00:00
Connecting Shapes to Data 00:00:00
Scaling Shapes 00:00:00
Managing Visual Capabilities to Allow Data Input 00:00:00
Starting the Data Extraction 00:00:00
Limiting the Data Input 00:00:00
Extracting Data 00:00:00
Displaying the User Data 00:00:00
Optimizing the Code 00:00:00
Adding Dynamic Coloring 00:00:00
Making Bars Selectable (Cross-Visual) 00:00:00
Adding X-Axis Labels 00:00:00
Adding Custom Visuals Settings 00:00:00
Extracting the Visual Configuration 00:00:00
Informing Power BI About the Custom Configuration 00:00:00
Next Steps 00:00:00
Packaging the Custom Visual 00:00:00
Wrap Up 00:00:00
QUIZ 00:00:00
0 STUDENTS ENROLLED

    Related Courses

    X