Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. At Pragmatic Works, Devin determines which courses are created, delivered, and updated for customers, including 10+ Power BI courses. This is his seventh SQL Server and Business Intelligence book to author. Devin often speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays, and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG). His personal blog can be found at Devin Knight's website. Brian Knight is the owner and founder of Pragmatic Works, and is a serial entrepreneur, starting up other companies. Brian is a contributing columnist at several technical magazines. He is the author of 16 technical books. Brian has spoken at conferences like PASS Summit, SQL Connections, TechEd, SQLSaturdays, and Code Camps. He has received a number of awards from the State of Florida, governor, and press, including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). His blog can be found at Pragmatic Works website. Mitchell Pearson has worked for Pragmatic Works for six years as a Business Intelligence Consultant and Training Content manager. Mitchell has experience developing enterprise level BI Solutions using the full suite of products offered by Microsoft (SSRS, SSIS, SSAS, & Power BI). Mitchell is very active in the community presenting at local user groups, SQL Saturday events, PASS virtual chapters and giving free webinars for Pragmatic Works. Mitchell can also be found blogging at Mitchellsql website. Mitchell is also the president of the local Power BI User Group in Jacksonville, Florida. In his spare time Mitchell spends his time with his wife and three kids. For fun Mitchell enjoys playing table top games with friends. Manuel Quintana is a Training Content Manager at Pragmatic Works. Previously he was senior manager working in the hotel industry. He joined the Pragmatic Works team in 2014 with no knowledge in the Business Intelligence space but now speaks at SQL Saturday's and SQL Server User Groups locally and virtually. He also teaches various BI technologies to many different fortune 500 companies on behalf of Pragmatic Works. Since 2014 he has called Jacksonville home and before that Orlando but he was born on the island of Puerto Rico and loves to go back and visit his family. When he isn't working on creating new content for Pragmatic Works you can probably find him playing board games or watching competitive soccer matches.

• Table of ContentsGetting Started with Importing Data OptionsData Transformation StrategiesBuilding the Data ModelLeveraging DAXVisualizing DataUsing a Cloud Deployment with the Power BI ServicePlanning Power BI ProjectsConnecting to Sources and Transforming Data with MDesigning Import and DirectQuery Data ModelsDeveloping DAX Measures and Security RolesCreating and Formatting Power BI ReportsApplying Custom Visuals, Animation, and AnalyticsDesigning Power BI Dashboards and ArchitecturesManaging Application Workspaces and ContentManaging the On-Premises Data GatewayDeploying the Power BI Report ServerCreating Power BI Apps and Content DistributionAdministering Power BI for an OrganizationScaling with Premium and Analysis Services

Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. At Pragmatic Works, Devin determines which courses are created, delivered, and updated for customers, including 10+ Power BI courses. This is his seventh SQL Server and Business Intelligence book to author. Devin often speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays, and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG). His personal blog can be found at Devin Knight's website. Brian Knight is the owner and founder of Pragmatic Works, and is a serial entrepreneur, starting up other companies. Brian is a contributing columnist at several technical magazines. He is the author of 16 technical books. Brian has spoken at conferences like PASS Summit, SQL Connections, TechEd, SQLSaturdays, and Code Camps. He has received a number of awards from the State of Florida, governor, and press, including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). His blog can be found at Pragmatic Works website. Mitchell Pearson has worked for Pragmatic Works for six years as a Business Intelligence Consultant and Training Content manager. Mitchell has experience developing enterprise level BI Solutions using the full suite of products offered by Microsoft (SSRS, SSIS, SSAS, & Power BI). Mitchell is very active in the community presenting at local user groups, SQL Saturday events, PASS virtual chapters and giving free webinars for Pragmatic Works. Mitchell can also be found blogging at Mitchellsql website. Mitchell is also the president of the local Power BI User Group in Jacksonville, Florida. In his spare time Mitchell spends his time with his wife and three kids. For fun Mitchell enjoys playing table top games with friends. Manuel Quintana is a Training Content Manager at Pragmatic Works. Previously he was senior manager working in the hotel industry. He joined the Pragmatic Works team in 2014 with no knowledge in the Business Intelligence space but now speaks at SQL Saturday's and SQL Server User Groups locally and virtually. He also teaches various BI technologies to many different fortune 500 companies on behalf of Pragmatic Works. Since 2014 he has called Jacksonville home and before that Orlando but he was born on the island of Puerto Rico and loves to go back and visit his family. When he isn't working on creating new content for Pragmatic Works you can probably find him playing board games or watching competitive soccer matches.

