BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Cecil Renshaw | SBSI - ECPv6.18.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://sharepointmentoring.com
X-WR-CALDESC:Events for Cecil Renshaw | SBSI
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Chicago
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20260308T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20261101T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20270314T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20271107T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20280312T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20281105T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20270126T090000
DTEND;TZID=America/Chicago:20270126T120000
DTSTAMP:20261014T201923Z
CREATED:20261014T043812Z
LAST-MODIFIED:20261014T201923Z
UID:10000154-1800954000-1800964800@sharepointmentoring.com
SUMMARY:Power BI Jumpstart: From an Excel File to an Interactive Report
DESCRIPTION:Hands-on\, 3 hours. Connect Power BI Desktop to an Excel file\, clean the data\, and build a report page with a slicer.\n\n\nThe monthly report is an Excel file you rebuild by hand. \nYou connect Power BI Desktop to an Excel sales file and clean it in Power Query. You format the numbers as currency\, add a product hierarchy and two measures that count orders and customers correctly. Then you build a dashboard page: four KPI cards\, a year slicer\, a sales trend line chart and a sales-by-category bar chart you can drill into\, and you control which visuals the slicer filters. The instructor shows how a report is published and shared. \nWhat you will do \n\nFind your way around Power BI Desktop\nConnect to an Excel file and clean the data in Power Query\nFormat numbers and add a product hierarchy and two measures\nBuild KPI cards\, a slicer\, a trend line chart and a drill-down bar chart\nControl which visuals a slicer filters\nExplain what is needed to share a report\n\nYou leave with: A report file with a dashboard page: four KPI cards\, a year slicer\, a trend line chart and a drill-down bar chart. \nWho it is for: Analysts and managers who report from Excel today and are new to Power BI. \nWhat you need \n\nA Windows PC with Power BI Desktop installed. It is free. It does not run on a Mac. No paid license is needed for the hands-on work. Sharing or publishing a report needs Power BI Pro or Premium Per User and is shown by the instructor.\nCheck before you register: Install Power BI Desktop from the Microsoft Store before class. If your PC is locked down\, ask your IT department to install it.\nPower BI Desktop installed. Sample Excel file downloaded from the link sent before class. Basic Excel helps.\nA computer with a reliable internet connection. The online meeting link is sent after you register.\n\nYou receive: Lab Exercise Manual and the sample data file. \nLength: 3 hours. Level: Beginner. Format: Instructor-led\, hands-on. \nYour instructor: Cecil Renshaw is a Microsoft Certified Trainer (MCT) and Project Management Professional (PMP) with more than 18 years of Microsoft 365 training and consulting for government agencies\, corporations and small businesses. He writes his own courseware. SharePoint Business Solutions\, Inc. (SBSI)\, sharepointmentoring.com. \nRefunds: Full refund up to 7 days before the class. The class runs with at least 4 registrations. If SBSI cancels the class\, you get a full refund. \nPrivate sessions: This class can be run for your team\, online or on-site. Contact cecil.renshaw@sharepointbiz.com or (217) 741-7165.
URL:https://sharepointmentoring.com/event/power-bi-jumpstart-from-an-excel-file-to-an-interactive-report/
END:VEVENT
END:VCALENDAR