Class Introduction
The team conducted a Power BI training session focused on data modeling and visualization. They reviewed the relationship between fact and dimension tables, explaining that fact tables contain many transaction records while dimension tables contain unique identifiers. The instructor guided students through creating relationships between tables including employees, customers, products, categories, shippers, and order details. They then moved on to dashboard creation, teaching students how to format shapes, add company logos, and implement data filters using slicers. The session covered adding multiple slicers with different data parameters including category names, company names, countries, cities, employee names, and month names. Finally, they attempted to create a line chart to visualize sales trends over time, though some students experienced technical difficulties with the chart formatting that the instructor noted needed further troubleshooting.
Power BI Data Modeling Concepts
The team discussed working with Power BI datasets, focusing on the Northwind Trader folder and reviewing modeling concepts. They conducted a revision on fact and dimension tables, explaining that fact tables represent transactions with many possible occurrences, while dimension tables contain unique identifiers. The team clarified that relationships should follow a many-to-one direction from fact to dimension tables.
Database Relationship Design Discussion
The team discussed establishing relationships between database tables, focusing on creating many-to-one relationships. They successfully linked employee ID, customer ID, product ID, and shipper ID between their respective tables. The team then addressed the relationship between product and category tables, explaining that since categories can appear multiple times for different products, the category ID should be placed in the product table. Finally, they established the relationship between order details and orders, with order ID serving as the connecting field. The discussion concluded with a mention of linking date fields from the orders table to a date table, though the specific implementation details were not completed in the transcript.
Power BI Data Visualization Training
The team discussed moving data from the order table to the date table by dragging and dropping order date, required date, and ship date into the date column. They then transitioned to working on report view and dashboard creation in Power BI, with the instructor explaining how to access and use the format tab for visualizations. The session covered the three types of pages in Power BI (standard, drill through, and tooltip) and basic visualization setup, with the instructor offering to provide individual assistance to team members who needed help with different interface views.
Related Offerings
Power BI Dashboard Creation Guide
The team discussed dashboard creation in Power BI, focusing on organizing data and visualization best practices. They explained the process of connecting data sources, cleaning the data once, and arranging it in tables and queries for reporting purposes. The discussion covered dashboard layout elements including company logos, titles, date slicers, and data filters, with specific instructions on formatting shapes and adding visual elements to dashboards.
PowerVR Dashboard Formatting Techniques
The team discussed how to format shapes in PowerVR, including changing colors and adding text. They demonstrated how to insert and format images, including options to upload images from a computer or enter image URLs. The team worked on adding a logo to the top left corner of the dashboard and discussed fitting the image within the designated box.
Data Dashboard Slicer Configuration
The team discussed adding and configuring slicers in their data dashboard. They explained how to access and use the slicer function through either the Insert dropdown or the build menu, and demonstrated how to add category names to slicers. The team learned to format slicers as drop-down lists, resize them for compactness, and add borders with custom colors. They practiced copying and pasting slicers to create multiple slices, with the goal of making six slices in total. The meeting took a brief 10-minute break before continuing.
Power BI Slicer Configuration Setup
The team worked on setting up multiple slicers in Power BI, with instructions provided for configuring different categories including category name, company name, country, city, employee name, and month name. Some team members experienced technical issues where multiple categories were showing simultaneously, which the instructor suggested could be resolved by saving and reopening the file. The session focused on properly configuring the slicers with different data tables and ensuring each category displayed correctly in the interface.
Dashboard Slicer Formatting Techniques
The team discussed how to properly arrange and format slicers in a dashboard, including selecting multiple slices and using the "distribute vertically" option for better alignment. They explained the process of creating a "Clear All Slices" button through the Insert tab to avoid accidentally clearing selections when working with the dashboard. The team demonstrated how to select and rearrange multiple slicers, including positioning the Clear All Slices button at the bottom of the dashboard.
Dashboard Date Slicer Implementation
The team discussed adding a date slicer to their dashboard and worked through the process of configuring it to display monthly data. They then attempted to create a line chart to visualize sales trends over time, but encountered technical issues with data not displaying properly in the chart. The session was concluded early due to ongoing formatting problems that needed to be addressed in a future class, with plans to revisit chart creation and visualization techniques in the next meeting.
Ready to turn your Power BI data model into interactive, business-ready dashboards?
👉 Explore our Power BI Data Analytics Training Program and learn data modeling, table relationships, slicers, dashboard design, DAX, interactive visualizations, and data storytelling through practical projects.
