Forum Discussion
Solution Sagemost frequently using queries to organize data for visualization
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.
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,
4 Replies
- malagari
Continued Contributor
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-msftMicrosoft Employee
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,
