cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samartinez Frequent Visitor
Frequent Visitor

Need Power BI Guided Training Classes for Our Team

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Need Power BI Guided Training Classes for Our Team

Hi @samartinez ,

I'd like to suggest you to take a look at power bi guide learning documents:

Microsoft Power BI Guided Learning

Getting started with Power BI Desktop

Power BI Training Resources (Free)
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Need Power BI Guided Training Classes for Our Team

Hi @samartinez ,

I'd like to suggest you to take a look at power bi guide learning documents:

Microsoft Power BI Guided Learning

Getting started with Power BI Desktop

Power BI Training Resources (Free)
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

samartinez Frequent Visitor
Frequent Visitor

Re: Need Power BI Guided Training Classes for Our Team

Thanks again. These are great resources for self-paced learning and researching for a particular issue. I was hoping to receive a referral so that our team receives customized face-to-face training. -Silvio

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 397 members 3,602 guests
Please welcome our newest community members: