This practical course is designed for those who need to create business analytics using Microsoft Power BI. Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analyzed and published from a variety of sources. With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets, you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. By the end of the Adventure Works project, not only will you have developed an entire business intelligence tool from the ground up, but you will have gained the knowledge and confidence to apply these same concepts to your own real-world analyses.
Introduction to business intelligence
Introduction to data analysis
Introduction to data visualization
Overview of self-service BI
Considerations for self-service BI
Microsoft tools for self-service BI
Intro to the Query Editor
Types of Data Connectors
Basic Table Transformations
Text, Number & Date Tools
Index & Conditional Columns
Grouping & Aggregating Data
Pivoting & Unpivoting
Modifying, Merging & Appending Queries
Connecting to Folders
Defining Hierarchies & Categories
Query Editing Best Practices
Intro to Database Normalization
Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables
Creating Table Relationships
“Star” vs. “Snowflake” Schemas
Active vs. Inactive Relationships
Relationship Cardinality
Connecting Multiple Data Tables
Filtering & Cross-Filtering
Hiding Fields from Report View
Data Modeling Best Practices
Intro to Data Analysis Expressions (DAX)
Calculated Columns vs. Measures
Row Context vs. Filter Context
DAX Syntax & Operators
Common Function Categories
Basic Date & Time Formulas
Logical & Conditional Statements
Text, Math & Stats Functions
Joining Data with RELATED
CALCULATE, ALL & FILTER Functions
DAX Iterators (SUMX, AVERAGEX)
Time Intelligence Formulas
DAX Best Practices
Intro to the Power BI Report View
Adding Objects & Basic Charts
Formatting & Filtering Options
Matrix Visuals
Slicers & Timelines
Cards & KPIs
Map Visuals (Basic, Fill, ArcGIS)
Treemaps, Lines, Areas & Gauges
Editing Report interactions
Adding Drill through Filters
Linking to Report Bookmarks
Using “What-If” Parameters
Managing & Viewing Roles
PREVIEW: Publishing to Power BI Service
Data Viz Best Practices
Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer
Find subjects you're passionate about by browsing our online course categories. Start
learning with top courses Built With Industry Experts.