datasavvy.wordpress.com

datasavvy.me

Presentations – Data Savvy

https://datasavvy.me/presentations

My experiences and education in data modeling, integration, transformation, analysis, and visualization. I like to present at SQL Saturdays and user group meetings. I post presentation materials here for those that are interested. An Approach to Data Visualization in Power BI. Building Your ETL Framework with BIML. Overcoming Chartaphobia: Moving Your Organization Toward Interesting and Enlightening Data Viz. Data Viz Documentation Examples. Who Needs SSAS When You’ve Got SQL. What’s New In Power BI.

datasavvy.me

Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014 – Data Savvy

https://datasavvy.me/2016/10/14/process-compatibility-level-1200-ssas-tabular-model-from-ssis-2014

My experiences and education in data modeling, integration, transformation, analysis, and visualization. Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014. Which aren’t compatible with the new SSAS tabular models. Attempting to use the AS Processing Task results in the following error:. The reason for keeping SSAS processing in an SSIS package was because it kept consistent logging throughout their data refresh process. So we set out to find another solution. Just pasting the JSON to pro...

datasavvy.me

Community – Data Savvy

https://datasavvy.me/community

My experiences and education in data modeling, integration, transformation, analysis, and visualization. The SQL Server/MSBI Community has enriched my career through lots of learning and even job opportunities. Here are some of the ways that I have contributed to the community:. I’m the VP of Events for the Denver SQL User Group. I co-organized five SQL Saturdays: SQL Saturday Kansas City #s 159. I co-wrote a free e-book. About Datazen in 2015 after it was acquired by Microsoft. I am a Varigence. 8211; N...

datasavvy.me

Books – Data Savvy

https://datasavvy.me/category/books

My experiences and education in data modeling, integration, transformation, analysis, and visualization. I’m speaking in January about data visualization. I am excited to have two opportunities to speak in January. The first is the Kansas City SQL Server User Group. I will be speaking at the monthly KCSSUG meeting on January 16th at 2:30pm CST. You can RSVP for the event here. Next I will be speaking at SQL Saturday #271 in Albuquerque. First, take a look at this graph:. Even if your data isn’t sav...

billfellows.blogspot.com

World of Whatever: Presentations

http://billfellows.blogspot.com/p/presentations.html

A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life. As a member of the Professional Association of SQL Server. I find it's important to try and give back to the community from which I've received so much. One of the ways I do this is through delivering presentations on assorted topics. To date, I've built out and delivered 11 different presentations at a variety of user group meetings and conferences. SSIS package generation via Biml.

datasavvy.me

Azure – Data Savvy

https://datasavvy.me/category/azure

My experiences and education in data modeling, integration, transformation, analysis, and visualization. Copying data from On Prem SQL to ADLS with ADF and Biml Part 2. I showed in my previous post. We generated one pipeline per schedule and load type:. Hourly – Full. Hourly – Incremental. Daily – Full. Daily – Incremental. We also generated some one-time load pipelines for DR/new environment setup. Dear Microsoft: Please fix. Our Excel file looks like this. Columns B, C, L, and M are populated by Excel ...

datasavvy.me

Data Explorer – Data Savvy

https://datasavvy.me/category/data-explorer

My experiences and education in data modeling, integration, transformation, analysis, and visualization. Links for Excel Data Explorer. There are 3 major capabilities provided by Data Explorer:. Obtain data from a multitude of sources including relational databases, flat files, OData feeds, web pages, Hadoop, and more. Search for data (currently, you enter search criteria and Data Explorer searches Wikipedia for relevant results and lets you choose the one you like). The variety of data sources and data ...

datasavvy.me

BlueGranite Links – Data Savvy

https://datasavvy.me/bluegranite-links

My experiences and education in data modeling, integration, transformation, analysis, and visualization. I currently work at BlueGranite, an analytics consulting firm. Join the BlueGranite team. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. Notify me of new comments via email. Hey, @ denversql.

datasavvy.me

Data Warehousing – Data Savvy

https://datasavvy.me/category/data-warehousing

My experiences and education in data modeling, integration, transformation, analysis, and visualization. Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1. Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know that adding technologies to your repertoire means adding more acronyms. My Azure Data Factory is made up of the following components:. Gateway – Allows ADF to retrieve data from an on premises data source. In order to automat...