TURBOCHARGE Your Company Analytics with Power BI Barry

TURBOCHARGE Your Company Analytics with Power BI Barry Crowell BI/EDW Solutions Architect KTL Solutions, Inc.

5119 Pegasus Court, Suite T Frederick, MD 21704 (P) 301 -360 -0001 (E) info@ktlsolutions. com Who is KTL Solutions? KTL Solutions combines consulting services and technology to help businesses eliminate manual processes, use existing technology more effectively, and improve overall productivity within their organization. We work within the GP/SL and CRM Dynamics realm; Business Intelligence; Managed Services; and Custom Development realms.

AGENDA • Power BI Tips • Content Packs • Future Developments • Power BI Demo

Tips - Turbocharge Your Dynamics 365 Connection

Tips - Power BI Tiles on Dynamics 365 Dashboards Settings > Administration > Reporting > Allow Power BI visualization

DAX Functionality in Direct. Query Mode

Dynamics 365 Content Packs • Sales Manager for Dynamics 365 • Service Manager for Dynamics 365 **Customizing the default content packs: https: //technet. microsoft. com/en-us/library/mt 490470. aspx

The Future - Power BI On Premise

Power BI - Showcase Before

DEMO

Final Thoughts • • • Ideas - https: //ideas. powerbi. com/forums/265200 -power-bi • Stories Gallery - https: //community. powerbi. com/t 5/Data-Stories-Gallery/bdp/Data. Stories. Gallery • Power BI Dynamic Security Learning - https: //powerbi. microsoft. com/en-us/guided-learning/ DAX - https: //powerbi. microsoft. com/en-us/guided-learning/powerbi-learning 7 -1 -intro-to-dax/ • • https: //www. ktlsolutions. com/bi/dynamic-security-additional-thoughts/ https: //www. ktlsolutions. com/technology/implement-analysis-services-dynamicsecurity-based-microsoft-crm-user-access-rights/ Additional Questions: Barry Crowell KTL Solutions, Inc. bcrowell@ktlsolutions. com 301 -329 -2794