This is the second course in TLG Learning’s custom Power BI Desktop training series. What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed … Continue reading PBICDMD: Data Model Design using Power BI Desktop – Level 2

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence … Continue reading PBICAL: Introduction to DAX for Power BI Desktop Users – Level 3

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes extracting/transforming from various data sources, tabular data modelling, DAX, creating visualizations, the Power BI Service, and the Power BI Mobile App.

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Power Query Power Pivot Tables, Pivot Charts, the Excel Data Model, and Power BI.

First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data … Continue reading PBIBC16: Power BI for Excel 2016 – Report Builders, Power BI Tools, Data Model Designers and DAX Functions

This is the second course in TLG Learning’s custom Power BI Desktop training series. What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed … Continue reading PBICDMD16: Data Model Design using Power BI Desktop – Level 2

This is the first course in TLG Learning’s exclusive Data Analysis using Power BI Desktop series. This course lays the foundation for Power BI Report Builders. Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created using Power BI Desktop. This course covers … Continue reading PBICRB16: Data Analysis using Power BI Desktop – Level 1 – Report Builder

First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data … Continue reading PPBC2013: PowerBI for Excel 2013 – Report Builders, PowerBI Tools, Data Model Designers, and DAX Functions