Custom delivery
This class can be tailored to meet your company's needs. It can be delivered at your facility, or off-site at our office. Please contact Employers Network for more information.
Microsoft Power bi
This hands-on class covers the core functionality needed to create and update professional-looking business intelligence reports with a minimum of wasted time and effort. It is designed for anyone who wishes to gain a foundational understanding of Power BI whether they are truly new to its use or simply wish to “fill in the gaps” of their knowledge. Special emphasis will be given to comparing and contrasting the capabilities of Power BI with those of Excel.
Class format will provide time for the instructor to recommend best practices, explain new concepts, introduce shortcuts, and answer questions. Participants will have time to apply new skills to real‑world scenarios. Topics include:
Understanding key data analysis and visualization concepts
Comparing the self-service BI capabilities of Power BI & Excel
Mapping and navigating the Power BI user interface
Connecting to various data sources
Configuring and managing data schemas & relationships
Determining data cardinality & cross filtering
Loading data to the Power BI data model
Cleaning and transforming data with the query editor
Selectively rolling back steps in the query editor
Profiling data in order to identify & resolve data anomalies
Shaping data for analysis & accessing the M code editor
Deleting, promoting, grouping, sorting & filtering rows of data
Combining, extracting, transforming & unpivoting columns of data
Scraping data from websites and reports
Summarizing data in tables and matrices
Visualizing data across various chart types
Mapping geographic data in Power BI
Creating KPI gauge and card visuals
Enhancing data analysis with custom formatting and rich tooltips
Modeling data with DAX calculations
Creating calculated measures and conditional columns
Creating interactive visualizations
Setting up data hierarchies & drillthrough
Filtering and slicing reports
Instructor
Schedule
This is a 2-Day Class.
July 9-10, 2024
Class meets 8:30 a.m. to 4:30 p.m on both days.
Fee
Members: $995 per person
Non-members: $1215 per person
Attendance
Registered participants who fail to attend a class ('no-shows') will be charged full class cost. The 'no-show' fee may not be used as a credit for another EN class, or other type of event or service.
Cancellations made less than 10 business days prior to start of class will be charged full class cost. The charge may not be used as a credit for another EN class. or other type of event or service however, substitutions are welcome.