The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

Creating a Power BI Solution in one day


In this full-day seminar, you are guided in creating a complete solution step-by-step, using all the features of Power BI. Starting from scratch, you see how to leverage on Power Query to import and integrate data from many different sources, sharing the results of the queries created, so that they will be easy to reuse. Then you see how to create a Power Pivot model following the best practices and using the resources available on the web, and how to create dashboards in Excel, leveraging pivot tables, Power View and regular Excel formatting. After publishing the result on Office 365, you see how to refresh the data on the cloud using the Data Management Gateway. More analytics are available on a published model: you see how to use Power View and Q&A (which enables queries in natural language), optimizing the data model for a better user experience. Q&A enables queries written in natural language, and it might require some information in the data model in order to disambiguate similar names or similar relationships. Finally, you see how to display data on maps using both Power View and Power Map, which offers visualizations that are more advanced and enables video production, useful for a high impact presentation. At the end of the day, you will be ready to start using the entire Power BI stack in your company, choosing the right feature for each requirement and applying the best practices in each step.

Learning Objectives

Previous Experience

Tech Covered

Azure, BI, Power Query, Power Pivot, Analytics, Power BI