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 44 distinct relationships within the factor structure.
    • Passing values into function calls and measures, using test inputs such as 100100 and 120120.
  • 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 20242024, Microsoft 365365, Excel 20212021, and Excel 20192019.
  • 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:3306127.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:3306127.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.