This course is targeted at business intelligence developers and Power Users that are currently, or are in process of, developing Excel dashboards.
In this module we will explore the elements needed for effective and efficient dashboard building. We will cover best practices for success in business intelligence, and also examine visualization types, along with the pros and cons associated with each, and common pitfalls, so you’ll know what to avoid when designing dashboards.
In this module we will explore importing data, creating relationships, and utilizing date tables. We will also create and configure calculated columns, calculated fields, and KPIs.
In this module we will create an Excel dashboard. We will explore how to create and configure pivot tables and pivot charts using PowerPivot, and we’ll also cover how to create a custom table, add that table to the data model, and configure the results to format conditionally.
In this module we will explore Power View. We will explain the interface and cover the tables and charts available. Lastly we will demonstrate how to share your dashboards using SharePoint.
Locatia de desfasurare a cursului:
Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti
Cine susține cursul?
Familiarity with Microsoft Office applications – particularly Excel
Basic knowledge of the Microsoft Windows operating system and its core functionality
Basic knowledge of data warehouse schema topology (including star and snowflake schemas
Curs 10988 Managing SQL Business Intelligence Operations
Curs 10989 Analyzing Data with Power BI
Curs 20778 Analyzing Data with Power BI
Curs 20779 Analyzing Data with Excel
Curs 55108 Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX) Power BI
Curs 55163 Preparing Your Data for Power BI