Description
If you want to become good at creating Self Service Business Intelligence (BI) using the excellent and extensive Microsoft tool sets, you must learn how to become a data modeler using Power Pivot.
This course teaches the skills a business analyst needs to know in order to successfully use Power BI, Power Pivot for Excel and Power Query. The course starts out first using Powerful Advanced Excel functionality and then moves to Power BI tools.
Want to write basic Data Analysis eXpressions (DAX) formulas to extract business insights?
Want to write more advanced DAX formulas that use the power of DAX to extract additional business insights from the data that are not immediately obvious (yet are inherently available)?
Want to move from being a Power Pivot for Excel user to being a Power BI user, covering the differences between the tools and how to start using Power BI effectively?
Learning Objectives
The Main objective of this training is to make you understand Power Query, Power Pivot, Power View and Power Map to create powerful business intelligent reports and dashboards
Understand Power Query & Power Pivot and how to apply it to your job.
Produce valuable metrics for your business that never existed before.
Learn best tips & tricks to solve complex problems & create stunning work.
Target Audience
Intensive users of Excel, especially those responsible for reporting and analysis.
Business leaders who need to mine their data for actionable insight – using existing resources and on short deadlines.
Organizations looking to leverage Microsoft’s groundbreaking Power Pivot & BI offerings.
Business Intelligence and Database professionals looking to increase their professional agility and dramatically expand their capabilities.
Program Outline
Power Query
Cleaning up Data
Merging & Appending Data
Grouping Data
Loading data to PowerPivot
Power Pivot
Create relationships between Tables
Manage millions of rows of data
Custom Calculations, Key Metrics/KPIs
Analyzing Data with Pivot Tables
Power View
Creating Tables and Cards
Visualizing data with Graphs
Creating Interactive dashboards
Filter and Ask Questions of your Data
Powerful data analysis with Scatter Plots and Bubble Plots
Visualize Geographical data and maps
Power Map
Mapping Data with Power Map
Changing the Method of Aggregation
Mapping Data over Time
Creating Tours

Reviews
There are no reviews yet.