Up & Running with Power BI Desktop

WHAT WILL YOU LEARN?

In this course, you'll be playing the role of Lead Analyst for Adventure Works Cycles, a global manufacturing company. Your mission? Design and deliver a professional-quality, end-to-end business intelligence solution, armed only with a handful of raw csv files.

But don't worry, I'll be guiding you through the ins-and-outs of Power BI Desktop, sharing crystal clear explanations and helpful pro tips each step of the way.

We'll follow a steady, systematic progression through the B.I. workflow, and break down our project into four key objectives:

OBJECTIVE #1: Connect & Transform the Raw Data

• Intro to the Query Editor
• Types of Data Connectors
• Basic Table Transformations
• Text, Number & Date Tools
• Index & Conditional Columns
• Grouping, Aggregating, Pivoting & Unpivoting
• Modifying, Merging & Appending Queries
• Connecting to Folders
• Defining Hierarchies & Categories

OBJECTIVE #2: Build a Relational Data Model

• Intro to Database Normalization
• Data ("Fact") Tables vs. Lookup ("Dimension") Tables
• Creating Table Relationships
• "Star" vs. "Snowflake" Schemas
• Active vs. Inactive Relationships
• Filter Context & Cardinality
• Connecting Multiple Data Tables
• Hiding Fields from Report View
• Data Modeling best Practices

OBJECTIVE #3: Add Calculated Fields with DAX

• Intro to Data Analysis Expressions (DAX)
• Calculated Columns vs. Measures
• Row Context vs. Filter Context
• DAX Syntax & Operators
• Basic Date & Time Intelligence Formulas
• Logical & Conditional Statements
• Text, Math & Stats Functions
• CALCULATE, ALL & FILTER Functions
• DAX Iterators (SUMX, AVERAGEX)
• DAX Best Practices

OBJECTIVE #4: Design Interactive Reports

• Intro to the Power BI Report View
• Adding Objects & Basic Charts
• Formatting & Filtering Options
• Slicers, Timelines, Cards & KPIs
• Map Visuals (Basic, Fill, ArcGIS)
• Treemaps, Lines, Areas & Gauges
• Editing Report interactions & Drillthrough Filters
• Using Report Bookmarks & Parameters
• Managing & Viewing Roles
• Data Visualization Best Practices

By the end of the project, you'll have developed an entire BI tool from the ground up, and gained the knowledge and confidence to apply these same concepts to your own real-world analyses.

Whether you're a casual user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI ROCK STAR -- guaranteed.