Power BI Desktop

The BI Journey: The Expert’s Advice – Part 2

  • Article

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

Using Power BI Desktop to Visualize SQL Server Metadata

  • Article

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

Importing Excel Data into Power BI Desktop

  • Article

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

Blogs

Daily Coping 26 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure SQL Database – Greatest and Least TSQL

By

Being in the cloud does have many benefits, from lower administration to fast scaling...

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Read the latest Blogs

Forums

Large Database Files

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Large Database Files

Black Friday Wishes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Black Friday Wishes

Reporting Services Subscription: Special character in email address

By shell_l_d

Hi How can an email address containing a special character (in this case, an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers