Course description
To successfully compete in today's global business environment an organisation must constantly monitor, recognise and understand every aspect and every issue of its operations, its industry and the overall business environment.
Setting up a business intelligence within an organisation takes more than just installing the technology. A successful BI programme involves a set of interlaced business concepts and frameworks designed to improve the fact-based business decision-making process.
This course focuses on the business aspects of designing and implementing a BI programme rather than looking at BI from the information technology aspect.
Upcoming start dates
Upcoming start dates
Suitability - Who should attend?
This course is designed for business executives, and managers that are looking to introduce Business Intelligence and a performance driven culture to their businesses.
Outcome / Qualification etc.
- Learn how Business Intelligence (BI) leads to sustainable and profitable growth
- Get hands-on experience in developing strategic elements and performance measures and analysing results
- Identify best practice and latest trends in strategy, BI and Competitive Intelligence
- Learn how to implement and sustain BI in your organisation
Training Course Content
Day 1
Introduction to Power BI
- What is Power BI?
- The Power BI service
- Power BI Report Server
- Power BI Desktop
- Reports and Dashboards
- Datasets
- Row-Level Security
- Content Packs
- Natural Language Queries
Day 2
Data Sources
- Connecting to Files
- Importing Excel Files
- Publishing to Power BI from Excel
- Updating Files in Power BI
- Data Refresh
- The Power BI Data Model
- Managing Data Relationships
- Optimising the Model for Reporting
- Hierarchies
- SQL Servers
- Other Data Sources
- R Script Data Connector
- Configuring Data for Q&A
- Creating Content Packs
- Creating a Group
Day 3
Shaping and Combining Data
- The Query Editor
- Applied Steps
- Advanced Editor
- Shaping Data
- Formatting Data
- Transforming Data
- Combining Data
- Merging Data
Day 4
Shaping and Combining Data
- The Query Editor
- Applied Steps
- Advanced Editor
- Shaping Data
- Formatting Data
- Transforming Data
- Combining Data
- Merging Data
Day 5
Interactive Data Visualisations
- Power BI Reports: Page Layout and Formatting
- Multiple Visualisations
- Creating Charts
- Using Geographic Data
- Histograms
- Power BI Admin Portal
- Service Settings
- Desktop Settings
- Dashboard and Report Settings
Request info
London Premier Centre
London Premier Centre is a UK leading training provider based in London and specialises in international short courses. Our inspiring, comprehensive portfolio of more than 400 professional development courses and seminars covers a wide range of professions from Administration, Leadership,...