Class Introduction

The meeting focused on data modeling and the start of visualization in Power BI. Team reviewed a hospital records assessment and explained the difference between fact and dimension tables, using examples like employee records and swipe-in/out events. Team clarified the concept of star and snowflake schemas and emphasized the importance of many-to-one relationships and creating a date table for time intelligence. The group then worked on a Northwind Traders report, where Team demonstrated how to set a custom theme, insert a company logo, and create a report title using a shape. Team showed how to create a card visual for net sales and how to add and format multiple slicers for categories, country/city, year, employee name, product name, and shipper company name. The session also covered how to align slicers and use hierarchical slicers. Team briefly discussed the use of different chart types for different data comparisons and mentioned the importance of following company brand guidelines for report design.


Visualization Class Planning Discussion
The team discussed an upcoming class focused on visualization, which was identified as core to the training program. Several participants including Balajee, Mahdi, and others joined the online meeting, though some key attendees like Mohit, Nitya, and Anju were absent. The instructor noted that only a few participants had completed the required data modeling assessment on healthcare records, and planned to review the assessment criteria before proceeding with the Northwin Traders files.

Data Modeling Facts and Dimensions
The team discussed data modeling approaches, focusing on facts and dimensions methodology. The instructor explained how to create a data model using a hospital scenario with tables for encounters, patients, organization, payers, and procedures. They demonstrated connecting these tables through relationships, emphasizing the importance of identifying fact tables (which record events) and dimension tables (which provide context). The instructor also addressed common challenges in linking tables with different column names and provided guidance on using Power Query to rename columns for better data modeling.

Related Offerings

Fact Table Modeling Concepts
Mahdi asked about headers and details in fact tables, using a receipt example from Lulu to illustrate the concept. The team explained that headers contain dimension information like company name and product ID, while details represent the transaction facts. The team emphasized the importance of practicing data modeling exercises and provided three key rules: differentiate between fact and dimension tables, maintain a many-to-one relationship, and always create and link a date table.

Data Modeling and Visualization
The team discussed the importance of using a date table in data modeling, with the instructor explaining that it enables proper time-based comparisons between different periods. Mahdi requested access to the necessary file and modeling work, which was provided by the instructor. The session transitioned to focusing on report visualization, with the instructor guiding the team to open report view and demonstrating how to access the design button for creating reports.

Power BI Theme Customization Guidelines
The team discussed how to customize themes and design elements in Power BI, focusing on company brand guidelines and color palettes. They walked through the process of accessing theme settings, customizing colors, and downloading theme JSON files for future use. The session also covered how to insert a title and company logo into reports, with specific instructions on formatting shapes and uploading images.

Power BI Report Formatting Guidance
The team provided technical guidance to Shabeeba on formatting a Power BI report, including adjusting the title position, inserting company logos and images, and configuring data visualization elements. They explained the fundamentals of Power BI data modeling, including the use of summarization symbols and the importance of data types for proper calculations. The session included practical demonstrations of creating different chart types (bar charts for budget comparisons, line charts for time series data, and pie charts for population breakdowns) and introduced the concept of slicers for data filtering.

Power BI Slicer Training Session
The team conducted a training session on creating and formatting slicers in Power BI, led by an instructor helping ROMMEL with practical demonstrations. They covered how to insert slicers, change formats to dropdown, replicate slicers, and apply formatting options like borders and shadows. The instructor explained hierarchical slicers using country-city examples and demonstrated how to filter data through multiple dimensions including category, date, employee, product, and shipper information. The session concluded with a request for students to leave positive Google reviews to counteract recent negative reviews affecting the business profile.

Learn how to build structured data models and create professional Power BI reports with interactive filters and consistent company branding. Join Team Academy’s practical Power BI training to strengthen your data modeling and dashboard design skills.

👉 Explore Team Academy’s Power BI training program and start building business-ready reports.