All times listed are in EDT (= UTC -4)

10:00 – 11:00 | Jackie Kiadii | Solve Your Data Cleanup Headaches With Power Query

75% of a Data Analyst’s time is not spent on visualization. It’s spent organizing and
cleaning data. If you’ve had to clean up your data in Excel, you know there’s a lot
involved. Multiple functions (VLOOKUP, LEFT, RIGHT, MID), Text-to-columns,
pasting values, and much more.
With Power Query, you are able to automate your data cleanup without having to
use code. You can collect data from multiple sources, transform it, and prepare it
for visualizations.
In this session, you’ll learn how to replace time-consuming Excel functions with
Power Query, so that you save precious time.

11:00 – 12:00 | DeNisha Malone | Using PowerShell Cmdlets to Automate Power BI Administration

Power BI has made its mark in the world as the leading business intelligence application for personal, business, and enterprise benefit. As the tool spreads from business to business, the ability to automate administration processes has become an important skill. In this session, attendees will learn ways to use cmdlets in Windows Powershell to administer the Power BI Service tenant. DeNisha will also demo how to call a Power BI Rest-API and produce a CSV file in your local drive with results..

1:00 – 2:00 |Marco Russo| Different types of many-to-many relationships in Power BI

The new composite models in Power BI introduced a new type of relationship cardinality called many-to-many. Nevertheless, despite their name, they are not many-to-many relationships, they are relationships between tables generated at a different granularity.

In this session we clarify the purpose of the relationships with many-to-many cardinality, highlighting the significant difference with canonical many-to-many relationships. In the meantime, we show how and when to use the different kind of many-to-many relationships with several practical examples.

2:00 – 3:00 | Alex Powers | Calculated Columns. A love-hate relationship

As a report developer it’s all about making the right design designs. In this session we’ll dive into the good, the bad and the ugly of calculated columns to help you improve your report performance

About Jackie Kiadii, MCT, MOSE – Excel:

Companies invest trillions of dollars in their software, yet $1.3 trillion is wasted
each year because people are using it incorrectly. Jackie Kiadii is on a mission to
teach as many people as possible how to take control of their workdays by learning
how to use their software the right way. Her training focuses on shortcuts, tips and
tricks to help her students get their work done so that they can get on with life.
A graduate of Georgia State University Computer Information Systems program,
Jackie has taught Microsoft Office for over 20 years.
Contact: http://www.probiztechnology.com/
Linkedin.com/in/jkiadii

About DeNisha Malone:

DeNisha Malone is a Business Intelligence Consultant and Developer who works with Microsoft, Google, and Amazon data customers. She consults in the use and administration of their BI Reporting tools in enterprise level environments.

With the self-service of reporting on the rise, DeNisha takes advantage of the opportunity to teach others, as she travels to speak at conferences and events around the world. She dedicates her lessons to BI best practices, Data Storytelling, and Power BI Administration. She holds a Bachelors in Business Information Technology from the University of Memphis, focusing in Advanced Analytics and Business Management.

A Business Intelligence consultant and mentor at SQLBI (www.sqlbi.com). His specialty is anything related to data warehouse relational and multidimensional design. He speaks at international conferences including Microsoft Ignite, Microsoft Data Insights, PASS Summit, and SQLBits. Marco is also the author of several books about Analysis Services, Power Pivot, and DAX.