If you need to analyse data then this is the course for you.

Many people use Excel to analyse data, and this works well for simple data sets that can be represented by a single table with less than a million rows. Even then Excel doesn't make it easy to produce good looking and easily shareable reports and dashboards.

Whether the data source is spreadsheet, database or involves pulling data from several different files or systems, then Power BI will make your life easier. Building reports and dashboards from this data and subsequently sharing the results is exactly what it's designed to do.
 

• Overview of Power BI - how Power BI Service and Power BI Desktop application work together and when to use their features
• Dashboards - using the Power BI service to connect to data, and use natural language queries or quick insights to create dashboards
• Reports - creating reports with a visual interactions/filtering directly in the Power BI service. Enhancing dashboards with report content and annotations
• Sharing - options for sharing with a few people or collaborating among a group and sharing organisation wide
• Power BI Desktop - connect to and combine data by using queries (M language) and defining or modifying relationships between fields
• Calculated Columns - enrich the data model with calculated columns to improve slicing and data
• Measures - create calculations to summarise the data using DAX
• Publishing - publish information from Power BI Desktop to the Power BI Service and control access to that data

Getting Started with Power BI Desktop 

• Power BI Concepts and Overview 
• Introduction to Main Features 
• Imports 
• Visualizations 
• Filters and Queries 
• Reports 

Connecting to Data Sources with Power BI Desktop 

• Data Sources Power BI Desktop will connect to 
• Data Types and Properties in Power BI Desktop 
• Import and Enter Data 
• Get Data and Query Editor 
• Introducing the Query Editor 
• Using the Query Editor to Connect to Data 
• Combining Data Sources as a Mash Up 
• Working with Relationships in Data 

Data Visualizations 

• Overview of Data Visualizations 
• Tables and Matrix Views 
• Applying Conditional Formats 
• Charts 
• Interactive Data and Date Slicers 
• Drill Visualizations to see underlying data 
• Create Reusable Field Hierarchies 
• Record Grouping and Binning in Visualizations 
• Drill Visualizations with using Dates 
• Clustering 
• Analytics and Forecast Lines in Visualizations 
• Creating Role Based Views 
• Data Categories, Geo-Data and Maps

Querying and Shaping the Data 

• Common Activities using Query Editor 
• Filters 
• Transforms 
• Pivot and Group By 
• Creating Custom Calculated Columns 
• Adding Conditional Columns 
• Introduction to DAX Expressions 
• Histograms 

Reports and Output Options 

• Report Elements and Options 
• Working with Pages 
• Adding Graphics 
• Visual and Filter Settings 
• Export Power BI Data to CSV 
• Create a Power BI Template

The course runs from 9:30am through to 4:30pm. Refreshments are available from 9am.

We provide:

• Full course material
• Certificate of attendance
• Note pad and pen
• Polos!

Also includes:

• Free on-site parking
• Refreshments throughout the day
• Lunch at a local restaurant
• Free WiFi

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.