Course Information
Microsoft Power BI Data Analysis Introduction (Practitioner)
Parking for SAO, Professional Development courses is in Garage B (1511 San Jacinto Blvd.). The Garage signage may read 1511 San Jacinto or Garage B. The elevator in Garage B is not reliable. If you are unable to walk the stairs, please contact the professionaldevelopment@sao.texas.gov for alternate parking arrangements. Handicapped parking is free at the meters around the downtown area.
A course coordinator will email you a parking permit prior to the course start date. A permit must be displayed or you will be ticketed.
Course Description
This course introduces users to Microsoft Power BI and teaches how to use and build business intelligence reports. Expanding your skills in this area is a valuable endeavor to meet today’s increasing demands for data analysis and business intelligence within any organization.
Course Objectives
Objectives
In this course, you will analyze data with Microsoft Power BI. You will:
•Analyze data with self-service BI.
•Connect to data sources.
•Perform data cleaning, profiling, and shaping.
•Visualize data with Power BI.
•Enhance data analysis by adding and customizing visual elements.
•Model data with calculations.
•Create interactive visualizations.
Outline
Get started building with Power BI
•Use Power BI
•Building blocks of Power BI
•Tour and use the Power BI service
Get data with Power BI Desktop
•Overview of Power BI Desktop
•Explore Power BI Desktop
•Connect to data sources
•Get data from Excel
•Transform data to include in a report
•Combine data from multiple sources
•Clean data to include in a report
Model data in Power BI
•Introduction to modeling your data
•How to manage your data relationships
•Create calculated columns
•Optimize data models
•Create measures
•Create calculated tables
•Explore time-based data
Use visuals in Power BI
•Introduction to visuals in Power BI
•Create and customize simple visualizations
•Create slicers
•Map visualizations
•Matrices and tables
•Create scatter, waterfall, and funnel charts
•Modify colors in charts and visuals
•Page layout and formatting
Explore data in Power BI
•Introduction to the Power BI service
•Quick insights in Power BI
•Create and configure a dashboard
•Ask questions of your data with natural language
•Create custom Q&A suggestions
•Share dashboards with your organization
•Display visuals and tiles in full screen
•Edit tile details and add widgets
•Get more space on your dashboard
Publish and share in Power BI
•Introduction to using workspaces
•Publish Power BI Desktop reports
•Print and export dashboards and reports
•Introducing Power BI Mobile
•Create workspaces in Power BI
•Build apps
•Use apps
•Integrate OneDrive for Business with Power BI
•Publish to web
Prerequisites
To ensure your success in this course you should have experience managing data with Excel.
Instructors
Sharon R. Fry • MOS Master, MCT, MCP, MTA
Professional Profile
Recognized for exceptional abilities and advanced understanding of complex concepts
Resourceful instructor and software specialist with a proven track record of successful training delivery
Specialist in streamlining business processes with creativity and utilization of available technology • Knowledgeable and experienced in multiple operational areas of varied industries Qualifications Summary
Microsoft Certified Trainer since 2009; Certified Microsoft Office Specialist Access, Excel, OneNote, Outlook, PowerPoint, SharePoint, Word 2013; Master 2007 (Access, Excel, Outlook, PowerPoint, Word), PowerPoint 2003, Word & Excel 97; Microsoft Specialist for Microsoft Project 2013; Microsoft Certified Professional (MCP); Microsoft Technology Associate (Windows Operating System and Database Administration)
Proficient in database & spreadsheet development; fundamental programming and user interface design; document/presentation, graphic & web design; and assorted software applications
Excellent math, spelling, typing and proofreading skills, and knowledge of grammar, punctuation and usage Computing Skills Operating Systems:
IBM-compatible/PC, Microsoft Windows
Apple Macintosh OS
Linux/Unix exposure
AS/400 Systems Microsoft Products:
Certified Microsoft Office Specialist for Access, Excel, OneNote, Outlook, PowerPoint, SharePoint, Word; also use and train InfoPath; Internet Explorer, Office 365, OneDrive for Business, Project; Publisher, Skype for Business, SharePoint Designer, SQL Server, Visio Adobe Products: Acrobat, Dreamweaver; Flash, Illustrator, InDesign, PageMaker, Photoshop, Reader Professional/Industry Specific: AdSpeed, Multiday Creator, Page Director, Pongrass Pagination, QuarkXpress, various proprietary systems Other: Crystal Reports, WordPerfect, Lotus Notes, Firefox, OpenOffice, Paradox, Quickbooks, Quicken, graphics applications, HTML editors, security tools, tutorial builders, utilities.