Power BI Visualizations, Functions, Architecture, and MySQL Integration
Visualizations and Plotting Total Sales
- Visual plotting metrics for Total Sales:
- Total sales by year, configured in columns to construct the display structure.
- Total sales by month.
- Total sales by segment.
- Total sales by category and difference calculations across categories.
- Configuration of multiple charts and slicers:
- Creation of multiple charts to represent sales across varied dimensions.
- Dynamic filtering using slicers linked directly through exact category fields.
- Parameter field configuration within the field section.
- Utilization of the numeric range selector and the clear field function.
- Interface positioning and axis field mapping:
- Category field applied to the X-axis parameter.
- Field list positioned on the right side of the interface.
- Category names and multiple category selections routed through slicers on the left side to slice sales data across selected dates.
- Integration items present within Microsoft Outlook.
Power BI Suite, Ecosystem Architecture, and Project Presentation
- Core components of the Power BI ecosystem:
- Power BI Desktop: Local development tool for authoring reports and data models.
- Power BI Service suite: Cloud-based platform for collaboration, sharing, and deployment.
- Power BI Mobile App: Application for viewing reports on mobile devices.
- Power BI Gateway: Bridge for secure data transfer between on-premises sources and cloud services.
- Power BI Embedded: Service for integrating visuals and dashboards into custom applications.
- Enterprise cadence and updates:
- Company-level monthly update releases.
- Project presentation and domain requirements:
- Inclusion of valid structured points, allocated presentation time, and targeted slide areas.
- Value title definition corresponding to industry domains.
- Hospital domain project items.
- E-commerce domain project items, specifically focusing on e-commerce sales tracks.
User-Defined Functions (UDF) and DAX Time Intelligence
- User-Defined Functions (UDF) structure:
- Analogous in logic and structure to Python functions.
- Problem-solving approach via custom function definitions for complex tasks.
- Syntax structure: Initiated with the
define keyword, followed by the function name, equal operator, parameters, and expressions. - Parameter management and relational mappings, identifying approximately 4 distinct relationships within the factor structure.
- Passing values into function calls and measures, using test inputs such as 100 and 120.
- DAX calculations and data modeling:
- Evaluation of single values passed into expressions.
- Model updating utilizing
CALCULATE expression functions. - Creation of prior-period measures: Constructing
Sales last year compared against normal, original total sales last year.
Excel Versions, Export Workflows, and Semantic Models
- Microsoft Excel and Office 365 environments:
- Software versions: Excel 2024, Microsoft 365, Excel 2021, and Excel 2019.
- Export and publishing workflows:
- Power BI publish options for reports.
- Direct export capabilities for report pages into Microsoft PowerPoint and PDF formats.
- Semantic model management:
- Uploading semantic projects.
- Loading semantic models to the Power BI Service suite.
- Automated management of data source connections.
MySQL Database Configuration and Power BI Connection
- Connection parameters and network addressing:
- Server identifier / IP address and port:
127.0.0.1:3306 (127.0.0.1:3306). - Authentication credentials:
- Username:
root. - Password:
password.
- Database configuration and entity selection:
- Database customer tables:
Customer 1 through Customer 5. - Database name identifiers:
Saturday class Classroom / Saturday online offline class.
- Step-by-step navigation in Power BI Desktop:
- Open the Home tab in Power BI Desktop.
- Click on Data / Get Data.
- Select More options.
- Select MySQL Database and connect.
- Enter the Server ID:
127.0.0.1:3306 (127.0.0.1:3306). - Input the database name:
Saturday class Classroom. - Provide authentication credentials (Username:
root, Password: password). - Schedule: Session follows up in the next section on Monday.