A Complete Introduction to Power BI
Learn how to create stunning interactive reports and dashboards, visualize data, provide actionable insights and drive business results!
The Microsoft Power BI complete introduction course is available on the dates shown (for anyone, anywhere bookings) and for organisations to book as 'in-house' virtual courses. The introduction course is split into the five modules below. A further 3 modules are available for those wishing to progress onto the advanced course. The training is delivered in small class sizes of no more than 8 delegates.
By the end of the course, you'll:
- Be able to use the key components of Power BI
- Learn how to connect to a wide variety of data sources
- Use the query editor to transform and morph data into the right format
- Perform complex data modelling operations using relationships, calculated columns, measures and Dax
- Create visual and interactive dashboards and reports
- Share Dashboards and report
- And lots more!
In a nutshell you'll have the skills to start using Power BI with confidence.
Book course or request more information.
Course Content
Microsoft Power BI Course Outline
- What is Power BI, Power Query and Power Pivot?
- The Power BI service
- Power BI Report Server
- Power BI Desktop
- Understanding Dashboards, Reports and Datasets
- Creating, editing & saving PBIX files
- Natural Language Queries
- Connecting To CSV Files
- Connecting To Excel Data
- Connecting To A Folder Of Data
- Connecting To A Web URL
- Connecting To Web Page Content
- Connecting To A Microsoft Access Database
- SQL servers
- Other data sources
- Creating a group
- The Query Editor
- Applied Steps
- Advanced Editor
- Shaping Data
- Formatting Data
- Transforming Data
- Combining Data
- Merging Data
- What are the Relationships?
- Viewing Relationships
- Creating Relationships
- Cardinality
- Cross Filter Direction
- What is DAX?
- Syntax
- Functions
- Context
- Calculated Columns
- Calculated Tables
- Measures
- Visualization options
- Reports and Dashboards
- Choosing the right visual
- Changing visuals
- Editing properties
- Sorting and formatting
- Sorting data
- Drilling down and filtering
- Working with hierarchies
- The underlying data and hierarchies
- Analysing data
- Creating a hierarchy
- Filters
- Turning off interactions
- Applying advanced filtering
- Performance – small files and fast calculations
- Sharing your data
Who should attend?
Our Power BI Courses are suitable for Business Analysts and other professionals who want to create visual representations of data and produce user friendly reports and dashboards using data from Excel or databases.
Which course(s) is right for me?
This course is designed for beginners but it's recommended that you have a good knowledge of Excel (particularly Pivot Tables) or databases.
If you feel that you need to brush up on your Excel skills first, we would recommend filling in our training needs analysis.
Finally, if you're looking to take your Power BI knowledge further, we also have a 1-day Advanced Power BI Course.