This is a complete training session for the audience to start their journey with Microsoft Power BI. In the end of the training, the audience will leave the room with a fully functional Power BI report created using a real-world dataset.
Agenda:
1. Introduction to Business Intelligence
2. Introduction to Power BI
• This will include going through the Power BI eco-system – Power BI Desktop & Power BI service
3. Data Cleaning
• Import data to Power BI
• Exploring Data profiling options
• Learn about basic transformations in Power Query editor
• Basics to Advance Editor
• Best practises around naming the transformations & data-types
• Custom Columns creation – scratch or by examples
• Date table creation
• Quiz
4. Data Modelling basics
• Creating basic relationship
• Understanding the cardinality
• Hide/view capabilities
• Best practises around Comments & Naming conventions
• Quiz
5. DAX basics
• Measures vs columns
• Quick measures
• Basic DAX functions
• Date table using DAX
• Quiz
6. Data Visualisations
• Introduction to the page canvas, background & settings
• Visuals in Power BI
• Custom visuals
• What visuals to use when
• Analytics feature in visuals
• Conditional formatting in visuals
• Best practises around layout of visuals in a report
• Usage of buttons/bookmarks to create interactive reporting
• Drill down, drill up & drill throughs capabilities
• Colour schemes and themes in Power BI
• Creating a brand specific custom theme
• Quiz
7. Power BI report from scratch in Power BI Desktop
• By using all the learning above, a Power BI report will be created from scratch
8. Power BI Service
• Basics of Power BI Service
• Creating your first workspace
• Publish & share your first report
• Quiz
9. Introduction to Gateways
• Installing personal gateway
• Configuring gateway in Power BI Service
• Quiz
10. Summary
11. Q&A Time