At your office, home, conference room.. you name it. Training at your location, at your convenience.
Hands-On Approach
Zero boring slides. 100% active building. Learn by doing.
NOT JUST TEACHERS
Classes are held by a professional with real-life day to day advanced Microsoft Power BI experience. We try to concentrate our focus on training students to be ready for working environment.
Contact Us
(901) 437-4255 Memphis Excel Classes by Chi Brander Inc. 295 Washington Ave Ste 3 Memphis, TN 38103
Use sample data to develop measures, comparisons, and report pages that answer specific business questions.
01
Distribution network reporting
Relate shipment events to date and location tables, then examine volume and delivery timing across facilities.
02
Manufacturing performance
Compare planned and completed production, investigate downtime categories, and filter results by line or product.
03
Medical-supply availability
Combine sample receipts, issues, and item lists to explore usage patterns and stock balances across departments.
04
Administrative service capacity
Model fictional staffing hours and workload records to compare demand across teams and reporting periods.
05
Purchasing and department costs
Connect expense and budget data, define variance measures, and provide a path from overall spending to supplier or category detail.
Learning workflow
Take a reporting question from files to a working report
Practice a sequence your team can apply to recurring business reporting.
Identify the reporting inputs
Choose a question and connect the Excel workbooks, CSV exports, or other supported sources needed to answer it.
Prepare the source records
Use Power Query to combine recurring exports, standardize timestamps and item codes, and resolve inconsistent data types.
Connect the tables
Build relationships between activity records and date, facility, product, or department tables; check totals against the source.
Define the calculations
Create course-appropriate DAX measures for quantities, costs, elapsed periods, and comparisons using clear business definitions.
Build the report pages
Select charts and tables that show the main result, with filters and supporting detail for closer investigation.
Plan refresh and access
Review refresh requirements, sharing and workspace considerations, and who will maintain the report and its source files.
Key details
Get ready for your Power BI session
Prepare the software and examples your group will use before class.
01Bring a Windows laptop with Power BI Desktop installed and confirm that it can open the class files.
02Choose a level that fits your experience with tables, formulas, and reports; ask for guidance if you are unsure.
03For custom training, arrange advance review of sanitized company files and identify the reporting question you want to explore.
04Remove patient and employee details, shipment customer identifiers, confidential freight rates, and proprietary manufacturing information from practice files.