SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Further your Power BI development skills
Description
In this course we will learn tips and tricks to add onto your prior knowledge of Power BI.
The emphasis is on tips and tricks that can help the participants take the next step in their Power BI journey as well as best practices in Power Query, data modelling and reporting.
We will cover more advanced techniques in Power Query, data modelling best practices, report design and storytelling techniques.
Power BI comes in two different versions, free and paid. This course will use the free version so there is no need to have any kind of Power BI license to attend the course.
The participants need to come with their own laptop with Power BI Desktop installed.
The course contains the following:
Ingesting data in Power BI Desktop
- Importing data from folder
- Pivot and Unpivot
- Add columns
- Functions
- Append and Merge queries
- Last updated date
- SharePoint and OneDrive for Business as source
- Organizing queries
Modelling in Power BI
- Star schema
- Different cardinality
- Relationships
- Modelling views
- Auto Date/Time Hierarchies
- Row level security
Reporting
- Power BI Theming
- Background images
- Custom visualizations
- Storytelling with bookmarks, drillthrough, report page tooltip and DAX
Data flows
- What is Power BI data flows?
- Reusing your logic
- Dependencies
- Scheduling and sharing
What you gain from the course:
- Advance your Power BI skills
- Learn best practices
- Learn tips and tricks when importing data
- Learn to present more compelling reports
Who should attend this course:
This course is best suited for users with some Power BI knowledge that want to take the next step in their Power BI journey. It is assumed that the participants know the basics of Power BI and how some experienced in using it.
Learning Objectives
Previous Experience
Tech Covered
Cloud, Power BI, Developing