If you haven’t already, make sure to start with Part I – V where I explore OneDrive, Live Connect, Dataverse, SQL Server, and DataFlow and set the baseline on how to measure “best” connector type in Power BI. Part I- https://bilingualanalytics.com.au/data-connectors-onedrive/ Part II- https://bilingualanalytics.com.au/data-connectors-live-connect-power-bi-dataset Part III – https://bilingualanalytics.com.au/data-connectors-dataverse/ Part IV Read more…
If you haven’t already, make sure to start with Part I – IV where I explore OneDrive, Live Connect, Dataverse, and SQL Server and set the baseline on how to measure “best” connector type in Power BI. Part I- https://bilingualanalytics.com.au/data-connectors-onedrive/ Part II- https://bilingualanalytics.com.au/data-connectors-live-connect-power-bi-dataset Part III – https://bilingualanalytics.com.au/data-connectors-dataverse/ Part IV – Read more…
If you haven’t already, make sure to start with Part I – III where I explore OneDrive, Live Connect, and Dataverse and set the baseline on how to measure “best” connector type in Power BI. Part I- https://bilingualanalytics.com.au/data-connectors-onedrive/ Part II- https://bilingualanalytics.com.au/data-connectors-live-connect-power-bi-dataset Part III – https://bilingualanalytics.com.au/data-connectors-dataverse/ Without getting too technical here, Read more…
If you haven’t already, make sure to start with Part I and Part II where I explore OneDrive and Live Connect, and set the baseline on how to measure “best” connector type in Power BI. Part I- https://bilingualanalytics.com.au/data-connectors-onedrive/ Part II- https://bilingualanalytics.com.au/data-connectors-live-connect-power-bi-dataset Today I am going to share with you my Read more…
If you haven’t already, make sure to start with Part I, where I explore OneDrive and set the baseline on how to measure “best” connector type in Power BI. Link – https://bilingualanalytics.com.au/data-connectors-onedrive/ Today I am going to write about my experience with the Power BI dataset as a data source. Read more…
I believe most of the report creators are going to start importing data to Power BI from Excel. It’s really easy to start from there as many users already know how to use Excel. I reckon that’s the reason why Import data from Excel is also the first option to Read more…
If you ever worked with real-life data, you probably know that it is hardly ever clean. This means it must be cleansed before we can apply any Data Visualization to it to draw business insights. Let’s try to define Dirty Data. Dirty Data could be incorrect, inaccurate, incomplete, or inconsistent Read more…
If you ever worked in an Analyst position, you know that scenario analysis is a key part of the job. Scenario Analysis helps users to use historical data to create different estimations. It can be as simple as forecasting or planning next year’s sales figures, or budgeting department-level expenditures, or Read more…
If you ever felt like that your Fields pane (the one on the right hand side in Power BI) is overcrowded and you cannot find measures quickly, today’s tip is for you! It doesn’t take more than a few minutes (no more than 5 for sure) to organize measures in Read more…
Based on real-life examples In the previous three blog posts, we learned how to use Transpose Data, Pivot Column, and Unpivot Columns in Power Query. These super-powerful data transformation tools allow us to automatically shape our data in a way that we can easily load into Power BI or Excel. Read more…