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.
Introduction to Azure Analysis Services
Description
Azure Analysis Services is a fully-featured PaaS version of Analysis Services. In this full-day pre-con you’ll learn what it is, why you should consider using it and how you can build BI solutions with it.
Topics covered will include:
- Comparing the features and costs of on-premises Analysis Services and Azure Analysis Services, and deciding when Azure Analysis Services is the right option
- Creating and configuring an Azure Analysis Services instance
- Using Visual Studio/SSDT and other tools such as the Web Designer, BISM Normalizer and Tabular Editor to design your Analysis Services database
- Using M for data access to on-premises and cloud-based data sources
- Choosing between storing data in-memory and DirectQuery mode
- Using PowerShell and the REST API to automate common tasks
- Scaling-up and scaling-out, when each one is appropriate, and how to automate this
- Automating partition creation
- Granting access to internal and external users
- Applying row-level and object-level security
- Using Azure Analysis Services as a data source for Power BI and Excel
- Monitoring and auditing
In addition, any new features (and it’s inevitable that there will be many) that are added to Azure Analysis Services in the run-up to SQLBits will also be covered.
Learning Objectives
Previous Experience
Tech Covered
memory, Azure, SSAS, BI, partitioning, PowerShell, Power BI