(605) SQL Server User Group

Meeting: Tue, Feb 13 2018

February 2018 Meeting

This presentation will be an introduction to Power BI. We will answer the questions, what is power BI and where did it come from, how do I get started, what the heck is DAX, what is Power BI desktop, and how do I publish and share a report or dashboard. We will also cover some basic security and leave plenty of time for questions at the end. 

When:

Tue, Feb 13 2018 Event Time: 17:30 - 19:00 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Tue, Feb 13 2018 23:30 - 01:00
iCal


RSVP: https://www.surveymonkey.com/r/B8KL9BG


Where:

4509 West 58th Street - Sioux Falls, South Dakota (map)

None



Featured Presentation

Microsoft Power BI and Analytics Stack

Speaker: Dustin Mammenga, Lead BI Analyst MetaBank

Summary: This presentation will be an introduction to Power BI. We will answer the questions, what is power BI and where did it come from, how do I get started, what the heck is DAX, what is Power BI desktop, and how do I publish and share a report or dashboard. We will also cover some basic security and leave plenty of time for questions at the end.

 

About Dustin: Dustin has worked in business intelligence in the financial industry for about 15 years. He started off my career compiling call center stats using spreadsheets. From there he had a pretty typical progression through Microsoft’s BI offerings, starting with Access, then moving to SQL Server and Reporting Services and later Analysis Services and Power BI. In addition to his time spent as an analyst and report developer, he has also spent a good portion of my career as a SharePoint administrator, as for a long period that was Microsoft’s primary vehicle for its business intelligence technologies. These days he focuses a lot on data architecture, data modeling, and data quality using Microsoft Analysis Services, Reporting Services and Power BI.

Microsoft Power BI and Analytics Stack

Speaker: Marissa Miller, Lead BI Analyst MetaBank

Summary: This presentation will be an introduction to Power BI. We will answer the questions, what is power BI and where did it come from, how do I get started, what the heck is DAX, what is Power BI desktop, and how do I publish and share a report or dashboard. We will also cover some basic security and leave plenty of time for questions at the end.

 

About Marissa: Marissa has worked in business intelligence for about 13 years. She started out building and analyzing credit card data and automating manual processes with SSRS and SQL Server. From there, she moved into a more analytical role and provided insight to product/portfolio development. She is currently working as a lead BI analyst, with a primary focus on report development and data modeling using Microsoft Reporting Services, Management Studio, Microsoft Analysis Services and Power BI.

Writing Code to Write Code

Speaker: Carl Ware, Data Conversion Analyst II Zuercher Technology

Summary: Writing code to write code, when done right, can save a lot of time, especially for a repeatable task. Also, the fewer times you have to move bits the less time it takes to process them. I am going to demo how my team and I have improved our throughput by using scripts to generate XML that allow us to utilize foreign data wrappers to more quickly extract data from SQL Server into PostgreSQL for later processing.

 

About Carl: Carl as worked with various types of SQL databases for 10 years in both telephony and law enforcement. Most recently he has been converting legacy customer systems from a wide variety of vendors and RDBMS into Zuercher's PostgreSQL database. This requires high touch with end users to extract not only data but what it means, how they use it, and where it will best fit in the Zuercher system. He and his team are often tasked with creating tools to make processes faster, more accurate, and more turn-key.


Back to Top cage-aids
cage-aids
cage-aids
cage-aids