most frequently using queries to organize data for visualization

[rocky09]

I am new to this Power BI. My Management asked me work on PBI Reports. I have referred few Community Videos on Youtube and played with some sample data. I can say, this is a Most Power Tool. 

I have to work on large database (Oralce). It contains more than 40 tables. Can any one guide, what are the most using queries by you. Because, I am not familiar with advanced queries.

Please suggest me some tutorials and links in terms of different scenarious. So, I can get hand on the Queries stuff.

I guess, I have explained well. If not, please ask me. So, I will try to provide more information.

[malagari]

Before I can recommend any resources, how familiar are you with relational databases?  Understanding how all of the tables relate to one another is crucial when working with BI.

[rocky09]

Hi Dan,

Thank you very much for you reply.  Yeah, I have basic knowledge on relational database. I used to work on MS Access Queries.

[v-sihou-msft · Accepted solution]

@rocky09

When retriveing data, you can just use T-SQL query to get the data. Power BI will generate Power Query which you can edit it in Query Editor (Advance Editor). For Power Query (M language), please see: Power Query (informally known as "M") Formula reference.

For retrieved dataset, you can use DAX to add measure and calculated column for your calculation. For DAX tutorials, please see: DAX basics in Power BI Desktop

QuickStart: Learn DAX Basics in 30 Minutes

SQL Server DAX Tutorial Overview

Regards,

[rocky09]

@v-sihou-msft

Thank you so much. 🙂