cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 Smiley Happy 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.
3 REPLIES 3
MaryseM New Member
New Member

Re: Need Power BI Guided Training Classes for Our Team

You can try to contact https://www.pragmaticworkstraining.com

Regards

samartinez Frequent Visitor
Frequent Visitor

Re: Need Power BI Guided Training Classes for Our Team

Thanks MaryseM for the self-paced course vendor. This is a great resource too. I think we would prefer to have a face-to-face instructor. This will minimize our distraction and keep us focused rather than trying to learn and work at the same time Smiley Happy I will definitely take advantage of this resource though. Thx. Silvio
lbudack Frequent Visitor
Frequent Visitor

Re: Need Power BI Guided Training Classes for Our Team

I recently took a one-day workshop with Blue Granite and really enjoyed it. They do custom projects like this as well as trainings so check them out. They're based in Michigan but do travel. https://www.blue-granite.com/contact-us

 

Good luck! 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 188 members 2,268 guests
Please welcome our newest community members: