PowerPivot/PowerView/PowerQuery/PowerBI

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 21: Time Intelligence – Dates Functions: FIRSTDATE() and LASTDATE()

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces two DAX Time Intelligence functions related to the Date: FIRSTDATE(), and LASTDATE(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

2023-03-01

3,871 reads

SQLServerCentral Article

An Introduction to Power BI

  • Article

Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]

5 (2)

2021-07-12

7,994 reads

SQLServerCentral Article

Analyze Azure Cosmos DB data using Synapse Link and Power BI

  • Article

Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]

2021-01-12

2,205 reads

Blogs

Experimenting with RedisGraph on Docker and Windows

By

I have been experimenting a bit with graph databases, trying to learn more about...

Resources for Adding Graph Structures to Your Database at VS Live

By

Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Read the latest Blogs

Forums

How to Connect SQL Server and Create C# Objects for Data Management

By cmarix

Comments posted to this topic are about the item How to Connect SQL Server...

Adjusting DOP based on Feedback

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adjusting DOP based on Feedback

How Important is Zero Downtime?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important is Zero Downtime?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers