Every once in a while, we have to analyze data outside the cozy realm of a database. Dealing with a small Excel sheet? Easy peasy. But what about those massive files, JSON jumbles, SharePoint lists, or the mystical OData feeds? Wouldn't life be easier if you could magically turn these files into SQL tables and flaunt your SQL skills? But reality check – who just casually has an SQL server lying around? And how much time would you spend to convert those files to tables?

Imagine you have a fully managed and optimized Azure SQL database at your disposal where you can toss in data from any file or source without writing a single line of code. There is no need to tweak or optimize. You can create or obliterate it whenever you feel like it. And the best part is it's free with the right license. Datamarts in Power BI is your data daydream come true.

In this session, we will talk about Datamarts in Power BI and how to use them to convert data files to SQL tables in minutes. We will also discuss how Datamarts are backed by a fully managed Azure SQL Database and provide SQL endpoints for analysis. This session is perfect for anyone who wants to learn how to convert data files to database tables to speed up your analysis.

Target audience: Power BI Developers, Data Analysts, QA Analysts
Session duration: 30 - 40 minutes
Session Level: Introductory (100)