Size: 4.97 GB
Transform, analyze & visualize data with Microsoft Power BI Desktop: hands-on demos, project files & 1-on-1 support
What you’ll learn
- 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
Requirements
- Microsoft Power BI Desktop (free download)
- This course is designed for PC/Windows users (currently not available for Mac)
- Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required
Description
NOTE: This is PART 1 of a 2-Part Microsoft Power BI series:- Up & Running with Power BI Desktop
- Publishing to Power BI Service
- 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 Drillthrough Filters
- Linking to Report Bookmarks
- Using “What-If” Parameters
- Managing & Viewing Roles
- PREVIEW: Publishing to Power BI Service
- Data Viz Best Practices
- 100+ page Power BI ebook
- Downloadable project files
- Homework exercises & quizzes
- 1-on-1 expert support
- Course Q&A forum
- 30-day money-back guarantee
Who this course is for:
- Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
- Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
- Aspiring data professionals looking to master the #1 business intelligence tool on the market
- Students who want a comprehensive, engaging, and highly interactive approach to training
You may also like
-
Python For Data Science And Machine Learning Bootcamp
-
The Complete Communication Skills Master Class for Life
-
Python for Finance: Investment Fundamentals & Data Analytics 2020
-
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL 2020
-
The Data Science Course 2019: Complete Data Science Bootcamp 2020