Three Day Microsoft Power BI Training
Codestone Three Day
MS Power BI Training
Access the information you need to make informed, data-driven decisions through innovative dashboards and compelling reports.
Drive change within your business with modern, data-rich solutions. Create interactive reports, unearth powerful insights and share your discoveries throughout your organisation with fully integrated workflows.
3-Day Live
Power BI Training
During this introduction to Power BI training, our structured course aids employees with beginner to intermediate experience in both understanding and getting the most value out of Power BI. Every training session throughout the course has relevant ‘real-life’ scenarios where they’ll be required to create KPIs to answer specific questions. As a result, your employees will have the opportunity to learn the key principles they need to start using Power BI effectively. They’ll also receive a solid foundation in the best possible practices and processes for the purpose of delivering captivating visual stories using your business data.
The dedicated team at Codestone boast decades of combined industry experience and expertise. You and your employees will have the opportunity to learn the ins and outs of one of Microsoft’s most innovative platforms, from a team that has successfully strategised and implemented Power BI solutions for businesses all over the world.
What to expect
For more than two decades, Codestone have been committed to driving business success through world-leading analytical services and training. Using the latest, most innovative technologies, we have a proven track record of empowering our clients and their businesses with the skills and tools they need to drive business growth and unearth the power of insight.
Day 1
- Introduction to Power BI Desktop
- Creating a table
- Creating a matrix table
- Creating a chart
- Formatting and aligning visuals
- Editing and changing visuals
- Creating and formatting maps
- Filtering reports
- The filter panel
- Slicer visuals
- Text boxes and action buttons
- Adding images and logos
- Presentation tips and publishing
Day 2
- Connecting to data sources
- Adding tables to the model
- Relationships and joins between tables
- Removing and editing joins
- Active and inactive relationships
- Power Query introduction
- Changing data types
- Filtering data from queries
- Removing columns, editing and transforming them
- Editing applied steps
- Duplicating and referencing queries
- Merging and grouping data
- Appending data
- Un-pivoting data
- Using M code
- Preparing the data model for end users
- Sorting and hierarchies
- Summarising fields
- Hiding columns
- Data grouping
- Setting the date table
Day 3
- Calculations in Power BI
- Calculated columns v measures
- Creating calculated columns
- Measures and quick measures
- The CALCULATE function
- The FILTER function
- Using an IF function
- Using the SWITCH function
- The USERELATIONSHIP function
- Using formulas for presentation
- Creating a 7-day rolling average
- Using variables in DAX formulas
- Useful tools such as DAX Studio