Our team is new to Power BI and we need to get up and running quickly. I know there are some video resources online but we are looking to get some guided Power BI classes for the team. Can anyone please recommend a great vendor/resource that could provide a 3 day Power BI class in Orange County (Brea), California? We are looking to have this training tailored to our Team of 5-7 people along with our data rather than using fake/non-relative to us. This will make the training more impactful and better received by the team. Below are a few topics that I would like to cover 3-day training. I'm sure it's a lot... Any help would be greatly appreciated. -Silvio Day 1 = Intro / Basic Functionalities: POWER BI OBJECTIVE #1: Connect & Transform the Raw Data • Intro to the Power BI Query Editor • Types of Power BI 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 & Power BI Best Practices POWER BI OBJECTIVE #2: Build a Relational Data Model • Intro to Database Normalization • Data ("Fact") Tables vs. Lookup ("Dimension") Tables • Creating Power BI Table Relationships • "Star" vs. "Snowflake" Schemas • Active vs. Inactive Relationships • Relationship Cardinality • Connecting Multiple Data Tables • Filtering & Cross-Filtering • Hiding Fields from the Power BI Report View • Data Modeling & Power BI best Practices Day 2 - 3 = Intermediate / Advanced (Calculations / Dax / Advanced Dashboarding Features) POWER BI OBJECTIVE #3: Add Calculated Fields with DAX • Intro to Data Analysis Expressions (DAX) • Calculated Columns vs. Measures • Row Context vs. Filter Context in Power BI • DAX Syntax & Operators • Common Power BI Functions • 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 & Power BI Best Practices POWER BI OBJECTIVE #4: Design Interactive Power BI Reports • Intro to the Power BI Report View • Adding Basic Charts to Power BI Reports • Formatting & Filtering Options • Matrix Visuals • Slicers & Timelines • Cards & KPIs • Power BI 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 • Power BI Data Viz Best Practices POWER BI OBJECTIVE #5: Power BI Service & Publishing We’ll start with a quick orientation to the Power BI landscape and Power BI Service interface, introduce some common user personas (Creators, Analyzers, and Collaborators), and then systematically guide you through the key features of Power BI Service, including: • Connecting to Data from Power BI Service • Flat files, Excel workbooks, tables, Power BI reports, etc. • Configuring Gateways, Scheduled Refresh & Dataflows • Personal vs. Enterprise gateways, refresh settings, Power BI dataflows, etc. • Creating Power BI Reports & Dashboards • Reading vs. Editing views, pinning tiles & pages, assembling dashboards, etc. • Exploring & Analyzing Data within Power BI Service • Natural language Q&A, data-driven alerts, quick insights, bookmarks, etc. • Publishing, Sharing & Collaborating • Creating Apps, sharing Power BI workspaces, assigning user roles and row-level security, etc. • Using the Power BI Mobile App • Annotating, sharing, commenting, alerting, etc.