• Table of ContentsGetting Started with Importing Data OptionsData Transformation StrategiesBuilding the Data ModelLeveraging DAXVisualizing DataUsing a Cloud Deployment with the Power BI ServicePlanning Power BI ProjectsConnecting to Sources and Transforming Data with MDesigning Import and DirectQuery Data ModelsDeveloping DAX Measures and Security RolesCreating and Formatting Power BI ReportsApplying Custom Visuals, Animation, and AnalyticsDesigning Power BI Dashboards and ArchitecturesManaging Application Workspaces and ContentManaging the On-Premises Data GatewayDeploying the Power BI Report ServerCreating Power BI Apps and Content DistributionAdministering Power BI for an OrganizationScaling with Premium and Analysis Services

Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. At Pragmatic Works, Devin determines which courses are created, delivered, and updated for customers, including 10+ Power BI courses. This is his seventh SQL Server and Business Intelligence book to author. Devin often speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays, and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG). His personal blog can be found at Devin Knight's website. Brian Knight is the owner and founder of Pragmatic Works, and is a serial entrepreneur, starting up other companies. Brian is a contributing columnist at several technical magazines. He is the author of 16 technical books. Brian has spoken at conferences like PASS Summit, SQL Connections, TechEd, SQLSaturdays, and Code Camps. He has received a number of awards from the State of Florida, governor, and press, including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). His blog can be found at Pragmatic Works website. Mitchell Pearson has worked for Pragmatic Works for six years as a Business Intelligence Consultant and Training Content manager. Mitchell has experience developing enterprise level BI Solutions using the full suite of products offered by Microsoft (SSRS, SSIS, SSAS, & Power BI). Mitchell is very active in the community presenting at local user groups, SQL Saturday events, PASS virtual chapters and giving free webinars for Pragmatic Works. Mitchell can also be found blogging at Mitchellsql website. Mitchell is also the president of the local Power BI User Group in Jacksonville, Florida. In his spare time Mitchell spends his time with his wife and three kids. For fun Mitchell enjoys playing table top games with friends. Manuel Quintana is a Training Content Manager at Pragmatic Works. Previously he was senior manager working in the hotel industry. He joined the Pragmatic Works team in 2014 with no knowledge in the Business Intelligence space but now speaks at SQL Saturday's and SQL Server User Groups locally and virtually. He also teaches various BI technologies to many different fortune 500 companies on behalf of Pragmatic Works. Since 2014 he has called Jacksonville home and before that Orlando but he was born on the island of Puerto Rico and loves to go back and visit his family. When he isn't working on creating new content for Pragmatic Works you can probably find him playing board games or watching competitive soccer matches.

• Table of ContentsGetting Started with Importing Data OptionsData Transformation StrategiesBuilding the Data ModelLeveraging DAXVisualizing DataUsing a Cloud Deployment with the Power BI ServicePlanning Power BI ProjectsConnecting to Sources and Transforming Data with MDesigning Import and DirectQuery Data ModelsDeveloping DAX Measures and Security RolesCreating and Formatting Power BI ReportsApplying Custom Visuals, Animation, and AnalyticsDesigning Power BI Dashboards and ArchitecturesManaging Application Workspaces and ContentManaging the On-Premises Data GatewayDeploying the Power BI Report ServerCreating Power BI Apps and Content DistributionAdministering Power BI for an OrganizationScaling with Premium and Analysis Services