Our Power BI training course will give you hands-on experience with Microsoft's heavy hitting Business Intelligence platform. Open up more highly-extensible reporting and analysis capabilities than you would have thought possible.
Microsoft has a decade-spanning stable of pedigree platforms that have fueled and serviced the exponential growth and thirst for enterprise data storage, processing and reporting solutions.
The latest suite of Power BI tools are the culmination of a raft of integration, business logic, visualisation and deployment technologies presented in such a way that self-service business intelligence isn't just a nice idea now - it brings genuinely powerful control and takes away a lot of the complexity these functions would previously have required.
Power BI has the capability to pull in and process data from hundreds of other platforms - not just Microsoft's own (such as Dynamics, Sharepoint, SQL Server, Excel...) but pretty much anything with a decent API whether on-premise or in the cloud - and squirt out interactive dashboards to browsers and desktop / mobile apps.
If you have a specific use case, project requirement or skills gap, please get in touch to find out how we can tailor a Power BI training workshop for you and / or your team's needs.
By the end of this course, you will have learnt about:
- Business Intelligence fundamentals
- An overview of the Power BI suite
- Connecting to various data sources
- Data Modelling
- Data Analysis Expressions (DAX) language
- Data Visualisation
- Publishing your solution (web / mobile apps)
Who should attend
Data analysts, business analysts, software developers and other business stakeholders who want to create and publish cross-platform Business Intelligence dashboards solutions
Prerequisites
Delegates should have intermediate to advanced Microsoft Excel skills (or with an equivalent package such as Crystal Reports, Business Objects). Some experience of Excel Macros / scripting would be useful but is not mandatory.
On-site
If you are looking for a tailored Power BI course which takes into account your existing technical skills, project requirements and timeframes, and specific topics of interest, please get in touch.
We can focus on the most relevant topics and even incorporate hands-on exercises based on your own data sources (we're happy to sign an NDA to facilitate this).
Give us a call on 020 3137 3920 or get in touch to talk to us about your learning goals and project requirements.
Business Intelligence fundamentals
- Defining BI and what it means to you
An overview of the Power BI suite
- Power BI Desktop
- Power BI Mobile
- Power BI Service
Connecting to data sources & Transforming Data
- Power Query & Query Editor
- Cleaning, Filtering and Normalising data
- Transformation GUI
Data Modelling & DAX
- xVelocity engine
- Relationships
- Hierarchies
- Formatting
- Sorting
- Data Analysis Expressions (DAX) language
- Calculations
- Normalising data
Data Visualisation & Publishing
- Charts, charts, charts
- Drill Down and Drill Up
- Filters
- Slicers
- More charts
- KPIs
- Building Dashboards
- Sharing visualisations
- Additional BI Service functions
"The pace of the course and the instructor's flexibility meant we were able to cover a lot of ground, all of which was directly relevant to our upcoming projects. A number of different Big Data solutions were explored."
Hadoop Training Course
NB, Senior Analyst
University of Oxford
"Well paced, good overview of the material as required. Good balance of hands-on and talk/theory."
Apache Spark Training Course
JB, Lead Developer
Orange