Advanced Power BI Layer Grouping techniques / Naming conventions
Advanced Power BI Bookmarking techniques (multiple views within the same page)
Advanced Power BI Navigation Pane creation
Microsoft Power BI Report/Dashboard Background creation in PowerPoint
Alignment tools in PowerPoint and Power BI
Advanced Power BI slicer integration
Resizing tools in PowerPoint and Power BI
Power BI Drill-through page creation
Power BI Tooltip page creation
Custom Power BI theme creation
Utilization of icons / animated icons in Power BI reports
Web app like designed page

Pizza Place Sales
A year's worth of sales from a fictitious pizza place,
the date and time of each order and the pizzas served,
additional details on the type, size, quantity, price, and ingredients.
Recommended Analysis
How many customers do we have each day? Are there any peak hours?
How many pizzas are typically in an order? Do we have any bestsellers?
How much money did we make this year? Can we indentify any seasonality in the sales?
Are there any pizzas we should take of the menu, or any promotions we could leverage?

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org..

Set Up

• CSV
• Raw Data ETL
• Data Modeling
• DAX
• Dashboard Visualisation

Identify basic Power BI functionality, including data sources, contextual menus, regional settings, and differences between Power BI Desktop & Service.
Identify common Power Query tools and use cases for adding and transforming columns, including grouping, merging, appending, and transforming text and dates.
Identify common data modeling tools and best practices, including table names, relationships, hierarchies, data categories, cardinality, and filter flow.
Identify examples of filter context and various filtering methods, including user roles, parameters, and drill through filters.
Identify DAX syntax, when to use common functions, performance implications, and differences between measures and calculated columns.
Identify and interpret key Power BI visuals, including configuration options, interaction modes, and common use cases.
Identify common optimization techniques, including pausing visuals, applying presets, analyzing performance, and leveraging external tools.

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org..

Set Up

• MS SQL
• Raw Data ETL
• Data Modeling
• DAX
• Dashboard Visualisation
• Just sit back, relax and enjoy the show :)

Business Requirements

DS - Sales Manager:
We need to improve our internet sales reports and want to move from static reports to visual dashboards.
Essentially, we want to focus it on how much we have sold of what products, to which clients and how it has been over time.
Seeing as each sales person works on different products and customers it would be beneficial to be able to filter them also.
We measure our numbers against budget, so I added that in a spreadsheet, so we can compare our values against performance. The budget is for 2023, and we usually look 2 years back in time when we do analysis of sales.
Let me know if you need anything else!
// DS

Set Up

• MS SQL
• SQL Server Management Studio
• Power Bi
• AdventureWorks DBs 2019
• Update SQL AdventureWorks DBs 2019 Script
• Sent Over Data - regarding Sales Budget
• Business Request & Demand Overview
• Creating Power BI Dashboards

Identify basic Power BI functionality, including data sources, contextual menus, regional settings, and differences between Power BI Desktop & Service.
Identify common Power Query tools and use cases for adding and transforming columns, including grouping, merging, appending, and transforming text and dates.
Identify common data modeling tools and best practices, including table names, relationships, hierarchies, data categories, cardinality, and filter flow.
Identify examples of filter context and various filtering methods, including user roles, parameters, and drillthrough filters.
Identify DAX syntax, when to use common functions, performance implications, and differences between measures and calculated columns.
Identify and interpret key Power BI visuals, including configuration options, interaction modes, and common use cases.
Identify common optimization techniques, including pausing visuals, applying presets, analyzing performance, and leveraging external tools.

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org..

Set Up

• MS SQL
• Raw Data ETL
• Data Modeling
• DAX
• Dashboard Visualisation
• Just sit back, relax and enjoy the show :)