Power BI Excel 2016 Level 2 - Data Model DesignPowerBIDataModelPower BI Excel 2016 Level 2 - Data Model Design<p>What makes Power BI for Excel such a vast improvement over detailed Excel worksheets is the PowerPivot Data Model, which allows data to be pulled together from multiple tables and multiple databases. This course is designed for Power BI for Excel Designers who are ready to create custom data models for themselves and for other Power BI Designers. Topics covered include database design concepts, how to build both general purpose and customized data models, building data hierarchies, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information.</p>http://springhouse.com/course-catalog/PowerBIDataModel2/8/2019 9:41:47 PM01766aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse18267b7c-6d52-e611-aa97-00155d0a1406
Power BI Excel 2016 Level 3 - DAX Functions, Tables and Dashboard TechniquesPowerBIDaxPower BI Excel 2016 Level 3 - DAX Functions, Tables and Dashboard Techniques<p>This course is built for Power BI for Excel Designers that will be responsible for taking basic PowerPivot data models turning them into power business intelligence solutions. 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. Specific 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 calculations, creating advanced DAX dashboards and report elements using Slicers.</p>http://springhouse.com/course-catalog/PowerBIDax2/25/2019 1:54:08 PM01769aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse8adf039a-6d52-e611-aa97-00155d0a1406
Power BI for Excel 2016 Boot Camp - Report Builders, Power BI Tools, Data Model Designers, and DAX FunctionsPowerBIBootCampPower BI for Excel 2016 Boot Camp - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions<p>​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 models, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information. Fourth and fifth day topics covered in this class include Relational functions, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis. </p>http://springhouse.com/course-catalog/PowerBIBootCamp9/28/2018 2:51:35 PM01808aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse3d19bfa6-5853-e611-aa97-00155d0a1406
10988 Managing SQL Business Intelligence Operations1098810988 Managing SQL Business Intelligence Operations<p>​This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.</p>http://springhouse.com/course-catalog/109883/21/2018 6:32:50 PM01672aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalseebeb5417-eb84-e611-879d-00155d0a1406http://mocondemand.springhouse.com/#!/10988-On-Demand-Managing-SQL-Business-Intelligence-Operations/p/86683225
20467 Designing Business Intelligence Solutions with Microsoft SQL Server 20142046720467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014<p>This course may be funded with Microsoft Software Assurance Training Vouchers (SATVs).</p><p>This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.</p><p> </p><p> <span style="font-weight:bold;">Note: </span>This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.</p>http://springhouse.com/course-catalog/204673/21/2018 4:38:40 PM03026aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse0459cef2-4ad5-e311-97ab-00155d00bf00
20778 Analyzing Data with Power BI2077820778 Analyzing Data with Power BI<p>​The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.</p>http://springhouse.com/course-catalog/207782/8/2019 9:46:03 PM01753aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalse2ee2ca05-1bad-e711-8b1b-00155d0a1406
20779 Analyzing Data with Excel2077920779 Analyzing Data with Excel<p>​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 Pivot Charts, the Excel Data Model, and Power BI.</p>http://springhouse.com/course-catalog/207793/21/2018 8:05:36 PM073aspxhttp://websource.springhouse.com/Lists/CRM Product List/AllItems.aspxFalsea19b9696-8aaf-e711-8b1b-00155d0a1406

Microsoft Gold Partner

PMI R.E.P.

AXELOS Limited

The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited.
IT Infrastructure Library® is a registered trade mark of AXELOS Limited
The Swirl logo™ is a registered trade mark of AXELOS Limited
Accredited course material is property of ITSM Academy.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 - info@springhouse.com