Learn how to create a complete solution based on Power BI. Starting from scratch, import data, create a data model, design and publish your report.
Microsoft Power BI is a cloud service that provide a complete self-service analytics solution, including tools for data extraction, transformation, modeling and visualization. Data modeling is possible by using both Excel or Power BI Desktop. The Power BI Service enables you to create reports and dashboards, sharing them with other users. Mobile apps for several platforms also improve access on any device.
In this full-day seminar, you are guided in creating a complete solution, using all the features of Power BI. Starting from scratch, you see how to create query in a visual way to import and integrate data from many different sources, with a particular attention on leveraging existing data in the company, transforming data in order to improve the resulting model and sharing the results of the queries created, so that they will be easy to reuse. Then you see how to create a data model following the best practices and using the resources available on the web in order to accelerate the creation of tables and formulas that can be shared in many models. The reference data model will improve over the day, adding metadata to improve the usability of other Power BI features. You will also learn how to connect to existing on-premises data models in Analysis Services, without copying and storing data in the cloud by using the personal gateway or the SSAS connector.
Once the data model is ready, you see how to create reports and dashboards in Power BI, leveraging the many data visualizations available. After publishing the result on Power BI site, you see how to refresh the data on the cloud, including all the details about correct configuration and best practices for moving on premise data to the cloud in a secure way.
You will see how to use Q&A, learning how to optimize the data model for a better user experience during data exploration with this tool. 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.
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. The additional benefit from attending the workshop is to understand how the Microsoft BI stack is evolving to include cloud services as a part of your data warehouse infrastructure.