Who is the best Batman? – A Power BI Analysis of data Introduction Who is the best Batman? We were drinking some cold beers with some friends when someone said that Pattinson was the best Batman. People started to discuss and after 2 hours, the police had to stop the fight. The discussion inspires me […]
2022-05-09
2,993 reads
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
16,846 reads
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
386 reads
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
2019-05-06
Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.
2018-04-05
3,082 reads
You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.
2017-01-16
3,767 reads
In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made more generally available for sharing and further analysis. As well as the data, we'd probably need the other analysis components such as the Power Pivot tables, Power View visualizations, Power Query queries. It is all possible, and Robert Sheldon demonstrates how.
2016-12-28
2,896 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers