Skip to content

Why I’m a Business Intelligence Consultant (T-SQL Tuesday #111)

T-SQL Tuesday #111: Why I'm a Business Intelligence Consultant

This month’s T-SQL Tuesday is hosted by Andy Leonard (@AndyLeonard). Andy wants to know what is our “why”, or why we do what we do. Before I can answer the why, I will briefly explain the what :) I work as a Business Intelligence consultant, focusing on Data Warehousing, Data Integration, and Data Visualization.

The short answer to “why?” is because the work is both challenging and rewarding. As a Business Intelligence consultant, I get to use all my skills from programming to design. I get to satisfy my instinctive need to group, organize, and sort things when working with data. Then I get to make things shiny and pretty. Finally, I get to work with other people, learn about their industries, and help them do their jobs better.

The long answer is… longer :) I absolutely love my job now, but I ended up in the world of data completely accidentally. I’ve gone from Web Development to Graphic Design to Interactive Design to Java Programming to SharePoint Development to Data Warehouse Architecture to Community Evangelizing… And now I’m here :) (Phew!) So why am I a Business Intelligence consultant?

Continue reading →

How to find a Dataset ID in Power BI

Find Power BI Dataset ID

Today, I had to get a single dataset ID from a report I had deployed to the Power BI Service. I quickly realized I had no idea where or how to get it! Turns out, it’s super easy to find – if you know where to look :)

Since I had to click around for a bit, do some searches, and get sidetracked in the REST APIs and PowerShell Cmdlets before I finally realized the ID was staring me right in the face all along, I figured I’d share this quick tip. That way, the next time I search for it, I might find my own blog post :D And who knows, maybe it can help one or two others?

Continue reading →

Friend of Redgate 2019

Cathrine Wilhelmsen is a Friend of Redgate 2019

Yay! I’m very happy to be a Friend of Redgate again in 2019 :)

I first became a Friend of Redgate in 2015, so this will be my fifth year in the program – and hopefully not my last! But what is this program, really? And why am I so happy to be a part of it?

What’s the Friends of Redgate Program?

Friends of Redgate are active community members who use the Redgate tools, and also blog, speak, help others, and provide product feedback.

Check out all the awesome Friends of Redgate in 2019!

Continue reading →

Speaking at SQLKonferenz 2019

PASS Deutschland is celebrating 15 years at SQLKonferenz 2019! I’m honored that I get to be part of it. From February 19-21, I will be hanging out in Darmstadt, Germany with Damon the Data Monster – and a couple hundred other old and new friends :)

Cathrine Wilhelmsen is speaking at SQLKonferenz 2019

I attended my first SQLKonferenz in 2015, and had an absolutely fantastic time. It was the first multi-day SQL Server conference I ever attended, and it was only my third time speaking! I was a nervous wreck :) But things went well, I made new friends, and I have wanted to go back ever since. This is finally the year! :D

Continue reading →

Video: Azure Data Factory Data Flows Introduction

Video: Azure Data Factory Data Flows Introduction

In January 2019, I was honored to be asked to contribute to the PASS Insights BI Edition Newsletter. I said yes, of course! :) I chose to create an Azure Data Factory Data Flows introduction video. This is a sneak preview of the upcoming Data Flows feature, with a quick walkthrough of how easy it can be to create scalable data transformations in the cloud – without writing any code!

Please note: As of January 2019, when I recorded this video and published this blog post, Azure Data Factory Data Flows is still in preview. Features will be added and things will get changed, just like all the other Azure products. But! Hopefully this shows what you can look forward to.

At the end of this blog post, I have tried to answer some frequently asked questions about Azure Data Factory Data Flows.

Video: Data Flows Introduction

Continue reading →